echo '</TD></TR></TABLE>'; echo '<BR><BR>'; $query_array = query__get_query_array($posted_query['query']); $active_clause = array('query' => participant_status__get_pquery_snippet("eligible_for_experiments"), 'pars' => array()); $exptype_clause = array('query' => "subscriptions LIKE (:experiment_ext_type)", 'pars' => array(':experiment_ext_type' => "%|" . $experiment['experiment_ext_type'] . "|%")); $notyetassigned_clause = array('query' => "participant_id NOT IN (SELECT participant_id FROM " . table('participate_at') . " WHERE experiment_id= :experiment_id)", 'pars' => array(':experiment_id' => $experiment_id)); $additional_clauses = array($active_clause, $exptype_clause, $notyetassigned_clause); $query = query__get_query($query_array, $query_id, $additional_clauses, $sort); //echo '<TABLE width="70%" border=0><TR><TD><B>Query:</B></TD></TR><TR><TD>'; //echo $query['query']; //echo '</TD></TR></TABLE>'; //dump_array($query['pars'],"Parameters"); echo '<FORM name="part_list" method="POST" action="' . thisdoc() . '"> <INPUT type=hidden name=experiment_id value="' . $experiment_id . '">'; // show list of results $assign_ids = query_show_query_result($query, "assign"); $_SESSION['assign_ids_' . $experiment_id] = $assign_ids; echo '</FORM>'; } else { if (!isset($_SESSION['lastquery_assign_' . $experiment_id])) { $_SESSION['lastquery_assign_' . $experiment_id] = ''; } $load_query = $_SESSION['lastquery_assign_' . $experiment_id]; if (!$load_query) { $load_query = query__load_default_query('assign', $experiment_id); } $hide_modules = array('statusids'); $status_query = participant_status__get_pquery_snippet("eligible_for_experiments"); $saved_queries = query__load_saved_queries('assign', $settings['queryform_experimentassign_savedqueries_numberofentries'], $experiment_id); $exptypes = load_external_experiment_types(); $active_clause = participant_status__get_pquery_snippet("eligible_for_experiments");
redirect("admin/participants_unconfirmed.php"); } } } if ($proceed) { echo '<center>'; echo '<FORM action="participants_unconfirmed.php" method="POST">'; $posted_query = array('query' => array(0 => array("statusids_multiselect" => array("not" => "", "ms_status" => "0")))); $query_array = query__get_query_array($posted_query['query']); $query = query__get_query($query_array, 0, array(), 'creation_time DESC', false); echo '<BR> <TABLE width="80%" border="0"> <TR><TD> <TABLE width="100%" border="0"> <TR><TD width="50%" align="right"> <input class="button" type=submit name="deleteall" value="' . lang('delete_all') . '"> </TD><TD width="50%" align="right"> <input class="button" type=submit name="deletesel" value="' . lang('delete_selected') . '"> </TD></TR> </TABLE> </TD></TR> <TR><TD colspan="2">'; $emails = query_show_query_result($query, "participants_unconfirmed", false); echo '</FORM>'; echo '</TD></TR></TABLE>'; $emailstring = implode(",", $emails); echo '<BR><BR>' . button_link('mailto:' . $settings['support_mail'] . '?bcc=' . $emailstring, lang('write_message_to_all_listed'), 'envelope'); echo '<BR><BR>' . button_link('participants_main.php', lang('back'), 'level-up') . '<BR><BR>'; echo '</CENTER>'; } include "footer.php";
//echo $query['query']; //echo '</TD></TR></TABLE>'; //dump_array($query['pars'],"Parameters"); //dump_array($_REQUEST); // show list of results echo '<form id="bulkactionform" action="participants_show.php" method="POST">'; if (isset($_REQUEST['search_sort'])) { echo '<input type="hidden" name="search_sort" value="' . $_REQUEST['search_sort'] . '">'; } if (isset($_REQUEST['active'])) { echo '<input type="hidden" name="active" value="' . $_REQUEST['active'] . '">'; } if ($active) { $plist_ids = query_show_query_result($query, "participants_search_active"); } else { $plist_ids = query_show_query_result($query, "participants_search_all"); } echo '</form>'; } else { //if (!isset($_SESSION['lastquery_'.$experiment_id])) $_SESSION['lastquery_'.$experiment_id]=''; //$load_query=$_SESSION['lastquery_'.$experiment_id]; if ($active) { if (!isset($_SESSION['lastquery_participants_search_active'])) { $_SESSION['lastquery_participants_search_active'] = ''; } $load_query = $_SESSION['lastquery_participants_search_active']; if (!$load_query) { $load_query = query__load_default_query('participants_search_active'); } $hide_modules = array('statusids'); $status_query = participant_status__get_pquery_snippet("eligible_for_experiments");