MAXIMUM ELITE ELEVATION TOUR 2022

session_start();

if(isset($_POST["login"])){

     $db = JFactory::getDbo();

     $query = $db->getQuery(true);

     $number = $_POST['number'];

     $_SESSION["number"] = $number;

// Fields to update

     $fields = $db->quoteName('redeemed') . ' = ' . $db->quoteName('redeemed').'+1';

// Conditions for which records should be updated.

     $conditions = array(

          $db->quoteName('valid') . ' = 1',

          $db->quoteName('number') . ' = "'. $number .'"'

);

$query->update($db->quoteName('t2cqs_tickets_validator'))->set($fields)->where($conditions);

$db->setQuery($query);

$result = $db->execute();


// Create a new query object.
$query = $db->getQuery(true);

$query->select($db->quoteName('id'));

$query->from($db->quoteName('t2cqs_tickets_validator'));

$conditions = array(

    $db->quoteName('valid') . ' = 1',

    $db->quoteName('number') . ' = "'. $number .'"'

);

$query->where($conditions);

$db->setQuery($query);

$results = $db->loadResult();

//echo $results;

// Condition to check array is empty or not

if(!empty($results)){

     //echo "Yes";

     $_SESSION["id"] = $results;

     header("location:/meetinyxe2021/ticket.php?ID=$number");
     //echo "Redirecting.....";

          } else { 

               echo "Sorry, it looks like that ticket number is invalid for tonight's competition. Please try again!";
          }

}

?>