$value) { if(preg_match("/delete_ticket_id_([[:digit:]]+)/",$key,$matches)) { //$sql_delete_ticket = sprintf("delete from ticket where ticket_id = %d",$matches[1]); // Expire the selected tickets instead of deleting them $yesterday = time() - 60 * 60 * 24; $sql_delete_ticket = sprintf("UPDATE ticket SET expiration_datetime = '%s' WHERE ticket_id = %d", date('Y-m-d H:i:s', $yesterday), $matches[1]); mysql_query($sql_delete_ticket) or die(mysql_error()); } } } $current_datetime = date("Y-m-d H:i:s"); $sql_get_experiment_name = sprintf("select experiment_title, language from experiment where experiment_id = %d",$_SESSION['editor_experiment_id']); $get_experiment_name = mysql_select($sql_get_experiment_name); $sql_get_available_tickets = sprintf("select ticket_id,ticket_code,expiration_datetime,experiment_title from experiment "). sprintf("left join ticket on "). sprintf("(experiment.experiment_id = ticket.experiment_id) "). sprintf("where experiment.experiment_id = %d ", GetSQLValueString($_SESSION['editor_experiment_id'],"int")). sprintf("and (ticket.type = 'master' and ticket.used !='T' and "). sprintf("(ticket.expiration_datetime >= %s or ticket.expiration_datetime is null) ", GetSQLValueString($current_datetime,"date")). sprintf("or ticket_id is null)"); $get_available_tickets = mysql_query($sql_get_available_tickets) or die(mysql_error()); $result_available_tickets = mysql_fetch_assoc($get_available_tickets); printf("

Master Tickets for Experiment \"%s\"

",$get_experiment_name['experiment_title']); printf("

\n",$_SERVER['PHP_SELF']); printf("\n"); printf(""); printf("\n"); do { if($result_available_tickets['ticket_id'] != NULL) { printf("",$result_available_tickets['ticket_id']); $ticket_url = sprintf("%sstart.php?tc=%s",$questionnaire_location,$result_available_tickets['ticket_code']); $expiration_datetime = ($result_available_tickets['expiration_datetime'] != NULL) ? $result_available_tickets['expiration_datetime'] : "No Expiration Time"; printf("\n",$ticket_url,$ticket_url); printf("\n",$expiration_datetime); } else { printf(""); } } while($result_available_tickets = mysql_fetch_assoc($get_available_tickets)); printf("\n"); printf("

Disable	Ticket URL (click link to start experiment)	Expiration Date/Time
	%s	%s
No Available Master Tickets

"); printf("
"); printf(""); printf("

"); ?>