Sebastian, II am not pasting in double '..
For example. I just pasted this is from your file:

INSERT INTO arcadegames VALUES (
1,
'tetris',
'Tetris',
'The classic game of Tetris that we all know and love...',
'tetris.swf',
'', '', 0, 0, 0,
'Tetris Champion',
'#FF0000',
'$tetrisscore',
550, 380,
'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"',
'username=$username&s=$session[sessionhash]&highscore=$highscore&bbtitle=$bbtitle&location=$v pa_bburl&gamename=$game',
'<param name="quality" value="high">\r\n<param name=bgcolor value="#576375">',
'pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash"'
);


And I got this error which displays the insert wrong for some strange reason:

Error
SQL-query:

INSERT INTO arcadegames VALUES (
1,
'tetris',
'Tetris',
'The classic game of Tetris that we all know and love...',
'tetris.swf',
'', '', 0, 0, 0,
'Tetris Champion',
' '$tetrisscore',
550, 380,
'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab 'username=$username&s=$session[sessionhash]&highscore=$highscore&bbtitle=$bbtitle&location=$v pa_bburl&gamename=$game',
'\r\nMySQL said: You have an error in your SQL syntax near '$tetrisscore',
550, 380,
'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540' at line 9Back

Do you see?

I really want to get this working.

JackG:

I know you didn't put an extra ' but the error it's returning is showing an extra ' in the database.

Drop (delete) the current arcadegames table, THEN run the sql again making sure it doesn't have the extra '

you must drop the arcadegames table.... then run that .sql file I posted above and it should work.

did you try dropping the table first then re-creating it?

If you're talking about my version, I found a way to make it 100% cheat proof (unless someone has access to the database)

aren't you the guy the just blocked me on msn messenger :|

anybody know about cheating on THIS version ?

Probably not, I haven't blocked anyone for days!

If I did, don't take it personally - I do it to people all the time when I need some peace ;)

Hi Sebastian - I really appreciate it but -

Dident work.

I dropped the ArcadeGames forum. Pasted the first ister in
and got this error:

Error
SQL-query:

INSERT INTO arcadegames VALUES (
1,
'tetris',
'Tetris',
'The classic game of Tetris that we all know and love...',
'tetris.swf',
'', '', 0, 0, 0,
'Tetris Champion',
' '$tetrisscore',
550, 380,
'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab 'username=$username&s=$session[sessionhash]&highscore=$highscore&bbtitle=$bbtitle&location=$v pa_bburl&gamename=$game',
'\r\nMySQL said: You have an error in your SQL syntax near '$tetrisscore',
550, 380,
'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540' at line 9Back




- Now I dont have the arcade games table...

Hi guys,

I am going to do everything in my power to get Beta 2 out in the next few days over the holiday weekend. Those of you that have seen it on my site know that it has been progressing gradually, it's almost completely to where I want it.

When Beta 2 is released, I will first make sure that works, and then come up with an upgrade script (hopefully) after that. The upgrade script will just consist of some queries to run that will preserve your old score tables. If you don't mind losing your scores, the best (and recommended) upgrade will be to just delete the tables and start fresh.

More info to come soon. Thanks.

This has been fixed for the new version (see previous post). Thanks!

Have a problem when the game ends, it displays :

Warning: MySQL: A link to the server could not be established in proarcade.php on line 203

And then takes you to the screen that tells you your rank and to enter a comment but it doesnt save any of the comments but does save your score.

Any ideas?

PS. Great script, will provide many hours of amusement for the users :)

That's a very odd error, it almost seems like a problem with the MySQL on your server. Could you look in your proarcade.php file and tell me which line is number 203? This is certainly an error that I have not yet come across.

In other news, I finished the postbit integration of the champions system tonight. You can see it in action on my website (look for posts by a user who is the champion of a particular game). Just as everything else in the arcade, it is completely configurable in the Admin CP.

More to come.