From: Lo?c C. <lo...@us...> - 2001-06-10 15:15:19
|
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'; } } |