Joomla Ticketmaster - Sell promo tickets first

I've made a couple of changes to Joomla Ticketmaster . They're hacks so will need uploading on any future developments of the component.


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