Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv20882/chat/lib
Modified Files:
connected_users.lib.php3
Log Message:
Too many changes to detail.
Index: connected_users.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/connected_users.lib.php3,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** connected_users.lib.php3 2001/05/31 20:10:31 1.2
--- connected_users.lib.php3 2001/06/10 15:15:17 1.3
***************
*** 68,76 ****
if ($isFullList)
{
! $query = 'SELECT u.username AS nicks, u.latin1 FROM ' . C_USR_TBL . ' u, ' . C_MSG_TBL . ' m WHERE u.room = m.room AND m.type = 1 GROUP BY nicks';
}
else
{
! $query = 'SELECT COUNT(*) FROM ' . C_USR_TBL . ' u, ' . C_MSG_TBL . ' m WHERE u.room = m.room AND m.type = 1';
}
}
--- 68,76 ----
if ($isFullList)
{
! $query = 'SELECT u.username AS nicks, u.latin1 FROM ' . C_USR_TBL . ' u, ' . C_ROOM_TBL . ' r WHERE u.room = r.room_name AND r.room_type = 1 GROUP BY nicks';
}
else
{
! $query = 'SELECT COUNT(*) FROM ' . C_USR_TBL . ' u, ' . C_ROOM_TBL . ' r WHERE u.room = r.room_name AND r.room_type = 1';
}
}
|
