phpmychat-cvs-commited

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

Update of /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib
In directory usw-pr-cvs1:/tmp/cvs-serv19598/chat/lib

Modified Files:
	connected_users.lib.php3 
Log Message:
Some SQL optimizations

***** Bogus filespec: -
***** Bogus filespec: 0.14/chat/lib
Index: connected_users.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/lib/connected_users.lib.php3,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -r1.1.1.1 -r1.2
*** connected_users.lib.php3	2001/02/25 18:27:35	1.1.1.1
--- connected_users.lib.php3	2001/04/22 11:29:40	1.2
***************
*** 14,18 ****
  	else
  	{
! 		$query = "SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY u.username";
  	}
  
--- 14,18 ----
  	else
  	{
! 		$query = "SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY username";
  	}