[phpMyChat CVS] CVS: phpMyChat-0.15/chat users_low.php3,1.18,1.19 users.php3,1.24,1.25

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

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

Modified Files:
	users_low.php3 users.php3 
Log Message:
Fixed a bug with PostgreSQL

Index: users_low.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users_low.php3,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -r1.18 -r1.19
*** users_low.php3	2001/05/22 21:15:34	1.18
--- users_low.php3	2001/05/25 22:29:14	1.19
***************
*** 182,186 ****
  	$usersQuery	= 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
  				. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! 				. 'WHERE ' . $roomsToCheck . ' '
  				. 'UNION '
  				. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
--- 182,186 ----
  	$usersQuery	= 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
  				. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! 				. 'WHERE ' . $roomsToCheck . ' AND usr.username = reg.username '
  				. 'UNION '
  				. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '

Index: users.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users.php3,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -r1.24 -r1.25
*** users.php3	2001/05/22 21:15:34	1.24
--- users.php3	2001/05/25 22:29:14	1.25
***************
*** 181,185 ****
  	$usersQuery	= 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
  				. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! 				. 'WHERE ' . $roomsToCheck . ' '
  				. 'UNION '
  				. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '
--- 181,185 ----
  	$usersQuery	= 'SELECT usr.room, usr.username, usr.latin1, usr.status, reg.gender '
  				. 'FROM ' . C_USR_TBL . ' usr, ' . C_MSG_TBL . ' msg, ' . C_REG_TBL . ' reg '
! 				. 'WHERE ' . $roomsToCheck . ' AND usr.username = reg.username '
  				. 'UNION '
  				. 'SELECT usr.room, usr.username, usr.latin1, usr.status, NULL AS gender '