| Línea 78... |
Línea 78... |
| 78 |
$timeaccess = ", ul.timeaccess AS lastaccess";
|
78 |
$timeaccess = ", ul.timeaccess AS lastaccess";
|
| 79 |
$uservisibility = "";
|
79 |
$uservisibility = "";
|
| 80 |
$uservisibilityselect = "";
|
80 |
$uservisibilityselect = "";
|
| 81 |
if ($CFG->block_online_users_onlinestatushiding) {
|
81 |
if ($CFG->block_online_users_onlinestatushiding) {
|
| 82 |
$uservisibility = ", up.value AS uservisibility";
|
82 |
$uservisibility = ", up.value AS uservisibility";
|
| 83 |
$uservisibilityselect = "AND (" . $DB->sql_cast_char2int('up.value') . " = 1
|
83 |
$uservisibilityselect = "AND (" . $DB->sql_cast_char2int('up.value', true) . " = 1
|
| 84 |
OR up.value IS NULL
|
84 |
OR up.value IS NULL
|
| 85 |
OR u.id = :userid)";
|
85 |
OR u.id = :userid)";
|
| 86 |
}
|
86 |
}
|
| 87 |
$params = array();
|
87 |
$params = array();
|
| Línea 95... |
Línea 95... |
| 95 |
$groupselect = "AND u.id = gm.userid AND gm.groupid = :currentgroup";
|
95 |
$groupselect = "AND u.id = gm.userid AND gm.groupid = :currentgroup";
|
| 96 |
$groupby = "GROUP BY $userfields";
|
96 |
$groupby = "GROUP BY $userfields";
|
| 97 |
$lastaccess = ", MAX(u.lastaccess) AS lastaccess";
|
97 |
$lastaccess = ", MAX(u.lastaccess) AS lastaccess";
|
| 98 |
$timeaccess = ", MAX(ul.timeaccess) AS lastaccess";
|
98 |
$timeaccess = ", MAX(ul.timeaccess) AS lastaccess";
|
| 99 |
if ($CFG->block_online_users_onlinestatushiding) {
|
99 |
if ($CFG->block_online_users_onlinestatushiding) {
|
| 100 |
$uservisibility = ", MAX(up.value) AS uservisibility";
|
100 |
$uservisibility = ", MAX(" . $DB->sql_cast_char2int('up.value', true) . ") AS uservisibility";
|
| 101 |
}
|
101 |
}
|
| 102 |
$params['currentgroup'] = $currentgroup;
|
102 |
$params['currentgroup'] = $currentgroup;
|
| 103 |
}
|
103 |
}
|
| Línea 104... |
Línea 104... |
| 104 |
|
104 |
|