. /** * Online users block. * * @package block_online_users * @copyright 1999 onwards Martin Dougiamas (http://dougiamas.com) * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ /** * This block needs to be reworked. * The new roles system does away with the concepts of rigid student and * teacher roles. */ class block_online_users extends block_base { function init() { $this->title = get_string('pluginname','block_online_users'); } function has_config() { return true; } function get_content() { global $USER, $CFG, $DB, $OUTPUT; if ($this->content !== NULL) { return $this->content; } $this->content = new stdClass; $this->content->text = ''; $this->content->footer = ''; if (empty($this->instance)) { return $this->content; } $timetoshowusers = 300; //Seconds default if (isset($CFG->block_online_users_timetosee)) { $timetoshowusers = $CFG->block_online_users_timetosee * 60; } $now = time(); $timefrom = 100 * floor(($now - $timetoshowusers) / 100); // Round to nearest 100 seconds for better query cache //Calculate if we are in separate groups $isseparategroups = ($this->page->course->groupmode == SEPARATEGROUPS && $this->page->course->groupmodeforce && !has_capability('moodle/site:accessallgroups', $this->page->context)); //Get the user current group $currentgroup = $isseparategroups ? groups_get_course_group($this->page->course) : NULL; $groupmembers = ""; $groupselect = ""; $params = array(); //Add this to the SQL to show only group users if ($currentgroup !== NULL) { $groupmembers = ", {groups_members} gm"; $groupselect = "AND u.id = gm.userid AND gm.groupid = :currentgroup"; $params['currentgroup'] = $currentgroup; } $userfields = user_picture::fields('u', array('username')); $params['now'] = $now; $params['timefrom'] = $timefrom; if ($this->page->course->id == SITEID or $this->page->context->contextlevel < CONTEXT_COURSE) { // Site-level $sql = "SELECT $userfields, MAX(u.lastaccess) AS lastaccess FROM {user} u $groupmembers WHERE u.lastaccess > :timefrom AND u.lastaccess <= :now AND u.deleted = 0 $groupselect GROUP BY $userfields ORDER BY lastaccess DESC "; $csql = "SELECT COUNT(u.id) FROM {user} u $groupmembers WHERE u.lastaccess > :timefrom AND u.lastaccess <= :now AND u.deleted = 0 $groupselect"; } else { // Course level - show only enrolled users for now // TODO: add a new capability for viewing of all users (guests+enrolled+viewing) list($esqljoin, $eparams) = get_enrolled_sql($this->page->context); $params = array_merge($params, $eparams); $sql = "SELECT $userfields, MAX(ul.timeaccess) AS lastaccess FROM {user_lastaccess} ul $groupmembers, {user} u JOIN ($esqljoin) euj ON euj.id = u.id WHERE ul.timeaccess > :timefrom AND u.id = ul.userid AND ul.courseid = :courseid AND ul.timeaccess <= :now AND u.deleted = 0 $groupselect GROUP BY $userfields ORDER BY lastaccess DESC"; $csql = "SELECT COUNT(u.id) FROM {user_lastaccess} ul $groupmembers, {user} u JOIN ($esqljoin) euj ON euj.id = u.id WHERE ul.timeaccess > :timefrom AND u.id = ul.userid AND ul.courseid = :courseid AND ul.timeaccess <= :now AND u.deleted = 0 $groupselect"; $params['courseid'] = $this->page->course->id; } //Calculate minutes $minutes = floor($timetoshowusers/60); // Verify if we can see the list of users, if not just print number of users if (!has_capability('block/online_users:viewlist', $this->page->context)) { if (!$usercount = $DB->count_records_sql($csql, $params)) { $usercount = get_string("none"); } $this->content->text = "
".get_string("periodnminutes","block_online_users",$minutes).": $usercount
"; return $this->content; } if ($users = $DB->get_records_sql($sql, $params, 0, 50)) { // We'll just take the most recent 50 maximum foreach ($users as $user) { $users[$user->id]->fullname = fullname($user); } } else { $users = array(); } if (count($users) < 50) { $usercount = ""; } else { $usercount = $DB->count_records_sql($csql, $params); $usercount = ": $usercount"; } $this->content->text = "
(".get_string("periodnminutes","block_online_users",$minutes)."$usercount)
"; //Now, we have in users, the list of users to show //Because they are online if (!empty($users)) { //Accessibility: Don't want 'Alt' text for the user picture; DO want it for the envelope/message link (existing lang string). //Accessibility: Converted
to