Proyectos de Subversion Moodle

Rev

Rev 1 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1 Rev 1441
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