Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv4944/chat/lib
Modified Files:
get_user_infos.lib.php3
Log Message:
For Tinou: improved messages tables (lower database soft. charge)
Index: get_user_infos.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/get_user_infos.lib.php3,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** get_user_infos.lib.php3 2001/11/26 20:22:15 1.4
--- get_user_infos.lib.php3 2001/11/29 22:00:56 1.5
***************
*** 261,265 ****
// users entrance/exit) or containing only 'system' message but an
// user is currently logged in, status will be 'user'
! $dbLink->query("SELECT COUNT(*) FROM " . C_MSG_TBL . " WHERE m_time > 0 AND username NOT LIKE 'SYS %' AND room = '$slashedTargetRoomName' LIMIT 1");
list($isTrueMsg) = $dbLink->nextRecord();
$tmpUserPerm = ($isTrueMsg == 0) ? 5 : 1;
--- 261,265 ----
// users entrance/exit) or containing only 'system' message but an
// user is currently logged in, status will be 'user'
! $dbLink->query("SELECT COUNT(*) FROM " . C_MSG_TBL . " WHERE room = '$slashedTargetRoomName' AND username NOT LIKE 'SYS %' LIMIT 1");
list($isTrueMsg) = $dbLink->nextRecord();
$tmpUserPerm = ($isTrueMsg == 0) ? 5 : 1;
|
