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