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";