Double Icon for Users

[Anonymous]

The same person appears more than once in the same chatroom (with different genders) when I use Postgres and Redhat.   It seems okay with PGSQL and Mandrake.  The problem was solved when I changed the SQL Statement from the former to the latter:

Change..
$currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
                  . 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
                  . 'WHERE usr.room = \'' . $R . '\' '
                  . 'UNION '
                  ........... con'td...........

TO

$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 '
                  ........... con'td...........

[Loïc Chapeaux]

Hi Maskie!

Thanks for the fix :) I'll merge it on the cvs tree tomorrow.

Regards,
Loc

[Anonymous]

Loic,

just in case..I forgotten to add that the same thing goes with the $otherRoomsQuery :)