function pbmailpage($options, $content)
{
if (!is_user_logged_in()) {
return __t("You must login to view the mail page.");
}
$v = validate();
if ($v[0] != 'success') {
return $v[1];
}
// error message
extract($v[1]);
// $student, $problem, $focus, $sid
$name = nicefiedUsername($sid, FALSE);
$r = '';
global $wpdb;
$students = getStudents();
$cstudents = count($students);
$r .= reselector($students, $cstudents);
$r .= '<hr style="width:80%;align:center;">';
if ($problem !== NULL) {
$finished = $wpdb->get_var($wpdb->prepare("SELECT time FROM " . $wpdb->prefix . "pb_completed WHERE userid = %d AND problem = %s", $sid, $problem['slug']));
$r .= '<div class="history-note">' . sprintf(__t('Mail about %1$s [%3$s] for %2$s'), $problem['publicname'], userString($sid), '<a href="' . $problem['url'] . '">' . __t('link to original page') . '</a>');
$r .= '</div>';
if ($finished !== NULL) {
$r .= "<img title='" . $student->user_login . __t(" has completed this problem.") . "' src='" . UFILES . "checked.png' class='pycheck'/>";
} else {
$r .= "<img title='" . $student->user_login . __t(" has not completed this problem.") . "' src='" . UFILES . "icon.png' class='pycheck'/>";
}
if ($finished !== NULL) {
$r .= "<div class='history-prenote'>" . sprintf(__t('Note: this student completed the problem at %s'), $finished) . "</div>";
}
$r .= '<i>' . __t('Click on a message title to toggle the message open or closed.') . '</i>';
global $mailcond;
$messages = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "pb_mail WHERE ustudent = %d AND problem = %s AND {$mailcond} ORDER BY ID desc", $sid, $problem['slug']), ARRAY_A);
foreach ($messages as $i => $message) {
$c = $message['ID'] == $focus ? " showing" : " hiding";
$idp = $message['ID'] == $focus ? " id='m' " : '';
$r .= "<div {$idp} class='collapseContain{$c}' style='border-radius: 5px;'>";
$title = __t("From") . " " . nicefiedUsername($message['ufrom'], FALSE) . ' ' . __t('to') . ' ' . nicefiedUsername($message['uto'], FALSE) . ', ' . $message['time'];
if (count($messages) > 1 && $i == 0) {
$title .= " " . __t("(newest)");
}
if (count($messages) > 1 && $i == count($messages) - 1) {
$title .= " " . __t("(oldest)");
}
$r .= "<div class='collapseHead'><span class='icon'></span>{$title}</div>";
$r .= "<div class='collapseBody'><span class='quoth'>" . __t("Quote/<br/>Reply") . "</span>" . preBox($message['body'], -1, 10000, "font-size:12px; line-height:14px; white-space: pre-wrap;") . '</div>';
$r .= '</div>';
}
$to = "";
if (getUserID() == $sid) {
$guru_login = get_the_author_meta('pbguru', get_current_user_id());
$guru = get_user_by('login', $guru_login);
// FALSE if does not exist
$to .= '<div style="text-align: center">';
$to .= __t('Send a question by e-mail to: ');
if ($guru !== FALSE) {
$to .= "<select class='recipient'>\n<option value='1'>" . __t("My guru") . " ({$guru_login})</option>\n<option value='-1'>" . __t("CS Circles Assistant") . "</option>\n</select></div>";
} else {
$to .= "<select class='recipient'>\n<option value='-1'>" . __t("CS Circles Assistant") . "</option>\n<option value='0'>" . __t("(No guru is specified)") . "</option>\n</select>";
$to .= '<br/></div>';
}
}
$r .= '<div class="pybox fixsresize mailform" id="mailform">
<div id="bodyarea" class="pyboxTextwrap">
<textarea name="body" class="resizy" placeholder="' . __t('Type here to send a reply about this problem') . '" style="width:100%; white-space: pre-wrap; font-size: 11px; line-height:13px" rows=12></textarea>
</div>
' . $to;
if (getUserID() != $sid) {
$r .= '<input style="position:relative; top:2px" type="checkbox" id="noreply" onclick="toggleVisibility(\'bodyarea\')">' . ' <label style="font-size:75%" for="noreply">' . __t('Just mark as read without replying') . '</label><br>';
}
$r .= '<button onclick="mailReply(' . $sid . ',\'' . $problem['slug'] . '\');">' . __t('Send this message!') . '</button>
</div>';
$problemname = $problem['publicname'];
$r .= '<hr style="width:80%;align:center;">';
if (getUserID() != $sid) {
$r .= "<div class='history-note'><a href='" . cscurl('progress') . '?user='******'>" . sprintf(__t("%s's progress page (new window)"), $name) . "</a></div>";
}
$r .= "\n<div class='collapseContain hiding'>\n<div class='collapseHead'><span class='icon'></span>" . __t("Problem description for") . " " . $problem['publicname'] . "</div>\n<div class='collapseBody'>" . apply_filters('the_content', pyBoxHandler(json_decode($problem['shortcodeArgs'], TRUE), $problem['content'])) . "</div>\n</div>";
if (getUserID() != $sid) {
$r .= niceFlex('us', sprintf(__t('%1$s\'s submissions for %2$s'), $name, $problemname), 'problem-history', 'dbProblemHistory', array('user' => $sid, 'p' => $problem['slug']));
}
$r .= niceFlex('ms', sprintf(__t("My previous submissions for %s"), $problemname), 'problem-history', 'dbProblemHistory', array('p' => $problem['slug']));
if (getUserID() != $sid) {
$r .= niceFlex('omp', sprintf(__t("My other messages about %s"), $problemname), 'mail', 'dbMail', array('what' => $problem['slug'], 'xwho' => $sid));
}
$r .= niceFlex('oms', getUserID() == $sid ? __t("My messages for other programs") : sprintf(__t("Messages to/from %s for other problems"), $name), 'mail', 'dbMail', array('who' => $sid, 'xwhat' => $problem['slug']));
}
if ($cstudents > 0 || userIsAssistant()) {
$r .= niceFlex('allstu', sprintf(__t("All messages ever about %s's work"), $name), 'mail', 'dbMail', array('who' => $sid));
}
$r .= niceFlex('allme', __t("All messages ever to or from me"), 'mail', 'dbMail', array());
return $r;
}
function pyUser($options, $content)
{
if (!is_user_logged_in()) {
return __t("You must login to view your user page.");
}
global $wpdb;
$user = wp_get_current_user();
$uid = $user->ID;
$students = getStudents();
$cstudents = count($students);
$problem_table = $wpdb->prefix . "pb_problems";
$problems = $wpdb->get_results("SELECT * FROM {$problem_table} WHERE facultative = 0 AND lang = '" . currLang2() . "' AND lesson IS NOT NULL ORDER BY lesson ASC, boxid ASC", ARRAY_A);
$problemsByNumber = array();
foreach ($problems as $prow) {
$problemsByNumber[$prow['slug']] = $prow;
}
$gp = getSoft($_GET, "problem", "");
if ($gp != "" && $gp != "console" && !array_key_exists($gp, $problemsByNumber)) {
echo sprintf(__t("Problem %s not found (at least in current language)"), $gp);
return;
}
if (userIsAdmin() || userIsAssistant() || $cstudents > 0) {
$preamble = "<div class='progress-selector'>\n <form method='get'><table style='border:none'><tr><td>" . sprintf(__t("View one of your students? (you have %s)"), $cstudents) . '</td><td>';
$options = array();
$options[''] = __t('Show only me');
$options['all'] = __t('Summary of all my students');
if (!userIsAdmin()) {
foreach ($students as $student) {
$info = get_userdata($student);
$options[$info->ID] = userString($info->ID);
}
}
if (userIsAdmin()) {
$preamble .= 'blank: you; "all": all; id#: user (<a href="' . cscurl('allusers') . '">list</a>) <input style = "padding:0px;width:60px" type="text" name="user" value="' . getSoft($_REQUEST, 'user', '') . '">';
} else {
$preamble .= optionsHelper($options, 'user');
}
$preamble .= '</td></tr><tr><td>';
$preamble .= __t("Just show submissions for one problem?");
$options = array();
$options[''] = __t('Show all');
$options['console'] = __t('Console');
foreach ($problems as $problem) {
if ($problem['type'] == 'code') {
$options[$problem['slug']] = $problem['publicname'];
}
}
$preamble .= '</td><td>';
$preamble .= optionsHelper($options, 'problem');
$preamble .= "</td></tr><tr><td colspan='2' style='text-align:center'><input style='width: 25%' type='submit' value='" . __t('Submit') . "'/></tr></td></table></form></div>";
echo $preamble;
}
$allStudents = isSoft($_GET, 'user', 'all');
$viewingAsStudent = '' == getSoft($_GET, 'user', '');
$allProblems = $gp == "";
if (!$viewingAsStudent) {
if ($allProblems) {
$problem_html = "all problems";
} else {
if ($gp == 'console') {
$problem_html = "Console";
} else {
$problem_html = "<a href='" . $problemsByNumber[$gp]['url'] . "'>" . $problemsByNumber[$gp]['publicname'] . "</a>";
}
}
}
if (!$allStudents && array_key_exists('user', $_GET) && $_GET['user'] != '') {
if (!is_numeric($_GET['user'])) {
return __t("User id must be numeric.");
}
$getuid = (int) $_GET['user'];
if (userIsAdmin() || userIsAssistant()) {
if (get_userdata($getuid) === FALSE) {
return __t("Invalid user id.");
}
} else {
if (!in_array($getuid, $students)) {
return __t("Invalid user id.");
}
}
$uid = $getuid;
$user = get_userdata($uid);
echo "<div class='history-prenote'>" . sprintf(__t("Now viewing %s for "), $problem_html) . userString($uid) . '</div>';
}
if ($allStudents) {
echo "<div class='history-prenote'>" . sprintf(__t("Now viewing %s for all of your students"), $problem_html) . "</div>";
}
/***************** end of header ***************/
$flexigrids = "";
$completed_table = $wpdb->prefix . "pb_completed";
if ($allStudents && !$allProblems && $gp != "console") {
$flexigrids .= niceFlex('perstudent', sprintf(__t("Solutions by my students for %s"), $problemsByNumber[$_GET['problem']]['publicname']), 'problem-summary', 'dbProblemSummary', array('p' => $_GET['problem']));
}
$dbparams = array();
if (getSoft($_GET, 'user', '') != '') {
$dbparams['user'] = $_GET['user'];
}
if (getSoft($_GET, 'problem', '') != '') {
$dbparams['problemhash'] = $_GET['problem'];
}
$flexigrids .= niceFlex('submittedcode', $allProblems ? __t("Submitted code") : sprintf(__t("Submitted code for %s"), $_GET['problem'] == 'console' ? 'Console' : $problemsByNumber[$_GET['problem']]['publicname']), 'entire-history', 'dbEntireHistory', $dbparams);
$recent = "";
if (!$allStudents) {
// queries more than 6 in order to fill out progress table of all problems
$completed = $wpdb->get_results("SELECT * FROM {$completed_table} WHERE userid = {$uid} ORDER BY time DESC", ARRAY_A);
$recent .= '<div class="recent"><span class="latest-title">' . __t("Latest problems completed") . ":</span>";
// but for now we only use 6 entries for "most recently completed" section
for ($i = 0; $i < count($completed) && $i < 6; $i++) {
$p = getSoft($problemsByNumber, $completed[$i]['problem'], FALSE);
if ($p !== FALSE) {
if (getSoft($_GET, 'user', '') != '') {
if ($problemsByNumber[$p['slug']]['type'] == 'code') {
$url = '.?user='******'user'] . '&problem=' . $p['slug'];
} else {
$url = null;
}
} else {
$url = $p['url'];
}
$recent .= ' <a class="open-same-window problem-completed" ';
if ($url != null) {
$recent .= ' href="' . $url . '" ';
}
$recent .= ' title="' . $completed[$i]['time'] . '">' . $p['publicname'] . '</a>';
} else {
$recent .= '[' . $completed[$i]['problem'] . ']';
}
}
$recent .= '</div>';
}
$submissions_table = $wpdb->prefix . "pb_submissions";
$studentTable = '';
if ($allStudents && !userIsAdmin()) {
$studentList = getStudentList();
$where = "WHERE userid in {$studentList}";
if (!$allProblems) {
$where .= $wpdb->prepare("and problem LIKE %s", $gp);
}
// show number of problems each student completed
$scompleted = $wpdb->get_results("SELECT userid, count(1) as comps from {$completed_table} {$where} GROUP BY userid", OBJECT_K);
// show number of submissions by each student for this problem
$ssubmissions = $wpdb->get_results("SELECT userid, count(1) as subs from {$submissions_table} {$where} GROUP BY userid", OBJECT_K);
$studentTable .= '<div class="history-note">Student listing (click name to drill down)</div>';
$studentTable .= '<table>';
foreach (getStudents() as $stu) {
$studentTable .= '<tr>';
$studentTable .= '<td>';
$studentTable .= '<a class="open-same-window" href="?user='******'&problem=' . $gp . '">';
$studentTable .= userString($stu);
$studentTable .= '</a></td>';
$studentTable .= '<td>';
if ($allProblems) {
$studentTable .= (array_key_exists($stu, $scompleted) ? $scompleted[$stu]->comps : 0) . ' completed';
} else {
$studentTable .= '<img src="' . UFILES . (array_key_exists($stu, $scompleted) ? 'checked' : 'icon') . '.png"/>';
}
$studentTable .= '</td>';
$studentTable .= '<td>';
$studentTable .= (array_key_exists($stu, $ssubmissions) ? $ssubmissions[$stu]->subs : 0) . ' submissions';
$studentTable .= '</td>';
$studentTable .= '</tr>';
}
$studentTable .= '</table>';
}
$lessons_table = $wpdb->prefix . "pb_lessons";
$lessons = $wpdb->get_results("SELECT * FROM {$lessons_table} WHERE lang = '" . currLang2() . "'", ARRAY_A);
$lessonsByNumber = array();
foreach ($lessons as $lrow) {
$lessonsByNumber[$lrow['ordering']] = $lrow;
}
$overview = '';
if ($allProblems || !$allStudents) {
$overview = '<h2 style="margin-top:5px;text-align:center">' . __t('List of all problems') . ' ' . ($allStudents ? __t('(with #completed)') : __t('(with #submissions)')) . '</h2>';
if (!$viewingAsStudent) {
$overview .= "<div style='text-align:center'>Click on the <img style='height:1em,width:1em' src='" . UFILES . "/icon.png'> to drill down.</div>";
}
$checkIt = array();
//array from slug to boolean, whether to check the icon
$showNum = array();
//array from slug to number, number to display beside each
if ($allStudents) {
if (userIsAdmin() || userIsAssistant()) {
$completed = $wpdb->get_results("SELECT count(userid), problem from {$completed_table} GROUP BY problem", ARRAY_A);
} else {
$studentList = getStudentList();
$completed = $wpdb->get_results("SELECT count(userid), problem from {$completed_table} WHERE userid in {$studentList} GROUP BY problem", ARRAY_A);
}
foreach ($completed as $crow) {
$showNum[$crow['problem']] = $crow['count(userid)'];
}
} else {
$submissions = $wpdb->get_results("SELECT count(1), problem from {$submissions_table} WHERE userid = {$uid} GROUP BY problem", ARRAY_A);
foreach ($submissions as $srow) {
$showNum[$srow['problem']] = $srow['count(1)'];
}
foreach ($completed as $crow) {
// this was queried earlier
$checkIt[$crow['problem']] = TRUE;
}
}
$overview .= '<table style="width:auto;border:none;margin:0px auto;">';
$lesson = -1;
$lrow = NULL;
$llink = "";
$firstloop = true;
foreach ($problems as $prow) {
if ($prow['lesson'] != $lesson) {
if (!$firstloop) {
$overview .= "</td></tr>\n";
}
$firstloop = false;
$overview .= "<tr><td class='lessoninfo'>";
$lesson = $prow['lesson'];
$lrow = $lessonsByNumber[$lesson];
$overview .= '<a class="open-same-window" href="';
$llink = get_page_link($lrow['id']);
$overview .= $llink;
$overview .= '">';
$overview .= $lrow['number'] . ": " . $lrow['title'];
$overview .= '</a></td><td>';
}
if (!$viewingAsStudent) {
// drill-down link
$url = '.?user='******'user'] . '&problem=' . $prow['slug'];
} else {
$url = $prow['url'];
}
$overview .= '<a class="open-same-window" ';
if ($url != null) {
$overview .= ' href="' . $url . '" ';
}
$overview .= '>';
$overview .= '<table class="history-tablette" ><tr class="history-tablette-top"><td>';
$overview .= '<img style="margin:-10px 0px" title="' . $prow['publicname'] . '" src="' . UFILES . (isSoft($checkIt, $prow['slug'], TRUE) ? 'checked' : 'icon') . '.png"/>';
$overview .= '</a></td></tr><tr class="history-tablette-bottom"><td>';
/* $overview .= '<a class="open-same-window" ';
if ($url != null) $overview .= ' href="' . $url . '" ';
$overview .= '>';*/
$overview .= array_key_exists($prow['slug'], $showNum) ? $showNum[$prow['slug']] : ' ';
$overview .= '</td></tr></table></a>';
}
$overview .= '</table>';
}
return "<div class='userpage'>{$flexigrids} {$recent} {$studentTable} {$overview}</div>";
}