Experiment Editor

","%0D",$generic_mail_body); $mail_checked_tag = "checked"; } else { $mail_checked_tag = ""; } //delete tickets if delete_ticket_id was posted if(isset($_POST['delete_assign_submit'])) { foreach($_POST as $key=>$value) { if(preg_match("/delete_ticket_id_([[:digit:]]+)/",$key,$matches)) { $sql_delete_ticket = sprintf("delete from ticket where ticket_id = %d",$matches[1]); mysql_query($sql_delete_ticket) or die(mysql_error()); } elseif(preg_match("/ticket_id_([[:digit:]]+)/",$key,$matches)) { $assign_ticket_id = $matches[1]; if(isset($_POST['assigned_'.$assign_ticket_id])) $sql_assign_ticket = sprintf("update ticket set assigned='T' where ticket_id=%d",$assign_ticket_id); else $sql_assign_ticket = sprintf("update ticket set assigned='F' where ticket_id=%d",$assign_ticket_id); mysql_query($sql_assign_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, assigned 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 = 'user' 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("

User Tickets for Experiment \"%s\"

",$get_experiment_name['experiment_title']); printf("\n"); printf("",$flash_checked_tag); printf("
",$mail_checked_tag); printf("\n",$_SERVER['PHP_SELF']); printf("

\n"); printf("\n"); printf("\n"); 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"; $mail_body = $generic_mail_body . $ticket_url; if(isset($_SESSION['ticket_mail_link']) && $_SESSION['ticket_mail_link']) printf("\n",$mail_subject,$mail_body,$ticket_url); else printf("\n",$mail_body,$ticket_url); printf("\n",$expiration_datetime); ($result_available_tickets['assigned'] == 'T')? $assigned_check = "checked" : $assigned_check = ""; //printf("\n",$result_available_tickets['ticket_id'],$assigned_check); printf("\n"); } else { printf(""); } } while($result_available_tickets = mysql_fetch_assoc($get_available_tickets)); printf("

Delete	Ticket URL "); if(isset($_SESSION['ticket_mail_link']) && $_SESSION['ticket_mail_link']) printf("(click link to send by email)"); printf("	Expiration Date/Time	Assigned
	%s	%s	%s	\n\n",$_SERVER['PHP_SELF'],$result_available_tickets['ticket_id']); printf("	\n",$result_available_tickets['ticket_id']); printf("\n\n
No Available User Tickets

\n"); printf("
"); printf("\n"); /*if(isset($_POST['assignflashurl'])) printf("\n"); if(isset($_POST['mail_link'])) printf("\n");*/ printf(""); printf(""); ?>