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;
}
