Ensemble Cleaner
");
$_SESSION['editor_calling_page'] = $_SERVER['PHP_SELF'];
$_SESSION['editor_title'] = "Ensemble Cleaner";
$restrict_to_users = array('admin','root');
//if Delete Experiments form on this page was posted,
if(isset($_POST['delete_experiments']) && ($_POST['delete_experiments'] == 1)) {
printf("Are you sure you want to delete the following experiments?
");
foreach($_POST as $key=>$value) {
if(preg_match("/delete_experiment_id_([[:digit:]]+)/",$key,$matches)) {
$sql_del_exp = sprintf("select * from experiment where experiment_id = %d",$matches[1]);
$result_del_exp = mysql_select($sql_del_exp);
printf("%d %s",$result_del_exp['experiment_id'],$result_del_exp['experiment_title']);
$exp_delete_ids[] = $matches[1];
$sql_find_response_table = sprintf("describe %s",$result_del_exp['response_table']);
mysql_query($sql_find_response_table) or printf(" - COULD NOT FIND RESPONSE TABLE \"%s\"",$result_del_exp['response_table']);
echo "
";
}
}
printf("
");
printf("\n");
printf("\n");
printf(" | \n");
printf(" | \n");
printf("
");
}
//else if Delete Session form on this page was posted
elseif(isset($_POST['delete_session']) && ($_POST['delete_session'] == 1)) {
if($_POST['experiment_id'] == '%')
$get_experiment_name = '(ALL EXPERIMENTS)';
else {
$sql_get_experiment_name = sprintf("select * from experiment where experiment_id like %s",GetSQLValueString($_POST['experiment_id'],"text"));
$experiment_name = mysql_select($sql_get_experiment_name);
$get_experiment_name = $experiment_name['experiment_title'];
}
printf("Select sessions to delete for subject %s and experiment '%s'
",GetSQLValueString($_POST['subject_id'],"text"),$get_experiment_name);
$sql_session_id = sprintf("select * from session where subject_id like %s and experiment_id like %s",GetSQLValueString($_POST['subject_id'],"text"),GetSQLValueString($_POST['experiment_id'],"text"));
$result_session_id = mysql_query($sql_session_id) or die(mysql_error());
while($row_session_id = mysql_fetch_assoc($result_session_id))
$session_id_list[] = $row_session_id['session_id'];
//this form deletes one session at a time
printf("\n");
//this form provides the button to delete all sessions belonging to a subject for a specific experiment
printf("\n");
printf("Cancel Deletion and Go Back to Main Page
",$_SERVER['PHP_SELF']);
}
//else no forms were posted yet. if login is correct, print out the forms
else if(in_array($_SESSION['login'],$restrict_to_users)) {
/****** Session Deletion ********/
$sql_experiment_list = 'select * from experiment';
$result_experiment_list = mysql_query($sql_experiment_list);
printf("");
printf("
");
/****** Experiment Deletion *****/
$sql_experiment_list = 'select * from experiment';
$result_experiment_list = mysql_query($sql_experiment_list);
$list_experiment_fields = array('experiment_id','experiment_title','response_table');
printf("");
printf("
\n");
}
//else if login is not correct, only display options to login as another user or return to Experiment Editor
else if(!in_array($_SESSION['login'],$restrict_to_users)) {
printf("Sorry, this is a restricted area. Only the following users have access: ");
foreach($restrict_to_users as $key=>$value) {
printf("%s",$value);
if(intval($key) < (sizeof($restrict_to_users)-1))
printf(", "); //print a comma after each user except for the last one.
}
printf("
What would you like to do?
");
}
printf("Go to Experiment Editor
",$questionnaire_location);
printf("Login as another user
",$questionnaire_location);
?>