echo lang('registered_but_not_confirmed_xxx'); } echo ' </TD> <TD> ' . participants__count_participants("status_id='0'") . ' </TD> </TR> <TR> <TD> ' . lang('from_this_older_than_4_weeks_xxx') . ': </TD> <TD>'; $now = time(); $before = $now - 60 * 60 * 24 * 7 * 4; $tstring = "status_id='0' AND creation_time < " . $before; echo participants__count_participants($tstring) . ' </TD> </TR> </TABLE> <BR> </TD> </TR> <TR> <TD colspan="2"> <TABLE class="or_option_buttons_box" style="background: ' . $color['options_box_background'] . ';"> <TR> '; if (check_allow('participants_show')) {
$saved_queries = query__load_saved_queries('participants_search_active', $settings['queryform_partsearchactive_savedqueries_numberofentries']); } else { if (!isset($_SESSION['lastquery_participants_search_all'])) { $_SESSION['lastquery_participants_search_all'] = ''; } $load_query = $_SESSION['lastquery_participants_search_all']; if (!$load_query) { $load_query = query__load_default_query('participants_search_all'); } $hide_modules = array(); $status_query = ""; $formextra = ''; $saved_queries = query__load_saved_queries('participants_search_all', $settings['queryform_partsearchall_savedqueries_numberofentries']); } if ($active) { $active_clause = participant_status__get_pquery_snippet("eligible_for_experiments"); $count = participants__count_participants($active_clause); echo $count . ' ' . lang('active_participant_profiles_in_database') . '<BR>'; } else { $count = participants__count_participants(); echo $count . ' ' . lang('participant_profiles_in_database') . '<BR>'; } echo '<TABLE width="80%"><TR><TD>'; query__show_form($hide_modules, false, $load_query, lang('search_and_show'), $saved_queries, $status_query, $formextra); echo '</TD></TR></TABLE>'; } } if ($proceed) { echo '</center>'; } include "footer.php";
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"); $exptype_clause = "subscriptions LIKE '%|" . $experiment['experiment_ext_type'] . "|%'"; echo participants__count_participants($active_clause . ' AND ' . $exptype_clause); echo ' ' . lang('xxx_part_in_db_for_xxx_exp') . ' '; if (!isset($exptypes[$experiment['experiment_ext_type']]['exptype_name'])) { $exptypes[$experiment['experiment_ext_type']]['exptype_name'] = 'type undefined'; } echo $exptypes[$experiment['experiment_ext_type']]['exptype_name']; echo '<BR><BR>'; echo experiment__count_participate_at($experiment_id) . ' ' . lang('participants_assigned_to_this_experiment'); echo '<CENTER><TABLE width="80%"><TR><TD>'; query__show_form($hide_modules, $experiment, $load_query, lang('search_and_show'), $saved_queries, $status_query); echo '</TD></TR></TABLE></CENTER>'; } } if ($proceed) { echo ' <A HREF="experiment_show.php?experiment_id=' . $experiment_id . '"> ' . lang('mainpage_of_this_experiment') . '</A><BR><BR>
echo '<BR><BR> <table class="or_listtable"><thead> <TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';"> <TD>' . lang('id') . '</TD> <TD>' . lang('name') . '</TD> <TD>' . lang('description') . '</TD> <TD>' . lang('assigned_internal_experiment_types') . '</TD> <TD>' . lang('registered_for_xxx_experiments_xxx') . '</TD> <TD></TD> </TR></thead> <tbody>'; $query = "SELECT *\n FROM " . table('experiment_types') . "\n ORDER BY exptype_id"; $result = or_query($query); $shade = false; while ($line = pdo_fetch_assoc($result)) { $count = participants__count_participants(" subscriptions LIKE :exptype_id", array(':exptype_id' => '%|' . $line['exptype_id'] . '|%')); echo ' <tr class="small"'; if ($shade) { echo ' bgcolor="' . $color['list_shade1'] . '"'; } else { echo ' bgcolor="' . $color['list_shade2'] . '"'; } echo '> <td>' . $line['exptype_id'] . '</td> <td>' . $line['exptype_name'] . '</td> <td>' . $line['exptype_description'] . '</td> <td>' . $line['exptype_mapping'] . '</td> <td>' . $count . '</td> <td><A HREF="experiment_type_edit.php?exptype_id=' . $line['exptype_id'] . '">' . lang('edit') . '</A></td> </tr>'; if ($shade) {