function mod_whoonline($module_id, $cfg) { $inDB = cmsDatabase::getInstance(); if (!isset($cfg['color_admin'])) { $cfg['color_admin'] = '#FF0000'; } if (!isset($cfg['color_editor'])) { $cfg['color_editor'] = '#009900'; } $online_count = cmsUser::getOnlineCount(); $users = array(); $today_users = array(); if ($online_count['users']) { $sql = "SELECT\n o.user_id as id,\n u.login,\n u.nickname,\n p.gender as gender\n FROM cms_online o\n LEFT JOIN cms_users u ON u.id = o.user_id\n LEFT JOIN cms_user_profiles p ON p.user_id = u.id\n WHERE u.is_locked = 0 AND u.is_deleted = 0\n GROUP BY o.user_id"; $result = $inDB->query($sql); $users = getUsersArray($result, $cfg, $inDB); } if ($cfg['show_today']) { $today = date("Y-m-d"); $sql = "SELECT u.id as id, u.nickname as nickname, u.login as login, p.gender as gender\n FROM cms_users u\n LEFT JOIN cms_user_profiles p ON p.user_id = u.id\n WHERE u.is_locked = 0 AND u.is_deleted = 0 AND DATE_FORMAT(u.logdate, '%Y-%m-%d')='{$today}'\n ORDER BY u.logdate DESC"; $result = $inDB->query($sql); if ($inDB->num_rows($result)) { $today_users = getUsersArray($result, $cfg, $inDB); } } cmsPage::initTemplate('modules', 'mod_whoonline')->assign('cfg', $cfg)->assign('users', $users)->assign('guests', $online_count['guests'])->assign('today_users', $today_users)->display('mod_whoonline.tpl'); return true; }
function mod_whoonline($mod, $cfg) { $cfg = array_merge(array( 'color_admin' => '#FF0000', 'color_editor' => '#009900' ), $cfg); $online_count = cmsUser::getOnlineCount(); $users = array(); $today_users = array(); if ($online_count['users']) { $sql = "SELECT o.user_id as id, u.login, u.nickname, p.gender as gender FROM cms_online o LEFT JOIN cms_users u ON u.id = o.user_id LEFT JOIN cms_user_profiles p ON p.user_id = u.id WHERE u.is_locked = 0 AND u.is_deleted = 0 GROUP BY o.user_id"; $result = cmsCore::c('db')->query($sql); $users = getUsersArray($result, $cfg); } if ($cfg['show_today']) { $sql = "SELECT u.id as id, u.nickname as nickname, u.login as login, p.gender as gender FROM cms_users u LEFT JOIN cms_user_profiles p ON p.user_id = u.id WHERE u.is_locked = 0 AND u.is_deleted = 0 AND DATE_FORMAT(u.logdate, '%Y-%m-%d')='". date('Y-m-d') ."' ORDER BY u.logdate DESC"; $result = cmsCore::c('db')->query($sql); if (cmsCore::c('db')->num_rows($result)) { $today_users = getUsersArray($result, $cfg); } } cmsPage::initTemplate('modules', $cfg['tpl'])-> assign('cfg', $cfg)-> assign('users', $users)-> assign('guests', $online_count['guests'])-> assign('today_users', $today_users)-> display(); return true; }
function getUsersCombo($default_user_id = 0, $first_option = 'All users') { global $AppUI; $parsed = "<select name='user_id' class='text'>"; if ($first_option != "") { $parsed .= "<option value='0' " . (!$default_user_id ? "selected" : "") . ">" . $AppUI->_($first_option) . "</option>"; } foreach (getUsersArray() as $user_id => $user) { if ($user_id == 1) { continue; } // no Admin $selected = $user_id == $default_user_id ? "selected" : ""; $parsed .= "<option value='{$user_id}' {$selected}>" . $user["contact_first_name"] . " " . $user["contact_last_name"] . "</option>"; } $parsed .= "</select>"; return $parsed; }
function getUsersCombo($default_user_id = 0, $first_option = 'All users') { global $AppUI; $parsed = '<select name="user_id" class="text">'; if ($first_option != "") { $parsed .= '<option value="0" ' . (!$default_user_id ? 'selected="selected"' : '') . '>' . $AppUI->_($first_option) . '</option>'; } foreach (getUsersArray() as $user_id => $user) { $selected = $user_id == $default_user_id ? ' selected="selected"' : ''; $parsed .= '<option value="' . $user_id . '"' . $selected . '>' . $user['contact_first_name'] . ' ' . $user['contact_last_name'] . '</option>'; } $parsed .= '</select>'; return $parsed; }