Help with flash chat v474

[Blackdogg]

Hi i was wondering if anyone had any advice on using flash chat on an mccode v2 game i folllow all the instructions and it installs fine and works brilliantly that bad thing is that it stops my game from working and i get a query error any help would gratefully be apreciated

[AlabamaHit]

Re: Help with flash chat v474

searcdh the mod section i think someone has a Chat on here.....that works on there.

[Blackdogg]

Re: Help with flash chat v474

Yeah im using xat at the moment but i really like the look of flash chat v474 so iwas wondering if anyone else had used it and any problems they encountered

[AlabamaHit]

Re: Help with flash chat v474

oh sorry, didnt know you where looking for specific one...Cant really help you with that, i have IRC chat on mine....not flash...

[Blackdogg]

Re: Help with flash chat v474

Lol i have pjirc uploaded to my server but for the liife of me cant figure out how to get that working :P

[Tezza`]

Re: Help with flash chat v474

Try reading the Read me carfully.

[Blackdogg]

Re: Help with flash chat v474

Anyway back to the original topic this is the error that i get when flashchat is installed

QUERY 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 '' at line 1

Query was SELECT u.*,us.*,h.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN houses h ON h.hWILL=u.maxwill WHERE u.userid=

[AlabamaHit]

Re: Help with flash chat v474

I assume on that query your useing $userid

Make sure that globals is on that page..

 

global $db, $userid;

if thats not there. it will not know what $userid is therefor have a blank userid like that.

[Blackdogg]

Re: Help with flash chat v474

Yeah Im not that uselless lol ive sorted it now instead of users having to register with the chat site (which was where the problem was) its now intergrated into the game userlist :-D