![]() |
Also, I edited function.php to post[arcade] but I cant get it to show up on the postbit template...
|
Quote:
PHP Code:
the template should be put in the templatecache for performance reasons. unfortunately the templatecache isnt yet used in this hack. should be implemented, but to avoid overhead of caching unused templates a bit of the code has to be rearanged. i dont know whats up with the hack as futureal seems to be pretty busy @moment. i'm offering my help, if its wanted as i really like this hack and will be modifying my verion definitly. unfortunatly futureal didnt contact me yet about that and the state of development. |
Quote:
|
When is next version coming out? ;)
Any major issues/security issues with current one? |
Same ... any updates? I see you add many new features to the newer version .. update, update! :)
http://www.shadowsofnamek.com/forum/proarcade.php |
Tried to mannually make thetabes but get this error:
MySQL said: You have an error in your SQL syntax near '$tetrisscore', 550, 380, 'classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540' at line 9 |
My file has slashes in it. I will remove all slashed and try again.
|
Ahh ok - my files does not have slased but it has ( ' )
When i past into MysqlAdmin - it puts the slashed in (on submit).. hmmm What should I do? |
Don't copy&paste it ... run it from the sql file ... you are talking about the content in allgames right?
|
here's a pretty kool .fla poker game , anyone able to integrate it into the arcade and with LeSane's Store
|
Quote:
open proarcade.php look for this code : Quote:
Quote:
|
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 |
Quote:
|
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? |
Quote:
|
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? |
Quote:
|
Yeah, delete the second ' and it must work!
Whats with the other Querys?? Did you try them?? |
I think it was mentioned before but the Top scoreboard isn't showing the correct comments for the users top score, it shows their first comment always?
Anyone know a fix? Great hack btw :rambo: |
Actually I am not having that extra ' :
----- 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"' ); --------- php Myadmin returns 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 9 ---------- Looks like something wrong with the '#FF0000' line right above '$tetrisscore' Because I dont see that line in the error. ('#FF0000' ) I really appreciate your patience :) Any more ideas? |
Note to Hack Creator: I have Safe Mode = Off
|
Quote:
|
JackG: If you look at the error it's returning there is still a second ' on '$tetrisscore', - see it? Drop the arcadegames table and re-create it. you have to get rid of that second '
Attached is a working allgames.sql .. use this one. |
are there only 5 GAMES?.. i need more :) really i like it
|
just found this :D
Looks great i'll install it over the weekend :D :D Thanks :cool: |
is there a way for people to cheat on the scores , I remember with the other version of the arcade there was a way to just enter it into the address bar a certain way and it would put up whatever score you input
|
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? |
Quote:
|
aren't you the guy the just blocked me on msn messenger :|
anybody know about cheating on THIS version ? |
Quote:
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. |
Quote:
|
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. |
All times are GMT. The time now is 01:02 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|