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) {
