function itemsupdate($userid, $ordercode)
{
$query = 'UPDATE #__ticketmaster_orders' . ' SET userid = ' . (int) $userid . ' WHERE ordercode = ' . $ordercode . ' ';
## Do the query now
$this->_db->setQuery($query);
## When query goes wrong.. Show message with error.
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$db = JFactory::getDBO();
## Check if waiting list is turned on:
$sql = "SELECT show_waitinglist \n\t\t\t\t\tFROM #__ticketmaster_config \n\t\t\t\t\tWHERE configid = 1";
$db->setQuery($sql);
$config = $db->loadObject();
if ($config->show_waitinglist == 1) {
$query = 'UPDATE #__ticketmaster_waitinglist' . ' SET userid = ' . (int) $userid . ' WHERE ordercode = ' . $ordercode . ' ';
## Do the query now
$this->_db->setQuery($query);
## When query goes wrong.. Show message with error.
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$path_include = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'confirmation.php';
include_once $path_include;
$sendconfirmation = new confirmation((int) $ordercode);
$sendconfirmation->SendWaitingList();
}
return true;
}
function itemsupdate($userid, $ordercode)
{
$query = 'UPDATE #__ticketmaster_orders' . ' SET userid = ' . (int) $userid . ' WHERE ordercode = ' . $ordercode . ' ';
## Do the query now
$this->_db->setQuery($query);
## When query goes wrong.. Show message with error.
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
## TRIGGER INVOICING PLUGIN AND RELATED onAfterCheckout
JPluginHelper::importPlugin('rdmediahelpers');
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger('OnAfterCheckout', array($vars));
$db = JFactory::getDBO();
## Check if waiting list is turned on:
$sql = "SELECT show_waitinglist\n\t\t\t\t\tFROM #__ticketmaster_config\n\t\t\t\t\tWHERE configid = 1";
$db->setQuery($sql);
$config = $db->loadObject();
if ($config->show_waitinglist == 1) {
$query = 'UPDATE #__ticketmaster_waitinglist' . ' SET userid = ' . (int) $userid . ' WHERE ordercode = ' . $ordercode . ' ';
## Do the query now
$this->_db->setQuery($query);
## When query goes wrong.. Show message with error.
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$path_include = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'confirmation.php';
include_once $path_include;
$sendconfirmation = new confirmation((int) $ordercode);
$sendconfirmation->SendWaitingList();
}
return true;
}
function getConfig()
{
if (empty($this->_data)) {
$db = JFactory::getDBO();
## Making the query for showing all the cars in list function
$sql = 'SELECT * FROM #__ticketmaster_config WHERE configid = 1';
$db->setQuery($sql);
$data = $db->loadObject();
if ($data->show_waitinglist == 1) {
## Check if waiting list is turned on:
$sql = 'SELECT COUNT(id) AS total
FROM #__ticketmaster_waitinglist
WHERE sent = 0
AND ordercode = ' . (int) $this->ordercode . '';
$db->setQuery($sql);
$waiters = $db->loadObject();
if ($waiters->total != 0) {
$path_include = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'confirmation.php';
include_once $path_include;
$sendconfirmation = new confirmation((int) $this->ordercode);
$sendconfirmation->SendWaitingList();
}
}
}
return $data;
}
