guest sql error on send score

[testebr]

mySQL query error: SELECT * FROM vb3_games_session WHERE sessid= LIMIT 1

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 'LIMIT 1' at line 1
mySQL error code:
Date: Monday 26th 2007f March 2007 02:24:37 AM

arcade configuration = guest can play but cant send score

Please any solution fast.

Thank you

[MrZeropage]

this only appears for guests ?

[testebr]

yes only for guest on submit score

[MrZeropage]

I guess this is a v3arcade-game where this appears, right ?

Or is this also on standard-games like simon or snake ?

If you provide FTP+AdminCP access via PM I will try to find the problem and fix it directly on your site ...

[testebr]

Well... I just tested in one game, but I believe many gamers have same problem on guest submit score.

I have a lot v3 arcade games, 500+.

I can't provide FTP+AdminCP because I am using the Arcade in an Lan House with no internet access.

I can fix it if you guide me.

[MrZeropage]

I am sure for 99% that this only is a problem with guests playing v3arcade-games, not with ibproarcade-games.

Could you verify this by testing it with the standard-games coming along with ibProArcade ? I guess they work fine for guests ...

[testebr]

I just tested the game Yeti Sports 8- Jungle Swing (game_yeti8.tar) downloaded from your website (ibpdownloads) today and same problem:

mySQL query error: SELECT * FROM vb3_games_session WHERE sessid= LIMIT 1

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 'LIMIT 1' at line 1
mySQL error code:
Date: Tuesday 27th 2007f March 2007 10:50:26 PM

Screenshot:

62408

Cya

[MrZeropage]

but you played as guest again ?

[testebr]

hmmm, If I block cookies in browser I get the sql error...

with cookies enabled = no problem.

[MrZeropage]

Aaaaah, thanks for that info :)

Yes, as a guest has no user-table to insert any sessioninformation, I did that using cookies.
I think I will add some check before starting a game if cookies can be saved, and if not don't start the game...

[testebr]

let the user play with no cookies, simples dont try insert info to database.

It's possible?

[MrZeropage]

no, without any dedicated session-information having a clear reference to that visitor it is not possible to crypt/decrypt results (which new v3.x games do).
I don't have an idea yet how to store that information/reference without cookies and to make sure after playing to pull this one sessiondata that was started by that user - just imagine more than one guest is playing at the same time...

Having a normal user the userID is the reference, no problem - but guests...

[GrendelKhan{TSU]

I get this same error with some registered users.

Here's a link to the reported problem from one of my members :
arcade timeout and SQLerror (http://www.clantsu.org/forums/arcade-discussions/6052-hey-gk-could-you-fix.html)


I can get you admin access or whatever if you need to check it out.

[MrZeropage]

with registered users? Can you reproduce it?

If so, please provide AdminCP+FTP access via PM and tell me how to reproduce this error, then I can fix it :)

[Tenkoy]

Well, from what the people on my forum have been stating. The error appears to be due to being timed out. If they play for too long and are timed out, they recieve the error.

[MrZeropage]

Ok, this makes sense... If you get logged out, the arcade can't read your sessionid for that game - will think about a solution for this...