Esempio n. 1
0
 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;
 }
Esempio n. 2
0
 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;
 }
Esempio n. 3
0
 function _updateClient($eid, $id)
 {
     $mainframe = JFactory::getApplication();
     ## Include the confirmation class to sent the tickets.
     $path = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'confirmation.php';
     $override = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'override' . DS . 'confirmation.php';
     ## Check if the override is there.
     if (file_exists($override)) {
         ## Yes, now we use it.
         require_once $override;
     } else {
         ## No, use the standard
         require_once $path;
     }
     if (isset($eid)) {
         $sendconfirmation = new confirmation((int) $eid);
         $sendconfirmation->doConfirm();
         $sendconfirmation->doSend();
     }
     $mainframe->redirect('index.php', JText::_('COM_TICKETMASTER_CONFIRM_OK'));
 }
 function _doConfirm($eid)
 {
     ## Include the confirmation class to sent the tickets.
     $path = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'confirmation.php';
     $override = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'override' . DS . 'confirmation.php';
     ## Check if the override is there.
     if (file_exists($override)) {
         ## Yes, now we use it.
         require_once $override;
     } else {
         ## No, use the standard
         require_once $path;
     }
     if (isset($eid)) {
         $sendconfirmation = new confirmation((int) $eid);
         $sendconfirmation->doConfirm();
         $sendconfirmation->doSend();
     }
 }
    {
        if (isset($_GET["code"])) {
            $this->code = $_GET["code"];
            $this->check_code();
        } else {
            header("location: ../index.php");
        }
    }
    private function check_code()
    {
        $select_confirmation_from_db = $this->conn->prepare("select confirmation_code from registered_users where confirmation_code = :code");
        $select_confirmation_from_db->execute(array('code' => $this->code));
        $result = $select_confirmation_from_db->fetch(PDO::FETCH_ASSOC);
        if ($result) {
            $confirm_account = $this->conn->prepare("update registered_users set is_confirmed = 1 where confirmation_code = :code");
            $confirm_account->execute(array('code' => $this->code));
            //Deleting confirmation code so if user visits the same page again, or tried to visit with same confirmation code, throw error because code's been deleted once used.
            $delete_confirmation_code = $this->conn->prepare("update registered_users set confirmation_code = '' where confirmation_code = :code");
            $delete_confirmation_code->execute(array('code' => $this->code));
            session_start();
            $_SESSION["acc_con"] = "acc_con";
            header("location: account_confirmed.php");
        }
        if (!$result) {
            header("location: ../index.php");
        }
    }
}
include "../connection_to_db.php";
$confirm = new confirmation($conn);
$confirm->set_code($_GET);
Esempio n. 6
0
 function validate()
 {
     $mainframe = JFactory::getApplication();
     ## Getting the POST variables.
     $post = JRequest::get('post');
     if ($this->ordercode == 0) {
         $msg = JText::_('COM_TICKETMASTER_NO_VALID_ID');
         $mainframe->redirect('index.php?option=com_ticketmaster', $msg);
     }
     if ($this->id == 0) {
         $msg = JText::_('COM_TICKETMASTER_NO_VALID_ID');
         $mainframe->redirect('index.php?option=com_ticketmaster', $msg);
     }
     ## GETTING THE MODEL TO SAVE
     $model = $this->getModel('validate');
     ## OK, all tickets have been added to the database session.<br />
     ## We need to update the table for total-tickets.
     $path_include = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'confirmation.php';
     include_once $path_include;
     if (isset($this->ordercode)) {
         $sendconfirmation = new confirmation((int) $this->ordercode);
         $sendconfirmation->doConfirm();
         $sendconfirmation->doSend();
     }
     if (!$model->update($this->ordercode, $this->id)) {
         $msg = JText::_('COM_TICKETMASTER_VALIDATION_FAILED');
         $mainframe->redirect('index.php?option=com_ticketmaster', $msg);
     }
     $msg = JText::_('COM_TICKETMASTER_VALIDATED');
     $mainframe->redirect('index.php?option=com_ticketmaster', $msg);
 }
Esempio n. 7
0
    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;
    }