[phpMyChat CVS] CVS: phpMyChat-0.15/chat/lib get_user_infos.lib.php3,1.4,1.5

[Lo?c C. <lo...@us...>]

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;