Blackdogg Posted November 21, 2008 Share Posted November 21, 2008 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 Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted November 21, 2008 Share Posted November 21, 2008 Re: Help with flash chat v474 searcdh the mod section i think someone has a Chat on here.....that works on there. Quote Link to comment Share on other sites More sharing options...
Blackdogg Posted November 22, 2008 Author Share Posted November 22, 2008 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 Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted November 22, 2008 Share Posted November 22, 2008 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... Quote Link to comment Share on other sites More sharing options...
Blackdogg Posted November 22, 2008 Author Share Posted November 22, 2008 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 Quote Link to comment Share on other sites More sharing options...
Tezza` Posted November 22, 2008 Share Posted November 22, 2008 Re: Help with flash chat v474 Try reading the Read me carfully. Quote Link to comment Share on other sites More sharing options...
Blackdogg Posted November 22, 2008 Author Share Posted November 22, 2008 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= Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted November 22, 2008 Share Posted November 22, 2008 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. Quote Link to comment Share on other sites More sharing options...
Blackdogg Posted November 23, 2008 Author Share Posted November 23, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.