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 '
|
