Bug in 2.0RC1?

[Ogden2k]

On the portal under Who's online, it does not show the members specific username color (secondary). 1.0.1 did.

Just an FYI.

[ConqSoft]

Hmm, it does on mine, but I have the colors on their primary usergroup.

[Brian]

Try looking in your modules/onlineusers.php file for this code:
SELECT session.userid, username, usergroupid, (user.options & $_USEROPTIONS[invisible]) AS invisible


Replace with:
SELECT session.userid, username, usergroupid, (user.options & $_USEROPTIONS[invisible]) AS invisible,
IF(displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid


And see if that takes care of the problem.

[Ogden2k]

Here's what I get:
Invalid SQL:
SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible
IF(displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1117897522
ORDER BY invisible ASC, username ASC

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF(displaygroupid = 0, user.usergroupid, displaygroupid) AS dis
mysql error number: 1064

[Brian]

You've gotta love simple mistakes like that. Try adding a ',' after 'invisible' in that query (one line up). I've also updated the original post with the correct code.

[Ogden2k]

That worked, thank you. I should of picked up on the ','. :|