function test_retrieve_UserProfile_RMHStaffApprover($userProfileId)
{
$users = retrieve_UserProfile_RMHStaffApprover($userProfileId);
if ($users == false) {
echo "</br>" . "No user were found";
} else {
echo "</br>" . "found user" . "</br>";
foreach ($users as $user) {
display_user($user);
}
}
}
function get_all_mails($link)
{
try {
$query = "SELECT * FROM MAILING_LIST";
$preparedStatement = $link->prepare($query);
$preparedStatement->execute();
while ($result = $preparedStatement->fetch()) {
display_user($result);
}
} catch (PDOException $e) {
echo 'Error in DB request: ' . $e->getMessage();
}
}
function wpu_get_users($content)
{
if (is_page(get_option('wpu_page_id'))) {
if (isset($_GET['uid'])) {
display_user();
} else {
echo $content;
display_user_list();
}
} else {
//display the content
return $content;
}
}
function show_edit_form($id, $sid, $assign)
{
global $m, $langGradeOk, $tool_content, $course_code;
$sub = Database::get()->querySingle("SELECT * FROM assignment_submit WHERE id = ?d", $sid);
if (count($sub) > 0) {
$uid_2_name = display_user($sub->uid);
if (!empty($sub->group_id)) {
$group_submission = "({$m['groupsubmit']} " . "<a href='../group/group_space.php?course={$course_code}&group_id={$sub->group_id}'>" . "{$m['ofgroup']} " . gid_to_name($sub->group_id) . "</a>)";
} else {
$group_submission = '';
}
$tool_content .= "\n <form method='post' action='index.php?course={$course_code}'>\n <input type='hidden' name='assignment' value='{$id}'>\n <input type='hidden' name='submission' value='{$sid}'>\n <fieldset>\n <legend>{$m['addgradecomments']}</legend>\n <table width='99%' class='tbl'>\n <tr>\n <th class='left' width='180'>{$m['username']}:</th>\n <td>{$uid_2_name} " . q($group_submission) . "</td>\n </tr>\n <tr>\n <th class='left'>{$m['sub_date']}:</th>\n <td>" . q($sub->submission_date) . "</td></tr>\n <tr>\n <th class='left'>{$m['filename']}:</th>\n <td><a href='index.php?course={$course_code}&get={$sub->id}'>" . q($sub->file_name) . "</a></td>\n </tr>\n <tr>\n <th class='left'>{$m['grade']}:</th>\n <td><input type='text' name='grade' maxlength='3' size='3' value='" . q($sub->grade) . "'></td></tr>\n <tr>\n <th class='left'>{$m['gradecomments']}:</th>\n <td><textarea cols='60' rows='3' name='comments'>" . q($sub->grade_comments) . "</textarea></td>\n </tr>\n <tr>\n <th><label for='email_button'>{$m['email_users']}:</label></th>\n <td><input type='checkbox' value='1' id='email_button' name='email'></td>\n </tr>\n <tr>\n <th class='left'> </th>\n <td><input class='btn btn-primary' type='submit' name='grade_comments' value='{$langGradeOk}'></td>\n </tr>\n </table>\n </fieldset>\n </form><br>";
} else {
Session::Messages($m['WorkNoSubmission'], 'alert-danger');
redirect_to_home_page('modules/work/index.php?course=' . $course_code . '&id=' . $id);
}
}
function getSidebarMessages()
{
global $uid, $urlServer, $langFrom, $dateFormatLong, $langDropboxNoMessage;
$message_content = '';
$mbox = new Mailbox($uid, 0);
$msgs = $mbox->getInboxMsgs('', 5);
$msgs = array_filter($msgs, function ($msg) {
return !$msg->is_read;
});
if (!count($msgs)) {
$message_content .= "<li class='list-item'>" . "<span class='item-wholeline'>" . $langDropboxNoMessage . "</span>" . "</li>";
} else {
foreach ($msgs as $message) {
if ($message->course_id > 0) {
$course_title = q(ellipsize(course_id_to_title($message->course_id), 30));
} else {
$course_title = '';
}
$message_date = claro_format_locale_date($dateFormatLong, $message->timestamp);
$message_content .= "<li class='list-item'>" . "<span class='item-wholeline'>" . "<div class='text-title'>{$langFrom} " . display_user($message->author_id, false, false) . ":<br>" . "<a href='{$urlServer}modules/dropbox/index.php?mid={$message->id}'>" . q($message->subject) . "</a>" . "</div>" . "<div class='text-grey'>{$course_title}</div>" . "<div>{$message_date}</div>" . "</span>" . "</li>";
}
}
return $message_content;
}
($myrow->id == $_SESSION["uid"] && $myrow->reviewer == '1') ||
($myrow->id != $_SESSION["uid"] && $is_opencourses_reviewer && $is_admin)
)
)
));
//die(var_dump($myrow->id == $_SESSION["uid"] && $myrow->reviewer == '1'));
$user_roles = array();
($myrow->status == '1') ? array_push($user_roles, $langTeacher) : array_push($user_roles, $langStudent);
if ($myrow->tutor == '1') array_push($user_roles, $langTutor);
if ($myrow->editor == '1') array_push($user_roles, $langEditor);
if ($myrow->reviewer == '1') array_push($user_roles, $langOpenCoursesReviewer);
//setting datables column data
$data['aaData'][] = array(
'DT_RowId' => getIndirectReference($myrow->id),
'DT_RowClass' => 'smaller',
'0' => display_user($myrow->id) . " <span>(<a href='mailto:" . $myrow->email . "'>" . $myrow->email . "</a>) $am_message</span>",
'1' => "<small>".implode(', ', $user_roles)."</small>",
'2' => user_groups($course_id, $myrow->id),
'3' => $date_field,
'4' => $user_role_controls
);
}
echo json_encode($data, JSON_UNESCAPED_UNICODE);
exit();
}
$limit = isset($_REQUEST['limit']) ? intval($_REQUEST['limit']) : 0;
$toolName = $langUsers;
load_js('tools.js');
load_js('datatables');
$message = "<p class='success'>{$langGradebookEdit}</p>";
$tool_content .= $message . "<br/>";
}
}
//display the form and the list
$result = Database::get()->querySingle("SELECT * FROM gradebook_activities WHERE id = ?d", $actID);
$tool_content .= "<div class='alert alert-info'>" . $result->title . "</div>";
//show all the students
$resultUsers = Database::get()->queryArray("SELECT gradebook_users.id as recID, gradebook_users.uid as userID, user.surname as surname, user.givenname as name, user.am as am, course_user.reg_date as reg_date FROM gradebook_users, user, course_user WHERE gradebook_id = ?d AND gradebook_users.uid = user.id AND `user`.id = `course_user`.`user_id` AND `course_user`.`course_id` = ?d ", $gradebook_id, $course_id);
if ($resultUsers) {
//table to display the users
$tool_content .= "\n <form method='post' action='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&ins=" . $actID . "'>\n <table id='users_table{$course_id}' class='table-default custom_list_order'>\n <thead>\n <tr>\n <th width='1'>{$langID}</th>\n <th><div align='left' width='150'>{$langName} {$langSurname}</div></th>\n <th class='text-center' width='80'>{$langRegistrationDateShort}</th>\n <th class='text-center'>{$langGradebookGrade}</th>\n <th class='text-center'>{$langAttendanceBooking}</th>\n </tr>\n </thead>\n <tbody>";
$cnt = 0;
foreach ($resultUsers as $resultUser) {
$cnt++;
$tool_content .= "\n <tr>\n <td>{$cnt}</td>\n <td>" . display_user($resultUser->userID) . " ({$langAm}: {$resultUser->am})</td>\n <td>" . nice_format($resultUser->reg_date) . "</td>";
$tool_content .= "\n <td>";
if (weightleft($gradebook_id, 0) == 0) {
$tool_content .= userGradeTotal($gradebook_id, $resultUser->userID);
} elseif (userGradeTotal($gradebook_id, $resultUser->userID) != "-") {
//alert message only when grades have been submitted
$tool_content .= userGradeTotal($gradebook_id, $resultUser->userID) . " (<small>" . $langGradebookGradeAlert . "</small>)";
}
if (userGradeTotal($gradebook_id, $resultUser->userID) > $gradebook_range) {
$tool_content .= "<br><div class='smaller'>" . $langGradebookOutRange . "</div>";
}
$tool_content .= "<td class='text-center'>\n <input type='text' name='" . $resultUser->userID . "'";
//check if the user has attendace for this activity already OR if it should be automatically inserted here
$q = Database::get()->querySingle("SELECT grade FROM gradebook_book WHERE gradebook_activity_id = ?d AND uid = ?d", $actID, $resultUser->userID);
if (isset($q->grade)) {
$tool_content .= " value = '{$q->grade}'";
Session::Messages($langAttendanceEdit, "alert-success");
redirect_to_home_page("modules/attendance/index.php");
}
}
//display the form and the list
$result = Database::get()->querySingle("SELECT * FROM attendance_activities WHERE id = ?d", $actID);
$tool_content .= "<div class='alert alert-info'>" . $result->title . "</div>";
//show all the students
$resultUsers = Database::get()->queryArray("SELECT attendance_users.id as recID, attendance_users.uid as userID, user.surname as surname, user.givenname as name, user.am as am, course_user.reg_date as reg_date FROM attendance_users, user, course_user WHERE attendance_id = ?d AND attendance_users.uid = user.id AND `user`.id = `course_user`.`user_id` AND `course_user`.`course_id` = ?d ", $attendance_id, $course_id);
if ($resultUsers) {
//table to display the users
$tool_content .= "\n <form method='post' action='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&ins=" . $actID . "'>\n <table id='users_table{$course_id}' class='table-default custom_list_order'>\n <thead>\n <tr>\n <th width='1'>{$langID}</th>\n <th><div align='left' width='100'>{$langName} {$langSurname}</div></th>\n <th class='center' width='80'>{$langRegistrationDateShort}</th>\n <th class='center'>{$langAttendanceAbsences}</th>\n <th class='center'>{$langActions}</th>\n </tr>\n </thead>\n <tbody>";
$cnt = 0;
foreach ($resultUsers as $resultUser) {
$cnt++;
$tool_content .= "\n <tr>\n <td>{$cnt}</td>\n <td> " . display_user($resultUser->userID) . " ({$langAm}: {$resultUser->am})</td>\n <td>" . nice_format($resultUser->reg_date) . "</td>\n <td>" . userAttendTotal($attendance_id, $resultUser->userID) . "/" . $attendance_limit . "</td>\n <td class='center'>\n <input class='form-control' type='checkbox' value='1' name='" . $resultUser->userID . "'";
//check if the user has attendace for this activity already OR if it should be automatically inserted here
$q = Database::get()->querySingle("SELECT attend FROM attendance_book WHERE attendance_activity_id = ?d AND uid = ?d", $actID, $resultUser->userID);
if (isset($q->attend) && $q->attend == 1) {
$tool_content .= " checked";
}
$tool_content .= ">\n <input type='hidden' value='" . $actID . "' name='actID'>\n </td>";
$tool_content .= "\n </tr>";
}
$tool_content .= "</tbody></table> <input type='submit' class='btn btn-default' name='bookUsersToAct' value='{$langAttendanceBooking}' /></form>";
}
$showAttendanceActivities = 0;
}
//DISPLAY: list of attendance activities
if ($showAttendanceActivities == 1) {
//get all the available activities
$pageName = $langUserDuration;
$navigation[] = array('url' => 'index.php?course=' . $course_code, 'name' => $langUsage);
statistics_tools($course_code, "userduration");
// display number of users
$tool_content .= "\n <div class='alert alert-info'>\n <b>{$langDumpUserDurationToFile}: </b>1. <a href='userduration.php?course={$course_code}&format=csv'>{$langcsvenc2}</a>\n 2. <a href='userduration.php?course={$course_code}&format=csv&enc=1253'>{$langcsvenc1}</a>\n </div>";
$tool_content .= "\n <table class='tbl_alt' width='99%'>\n <tr>\n <th class='left'> {$langSurname} {$langName}</th>\n <th>{$langAm}</th>\n <th>{$langGroup}</th>\n <th>{$langDuration}</th>\n </tr>";
}
$result = user_duration_query($course_id);
if (count($result) > 0) {
$i = 0;
foreach ($result as $row) {
$i++;
$grp_name = user_groups($course_id, $row->id, $format);
if ($format == 'html') {
if ($i % 2 == 0) {
$tool_content .= "<tr class='even'>";
} else {
$tool_content .= "<tr class='odd'>";
}
$tool_content .= "<td class='bullet'>" . display_user($row->id) . "</td>\n <td class='center'>{$row->am}</td>\n <td class='center'>{$grp_name}</td>\n <td class='center'>" . format_time_duration(0 + $row->duration) . "</td>\n </tr>";
} else {
echo csv_escape($row->surname . ' ' . $row->givenname), ';', csv_escape($row->am), ';', csv_escape($grp_name), ';', csv_escape(format_time_duration(0 + $row->duration)), $crlf;
}
}
if ($format == 'html') {
$tool_content .= "</table>";
}
}
if ($format == 'html') {
draw($tool_content, 2);
}
$require_current_course = true;
$require_course_admin = true;
$require_help = true;
$helpTopic = 'Usage';
$require_login = true;
require_once '../../include/baseTheme.php';
require_once 'modules/group/group_functions.php';
require_once "statistics_tools_bar.php";
statistics_tools($course_code, "group");
$navigation[] = array('url' => 'index.php?course=' . $course_code, 'name' => $langUsage);
$pageName = $langGroupUsage;
initialize_group_info();
$q = Database::get()->queryArray("SELECT id, name, g.description, max_members, COUNT(*) AS registered\n\t FROM `group` AS g, group_members AS gm\n\t\t WHERE g.course_id = ?d AND g.id = gm.group_id\n\t\t GROUP BY g.id", $course_id);
if (count($q) > 0) {
$tool_content .= "<div class='table-responsive'><table class='table-default'>\n\t\t<tr>\n\t\t <th class='text-left'>{$langGroupName}</th>\n\t\t <th class='text-center'>{$langGroupTutor}</th>\n\t\t <th class='text-center'>{$langRegistered}</th>\n\t\t <th class='text-center'>{$langMax}</th>\n\t\t</tr>";
foreach ($q as $group) {
$tool_content .= "<td>\n\t\t\t<a href='../group/group_usage.php?course={$course_code}&module=usage&group_id={$group->id}'>" . q($group->name) . "</a></td>";
$tool_content .= "<td>" . display_user(group_tutors($group->id)) . "</td>";
$tool_content .= "<td class='text-center'>{$group->registered}</td>";
if ($group->max_members == 0) {
$tool_content .= "<td class='text-center'>-</td>";
} else {
$tool_content .= "<td class='text-center'>{$group->max_members}</td>";
}
$tool_content .= "</tr>";
}
$tool_content .= "</table></div>";
} else {
$tool_content .= "<div class='alert alert-danger'>{$langNoGroup}</div>";
}
draw($tool_content, 2);
/**
* @brief get user personal messages
* @global type $uid
* @global type $urlServer
* @global type $langFrom
* @global type $dateFormatLong
* @param type $lesson_id
* @return string
*/
function getUserMessages() {
global $uid, $urlServer, $langFrom, $dateFormatLong;
$message_content = '';
$mbox = new Mailbox($uid, 0);
$msgs = $mbox->getInboxMsgs('', 5);
foreach ($msgs as $message) {
if ($message->course_id > 0) {
$course_title = q(ellipsize(course_id_to_title($message->course_id), 30));
} else {
$course_title = '';
}
$message_date = claro_format_locale_date($dateFormatLong, $message->timestamp);
$message_content .= "<li class='list-item'>
<div class='item-wholeline'>
<div class='text-title'>$langFrom ".display_user($message->author_id, false, false).":
<a href='{$urlServer}modules/dropbox/index.php?mid=$message->id'>" .q($message->subject)."</a>
</div>
<div class='text-grey'>$course_title</div>
<div>$message_date</div>
</div>
</li>";
}
return $message_content;
}
$post_actions .= icon('fa-times', $langDelete).'</a>';
$post_actions .='</div>';
$response[0] = 'OK';
$response[1] = "<div class='alert alert-success'>".$langCommentsSaveSuccess."</div>";
$response[2] = $comment->getId();
$response[3] = "
<div class='row margin-bottom-thin margin-top-thin comment' id='comment-".$comment->getId()."'>
<div class='col-xs-12'>
<div class='media'>
<a class='media-left' href='#'>
". profile_image($comment->getAuthor(), IMAGESIZE_SMALL) ."
</a>
<div class='media-body bubble'>
<div class='label label-success media-heading'>".nice_format($comment->getTime(), true).'</div>'.
"<small>".$langBlogPostUser.display_user($comment->getAuthor(), false, false)."</small>".
$post_actions
."<div class='margin-top-thin' id='comment_content-".$comment->getId()."'>". q($comment->getContent()) ."</div>
</div>
</div>
</div>
</div>
";
} else {
$response[0] = 'ERROR';
$response[1] = "<div class='alert alert-warning'>".$langCommentsSaveFail."</div>";
}
} else {
$response[0] = 'ERROR';
$response[1] = "<div class='alert alert-warning'>".$langCommentsNewNoPerm."</div>";
}
/**
* display action details in course users administration
* @global type $langUnCourse
* @global type $langOfUser
* @global type $langToUser
* @global type $langOneByOne
* @global type $langGiveRightAdmin
* @global type $langGiveRightΕditor
* @global type $langGiveRightTutor
* @global type $langRemoveRightAdmin
* @global type $langRemoveRightEditor
* @global type $langRemoveRightAdmin
* @param type $details
* @return string
*/
private function course_user_action_details($details)
{
global $langUnCourse, $langOfUser, $langToUser, $langNewUser, $langGiveRightAdmin, $langGiveRightEditor, $langGiveRightTutor, $langRemoveRightAdmin, $langRemoveRightEditor, $langRemoveRightAdmin;
$details = unserialize($details);
switch ($details['right']) {
case '+5':
$content = $langNewUser;
break;
case '0':
$content = "{$langUnCourse} {$langOfUser}";
break;
case '+1':
$content = "{$langGiveRightAdmin} {$langToUser}";
break;
case '+2':
$content = "{$langGiveRightEditor} {$langToUser}";
break;
case '+3':
$content = "{$langGiveRightTutor} {$langToUser}";
break;
case '-1':
$content = "{$langRemoveRightAdmin} {$langToUser}";
break;
case '-2':
$content = "{$langRemoveRightEditor} {$langToUser}";
break;
case '-3':
$content = "{$langRemoveRightAdmin} {$langToUser}";
break;
}
$content .= " «" . display_user($details['uid'], false, false) . "»";
return $content;
}
/**
* display action details in abuse reports
* @global type $langcreator
* @global type $langAbuseReportCat
* @global type $langSpam
* @global type $langRudeness
* @global type $langOther
* @global type $langMessage
* @global type $langComment
* @global type $langForumPost
* @global type $langAbuseResourceType
* @global type $langContent
* @global type $langAbuseReportStatus
* @global type $langAbuseReportOpen
* @global type $langAbuseReportClosed
* @param type $details
* @return string
*/
private function abuse_report_action_details($details)
{
global $langcreator, $langAbuseReportCat, $langSpam, $langRudeness, $langOther, $langMessage, $langComment, $langForumPost, $langAbuseResourceType, $langContent, $langAbuseReportStatus, $langAbuseReportOpen, $langAbuseReportClosed, $langLinks;
$reports_cats = array('rudeness' => $langRudeness, 'spam' => $langSpam, 'other' => $langOther);
$resource_types = array('comment' => $langComment, 'forum_post' => $langForumPost, 'link' => $langLinks);
$details = unserialize($details);
$content = "{$langcreator}: " . display_user($details['user_id'], false, false) . "<br/>";
$content .= "{$langAbuseReportCat}: «" . $reports_cats[$details['reason']] . "»<br/>";
$content .= "{$langMessage}: «" . q($details['message']) . "»<br/>";
$content .= "{$langAbuseResourceType}: «" . $resource_types[$details['rtype']] . "»<br/>";
if ($details['rtype'] == 'comment') {
$content .= "{$langContent}: «" . q($details['rcontent']) . "»<br/>";
} elseif ($details['rtype'] == 'forum_post') {
$content .= "{$langContent}: «" . mathfilter($details['rcontent'], 12, "../courses/mathimg/") . "»<br/>";
}
if ($details['status'] == 1) {
$content .= "{$langAbuseReportStatus}: «" . $langAbuseReportOpen . "»";
} elseif ($details['status'] == 0) {
$content .= "{$langAbuseReportStatus}: «" . $langAbuseReportClosed . "»";
}
return $content;
}
<li class='list-group-item list-header'>
<div class='row'>
<div class='text-center'>
<b>$langGroupMembers</b>
</div>
</div>
<div class='row'>
<div class='col-xs-4'>$langSurnameName</div>
<div class='col-xs-4'>$langAm</div>
<div class='col-xs-4'>$langEmail</div>
</div>
</li>";
foreach ($members as $member) {
$user_group_description = $member->description;
$tool_content .= "<li class='list-group-item'><div class='row'><div class='col-xs-4'>" . display_user($member->id, false, true);
if ($user_group_description) {
$tool_content .= "<br />" . q($user_group_description);
}
$tool_content .= "</div><div class='col-xs-4'>";
if (!empty($member->am)) {
$tool_content .= q($member->am);
} else {
$tool_content .= '-';
}
$tool_content .= "</div><div class='col-xs-4'>";
$email = q(trim($member->email));
if (!empty($email)) {
$tool_content .= "<a href='mailto:$email'>$email</a>";
} else {
$tool_content .= '-';
$tool_content_tutor = $langGroupNoTutor;
}
$tool_content .= "<tr><th class='text-left'>{$langGroupTutor}:</th>\n <td>{$tool_content_tutor}</td></tr>";
$group_description = trim($group_description);
if (empty($group_description)) {
$tool_content_description = $langGroupNone;
} else {
$tool_content_description = q($group_description);
}
$tool_content .= "<tr><th class='left'>{$langDescription}:</th>\n <td>{$tool_content_description}</td></tr>";
// members
$tool_content .= "<tr>\n <th class='left' valign='top'>{$langGroupMembers}:</th>\n <td>\n <table class='table-default'>\n <tr>\n <th class='left'>{$langSurnameName}</th>\n <th class='center' width='120'>{$langAm}</th>\n <th class='center' width='150'>{$langEmail}</th>\n </tr>";
if (count($members) > 0) {
foreach ($members as $member) {
$user_group_description = $member->description;
$tool_content .= "<td>" . display_user($member->id);
if ($user_group_description) {
$tool_content .= "<br />" . q($user_group_description);
}
$tool_content .= "</td><td class='center'>";
if (!empty($member->am)) {
$tool_content .= q($member->am);
} else {
$tool_content .= '-';
}
$tool_content .= "</td><td class='text-center'>";
$email = q(trim($member->email));
if (!empty($email)) {
$tool_content .= "<a href='mailto:{$email}'>{$email}</a>";
} else {
$tool_content .= '-';
function display_user($user, $print_email = false, $icon = true, $class = "")
{
global $langAnonymous, $urlAppend;
if (count($user) == 0) {
return '-';
} elseif (is_array($user)) {
$begin = true;
$html = '';
foreach ($user as $user_data) {
if (!isset($user->user_id)) {
if ($begin) {
$begin = false;
} else {
$html .= '<br>';
}
$html .= display_user($user_data->user_id, $print_email);
}
}
return $html;
} elseif (!is_array($user)) {
$r = Database::get()->querySingle("SELECT id, surname, givenname, username, email, has_icon FROM user WHERE id = ?d", $user);
if ($r) {
$user = $r;
} else {
if ($icon) {
return profile_image(0, IMAGESIZE_SMALL) . ' ' . $langAnonymous;
} else {
return $langAnonymous;
}
}
}
if ($print_email) {
$email = trim($user->email);
$print_email = $print_email && !empty($email);
}
if ($icon) {
$icon = profile_image($user->id, IMAGESIZE_SMALL, 'img-circle') . ' ';
}
if (!empty($class)) {
$class_str = "class='{$class}'";
} else {
$class_str = "";
}
$token = token_generate($user->id, true);
$student_name = $user->surname || $user->givenname ? q($user->surname) . " " . q($user->givenname) : $user->username;
return "{$icon}<a {$class_str} href='{$urlAppend}main/profile/display_profile.php?id={$user->id}&token={$token}'>" . $student_name . "</a>" . ($print_email ? ' (' . mailto(trim($user->email), 'e-mail address hidden') . ')' : '');
}
$tool_content .= "<a href='group_space.php?course=$course_code&group_id=$group_id'>" . q($group_name) .
"</a> <span style='color:#900; weight:bold;'>($langMyGroup)</span>";
} else {
$tool_content .= q($group_name);
}
if ($user_group_description) {
$tool_content .= "<br />" . q($user_group_description) . " " .
icon('fa-edit', $langModify, "group_description.php?course=$course_code&group_id=$group_id") . " " .
icon('fa-times', $langDelete, "group_description.php?course=$course_code&group_id=$group_id&delete=true", 'onClick="return confirmation();"');
} elseif ($is_member) {
$tool_content .= "<br /><a href='group_description.php?course=$course_code&group_id=$group_id'><i>$langAddDescription</i></a>";
}
$tool_content .= "</td>";
$tool_content .= "<td class='text-center'>";
foreach ($tutors as $t) {
$tool_content .= display_user($t->user_id) . "<br>";
}
$tool_content .= "</td>";
// If self-registration and multi registration allowed by admin and group is not full
$tool_content .= "<td class='text-center'>";
if ($uid and
$self_reg and ( !$user_groups or $multi_reg) and ! $is_member and ( !$max_members or $member_count < $max_members)) {
$tool_content .= "<a href='group_space.php?course=$course_code&selfReg=1&group_id=$group_id'>$langRegistration</a>";
} else {
$tool_content .= "-";
}
$tool_content .= "</td>";
$tool_content .= "<td class='text-center'>$member_count</td><td class='text-center'>" .
($max_members ? $max_members : '-') . "</td></tr>";
$totalRegistered += $member_count;
<?php
require_once "../../class/user.class.php";
require_once "../../class/database.class.php";
session_start();
$db = new database();
$link = $db->connect();
require_once "functionsAdmin.php";
require_once "functions.php";
if ($_POST && isset($_POST['email'])) {
$email = trim(strip_tags($_POST['email']));
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
if (already_email($email, $link)) {
return 1;
} else {
add_email($email, $link);
$result = ['email' => $email, 'is_activated' => 1];
return display_user($result);
}
}
return 0;
} else {
return 0;
header('Location : login.php');
}
</tr>";
}
$result = user_duration_query($course_id);
if (count($result) > 0) {
$i = 0;
foreach ($result as $row) {
$i++;
$grp_name = user_groups($course_id, $row->id, $format);
if ($format == 'html') {
if ($i % 2 == 0) {
$tool_content .= "<tr class='even'>";
} else {
$tool_content .= "<tr class='odd'>";
}
$tool_content .= "<td class='bullet'>" . display_user($row->id) . "</td>
<td class='center'>$row->am</td>
<td class='center'>$grp_name</td>
<td class='center'>" . format_time_duration(0 + $row->duration) . "</td>
</tr>";
} else {
echo csv_escape($row->surname . ' ' . $row->givenname), ';',
csv_escape($row->am), ';',
csv_escape($grp_name), ';',
csv_escape(format_time_duration(0 + $row->duration)), $crlf;
}
}
if ($format == 'html') {
$tool_content .= "</table>";
}
}
function update_user($details)
{
global $THEUSER, $this_page, $PAGE, $who;
// There were no errors when the edit user form was submitted,
// so make the changes in the DB.
// Who are we updating? $THEUSER or someone else?
if ($this_page == "otheruseredit") {
// Someone else.
$success = $THEUSER->update_other_user($details);
// For displaying the altered info.
$user_id = $details["user_id"];
} else {
// $this_page == "useredit"
$success = $THEUSER->update_self($details);
// For displaying the altered info.
$user_id = $THEUSER->user_id;
}
if ($success) {
// No errors, all updated, show results.
if ($this_page == 'otheruseredit') {
$this_page = "userview";
} else {
$this_page = "userviewself";
}
display_user($user_id);
} else {
// Something went wrong.
$PAGE->page_start();
$errors["db"] = "Sorry, we were unable to update {$who} details. Please <a href=\"mailto:" . CONTACTEMAIL . "\">let us know</a> what you were trying to change. Thanks.";
display_form($details, $errors);
$PAGE->page_end();
}
}
//[0] -> status, [1] -> message, other positions -> other data
$response = array();
if ($_POST['action'] == 'new') {
if (Commenting::permCreate($is_editor, $uid, $course_id)) {
$comment = new Comment();
if ($comment->create($_POST['commentText'], $uid, $_POST['rtype'], intval($_POST['rid']))) {
$post_actions = '<div class="pull-right">';
$post_actions .= '<a href="javascript:void(0)" onclick="xmlhttpPost(\'' . $urlServer . 'modules/comments/comments.php?course=' . $course_code . '\', \'editLoad\', ' . $_POST['rid'] . ', \'' . $_POST['rtype'] . '\', \'\', ' . $comment->getId() . ')">';
$post_actions .= icon('fa-edit', $langModify) . '</a> ';
$post_actions .= '<a href="javascript:void(0)" onclick="xmlhttpPost(\'' . $urlServer . 'modules/comments/comments.php?course=' . $course_code . '\', \'delete\', ' . $_POST['rid'] . ', \'' . $_POST['rtype'] . '\', \'' . $langCommentsDelConfirm . '\', ' . $comment->getId() . ')">';
$post_actions .= icon('fa-times', $langDelete) . '</a>';
$post_actions .= '</div>';
$response[0] = 'OK';
$response[1] = "<div class='alert alert-success'>" . $langCommentsSaveSuccess . "</div>";
$response[2] = $comment->getId();
$response[3] = "\r\n <div class='row margin-bottom-thin margin-top-thin comment' id='comment-" . $comment->getId() . "'>\r\n <div class='col-xs-12'>\r\n <div class='media'>\r\n <a class='media-left' href='#'>\r\n " . profile_image($comment->getAuthor(), IMAGESIZE_SMALL) . "\r\n </a>\r\n <div class='media-body bubble'>\r\n <div class='label label-success media-heading'>" . nice_format($comment->getTime(), true) . '</div>' . "<small>" . $langBlogPostUser . display_user($comment->getAuthor(), false, false) . "</small>" . $post_actions . "<div class='margin-top-thin' id='comment_content-" . $comment->getId() . "'>" . q($comment->getContent()) . "</div>\r\n </div>\r\n </div>\r\n </div>\r\n </div> \r\n ";
} else {
$response[0] = 'ERROR';
$response[1] = "<div class='alert alert-warning'>" . $langCommentsSaveFail . "</div>";
}
} else {
$response[0] = 'ERROR';
$response[1] = "<div class='alert alert-warning'>" . $langCommentsNewNoPerm . "</div>";
}
echo json_encode($response);
} else {
if ($_POST['action'] == 'delete') {
$comment = new Comment();
if ($comment->loadFromDB(intval($_POST['cid']))) {
if ($comment->permEdit($is_editor, $uid)) {
if ($comment->delete()) {
function display_user_photo($user_id, $photo_size = null, $attributes = null)
{
return display_user($user_id, $photo_size, $attributes, false);
}
function show_non_submitted($id)
{
global $tool_content, $works_url, $course_id, $m, $langSubmissions, $langGroup, $course_code;
$row = Database::get()->querySingle("SELECT *, CAST(UNIX_TIMESTAMP(deadline)-UNIX_TIMESTAMP(NOW()) AS SIGNED) AS time\n FROM assignment\n WHERE course_id = ?d AND id = ?d", $course_id, $id);
$nav[] = $works_url;
assignment_details($id, $row);
if ($row->group_submissions) {
$groups = groups_with_no_submissions($id);
$num_results = count($groups);
if ($num_results > 0) {
if ($num_results == 1) {
$num_of_submissions = $m['one_submission'];
} else {
$num_of_submissions = sprintf("{$m['more_submissions']}", $num_results);
}
$tool_content .= "\n <p><div class='sub_title1'>{$m['WorkGroupNoSubmission']}:</div><p>\n <p>{$num_of_submissions}</p>\n <div class='row'><div class='col-sm-12'>\n <div class='table-responsive'>\n <table class='sortable'>\n <tr>\n <th width='3'> </th>";
sort_link($langGroup, 'username');
$tool_content .= "</tr>";
$i = 1;
foreach ($groups as $row => $value) {
if ($i % 2 == 1) {
$row_color = "class='even'";
} else {
$row_color = "class='odd'";
}
$tool_content .= "<tr>\n <td>{$i}.</td>\n <td><a href='../group/group_space.php?course={$course_code}&group_id={$row}'>{$value}</a></td>\n </tr>";
$i++;
}
$tool_content .= "</table></div></div></div>";
} else {
$tool_content .= "\n <p class='sub_title1'>{$m['WorkGroupNoSubmission']}:</p>\n <div class='alert alert-warning'>{$m['NoneWorkGroupNoSubmission']}</div>";
}
} else {
$users = users_with_no_submissions($id);
$num_results = count($users);
if ($num_results > 0) {
if ($num_results == 1) {
$num_of_submissions = $m['one_non_submission'];
} else {
$num_of_submissions = sprintf("{$m['more_non_submissions']}", $num_results);
}
$tool_content .= "\n <p><div class='sub_title1'>{$m['WorkUserNoSubmission']}:</div><p>\n <p>{$num_of_submissions}</p>\n <div class='row'><div class='col-sm-12'>\n <div class='table-responsive'>\n <table class='table-default'>\n <tr>\n <th width='3'> </th>";
sort_link($m['username'], 'username');
sort_link($m['am'], 'am');
$tool_content .= "</tr>";
$i = 1;
foreach ($users as $row => $value) {
if ($i % 2 == 1) {
$row_color = "class='even'";
} else {
$row_color = "class='odd'";
}
$tool_content .= "<tr>\n <td>{$i}.</td>\n <td>" . display_user($row) . "</td>\n <td>" . uid_to_am($row) . "</td>\n </tr>";
$i++;
}
$tool_content .= "</table></div></div></div>";
} else {
$tool_content .= "\n <p class='sub_title1'>{$m['WorkUserNoSubmission']}:</p>\n <div class='alert alert-warning'>{$m['NoneWorkUserNoSubmission']}</div>";
}
}
}
array(
'title' => $langDelete,
'url' => "$_SERVER[SCRIPT_NAME]?$url_params&action=delPost&pId=".$post->getId(),
'icon' => 'fa-times',
'class' => 'delete',
'confirm' => $langSureToDelBlogPost,
'show' => $allow_to_edit
)
))."
</div>
<h3 class='panel-title'>
<a href='$_SERVER[SCRIPT_NAME]?$url_params&action=showPost&pId=".$post->getId()."'>".q($post->getTitle())."</a>
</h3>
</div>
<div class='panel-body'>
<div class='label label-success'>" . nice_format($post->getTime(), true). "</div><small>".$langBlogPostUser.display_user($post->getAuthor(), false, false)."</small><br><br>".standard_text_escape(ellipsize_html($post->getContent(), $num_chars_teaser_break, "<strong> ...<a href='$_SERVER[SCRIPT_NAME]?$url_params&action=showPost&pId=".$post->getId()."'> <span class='smaller'>[$langMore]</span></a></strong>"))."
$comment_content
</div>
<div class='panel-footer'>
<div class='row'>
<div class='col-sm-6'>$rating_content</div>
<div class='col-sm-6 text-right'>$sharing_content</div>
</div>
</div>
</div>";
}
//display navigation links
$tool_content .= $blog->navLinksHTML($page, $posts_per_page);
foreach ($not_found as $uname) {
$tool_content .= q($uname) . '<br>';
}
$tool_content .= '</div>';
}
if (count($ok)) {
$tool_content .= "<div class='alert alert-success'>{$langUsersRegistered}<br>";
foreach ($ok as $userid) {
$tool_content .= display_user($userid) . '<br>';
}
$tool_content .= '</div>';
}
if (count($existing)) {
$tool_content .= "<div class='alert alert-info'>{$langUsersAlreadyRegistered}<br>";
foreach ($existing as $userid) {
$tool_content .= display_user($userid) . '<br>';
}
$tool_content .= '</div>';
}
}
$tool_content .= "<div class='alert alert-info'>{$langAskManyUsers}</div>\n <div class='form-wrapper'>\n <form method='post' action='{$_SERVER['SCRIPT_NAME']}?course={$course_code}'>\n <fieldset> \n <div class='form-group'>\n <div class='col-sm-12 radio'><label><input type='radio' name='type' value='uname' checked>{$langUsername}</label></div>\n <div class='col-sm-12 radio'><label><input type='radio' name='type' value='am'>{$langAm}</label></div>\n </div>\n <div class='form-group'>\n <textarea class='auth_input' name='user_info' rows='10'></textarea>\n </div>\n <div class='col-sm-offset-2 col-sm-10'>\n <input class='btn btn-primary' type='submit' name='submit' value='{$langAdd}'>\n </div> \n </fieldset>\n </form>\n </div";
draw($tool_content, 2);
/**
* @brief find if user exists according to criteria
* @param type $user
* @param type $field
* @return boolean
*/
function finduser($user, $field)
{
$result = Database::get()->querySingle("SELECT id FROM user WHERE `{$field}` = ?s", $user);
$user_id = (int) trim($str_1[1]);
$str_2 = explode(' - ', $str_1[0]);
$datetime = $str_2[0];
$str_3 = explode(' : ', $str_2[1]);
$username = $str_3[0];
$usertext = $str_3[1];
$token = token_generate($user_id, true);
echo "<div class='row margin-right-thin margin-left-thin margin-top-thin'>
<div class='col-xs-12'>
<div class='media'>
<a class='media-left' href='{$urlServer}main/profile/display_profile.php?id=$user_id&token=$token'>
". profile_image($user_id, IMAGESIZE_SMALL) ."
</a>
<div class='media-body bubble'>
<div class='label label-success media-heading'>$datetime</div>
<small>$langBlogPostUser ". display_user($user_id, false, false) ."</small>
<div class='margin-top-thin'>
" . $usertext . "
</div>
</div>
</div>
</div>
</div>\n";
}
} else { //prior to version 3.0 generated conferences
echo "<div class='row margin-right-thin margin-left-thin margin-top-thin'>
<div class='col-xs-12'>
<div class='alert alert-default'>
$str_1[0]
</div>
</div>
if ($course_id == 0) {
if ($msg->course_id != 0) {
$td[$i++] = "$bold_start<a class=\"outtabs\" href=\"index.php?course=".course_id_to_code($msg->course_id)."\">".course_id_to_title($msg->course_id)."</a>$bold_end";
} else {
$td[$i++] = "";
}
}
if ($mbox_type == 'inbox') {
$td[$i++] = display_user($msg->author_id, false, false, "outtabs");
} else {
$recipients = '';
foreach ($msg->recipients as $r) {
if ($r != $msg->author_id) {
$recipients .= display_user($r, false, false, "outtabs").'<br/>';
}
}
$td[$i++] = $recipients;
}
$td[$i++] = nice_format(date('Y-m-d H:i:s',$msg->timestamp), true);
// $td[$i++] = action_button(array(
// array(
// 'icon' => 'fa-times',
// 'url' => 'javascript:void(0);',
// 'level' => 'primary',
// 'title' => $langDelete,
// 'btn_class' => $mbox_type == 'inbox'? 'delete_in btn-default' : 'delete_out btn-default',
// 'link-attrs' => "data-id='$msg->id'"
// )
}
// Get the other users in the same group.
if ($review_type == '1') {
$result = $mysqli->prepare("SELECT username, title, surname, first_names, users_metadata.userID FROM (users_metadata, users) WHERE users_metadata.userID = users.id AND users_metadata.idMod IN (" . implode(',', array_keys($modules)) . ") AND calendar_year = ? AND type = ? AND value = ? AND userID != ? ORDER BY surname, initials");
$result->bind_param('sssi', $calendar_year, $type, $group, $_GET['userID']);
$result->execute();
$result->bind_result($member_username, $member_title, $member_surname, $member_first_names, $member_userID);
while ($result->fetch()) {
if ($member_userID != $userObject->get_user_ID()) {
// Make sure current user cannot peer review themself.
display_user($review_type, $q_type, $questions, $saved_results, $cfg_web_root, $member_userID, $member_username, $member_title, $member_first_names, $member_surname, $display_photos, $columns, $parts, $marking);
}
}
$result->close();
} else {
display_user($review_type, $q_type, $questions, $saved_results, $cfg_web_root, $_GET['userID'], $student_username, $student_title, $student_first_names, $student_surname, $display_photos, $columns, $parts, $marking);
}
echo "</table>\n";
echo "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" style=\"width:100%\"><tr><td style=\"background-color:#5590CF; text-align:center\">";
echo "<input type=\"button\" name=\"close\" value=\"" . $string['close'] . "\" style=\"width:100px\" onclick=\"window.close();\" />";
echo "</td></tr>\n";
echo "</table>\n</form>\n";
?>
</html>
</body>
<?php
function display_user($review_type, $q_type, $questions, $saved_results, $cfg_web_root, $member_userID, $member_username, $member_title, $member_first_names, $member_surname, $display_photos, $columns, $parts, $marking)
{
$row_no = 0;
$rowspan = $review_type == '1' ? count($questions) + 2 : count($questions) * 2 + 2;
echo "<tr><td class=\"phototd\" rowspan=\"{$rowspan}\">";
foreach ($posts as $post) {
$sharing_content = '';
$rating_content = '';
if ($sharing_allowed) {
$sharing_content = $sharing_enabled ? print_sharing_links($urlServer . "modules/blog/index.php?course={$course_code}&action=showPost&pId=" . $post->getId(), $post->getTitle()) : '';
}
if ($ratings_enabled) {
$rating = new Rating('up_down', 'blogpost', $post->getId());
$rating_content = $rating->put($is_editor, $uid, $course_id);
}
if ($comments_enabled) {
$comm = new Commenting('blogpost', $post->getId());
$comment_content = "<a class='btn btn-primary btn-xs pull-right' href='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&action=showPost&pId=" . $post->getId() . "#comments_title'>{$langComments} (" . $comm->getCommentsNum() . ")</a>";
} else {
$comment_content = "<div class=\"blog_post_empty_space\"></div>";
}
$tool_content .= "<div class='panel panel-action-btn-default'>\r\n <div class='panel-heading'>\r\n <div class='pull-right'>\r\n " . action_button(array(array('title' => $langModify, 'url' => "{$_SERVER['SCRIPT_NAME']}?course={$course_code}&action=editPost&pId=" . $post->getId(), 'icon' => 'fa-edit', 'show' => $post->permEdit($is_editor, $stud_allow_create, $uid)), array('title' => $langDelete, 'url' => "{$_SERVER['SCRIPT_NAME']}?course={$course_code}&action=delPost&pId=" . $post->getId(), 'icon' => 'fa-times', 'class' => 'delete', 'confirm' => $langSureToDelBlogPost, 'show' => $post->permEdit($is_editor, $stud_allow_create, $uid)))) . "\r\n </div>\r\n <h3 class='panel-title'>\r\n <a href='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&action=showPost&pId=" . $post->getId() . "'>" . q($post->getTitle()) . "</a>\r\n </h3> \r\n </div>\r\n <div class='panel-body'>\r\n <div class='label label-success'>" . nice_format($post->getTime(), true) . "</div><small>" . $langBlogPostUser . display_user($post->getAuthor(), false, false) . "</small><br><br>" . standard_text_escape(ellipsize_html($post->getContent(), $num_chars_teaser_break, "<strong> ...<a href='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&action=showPost&pId=" . $post->getId() . "'> <span class='smaller'>[{$langMore}]</span></a></strong>")) . "\r\n {$comment_content}\r\n </div>\r\n <div class='panel-footer'>\r\n <div class='row'>\r\n <div class='col-sm-6'>{$rating_content}</div>\r\n <div class='col-sm-6 text-right'>{$sharing_content}</div>\r\n </div> \r\n </div>\r\n </div>";
}
//display navigation links
$tool_content .= $blog->navLinksHTML($page, $posts_per_page);
$tool_content .= "</div>";
/***end of blog posts area***/
/***sidebar area***/
$tool_content .= "<div class='col-sm-3'>";
$tool_content .= $blog->popularBlogPostsHTML($num_popular);
$tool_content .= $blog->chronologicalTreeHTML(date('n', strtotime($posts[0]->getTime())), date('Y', strtotime($posts[0]->getTime())));
$tool_content .= "</div></div>";
/***end of sidebar area***/
}
}
draw($tool_content, 2, null, $head_content);
