Quote:
Originally posted by Apok2002
hmmm....all went well until the allgames.sql query was run. I ran it both by source, and then also by copy/pasting. Got the same errors. Tried to run the queries one at a time, still had issues:
|
The query you are trying to one does not look right -- it has slashes in it. I'm not sure where they came from, I just double-checked my allgames.sql and it looks good. Make sure those slashes aren't in there, they will screw up the query.
It should look exactly like this:
PHP Code:
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=$vpa_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"'
);
Note that if all else fails, you can always add the games manually via the Admin CP. It should work just as well, it will just take slightly longer.