open proarcade.php

look for this code :
those are user group id's. ANY user group that you want to be able to play ,has to be added to this portion , for example , my code looks like this :

because of all the custom sections and levels we have. He can't put it in the php as a general user group clearance because he doesn't know how many user groups you have , or which ones you wish to allow usage of the arcade , so you have to modify that portion of proarcade.php yourself to fit your individual forum.

My problem is step 5.
I try to add allgames.sql and I get this:

(I run it from the file and also get the 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\',
\'#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\',
\'\\r\\n\',
\'pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"\'
);

INSERT INTO arcadegames VALUES (
2,
\'breakout\',
\'Breakout\',
\'A simple Arkanoid-style game -- see how many balls you can keep going at once!\',
\'breakout.swf\',
\'\', \'\', 0, 0, 0,
\'Breakout Champion\',
\'#ff0000\',
\'$breakoutscore\',
400, 500,
\'classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\"\',
\'location=$vpa_bburl&gamename=$game&s=$session[sessionhash]\',
\' \\r\\n \\r\\n \\r\\n\',
\'pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"\'
);

INSERT INTO arcadegames VALUES (
3,
\'pacman\',
\'Pacman\',
\'A perfect recreation of the arcade classic!\',
\'pacman.swf\',
\'\', \'\', 0, 0, 0,
\'Pacman Champion\',
\'#FF0000\',
\'$pacmanscore\',
360, 420,
\'classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"\\r\\ncodebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\"\',
\'location=$vpa_bburl&gamename=$game&s=$session[sessionhash]\',
\'\\r\\n\',
\'pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"\'
);

INSERT INTO arcadegames VALUES (
4,
\'spaceinvaders\',
\'Space Invaders\',
\'Drop down, increase speed, and reverse direction!\',
\'invaders.swf\',
\'\', \'\', 0, 0, 0,
\'Space Invaders Champion\',
\'#FF0000\',
\'$invadersscore\',
500, 500,
\'classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\"\',
\'location=$vpa_bburl&gamename=$game&s=$session[sessionhash]\',
\'\\r\\n\',
\'pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"\'
);

INSERT INTO arcadegames VALUES (
5,
\'snake\',
\'Snake\',
\'Eat as much as you can without hitting the walls or your own tail!\',
\'snake.swf\',
\'\', \'\', 0, 0, 0,
\'Snake Champion\',
\'#FF0000\',
\'$snakescore\',
400, 400,
\'classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"\\r\\ncodebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\"\',
\'location=$vpa_bburl&gamename=$game&s=$session[sessionhash]\',
\'\\r\\n\',
\'pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"\'
);


MySQL said: You have an error in your SQL syntax near '$tetrisscore', 550, 380, 'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540' at line 9
Back

Run the Querys one be one, not all together. Ive separated the querys in the quote for u.

Upps, you see that smilie?? So take youre allgames-file, and separate the querys there. That should be easy.. :)
If you copy and paste the code from here you get an MySql-Error...

anyone found , or anyone else interested in casino games for this that could be modified to work with lesane's store money system ?

Hi Minifreunde,

Thanks for taking the time to separate them for me.
But still the error comes (taken from allgames.sql file):


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\n


---> MySQL said: You have an error in your SQL syntax near '$tetrisscore',
550, 380,
'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540' at line 9


---------

Same sort of error if I run all at once.

I am on Win NT if that matters in this case.

* phpMyAdmin 2.1.0

* MySQL 3.23.28-gamma


Any ideas?

One ' not two ;) ('$tetrisscore')

hmmm. i dont understand what you mean.
I am copying what was in the zip file exactly
as is.

Please re phrase.

The error is theres '' in my quote above when there should only be '

IE: Two apostrophe's (') when there should be one.

Ok, but I am not using 2.
Why do I get an error?