ob_start();
$title = "import_language";
include "header.php";
if ($proceed) {
if (isset($_REQUEST['lang_id']) && $_REQUEST['lang_id']) {
$lang_id = $_REQUEST['lang_id'];
} else {
$lang_id = '';
}
$languages = get_languages();
if (!$lang_id || !in_array($lang_id, $languages)) {
redirect("admin/lang_main.php");
}
}
if ($proceed) {
$allow = check_allow('lang_lang_export', 'lang_lang_edit.php?elang=' . $lang_id);
}
if ($proceed) {
$tlang_name = load_language_symbol('lang_name', $lang_id);
if (isset($_REQUEST['upload']) && $_REQUEST['upload']) {
if (!isset($_REQUEST['action'])) {
$_REQUEST['action'] = "";
}
switch ($_REQUEST['action']) {
case 'upgrade':
$do_upgrade = true;
$do_update = false;
break;
case 'update':
$do_upgrade = false;
$do_update = true;
echo ' <tr class="small"';
if ($shade) {
echo ' bgcolor="' . $color['list_shade1'] . '"';
} else {
echo ' bgcolor="' . $color['list_shade2'] . '"';
}
if (!$line['enabled']) {
echo ' style="font-style: italic;"';
}
echo '>
<TD>' . $line['budget_id'] . '</TD>
<TD>' . ($line['enabled'] ? lang('y') : lang('n')) . '</TD>
<td>' . $line['budget_name'] . '</td>
<td>' . experiment__list_experimenters($line['experimenter'], false, true) . '</td>
<td>' . $line['budget_limit'] . '</td>';
if (check_allow('payments_budget_edit')) {
echo '<td valign=top>';
echo '<A HREF="payments_budget_edit.php?budget_id=' . $line['budget_id'] . '">' . lang('edit') . '</A>';
echo '</td>';
}
echo '</tr>';
if ($shade) {
$shade = false;
} else {
$shade = true;
}
}
echo '</tbody></table>';
echo '<BR><BR>
<A href="options_main.php">' . icon('back') . ' ' . lang('back') . '</A><BR><BR>';
echo '</CENTER>';
<?php
// part of orsee. see orsee.org
ob_start();
$old_versions = array('orsee2' => 'versions <3.0');
$title = "prepare_data_import";
$menu__area = "options_main";
include "header.php";
if ($proceed) {
check_allow('import_data', 'options_main.php');
}
if ($proceed) {
$continue = true;
echo '<center>';
if ($continue) {
$databases = array();
$query = "SELECT `SCHEMA_NAME`\n FROM `INFORMATION_SCHEMA`.`SCHEMATA`\n WHERE `SCHEMA_NAME` NOT IN ('information_schema','mysql')";
$result = or_query($query);
while ($line = pdo_fetch_assoc($result)) {
if ($line['SCHEMA_NAME'] != $site__database_database) {
$databases[] = $line['SCHEMA_NAME'];
}
}
// first step:
if (!isset($_REQUEST['old_version']) || !isset($old_versions[$_REQUEST['old_version']]) || !isset($_REQUEST['old_database']) || !in_array($_REQUEST['old_database'], $databases)) {
$continue = false;
echo '<FORM action="' . thisdoc() . '" method="POST">';
echo '<TABLE class="or_formtable">';
echo ' <TR><TD>From which ORSEE version do you want to import data?</TD>
<TD><SELECT name="old_version">';
foreach ($old_versions as $ov => $text) {
<TD>
' . lang('answer_in_xxxlang') . ' ' . $language . '
</TD>
<TD>
<textarea name="answer[' . $language . ']" cols=40 rows=20 wrap=virtual>' . stripslashes($answer[$language]) . '</textarea>
</TD>
</TR>';
}
echo ' <TR>
<TD COLSPAN=2 align=center>
<INPUT class="button" name=edit type=submit value="';
if ($faq_id) {
echo lang('change');
} else {
echo lang('add');
}
echo '">
</TD>
</TR>
</table>
</FORM>
<BR>';
if ($faq_id && check_allow('faq_delete')) {
echo '<BR><BR>
' . button_link('faq_delete.php?faq_id=' . urlencode($faq_id), lang('delete'), 'trash-o');
}
echo '<BR><BR>
<A href="faq_main.php">' . icon('back') . ' ' . lang('back') . '</A><BR><BR>
</center>';
}
include "footer.php";
$jquery = array();
include "header.php";
if ($proceed) {
if (isset($_REQUEST['item_name'])) {
$item_name = $_REQUEST['item_name'];
} else {
redirect("admin/options_profile_template.php");
}
}
if ($proceed) {
if (!in_array($item_name, array('profile_form_public', 'profile_form_admin_part'))) {
redirect("admin/options_profile_template.php");
}
}
if ($proceed) {
$allow = check_allow('pform_templates_edit', 'options_main.php');
}
if ($proceed) {
$t = options__load_object('profile_form_template', $item_name);
}
if ($proceed) {
if (!isset($_REQUEST['subpool_id'])) {
$subpool_id = 1;
} else {
$subpool_id = $_REQUEST['subpool_id'];
}
$subpool = orsee_db_load_array("subpools", $subpool_id, "subpool_id");
if (!$subpool['subpool_id']) {
$subpool = orsee_db_load_array("subpools", 1, "subpool_id");
}
}
if (in_array($k, $fields)) {
$columns[] = $k;
}
}
}
if (count($columns) == 0) {
message(lang('no_data_columns_selected'));
redirect('admin/' . thisdoc());
} else {
$query = "SELECT count(*) as num_matches, " . implode(', ', $columns) . "\n FROM " . table('participants') . "\n GROUP BY " . implode(', ', $columns) . "\n HAVING num_matches>1\n ORDER BY num_matches DESC";
$result = or_query($query);
$dupvals = array();
while ($line = pdo_fetch_assoc($result)) {
$dupvals[] = $line;
}
if (check_allow('participants_edit')) {
echo javascript__edit_popup();
}
$part_statuses = participant_status__get_statuses();
$cols = participant__get_result_table_columns('result_table_search_duplicates');
echo '<TABLE class="or_listtable"><thead>';
echo '<TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';">';
echo '<TD> </TD>';
echo participant__get_result_table_headcells($cols, false);
echo '</TR></thead>
<tbody>';
$num_cols = count($cols) + 1;
foreach ($dupvals as $dv) {
$mvals = array();
$pars = array();
$qclause = array();
$titem = orsee_db_load_array("lang", $id, "lang_id");
$done = false;
$formfields = participantform__load();
$allow_cat = $item;
foreach ($formfields as $f) {
if (preg_match("/(select_lang|radioline_lang)/", $f['type']) && $item == $f['mysql_column_name']) {
$done = true;
$header = isset($lang[$f['name_lang']]) ? $lang[$f['name_lang']] : $f['name_lang'];
$headervar = lang('lang');
$reset_part_field = $f['mysql_column_name'];
$deletion_message = lang('symbol_deleted');
$allow_cat = 'pform_lang_field';
break;
}
}
$allow = check_allow($allow_cat . '_delete', 'lang_item_edit.php?id=' . $id . '&item=' . $item);
}
if ($proceed) {
switch ($item) {
case 'experimentclass':
$header = lang('delete_experiment_class');
$headervar = lang('lang');
$reset_part_field = "";
$deletion_message = lang('experiment_class_deleted');
break;
case 'public_content':
$header = lang('delete_public_content');
$headervar = "content_name";
$reset_part_field = "";
$deletion_message = lang('public_content_deleted');
break;
} else {
redirect("admin/");
}
}
if ($proceed) {
if (isset($_REQUEST['betternot']) && $_REQUEST['betternot']) {
redirect('admin/events_edit.php?event_id=' . $event_id);
}
}
if ($proceed) {
if (isset($_REQUEST['reallydelete']) && $_REQUEST['reallydelete']) {
$reallydelete = true;
} else {
$reallydelete = false;
}
$allow = check_allow('events_delete', 'events_edit.php?event_id=' . $event_id);
}
if ($proceed) {
$space = orsee_db_load_array("events", $event_id, "event_id");
if ($reallydelete) {
$pars = array('event_id' => $event_id);
$query = "DELETE FROM " . table('events') . "\n WHERE event_id= :event_id";
$result = or_query($query, $pars);
log__admin("events_delete", "event_id:" . $event_id);
message(lang('lab_reservation_deleted'));
redirect('admin/calendar_main.php');
}
}
if ($proceed) {
// form
echo ' <CENTER>
</TR>';
if ($session_id) {
echo '
<TR>
<TD COLSPAN=2 align="right">
<INPUT class="button" name="copy" type="submit" value="' . lang('copy_as_new_session') . '">
</TD>
</TR>';
}
echo '
</table>
</FORM>
<BR>';
if ($session_id) {
$reg = experiment__count_participate_at($edit['experiment_id'], $session_id);
if ($reg == 0 && check_allow('session_empty_delete') || check_allow('session_nonempty_delete')) {
echo '
<table>
<TR>
<TD>
' . button_link('session_delete.php?session_id=' . $edit['session_id'], lang('delete'), 'trash-o') . '
</TD>
</TR>
</table>';
}
}
if ($session_id) {
$experiment_id = $edit['experiment_id'];
} else {
$experiment_id = $_REQUEST['experiment_id'];
}
<?php
// part of orsee. see orsee.org
ob_start();
$menu__area = "statistics";
$title = "budget_reports";
include "header.php";
if ($proceed) {
if (!(check_allow('payments_budget_view_my') || check_allow('payments_budget_view_all'))) {
redirect('admin/statistics_main.php');
}
}
if ($proceed) {
if (check_allow('payments_budget_view_all')) {
$restriction = "";
$pars = array();
} else {
$pars = array(':adminname' => '%|' . $expadmindata['adminname']) . '|%';
$restriction = " experimenter LIKE :adminname ";
}
// get budgets
$query = "SELECT * FROM " . table('budgets') . " " . $restriction . "\n ORDER BY enabled DESC, budget_name";
$result = or_query($query, $pars);
$shade = false;
$budgets = array();
$budget_ids = array();
while ($line = pdo_fetch_assoc($result)) {
$budgets[$line['budget_id']] = $line;
$budget_ids[] = $line['budget_id'];
}
if (count($budgets) == 0) {
if ($proceed) {
if ($experiment_id > 0) {
$experiment = orsee_db_load_array("experiments", $experiment_id, "experiment_id");
if (!isset($experiment['experiment_id'])) {
$experiment_id = 0;
}
}
}
if ($proceed) {
if ($experiment_id > 0) {
$experimenters = db_string_to_id_array($experiment['experimenter']);
if (!(in_array($expadmindata['admin_id'], $experimenters) && check_allow('file_download_experiment_my') || check_allow('file_download_experiment_all'))) {
redirect('admin/experiment_show.php?experiment_id=' . $experiment_id);
}
} else {
$allow = check_allow('file_download_general', 'download_main.php');
}
}
if ($proceed) {
// load file specification
$filedata = orsee_db_load_array("uploads_data", $upload_id, "upload_id");
// mime type
$mime_type = $upload['upload_mimetype'];
if (!$mime_type) {
$mime_type = downloads__mime_type($upload['upload_suffix']);
}
if (!$mime_type) {
$mime_type = "text/*";
}
$filename = str_replace(" ", "_", $upload['upload_name']) . "." . $upload['upload_suffix'];
ob_end_clean();
ob_start();
$menu__area = "options";
$title = "delete_symbol";
include "header.php";
if ($proceed) {
if (isset($_REQUEST['lang_id']) && $_REQUEST['lang_id']) {
$lang_id = $_REQUEST['lang_id'];
} else {
$lang_id = "";
}
if (!$lang_id) {
redirect("admin/lang_main.php");
}
}
if ($proceed) {
$allow = check_allow('lang_symbol_delete', 'lang_symbol_edit.php?lang_id=' . $lang_id);
}
if ($proceed) {
if (isset($_REQUEST['betternot']) && $_REQUEST['betternot']) {
redirect('admin/lang_symbol_edit.php?lang_id=' . $lang_id);
}
}
if ($proceed) {
if (isset($_REQUEST['reallydelete']) && $_REQUEST['reallydelete']) {
$reallydelete = true;
} else {
$reallydelete = false;
}
$symbol = orsee_db_load_array("lang", $lang_id, "lang_id");
if (!isset($symbol['lang_id'])) {
redirect("admin/lang_main.php");
$lang_icons_prepare = true;
include "header.php";
if ($proceed) {
if (!$_REQUEST['experiment_id']) {
redirect("admin/");
} else {
$experiment_id = $_REQUEST['experiment_id'];
}
}
if ($proceed) {
$allow = check_allow('experiment_recruitment_report_show', 'experiment_show.php?experiment_id=' . $experiment_id);
}
if ($proceed) {
// load experiment data into array experiment
$experiment = orsee_db_load_array("experiments", $experiment_id, "experiment_id");
if (!check_allow('experiment_restriction_override')) {
check_experiment_allowed($experiment, "admin/experiment_show.php?experiment_id=" . $experiment_id);
}
}
if ($proceed) {
$alllangs = get_languages();
if (isset($_REQUEST['replang']) && in_array($_REQUEST['replang'], $alllangs) && $_REQUEST['replang'] != lang('lang')) {
$replang = $_REQUEST['replang'];
} else {
$replang = lang('lang');
}
$lang_names = lang__get_language_names();
$switchlang_text = '';
foreach ($alllangs as $thislang) {
if ($thislang != $replang) {
$switchlang_text .= '<A HREF="' . thisdoc() . '?experiment_id=' . $experiment_id . '&replang=' . $thislang . '"><span class="languageicon langicon-' . $thislang . '">';
<?php
// part of orsee. see orsee.org
ob_start();
$menu__area = "options";
$title = "edit_language";
include "header.php";
if ($proceed) {
$allow = check_allow('lang_symbol_edit', 'lang_main.php');
}
if ($proceed) {
echo '<center>';
// load languages
$languages = get_languages();
if (isset($_REQUEST['el']) && $_REQUEST['el'] && in_array($_REQUEST['el'], $languages)) {
$el = $_REQUEST['el'];
} else {
$el = $settings['admin_standard_language'];
}
if (isset($_REQUEST['search']) && $_REQUEST['search']) {
$search = $_REQUEST['search'];
} else {
$search = '';
}
if (isset($_REQUEST['letter']) && $_REQUEST['letter']) {
$letter = $_REQUEST['letter'];
} else {
$letter = 'a';
}
if (isset($_REQUEST['alter_lang']) && $_REQUEST['alter_lang'] && isset($_REQUEST['symbols']) && is_array($_REQUEST['symbols'])) {
$pars = array();
}
if ($hide_header) {
include "nonoutputheader.php";
html__header();
echo '<basefont face="Arial,Helvetica,sans-serif"><center><BR>';
echo '<TABLE width="90%" border="0"><TR><TD style="border-radius: 20px 20px 20px 20px; background: ' . $color['content_background_color'] . ';"><BR>';
} else {
include "header.php";
}
if ($proceed) {
if (isset($_REQUEST['participant_id']) && $_REQUEST['participant_id']) {
$participant_id = $_REQUEST['participant_id'];
} else {
$participant_id = "";
}
$allow = check_allow('participants_edit', 'participants_main.php');
}
if ($proceed) {
$statuses = participant_status__get_statuses();
$continue = true;
$errors__dataform = array();
if (isset($_REQUEST['add']) && $_REQUEST['add']) {
// checks and errors
foreach ($_REQUEST as $k => $v) {
if (!is_array($v)) {
$_REQUEST[$k] = trim($v);
}
}
$errors__dataform = participantform__check_fields($_REQUEST, true);
$error_count = count($errors__dataform);
if ($error_count > 0) {
$subpool_id = "";
}
if (!$subpool_id || !$subpool_id > 1) {
redirect('admin/subpool_edit.php?subpool_id=' . $subpool_id);
}
if (isset($_REQUEST['betternot']) && $_REQUEST['betternot']) {
redirect('admin/subpool_edit.php?subpool_id=' . $subpool_id);
}
}
if ($proceed) {
if (isset($_REQUEST['reallydelete']) && $_REQUEST['reallydelete']) {
$reallydelete = true;
} else {
$reallydelete = false;
}
$allow = check_allow('subjectpool_delete', 'subpool_edit.php?subpool_id=' . $subpool_id);
}
if ($proceed) {
// load languages
$languages = get_languages();
$exptypes = load_external_experiment_types();
// load subject pool
$subpool = orsee_db_load_array("subpools", $subpool_id, "subpool_id");
if (!isset($subpool['subpool_id'])) {
redirect("admin/subpool_main.php");
}
}
if ($proceed) {
$exptype_ids = db_string_to_id_array($subpool['experiment_types']);
$subpool['exptypes'] = array();
foreach ($exptype_ids as $exptype_id) {
}
}
echo '
</td>
<td>
<a href="admin_edit.php?admin_id=' . $admin['admin_id'] . '">' . lang('edit') . '</a>
</td>
</tr>';
if ($shade) {
$shade = false;
} else {
$shade = true;
}
}
echo '</tbody>';
if (check_allow('admin_edit')) {
echo '<tfoot><tr>
<td colspan=5></td>
<td><INPUT name="change" type="submit" class="button" value="' . lang('save_changes_in_list') . '"></td>
<td></td>
</tr></tfoot>';
}
echo '</table></FORM>
<br><br>';
echo '<A HREF="mailto:' . $settings['support_mail'] . '?bcc=' . implode(",", $enabled_emails) . '">' . lang('write_message_to_all_enabled_admins') . '</A>';
echo '<BR><BR>';
echo '<A HREF="mailto:' . $settings['support_mail'] . '?bcc=' . implode(",", $emails) . '">' . lang('write_message_to_all_listed') . '</A>';
echo '<br><br>
</center>';
}
<?php
// part of orsee. see orsee.org
ob_start();
$title = "participant_profile_fields";
$menu__area = "options_main";
include "header.php";
if ($proceed) {
$allow = check_allow('pform_config_field_configure', 'options_main.php');
}
if ($proceed) {
$user_columns = participant__userdefined_columns();
foreach ($user_columns as $k => $arr) {
$user_columns[$k]['has_index'] = 0;
$user_columns[$k]['is_configured'] = 0;
}
$query = "SHOW INDEX FROM " . table('participants');
$result = or_query($query);
while ($line = pdo_fetch_assoc($result)) {
if (isset($user_columns[$line['Column_name']])) {
$user_columns[$line['Column_name']]['has_index'] = 1;
}
}
$query = "SELECT * FROM " . table('profile_fields');
$result = or_query($query);
$redundant = array();
while ($line = pdo_fetch_assoc($result)) {
if (isset($user_columns[$line['mysql_column_name']])) {
$user_columns[$line['mysql_column_name']]['is_configured'] = 1;
$user_columns[$line['mysql_column_name']]['enabled'] = $line['enabled'];
$user_columns[$line['mysql_column_name']]['type'] = $line['type'];
</TD>
<TD>
<TEXTAREA type=text name="lang_icon_base64" cols=40 rows=10 wrap=virtual>' . $tlang_icon . '</TEXTAREA>
</TD>
</TR>';
echo ' <TR>
<TD colspan=2 align=center>
<INPUT class="button" type=submit name="add" value="' . lang('change') . '">
</TD>
</TR>
</TABLE>
</FORM>';
echo '<TABLE width="80%" border=0>
<TR>
<TD width="50%" align=center>';
if (check_allow('lang_lang_export')) {
echo button_link('lang_lang_export.php?lang_id=' . urlencode($tlang), lang('export_language'), 'cloud-upload');
}
echo ' </TD>
<TD width=50% align=center>';
if (check_allow('lang_lang_import')) {
echo button_link('lang_lang_import.php?lang_id=' . urlencode($tlang), lang('import_language'), 'cloud-download');
}
echo ' </TD>
</TR>
</TABLE>';
echo '<BR><BR>
<A href="lang_main.php">' . icon('back') . ' ' . lang('back') . '</A><BR><BR>
</center>';
}
include "footer.php";
function mailqueue__show_mailqueue($experiment_id = "", $limit = -1)
{
global $lang, $color, $options, $proceed;
if ($proceed) {
$pars = array();
if ($limit == -1 && $experiment_id && isset($options['mailqueue_experiment_number_of_entries_per_page']) && $options['mailqueue_experiment_number_of_entries_per_page']) {
$limit = $options['mailqueue_experiment_number_of_entries_per_page'];
} elseif ($limit == -1 && isset($options['mailqueue_number_of_entries_per_page']) && $options['mailqueue_number_of_entries_per_page']) {
$limit = $options['mailqueue_number_of_entries_per_page'];
} else {
$limit = 100;
}
if (isset($_REQUEST['os']) && $_REQUEST['os'] > 0) {
$offset = $_REQUEST['os'];
} else {
$offset = 0;
}
if ($experiment_id) {
$equery = " AND experiment_id=:experiment_id ";
$pars[':experiment_id'] = $experiment_id;
} else {
$equery = "";
}
if (isset($_REQUEST['deleteall']) && $_REQUEST['deleteall']) {
$dall = true;
} else {
$dall = false;
}
if (isset($_REQUEST['deleteallonpage']) && $_REQUEST['deleteallonpage']) {
$dallpage = true;
} else {
$dallpage = false;
}
if (isset($_REQUEST['deletesel']) && $_REQUEST['deletesel']) {
$dsel = true;
} else {
$dsel = false;
}
}
if ($proceed) {
if ($dall || $dallpage || $dsel) {
if ($experiment_id) {
$allow = check_allow('mailqueue_edit_experiment', 'experiment_mailqueue_show?experiment_id=' . $experiment_id);
} else {
$allow = check_allow('mailqueue_edit_all', 'mailqueue_show.php');
}
$where_clause = " WHERE mail_id IS NOT NULL " . $equery;
$ok = false;
if ($dall) {
$ok = true;
}
if ($dallpage) {
$tallids = array();
if (isset($_REQUEST['allids']) && trim($_REQUEST['allids'])) {
$tallids = explode(",", trim($_REQUEST['allids']));
}
if (count($tallids) > 0) {
$i = 0;
$parnames = array();
foreach ($tallids as $id) {
$i++;
$tparname = ':mailid' . $i;
$parnames[] = $tparname;
$pars[$tparname] = $id;
}
$where_clause .= " AND mail_id IN (" . implode(",", $parnames) . ") ";
$ok = true;
} else {
message(lang('error__mailqueue_delete_no_emails_selected'));
$ok = false;
}
}
if ($dsel) {
$dids = array();
if (isset($_REQUEST['del']) && is_array($_REQUEST['del'])) {
foreach ($_REQUEST['del'] as $k => $v) {
if ($v == 'y') {
$dids[] = $k;
}
}
}
if (count($dids) > 0) {
$i = 0;
$parnames = array();
foreach ($dids as $id) {
$i++;
$tparname = ':mailid' . $i;
$parnames[] = $tparname;
$pars[$tparname] = $id;
}
$where_clause .= " AND mail_id IN (" . implode(",", $parnames) . ") ";
$ok = true;
} else {
message(lang('error__mailqueue_delete_no_emails_selected'));
$ok = false;
}
}
if ($ok) {
$query = "DELETE FROM " . table('mail_queue') . $where_clause;
//echo $query;
$done = or_query($query, $pars);
$number = pdo_num_rows($done);
message($number . ' ' . lang('xxx_emails_deleted_from_queue'));
if ($experiment_id) {
if ($number > 0) {
log__admin("mailqueue_delete_entries", "Experiment: " . $experiment_id . ", Count: " . $number);
}
} else {
if ($number > 0) {
log__admin("mailqueue_delete_entries", "Count: " . $number);
}
}
}
if ($experiment_id) {
redirect("admin/experiment_mailqueue_show.php?experiment_id=" . $experiment_id);
} else {
redirect("admin/mailqueue_show.php");
}
}
}
if ($proceed) {
$pars = array();
if ($experiment_id) {
$equery = " AND experiment_id=:experiment_id ";
$pars[':experiment_id'] = $experiment_id;
} else {
$equery = "";
}
$pars[':offset'] = $offset;
$pars[':limit'] = $limit;
$query = "SELECT * FROM " . table('mail_queue') . "\n WHERE mail_id IS NOT NULL " . $equery . " ORDER BY timestamp DESC\n LIMIT :offset , :limit";
$result = or_query($query, $pars);
$num_rows = pdo_num_rows($result);
if ($experiment_id && check_allow('mailqueue_edit_experiment')) {
echo '<FORM action="experiment_mailqueue_show.php" method="POST">
<INPUT type="hidden" name="experiment_id" value="' . $experiment_id . '">';
} elseif (check_allow('mailqueue_edit_all')) {
echo '<FORM action="mailqueue_show.php" method="POST">';
}
echo '<TABLE width=90% border=0>
<TR><TD width=50%>';
//echo '<FONT class="small">'.lang('query').': '.$query.'</FONT><BR><BR>';
echo ' </TD>
<TD align=right width=50%>';
if (check_allow('mailqueue_edit_all')) {
echo '
<TABLE width="100%" border="0">
<TR><TD width="33%" align="right">
<input class="button" type=submit name="deleteall" value="' . lang('delete_all') . '">
</TD><TD width="33%" align="right">
<input class="button" type=submit name="deleteallonpage" value="' . lang('delete_all_on_page') . '">
</TD><TD width="33%" align="right">
<input class="button" type=submit name="deletesel" value="' . lang('delete_selected') . '">
</TD></TR>
</TABLE>
';
}
echo '</TD></TR></TABLE>';
if ($offset > 0) {
echo '[' . log__link('os=' . ($offset - $limit)) . lang('previous') . '</A>]';
} else {
echo '[' . lang('previous') . ']';
}
echo ' ';
if ($num_rows >= $limit) {
echo '[' . log__link('os=' . ($offset + $limit)) . lang('next') . '</A>]';
} else {
echo '[' . lang('next') . ']';
}
echo '<TABLE class="or_listtable" style="width: 90%;"><thead>';
// header
echo '
<thead>
<TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';">
<TD>' . lang('id') . '</TD>
<TD>' . lang('date_and_time') . '</TD>
<TD>' . lang('email_type') . '</TD>
<TD>' . lang('email_recipient') . '</TD>
<TD>' . lang('reference') . '</TD>
<TD>' . lang('error') . '</TD>';
if (check_allow('mailqueue_edit_all')) {
echo '<TD>
' . lang('select_all') . '
<INPUT id="selall" type="checkbox" name="selall" value="y">
<script language="JavaScript">
$("#selall").change(function() {
if (this.checked) {
$("input[name*=\'del[\']").each(function() {
this.checked = true;
});
} else {
$("input[name*=\'del[\']").each(function() {
this.checked = false;
});
}
});
</script>
</TD>';
}
echo '
</TR>
</thead>
<tbody>
';
$shade = false;
$ids = array();
$experiment_ids = array();
$entries = array();
while ($line = pdo_fetch_assoc($result)) {
$ids[] = $line['mail_id'];
if ($line['experiment_id']) {
$experiment_ids[] = $line['experiment_id'];
}
$entries[] = $line;
}
$experiments = experiment__load_experiments_for_ids($experiment_ids);
foreach ($entries as $line) {
echo '<TR';
if ($shade) {
$shade = false;
} else {
$shade = true;
}
if ($shade) {
echo ' bgcolor="' . $color['list_shade1'] . '"';
} else {
echo ' bgcolor="' . $color['list_shade2'] . '"';
}
echo '>
<TD>' . $line['mail_id'] . '</TD>
<TD>' . ortime__format($line['timestamp'], 'hide_second:false', lang('lang')) . '</TD>
<TD>' . $line['mail_type'] . '</TD>
<TD>' . $line['mail_recipient'] . '</TD>
<TD>';
$reference = array();
if ($line['experiment_id']) {
$reference[] = 'Experiment: <A HREF="experiment_show.php?experiment_id=' . $line['experiment_id'] . '">' . $experiments[$line['experiment_id']]['experiment_name'] . '</A>';
}
if ($line['session_id']) {
$reference[] = 'Session: <A HREF="session_edit.php?session_id=' . $line['session_id'] . '">' . $line['session_id'] . '</A>';
}
if ($line['bulk_id']) {
$reference[] = 'Bulk email: ' . $line['bulk_id'];
}
echo implode('<BR>', $reference);
echo '</TD>
<TD>' . $line['error'] . '</TD>';
if (check_allow('mailqueue_edit_all')) {
echo '<TD><INPUT type="checkbox" name="del[' . $line['mail_id'] . ']" value="y"></TD';
}
echo '</TR>';
}
echo '</tbody></TABLE>';
if (check_allow('mailqueue_edit_all')) {
echo '<INPUT type="hidden" name="allids" value="' . implode(",", $ids) . '">';
echo '</FORM>';
}
return $num_rows;
}
}
if ($allow_order && isset($_REQUEST['save_order']) && $_REQUEST['save_order']) {
if (isset($_REQUEST['langitem_order']) && is_array($_REQUEST['langitem_order']) && count($_REQUEST['langitem_order']) > 0) {
$done = language__save_item_order($item, $_REQUEST['langitem_order']);
message(lang('new_order_saved'));
redirect('admin/lang_item_main.php?item=' . urlencode($item));
}
}
}
if ($proceed) {
echo '<center>';
echo '<TABLE class="or_page_subtitle" style="background: ' . $color['page_subtitle_background'] . '; color: ' . $color['page_subtitle_textcolor'] . '">
<TR><TD align="center">
' . $header . '
</TD>';
echo '</TR></TABLE><br>';
if (check_allow($allow_cat . '_add')) {
echo ' <BR>
' . button_link('lang_item_edit.php?item=' . urlencode($item) . '&addit=true', lang('create_new'), 'plus-circle') . '<BR><BR>';
}
// load languages
$languages = get_languages();
// $item already sanitized above
if ($show_part_stats) {
$num_p = array();
$query = "SELECT " . $item . " as type_p,\n count(*) as num_p\n FROM " . table('participants') . "\n GROUP BY " . $item;
$result = or_query($query);
while ($line = pdo_fetch_assoc($result)) {
$num_p[$line['type_p']] = $line['num_p'];
}
}
$query = "SELECT *\n FROM " . table('lang') . "\n WHERE content_type='" . $item . "'\n " . $where . "\n ORDER BY " . $order;
<?php
// part of orsee. see orsee.org
ob_start();
$jquery = array();
$title = "mailqueue";
$menu__area = "statistics";
include "header.php";
if ($proceed) {
$allow = check_allow('mailqueue_show_all', 'statistics_main.php');
}
if ($proceed) {
echo '<center>';
mailqueue__show_mailqueue();
echo '<BR><BR><A href="statistics_main.php">' . icon('back') . ' ' . lang('back') . '</A><BR><BR>';
echo '</center>';
}
include "footer.php";
echo '
</TD>
<TD>';
if ($inputform == 'area') {
echo '<textarea name="' . $language . '" cols=50 rows=20 wrap=virtual>' . stripslashes($titem[$language]) . '</textarea>';
} else {
echo '<INPUT name="' . $language, '" type="text" size=30 maxlength=100 value="' . stripslashes($titem[$language]) . '">';
}
echo ' </TD>
</TR>';
}
echo ' </TABLE>
<TABLE>
<TR>
<TD COLSPAN=2 align=center>
<INPUT class="button" name=edit type=submit value="' . $button_title . '">
</TD>
</TR>
</table>
</FORM>
<BR>';
if ($id && check_allow($allow_cat . '_delete')) {
echo '<BR><BR>
' . button_link('lang_item_delete.php?id=' . urlencode($id) . '&item=' . urlencode($item), lang('delete'), 'trash-o') . '
';
}
echo '<BR><BR>
<A href="lang_item_main.php?item=' . $item . '"><i class="fa fa-level-up fa-lg" style="padding-right: 3px;"></i>' . lang('back') . '</A><BR><BR>
</center>';
}
include "footer.php";
<?php
// part of orsee. see orsee.org
ob_start();
$title = "send_bulk_mail";
include "header.php";
if ($proceed) {
$allow = check_allow('participants_bulk_mail', 'participants_main.php');
}
if ($proceed) {
if (isset($_REQUEST['send']) && $_REQUEST['send']) {
$send = true;
} else {
$send = false;
}
// load invitation languages
$inv_langs = lang__get_part_langs();
$plist_ids = $_SESSION['plist_ids'];
$number = count($plist_ids);
if ($send) {
if (!is_array($plist_ids) || count($plist_ids) < 1) {
redirect("admin/");
}
}
}
if ($proceed) {
if ($send) {
// checks
$bulk = $_REQUEST;
$continue = true;
foreach ($inv_langs as $inv_lang) {
<?php
// part of orsee. see orsee.org
ob_start();
$menu__area = "statistics";
$title = "system_statistics";
include "header.php";
if ($proceed) {
$allow = check_allow('statistics_system_show', 'statistics_main.php');
}
if ($proceed) {
echo '<center>';
$data['participant_actions'] = stats__get_participant_action_data();
$_SESSION['stats_data'] = $data;
$out = stats__stats_display_table($data['participant_actions']);
echo '<TABLE class="or_formtable" style="width: 90%">
<TR><TD colspan="2">
<TABLE width="100%" border=0 class="or_panel_title"><TR>
<TD style="background: ' . $color['panel_title_background'] . '; color: ' . $color['panel_title_textcolor'] . '" align="center">
' . $data['participant_actions']['title'] . '
</TD>
</TR></TABLE>
</TD></TR>';
echo '<TR>';
echo '<TD valign="top" align="left" style="width: 50%">' . $out . '</TD>';
echo '<TD valign="top" align="center" style="width: 50%">';
echo '<img border="0" src="statistics_graph.php?stype=participant_actions">';
echo '</td>';
echo '</TR>';
echo '</TABLE>';
echo '<BR><BR><A href="statistics_main.php">' . icon('back') . ' ' . lang('back') . '</A><BR><BR>';
echo '<BR>
<table class="or_listtable"><thead>
<TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';">
<TD></TD>
<TD>' . lang('enabled?') . '</TD>
<TD>' . lang('when_executed?') . '</TD>
<TD>' . lang('last_execution') . '</TD>
<TD></TD>
<TD></TD>
</TR>
</thead>
<tbody>';
$query = "SELECT *\n FROM " . table('cron_jobs') . "\n ORDER BY job_name";
$result = or_query($query);
$allow_run = check_allow('regular_tasks_run');
$allow_edit = check_allow('regular_tasks_edit');
$shade = true;
while ($line = pdo_fetch_assoc($result)) {
echo ' <tr';
if ($shade) {
echo ' bgcolor="' . $color['list_shade1'] . '"';
} else {
echo ' bgcolor="' . $color['list_shade2'] . '"';
}
if ($shade) {
$shade = false;
} else {
$shade = true;
}
if ($line['enabled'] == 'n') {
echo ' style="color: #888"';
<?php
// part of orsee. see orsee.org
ob_start();
$menu__area = "options";
$title = "sub_subjectpools";
include "header.php";
if ($proceed) {
$allow = check_allow('subjectpool_edit', 'options_main.php');
}
if ($proceed) {
echo '<center>';
if (check_allow('subjectpool_add')) {
echo '<BR>' . button_link('subpool_edit.php?addit=true', lang('create_new'), 'plus-circle');
}
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>' . lang('description') . '</TD>
<TD>' . lang('subjects') . '</TD>
<TD></TD>
</TR></thead>
<tbody>';
$part_counts = array();
$query = "SELECT count(*) as part_count, subpool_id FROM " . table('participants') . " GROUP BY subpool_id";
$result = or_query($query);
while ($line = pdo_fetch_assoc($result)) {
$part_counts[$line['subpool_id']] = $line['part_count'];
}
// part of orsee. see orsee.org
ob_start();
$menu__area = "options";
$title = "edit_cronjob";
include "header.php";
if ($proceed) {
if (isset($_REQUEST['job_name'])) {
$job_name = $_REQUEST['job_name'];
} else {
$job_name = "";
}
if ($job_name) {
$allow = check_allow('regular_tasks_edit', 'cronjob_main.php');
} else {
$allow = check_allow('regular_tasks_add', 'cronjob_main.php');
}
}
if ($proceed) {
// load languages
$languages = get_languages();
if ($job_name) {
$job = orsee_db_load_array("cron_jobs", $job_name, "job_name");
} else {
$job = array('job_name' => '', 'enabled' => 'n', 'job_last_exec' => 0, 'job_time' => '');
}
$continue = true;
if (isset($_REQUEST['edit']) && $_REQUEST['edit']) {
if (!$_REQUEST['job_name']) {
message(lang('name_for_cronjob_required'));
$continue = false;
<?php
// part of orsee. see orsee.org
ob_start();
$title = "faq_long";
$menu__area = "options_main";
include "header.php";
if ($proceed) {
$allow = check_allow('faq_edit', 'options_main.php');
}
if ($proceed) {
echo '<center>';
if (check_allow('faq_add')) {
echo '
<BR>
' . button_link('faq_edit.php?addit=true', lang('create_new'), 'plus-circle');
}
// load languages
$languages = get_languages();
echo '<BR><BR>
<table class="or_listtable" style="width: 80%;"><thead>
<TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';">';
foreach ($languages as $language) {
echo '<td class="small">' . $language . '</td>';
}
echo '<TD>' . lang('this_faq_answered_questions_of_xxx') . '</TD>
<TD></TD>
</TR></thead>
<tbody>';
$query = "SELECT *\n FROM " . table('faqs') . ", " . table('lang') . "\n WHERE content_type='faq_question'\n AND " . table('faqs') . ".faq_id=" . table('lang') . ".content_name\n ORDER BY " . lang('lang');
$result = or_query($query);
echo ' DISABLED';
}
if (in_array($language, $enabled_part)) {
echo ' CHECKED';
}
echo '>
</TD>
<TD>';
if (check_allow('lang_lang_edit')) {
echo '<A HREF="lang_lang_edit.php?elang=' . $language . '">' . lang('edit_basic_data') . '</A>';
}
echo ' </TD>
<TD>';
if (check_allow('lang_symbol_edit')) {
echo '<A HREF="lang_edit.php?el=' . $language . '">' . lang('edit_words_for') . ' "' . $language . '"</A>';
}
echo ' </TD>
</TD>
</TR>';
}
echo '</tbody>';
if (check_allow('lang_avail_edit')) {
echo ' <tfoot><TR><TD colspan=2></TD><TD align=center colspan=2>
<INPUT class="button" type=submit name="change_def" value="' . lang('change') . '">
</TD><TD></TD>
</TR></tfoot>';
}
echo '</TABLE></FORM>';
echo '</center>';
}
include "footer.php";
