芝麻web文件管理V1.00
编辑当前文件:/home/asmplong/www/ancien-site-2019/site/modules/mod_whosonline/helper.php
getQuery(true); $query->select('guest, usertype, client_id'); $query->from('#__session'); $query->where('client_id = 0'); $db->setQuery($query); $sessions = (array) $db->loadObjectList(); if (count($sessions)) { foreach ($sessions as $session) { // if guest increase guest count by 1 if ($session->guest == 1 && !$session->usertype) { $guest_array ++; } // if member increase member count by 1 if ($session->guest == 0) { $user_array ++; } } } $result['user'] = $user_array; $result['guest'] = $guest_array; return $result; } // show online member names static function getOnlineUserNames() { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('a.username, a.time, a.userid, a.usertype, a.client_id'); $query->from('#__session AS a'); $query->where('a.userid != 0'); $query->where('a.client_id = 0'); $query->group('a.userid'); $db->setQuery($query); return (array) $db->loadObjectList(); } }