[phpMyChat CVS] CVS: phpMyChat - 0.14/chat usersL.php3,1.6,1.7 usersH.php3,1.12,1.13

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

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

Modified Files:
	usersL.php3 usersH.php3 
Log Message:
Fix a bug with PostgreSQL

***** Bogus filespec: -
***** Bogus filespec: 0.14/chat
Index: usersL.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersL.php3,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** usersL.php3	2001/04/22 11:29:40	1.6
--- usersL.php3	2001/05/25 22:22:40	1.7
***************
*** 76,80 ****
  	$currentRoomQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  						. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 						. 'WHERE usr.room = \'' . $R . '\' '
  						. 'UNION '
  						. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
--- 76,80 ----
  	$currentRoomQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  						. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 						. 'WHERE usr.room = \'' . $R . '\' AND usr.username = reg.username '
  						. 'UNION '
  						. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
***************
*** 147,151 ****
  			$otherRoomsQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  								. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 								. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
  								. 'UNION '
  								. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
--- 147,151 ----
  			$otherRoomsQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  								. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 								. 'WHERE usr.room = \'' . addslashes($Other) . '\' AND usr.username = reg.username '
  								. 'UNION '
  								. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '

Index: usersH.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat - 0.14/chat/usersH.php3,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** usersH.php3	2001/04/22 11:29:40	1.12
--- usersH.php3	2001/05/25 22:22:40	1.13
***************
*** 99,103 ****
  	$currentRoomQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  						. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 						. 'WHERE usr.room = \'' . $R . '\' '
  						. 'UNION '
  						. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
--- 99,103 ----
  	$currentRoomQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  						. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 						. 'WHERE usr.room = \'' . $R . '\' AND usr.username = reg.username '
  						. 'UNION '
  						. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
***************
*** 170,174 ****
  			$otherRoomsQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  								. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 								. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
  								. 'UNION '
  								. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
--- 170,174 ----
  			$otherRoomsQuery	= 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
  								. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
! 								. 'WHERE usr.room = \'' . addslashes($Other) . '\' AND usr.username = reg.username '
  								. 'UNION '
  								. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '