public static function getUsers()
{
if ($_SESSION['user']['name']) {
$user = new ChatUser(array('name' => $_SESSION['user']['name']));
$user->update();
}
// Deleting chats older than 5 minutes and users inactive for 30 seconds
//DB::query("DELETE FROM webchat_lines WHERE ts < SUBTIME(NOW(),'0:25:0')");
DB::query("DELETE FROM webchat_users WHERE last_activity < SUBTIME(NOW(),'0:15:30')");
$result = DB::query('SELECT * FROM webchat_users WHERE gravatar<>"' . $_SESSION['user_id'] . '" ORDER BY name ASC LIMIT 18');
$users = array();
$us = array();
while ($user = $result->fetch_object()) {
$user->gravatar = $user->gravatar;
$ilejest = 0;
if ($_COOKIE['chat_0'] != "off") {
$ilejest = DB::query('SELECT COUNT(*) as asd FROM webchat_lines WHERE tss>"' . DB::esc($_COOKIE['chat_' . $user->gravatar . '']) . '" and room_do="' . $user->gravatar . '" and room="' . $_SESSION['user_id'] . '" and czyt="0"')->fetch_object()->asd;
if ($ilejest >= 1) {
$user->ile_a = '<span class="ilejest" id="user_ile_' . $user->gravatar . '">(' . $ilejest . ')</span>';
} else {
$user->ile_a = '';
}
}
$us[] = $user->gravatar;
$users[] = $user;
}
$ile_u = DB::query('SELECT COUNT(*) as cnt FROM webchat_users')->fetch_object()->cnt;
if ($ile_u >= 1) {
$ile_u = $ile_u - 1;
}
$result = DB::query('SELECT * FROM webchat_lines WHERE czyt=0 and room="' . $_SESSION['user_id'] . '" GROUP by author');
while ($use = $result->fetch_object()) {
if (!in_array($use->room_do, $us)) {
$user->gravatar = $use->room_do;
$user->name = $use->author;
$ilejest = 0;
if ($_COOKIE['chat_0'] != "off") {
$ilejest = DB::query('SELECT COUNT(*) as asd FROM webchat_lines WHERE room_do="' . $user->gravatar . '" and room="' . $_SESSION['user_id'] . '" and czyt="0"')->fetch_object()->asd;
if ($ilejest >= 1) {
$user->ile_a = '<span class="ilejest" id="user_ile_' . $user->gravatar . '">(' . $ilejest . ')</span>';
} else {
$user->ile_a = '';
}
}
$users[] = $user;
}
}
return array('users' => $users, 'ile_a' => $ile_a, 'total' => $ile_u);
}
public static function getUsers()
{
if ($_SESSION['user']['name']) {
$user = new ChatUser(array('name' => $_SESSION['user']['name']));
$user->update();
}
DB::query("DELETE FROM webchat_lines WHERE ts < SUBTIME(NOW(),'0:5:0')");
DB::query("DELETE FROM webchat_users WHERE last_activity < SUBTIME(NOW(),'0:0:30')");
$result = DB::query('SELECT * FROM webchat_users ORDER BY name ASC LIMIT 18');
$users = array();
while ($user = $result->fetch_object()) {
$user->gravatar = Chat::gravatarFromHash($user->gravatar, 30);
$users[] = $user;
}
return array('users' => $users, 'total' => DB::query('SELECT COUNT(*) as cnt FROM webchat_users')->fetch_object()->cnt);
}
public static function getUsers()
{
if (Yii::app()->user->name) {
$user = new ChatUser(array('name' => Yii::app()->user->name));
$user->update();
}
// Deleting chats older than 5 minutes and users inactive for 30 seconds
DB::query("DELETE FROM webchat_lines WHERE ts < SUBTIME(NOW(),'0:5:0')");
DB::query("DELETE FROM webchat_users WHERE last_activity < SUBTIME(NOW(),'0:0:30')");
$result = DB::query('SELECT * FROM webchat_users ORDER BY name ASC LIMIT 18');
$users = array();
while ($user = $result->fetch_object()) {
$user->gravatar = Chat::gravatarFromHash($user->gravatar, 30);
$users[] = $user;
}
return array('users' => $users, 'total' => DB::query('SELECT COUNT(*) as cnt FROM webchat_users')->fetch_object()->cnt);
}
