Firstly the client was after selling tickets at Promotional Price and then once they've run out the full price tickets will sell.
To do this ADD your promo tickets FIRST . And the tickets MUST HAVE THE SAME NAME
Here's the hack
OPEN com_ticketmaster/models/eventlist.php
find
function getList() {
if (empty($this->_data)) {
$db = JFactory::getDBO();
$where = $this->_buildContentWhere();
$order = $this->_buildContentOrderBy();
## Making the query for showing all the clients in list function
$sql = 'SELECT a.*, b.eventname, b.groupname, v.venue AS venuename, v.id AS venueid
FROM #__ticketmaster_tickets AS a, #__ticketmaster_events AS b, #__ticketmaster_venues AS v'
.$where
.$order;
$db->setQuery($sql, $this->getState('limitstart'), $this->getState('limit' ));
$this->data = $db->loadObjectList();
}
return $this->data;
}
AND REPLACE WITH
function getList() {
if (empty($this->_data)) {
$db = JFactory::getDBO();
$where = $this->_buildContentWhere();
$order = $this->_buildContentOrderBy();
## Making the query for showing all the clients in list function
$sql = 'SELECT a.*, b.eventname, b.groupname, v.venue AS venuename, v.id AS venueid
FROM #__ticketmaster_tickets AS a, #__ticketmaster_events AS b, #__ticketmaster_venues AS v'
.$where
.' AND a.totaltickets > 0 GROUP BY a.ticketname'
.$order; // changed by littleripples.com
$db->setQuery($sql, $this->getState('limitstart'), $this->getState('limit' ));
$this->data = $db->loadObjectList();
}
return $this->data;
}
SAVE AND UPLOAD
