[phpMyChat CVS] CVS: phpMyChat-0.15/chat/lib connected_users.lib.php3,1.1,1.2

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

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

Modified Files:
	connected_users.lib.php3 
Log Message:
Fixed uggly sql errors

Index: connected_users.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/connected_users.lib.php3,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** connected_users.lib.php3	2001/05/31 19:56:33	1.1
--- connected_users.lib.php3	2001/05/31 20:10:31	1.2
***************
*** 55,69 ****
  	if ($doGetPrivate)
  	{
! 		$what	= ($isFullList)
! 				? 'username, latin1'
! 				: 'COUNT(*)';
! 		$query	= "SELECT $what FROM " . C_USR_TBL . ' GROUP BY username';
  	}
  	else
  	{
! 		$what	= ($isFullList)
! 				? 'u.username, u.latin1'
! 				: 'COUNT(u.*)';
! 		$query = "SELECT $what FROM " . C_USR_TBL . ' u, ' . C_MSG_TBL . ' m WHERE u.room = m.room AND m.type = 1 GROUP BY u.username';
  	}
  	$chatActivityLink = new pmcDB;
--- 55,77 ----
  	if ($doGetPrivate)
  	{
! 		if ($isFullList)
! 		{
! 			$query	= 'SELECT username, latin1 FROM ' . C_USR_TBL . ' GROUP BY username';
! 		}
! 		else
! 		{
! 			$query	= 'SELECT COUNT(*) FROM ' . C_USR_TBL;
! 		}
  	}
  	else
  	{
! 		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';
! 		}
  	}
  	$chatActivityLink = new pmcDB;