BTW, not related, but just reading your forum I noticed you had changed the refresh time from 3 secs to 0.1 secs - this is a very bad idea - 2 seconds is about the minimum you should consider. Basically you are telling every user to poll the server every 0.1 seconds - using large amounts of bandwidth and eventully if quite a few join, collapsing the whole thing. (Imagine trying to refresh a normal page 10 times a second !!).

thanks for telling that.
Actually i did that as a test to see if it fixes lag. Right now all were complaining of some 7 to 30 secs lag. I tried to test the chat with high refresh to see if it did anything. It hasn't. Ar best its now variable with some users getting it way too high and some low.
Anyway i will make it back to 2secs.

the problem is caused only on
1. Index.php edited, Forumhome not changed.
(or even if i change forumhome, and don't edit the index.php its allright. Its only on index.php file edit that it occurs.)
btw i just sent you some details via pm(index file and test user details.)

I am trying to use this code in collaboration with AdColumns so that it has a Whos in chat display on a side column. I put this code in a template being called by AdColumns but it doesn't appear to work this way. The template is being called on ForumHome, is there anything you can think of that would fix this problem so the code can function as part of a template that is being called?

I don't know much about adcolumns - and am not really sure what you are saying doesn't work. Can you be more specific, or link to your site.

Sleazy - thanks for the PM - I have replied with what should be the answer for you.

hey paul should I bother with flash chat?

AFAICT FlashChat is the best out there right now.

I have it, and this hack installed. Both running smoothly.

Well that depends - do you want a chat system ?

If so then yes, FC does the job (as do others I might add, but I, and many others chose this one).

Hey Paul,

I'm running VB3.03 and the latest FlashChat.... For some reason I'm getting this error. It's adding an extra vb3_ it seems when doing the queries.... I'm still too new to figure this out I guess..... Any help would be appreciated.....

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb3_vb3__fc_connections as connections
LEFT JOIN vb3_vb3__fc_rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN vb3_user as user ON(connections.userid = user.userid)
LEFT JOIN vb3_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb3_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start
mysql error: Table 'vb.vb3_vb3__fc_connections' doesn't exist

mysql error number: 1146

Romeos Tune,
I am getting the exact same error. Still trying to figure out what it is.