Once again I have to extend thanks to you Craigr! Worked like a charm.

Thanks!
Paul

Noticed recently that when the code is put in global.php that the profile pages do not appear - it causes an MySQL error. Here are the symptoms:

When no one appears in "Who's In Chat" then clicking on a username brings up their profile with no problems. If the user shows up in "Who's In Chat" then clicking on the username (either in Who's Online or Who's In Chat) brings up the error mentioned about:

----------------------------------------------------

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (0Array,2)

mysql error: Unknown column '0Array' in 'where clause'

mysql error number: 1054

----------------------------------------------------

If I log everyone out of Flash Chat and refresh the forum page - I have access to the profiles again. What is causing this error? I haven't tried to reproduce this with the "Who's In Chat" code in index.php. This error is completely reproducible and seems to originate from this hack.

Anyone have suggestions?

Thanks,
Paul

BTW - I have the navbar template modded to have the "Who's In Chat" show up on each page.

We are in the same boat as TheArchitect. Our profiles break when people are in the chat room. Any fix for this? PnL posted the error.

Thanks,

Sean

We are going to have to install another flashchat mod. We really like this one, it's too bad it breaks the profiles... I see you guys haven't posted in about 1 month... I'm loosing hope!!! You never address the Architect's issues either.....

Sean

There is an alternative here. :)

nice hack & works well but for one problem.....

i use vBadvanced and have put this hack into a module - i have done this successfully (having put hack into global.php) and it works perfectly when operating within the forum
(i.e. www.gpcricket.com.au/forum/)
however when i go my other pages on the website
(eg. http://www.gpcricket.com.au/index.php?page=shirts)
that are controlled by vBadvanced the avatar does not appear and I get a 'x' in a box, like a missing pic file link, in its place above each name (see screenshots)

any assistance to retrieve the avatars from webpages outside of the forum would be greatly appriciated

FYI i have returned the module to text-based for the moment