vbProArcade Beta 2

vbProArcade Beta 2

1/5/03: Beta 2 released
9/12/02: Beta 1.03 zip updated to include safe mode fix
9/3/02: Beta 1.03 released -- small bug fixes, see below
9/1/02: Beta 1 of vbProArcade has been posted. Please see below for installation instructions.


Background Information

vbProArcade is a fully-customizable Flash arcade add-on for vBulletin, complete with game-by-game scoreboards, forum integration, a "champions" system, statistics, and more.

This is an extensive hack that is still in BETA form, and I don't recommend installing it if you are not willing to work through potential issues and future updates/upgrades! I am working on making the installation instructions as easy as possible, but it will probably be some time before it is perfect.

Watch this post for updates as they happen, and check out screenshots from the list below. If you would like to see the hack in action, you may visit my Shadows of Namek forums. You will need to register to play, but you can view the scoreboards and the arcade itself as a guest.


Credits

This hack materialized thanks to work and help from a number of people and forums. Here they are:

• Original vbTetris Hack by Erwin Loh
• Original vbTetris Leaderboard Hack by John Warwick (john.eovie)
• One of my users, Simon Steel, for work on Flash coding/recoding
• The users of one of my forums, Shadows of Namek, for their extensive testing of the system
• And The Kryptonian for pre-release and release candidate installation testing.

Games

So far, there are FIVE GAMES that work correctly with this hack. They are:

Breakout
Pacman
Snake
Space Invaders
Tetris

All five .SWF files are included in the release archive.

There is now a Flash Games Development Thread for the purpose of modifying existing games to work with vbProArcade, or for creating new games to be compatible with vbProArcade. If you have a game that you wish to see modified but don't know how, post the .FLA source in that thread and hopefully somebody can assist you.


Installation Instructions

Download the file attached to this post, unzip it and familiarize yourself with the contents BEFORE doing anything.

There are TWO separate files worth reading, the Documentation and the Installation Instructions. I recommend that you read both BEFORE doing anything else.

Once you have done this, the instructions to be followed are contained in vbproarcade-install.txt. Follow them as precisely as possible. If you encounter an error somewhere, it is likely that you missed a step or made a small error. Please double-check your work BEFORE posting about problems here.

And it cannot be said enough: read that file before you do anything, and if you are unsure of something, please post your question(s) before attempting to install the hack.


Problems and Fixes/Workarounds (as of 1/5)

• None

Known Bugs/Limitations

Here is the list of stuff that I know does not work. I will be working towards correcting these bugs BEFORE adding new features for the next release.

• Netscape will allow you to play the games but not record scores
• If a user uses the "Back" button to go to the game screen, and does not refresh before playing, the score will result in a Security Violation. This is by design.

Screen Shots for Beta 2

Here is the list of posts from this thread that contain screen shots for the new version. Check them out!

• Main Arcade Screen: https://vborg.vbsupport.ru/showthrea...106#post292106
• Game Screen: https://vborg.vbsupport.ru/showthrea...107#post292107
• Game Over Screen: https://vborg.vbsupport.ru/showthrea...109#post292109
• Scoreboard: https://vborg.vbsupport.ru/showthrea...110#post292110
• Top Score Board: https://vborg.vbsupport.ru/showthrea...111#post292111
• Admin Modify Game: https://vborg.vbsupport.ru/showthrea...112#post292112
• Who's Online Display: https://vborg.vbsupport.ru/showthrea...113#post292113
• User Detail Screen: https://vborg.vbsupport.ru/showthrea...811#post337811
• Admin Score Editor: https://vborg.vbsupport.ru/showthrea...736#post338736
• Champ System in Postbit: https://vborg.vbsupport.ru/showthrea...745#post338745
• Modify Games in Admin CP (contracted): https://vborg.vbsupport.ru/showthrea...858#post389858
• Modify Games in Admin CP (expanded): https://vborg.vbsupport.ru/showthrea...859#post389859

Upcoming Features

This is the stuff that is in progress for future release:

• Complete Admin Panel Scoreboard Editor
• Additional integration with vB
• Even better Who's Online screen

Some have emailed or PM'd me asking if I would accept donations for my work on this hack, and yes, I certainly will, and any and all support is greatly appreciated. With over 2,000 lines of original PHP code, in addition to HTML and Flash work, I have spent a great deal of time developing and debugging the source for this, and it is a great feeling to have people like it so much that they want to give something back.

All donations received go directly back into supporting my websites and my design activities. You may click here to donate via Paypal. Note that donations are by no means required, and not donating does not mean you won't get support for the hack.

Last but not least, thanks for checking this out!

[MindTrix]

Along the top click on SQL

then there will be an input text area box, just paste it into there, then click GO, and it should do it.

[M?uschen]

?hm... It seams im to stupid to do what you say... i show you what i do... look at the image... and see the error message.

Thanks M?uschen.




Datenbank db85300001 - Tabelle arcadescores auf sql7.c.artfiles.de
Fehler

SQL-Befehl :

[mysql] DELETE FROM arcadescores

MySQL meldet:


You have an error in your SQL syntax near '[mysql]DELETE FROM arcadescores' at line 1
Zur?ck

[MindTrix]

Sorry mate thats my fault for confusing you

Use this code

DELETE FROM arcadescores;

[M?uschen]

Great... Thanks...

Best wishes and a Happy New Year... Mäuschen.

Edit:
Why are new scores only save in the [Scoreboard] ? The scores are so high, that they should be in the [Top Score Board] too... Have i make a mistake? What can i do?

Thanks Mäuschen.

[futureal]

Did you want to reset the Top Scores as well?

It's really all my fault, for releasing buggy code in the first place.

[M?uschen]

Hello futureal,

my english is not so good... yesterday i have clear the [Scoreboard] with MindTrix help but now one day later, my users play arcade and have higher point than the points in the [Top Score Board]. But the points are only in the [Scoreboard] and not in the [Top Score Board].

Why? Have i make a mistake? What can i do?

[Gutspiller]

When I try and add this database entry:

INSERT INTO arcadegames VALUES (1, 'tetris', 'Tetris', 'The classic game of Tetris that we all know and love...', 'tetris.swf', 'thumb-tetris.gif', 'GIF89a\0\0?\0\0\0?\0?\0?\0\Z+\0+\0?\0?\0?,?\0?\0?\0?\0?\ \q??+?????????????\0"?\0 ?\0#?\0#+\0!?\0?\0 ?\0!?\0"?\0?,?1P?2O?C`?Hd?He?Hd?If?Jg?Id?Ql?j??l??p?烘??????� ��??????????????????????\0&?
&?\'?-?*?(?9?8?8?:?;?=?3?A?$H?"@?7X?7W?<^?:X?8 T?@b?Ef?Gh?Jk?On?Ro?Zv?o??q??r??r??s??q??v??n??x?� ��???????1?8?<?;?=?=?#V?%X?&U?)[?$L?*[?.b?-_?,]?1d?0b?6d?9j?:j?;h?>n??m?@o?Ao?Bq?Lw?Ce?]??k??m??n??q??s?????????????????"Z?(^?+`?,b?,c?,^?/e?0d?0g?1f?2f?0b?3f?4h?5j?6j?8l?9n?:n?=r?Aq?Et?Fv? x??????????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\0\0?\0,\0\ 0\0\0\0\0\0?\0C H?+??*<??
??!??+"??!Fp+? ?-R??Y?J?,/?L9?\n??)t???Dd\0,?ǐM???0???P??H%?9??S?6H?V\ n???Ѩ??2u\n?ԪŚuiӧd?Z%??lרjÎ?ږkZ?k隵?/AA~I\ZLxҚM>?yD??%0`j?S???ˊ?@?M?˗!??P???S ?6???հ?(x??s???$J??q?\0Q?`4?+O.??\n3?/?a?`??q?hߞI?\'??Йپ]?1?bľ??3?t???}{J_0??Zm???u{??_ ?V?oI?`?s?????zM??Qq%aR?e!!?,Rɉ(Z?F\0N???$(???Aa??#=P0?A?+??c?PAA ,??L6??:?+@N:i?e???\\v?e@\0;', 1, 1, 391, 'icon-crown-cyan.gif', 'GIF89a\r\0\0?\0\0\\??+??@??N??\0??\0??\0??\0??\0??\0??\0??? ?G+?\0??\0??\0??\0+?\0??\0??\0??\0??\0??\0??\0??\0 ??\0??\0??????4??\0??\0??\0??\0??\0+?\0??\0??\0? ?\0??\0??\0??\0??\0??\0??\0??\0????\0??\0??\0??\0 ??\0??\0??\0??\0??\0??\0??\0??\0??\0??)??-??<??\0??\0??\0??\0??\0??\0????8??@???Ā??ϴ??? \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0!?
\0\0K\0,\0\0\0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Tetris Champion', '#FF0000', '$tetrisscore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="550" height="380">\r\n<param name="movie" value="$vpa_gameurl?location=$vpa_bburl&gamename=$ game&gamehash=$gamehash&s=$session[sessionhash]&username=$username&highscore=$highscore&bbtitle=$ bbtitle">\r\n<param name="quality" value="high">\r\n<param name=bgcolor value="#576375">\r\n<embed src="$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="550" height="380">\r\n</embed></object>');
INSERT INTO arcadegames VALUES (2, 'breakout', 'Breakout', 'A simple Arkanoid-style game -- see how many balls you can keep going at once!', 'breakout.swf', 'thumb-breakout.gif', 'GIF89a\0\0?\0\0\0u?\0n?\0n?\0m?\0g?\0f?\0g?\0f? \0a?\0`?\0`?\07m\03g\03f\00`\06\0=\09\0\Z3\0

\0
??
??????\n
?????????[xT\n?????????????Y\n

?????????????????ý??zzzvvvuuuQQQFFF333### \0\0\0\0\0\0!?
\0\0?\0,\0\0\0\0\0\0\0??? pH,\Z?Ȥ??)9?N?i?i+?Oq$?z??Ň?|ϣ???n?;?1???{?&?~????!|?&E???) >*??E>?????????\r??????\0?????>\r???\n??????D??
?????\r??? ʚ???????ݘ?????>?<敺81.3??=0+?5??;-?+2???h?X?"ǿ!?n??+?[B??ŋ?
\0;', 1, 1, 52, 'icon-crown-blue.gif', 'GIF89a\r\0\0?\0\0d\\?+-?@C?NR?\0?\0?\0?\0?\0\r?\0?\0??GO?\0?\0?\0?\0?\0?\0?\0?\0 ?\0?\0?\0?\0?\0?\0?\Z?(?4@?\0?\0?\0?\0 ?\0?\0?\0?\0?\0?\0?\0?\0?\0\Z?\0?\0?\0 ?(?\0?\0?\0?\0?\0?\0\Z?\0\Z?\0?\0?\0\Z?\0 ?\0?\0?)A?-A?<P?\0?\0?\0?\0?\0?\0 ?6?8H?@V?AĀ??_????\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\0\0K\0,\0\0 \0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Breakout Champion', '#ff0000', '$breakoutscore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="400" height="500">\r\n<param name="movie" value="$vpa_gameurl?location=$vpa_bburl&gamename=$ game&gamehash=$gamehash&s=$session[sessionhash]">\r\n<param name=loop value=false> \r\n<param name=menu value=false> \r\n<param name=quality value=high> \r\n<param name=bgcolor value=#000000>\r\n<embed src="$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="500">\r\n</embed>\r\n</object>');
INSERT INTO arcadegames VALUES (3, 'pacman', 'Pacman', 'A perfect recreation of the arcade classic!', 'pacman.swf', 'thumb-pacman.gif', 'GIF89a\0\0?\0\0?u?\03?L?_?????f???????\0\0?\ 0\0?\0\0?\0\0?\0\0?\0\0|\0\0y\0\0g\0\0`\0\0V\0\0H\ 0\0E\0\08\0\0+\0\0\'\0\0"\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\n\0\0\0\0?__??????? ?????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\0\0*\0,\ 0\0\0\0\0\0\0?@?pH,\Z?Ȥr?l:??h2??X1?!H?@x? )*??Ϣ??{n\'FNH{?x8?&????M!_%)?%??%M_?)
? ?L??
???L}?\0&??L\nf\'?\'_?)?\nLt??K?t??m??f??^Ʀ_fl?*l?`*??\rB$^?*?B?JDD\ZDY??????BA\0;', 1, 1, 1, 'icon-crown-red.gif', 'GIF89a\r\0\0?\0\0?f\\?++?@A?NP?\0?\0?\0?\0?\0\n?\0?\0??GM?\0?\0\r?\0?\0?\0?\0?\0?\0?\0?\0?\0 ?\0\r?\0?\0??%?4>?\0?\0?\0?\0?\0?\0?\0 ?\0?\0?\0?\0?\0?\0?\0?\0?\0?%?\0?\0?\ 0?\0\Z?\0\Z?\0?\0?\0?\0?\0?\0?\0?\0?)??->?<M?\0?\0?\0?\0?\0?\0?3?8F?@T??Ȁ??]???\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0!?
\0\0K\0,\0\0\0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Pacman Champion', '#FF0000', '$pacmanscore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="360" height="420">\r\n<param name="movie" value="$vpa_gameurl?location=$vpa_bburl&gamename=$ game&gamehash=$gamehash&s=$session[sessionhash]">\r\n<PARAM NAME=quality VALUE=high>\r\n<PARAM NAME=bgcolor VALUE=#000000>\r\n<embed src="$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="360" height="420"></embed></object>');
INSERT INTO arcadegames VALUES (4, 'spaceinvaders', 'Space Invaders', 'Drop down, increase speed, and reverse direction!', 'invaders.swf', 'thumb-invaders.gif', 'GIF89a\0\0?\0\0???????????????????????????????? ?????????????????????????????????????????????????? ????????????????????????????????+++??????????????? ???????????????~~~|||uuutttooonnnmmmkkk```\\\\\\XX XUUUQQQMMMLLLJJJGGGBBB@@@999777666333---,,,(((%%%"""  


\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\ 0\0c\0,\0\0\0\0\0\0\0??c??????????b??????????b? ?????????+?`UVa?]N]??bP?B\0>+??[=JW,(:T?aA3#Ea;H???M4?A G??b\\2˃?M7Z\r\0\r?\0Cb
0܂?\r/D\0?\0\06??o???H???o@#?\0lԩ B\0Z@? ??11??@ē(
?(??)Q\nHb??#(?0B?O%2\0Ѐ?+)8+???[??QcȗHOp??e??F+&0?t?\0+???L?j K??????j?רv??͋???E?L8Q \0;', 1, 1, 52, 'icon-crown-purple.gif', 'GIF89a\r\0\0?\0\0?\\ÿ+??@ϾNȰ\0Ƭ\0ż\0Ҹ\0??\0??\0??\0?? ??Gǥ\0¢\0??\0ֲ\0Ѿ\0??\0??\0Ժ\0׸\0??\0??\0??\ 0??\0??\0??????4ѧ\0ǧ\0Ǣ\0±\0Ҳ\0??\0??\0??\0 ??\0ھ\0??\0??\0??\0??\0??\0??\0????\0Ĝ\0??\0ի\ 0Ե\0޸\0޸\0ޱ\0ٰ\0ӵ\0ۯ\0׽\0??\0??)׸-ս<?+\0ɦ\0ϫ\0կ\0?+\0ػ\0????8??@ϐIJ??y????\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0!?
\0\0K\0,\0\0\0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Space Invaders Champion', '#FF0000', '$invadersscore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="500" height="500">\r\n<param name="movie" value="$vpa_gameurl?location=$vpa_bburl&gamename=$ game&gamehash=$gamehash&s=$session[sessionhash]">\r\n<param name="quality" value="high">\r\n<param name="menu" value="false">\r\n<embed src="$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="500" height="500">\r\n</embed></object>');
INSERT INTO arcadegames VALUES (5, 'snake', 'Snake', 'Eat as much as you can without hitting the walls or your own tail!', 'snake.swf', 'thumb-snake.gif', 'GIF89a\0\0?\0\07K78L8/@/G`G???~?~c?c[z[QmQOjOLfL4F4?㪢٢+?+?Ӟ?ҝ?ϛ?˘?Ǖ?Ò???t?tq?qn? nm?mk?kVsVSoS5G5?䫩ᩥܥ?ڤ+?+?ӟ?Ҟ?ѝ?М?Ϝ?Λ? ͚?̙?˙?ē?’???????????????????+??~?~|?|{?{w?w s?sr?ro?ol?la?aZxZTpTOiOKdK=Q=6H6+?+?ȗ??????c? cVrVMfMDZD","  \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0!?
\0\0U\0,\0\0\0\0\0\0\0??U???? ??????40??????4?,???????0???0+???????????+?????? ?U????????????-(#??&?#IŢ\'5N??;M?NѝT??S?Tݜ$\Z?TBG?F????????$?
??I 1
?\0v??Pʀy*????ō?7Ȱq?"?%?(D!?J?($?Xib?J ?.?IБ+@@bL8%,??\'T??B%G ??J??@
?3R ]??\r?d\0?•?M+&`r
E?O?\ZI?@???I?*-?K??ݻ?
\0;', 1, 1, 274, 'icon-crown-green.gif', 'GIF89a\r\0\0?\0\0x??T?Ye?in?q\r???? "?&*?,2?4A?Ch?i?\0??????\Z??$? #*?)-?.<?<@?@C?BO?O]?]?\0?\0?\0\r? ??\Z???\Z"??,?(,?(7?26?45?3M?L?\0???????? ?\Z"?\Z/?)8?1[?V\\?Yh?e?\0??\Z? ?(?U?MZ?Wj?eQ?C???b?D???\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\0\0K\0, \0\0\0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Snake Champion', '#FF0000', '$snakescore', 5, '<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000"codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="400" height="400">\r\n<param name="movie" value="$vpa_gameurl?location=$vpa_bburl&gamename=$ game&gamehash=$gamehash&s=$session[sessionhash]">\r\n<param name="quality" value="high">\r\n<param name="menu" value="false">\r\n<embed src="$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="400">\r\n</embed></object>');

I get this error:

Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO arcadegames VALUES (1, 'tetris', 'Tetris', 'The classic game of Tetris that we all know and love...', 'tetris.swf', 'thumb-tetris.gif', 'GIF89a\0\0?\0\0\0?\0?\0?\0\Z+\0+\0?\0?\0?,?\0?\0?\0?\0?\ \q?? ?????????????\0"?\0 ?\0#?\0#+\0!?\0?\0 ?\0!?\0"?\0?,?1P?2O?C`?Hd?He?Hd?If?Jg?Id?Ql?j??l??p?烘??????� ��??????????????????????\0&?
&?\'?-?*?(?9?8?8?:?;?=?3?A?$H?"@?7X?7W?<^?:X?8 T?@b?Ef?Gh?Jk?On?Ro?Zv?o??q??r??r??s??q??v??n??x?� ��???????1?8?<?;?=?=?#V?%X?&U?)[?$L?*[?.b?-_?,]?1d?0b?6d?9j?:j?;h?>n??m?@o?Ao?Bq?Lw?Ce?]??k??m??n??q??s?????????????????"Z?(^?+`?,b?,c?,^?/e?0d?0g?1f?2f?0b?3f?4h?5j?6j?8l?9n?:n?=r?Aq?Et?Fv? x??????????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\0\0?\0,\0\ 0\0\0\0\0\0?\0C H? ??*<??
??!?? "??!Fp ? ?-R??Y?J?,/?L9?\n??)t???Dd\0,?ǐM???0???P??H%?9??S?6H?V\ n???Ѩ??2u\n?ԪŚuiӧd?Z%??lרjÎ?ږkZ?k隵?/AA~I\ZLxҚM>?yD??%0`j?S???ˊ?@?M?˗!??P???S ?6???հ?(x??s???$J??q?\0Q?`4?+O.??\n3?/?a?`??q?hߞI?\'??Йپ]?1?bľ??3?t???}{J_0??Zm???u{??_ ?V?oI?`?s?????zM??Qq%aR?e!!?,Rɉ(Z?F\0N???$(???Aa??#=P0?A? ??c?PAA,??L6??:? @N:i?e???\\v?e@\0;', 1, 1, 391, 'icon-crown-cyan.gif', 'GIF89a\r\0\0?\0\0\\??+??@??N??\0??\0??\0??\0??\0??\0??\0??? ?G+?\0??\0??\0??\0+?\0??\0??\0??\0??\0??\0??\0??\0 ??\0??\0??????4??\0??\0??\0??\0??\0+?\0??\0??\0? ?\0??\0??\0??\0??\0??\0??\0??\0????\0??\0??\0??\0 ??\0??\0??\0??\0??\0??\0??\0??\0??\0??)??-??<??\0??\0??\0??\0??\0??\0????8??@???Ā??ϴ??? \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0!?
\0\0K\0,\0\0\0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Tetris Champion', '#FF0000', '$tetrisscore', 5, '');
INSERT INTO arcadegames VALUES (2, 'breakout', 'Breakout', 'A simple Arkanoid-style game -- see how many balls you can keep going at once!', 'breakout.swf', 'thumb-breakout.gif', 'GIF89a\0\0?\0\0\0u?\0n?\0n?\0m?\0g?\0f?\0g?\0f? \0a?\0`?\0`?\07m\03g\03f\00`\06\0=\09\0\Z3\0

\0
??
??????\n
?????????[xT\n?????????????Y\n

?????????????????ý??zzzvvvuuuQQQFFF333### \0\0\0\0\0\0!?
\0\0?\0,\0\0\0\0\0\0\0??? pH,\Z?Ȥ??)9?N?i?i ?Oq$?z??Ň?|ϣ???n?;?1???{?&?~????!|?&E???)>* ??E>?????????\r??????\0?????>\r???\n??????D??
?????\r??? ʚ???????ݘ?????>?<敺81.3??=0+?5??;-?+2???h?X?"ǿ!?n?? ?[B??ŋ?
\0;', 1, 1, 52, 'icon-crown-blue.gif', 'GIF89a\r\0\0?\0\0d\\?+-?@C?NR?\0?\0?\0?\0?\0\r?\0?\0??GO?\0?\0?\0?\0?\0?\0?\0?\0 ?\0?\0?\0?\0?\0?\0?\Z?(?4@?\0?\0?\0?\0 ?\0?\0?\0?\0?\0?\0?\0?\0?\0\Z?\0?\0?\0 ?(?\0?\0?\0?\0?\0?\0\Z?\0\Z?\0?\0?\0\Z?\0 ?\0?\0?)A?-A?=
\0?????\0;', 'Breakout Champion', '#ff0000', '$breakoutscore', 5, '');
INSERT INTO arcadegames VALUES (3, 'pacman', 'Pacman', 'A perfect recreation of the arcade classic!', 'pacman.swf', 'thumb-pacman.gif', 'GIF89a\0\0?\0\0?u?\03?L?_?????f???????\0\0?\ 0\0?\0\0?\0\0?\0\0?\0\0|\0\0y\0\0g\0\0`\0\0V\0\0H\ 0\0E\0\08\0\0+\0\0\'\0\0"\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\n\0\0\0\0?__??????? ?????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\0\0*\0,\ 0\0\0\0\0\0\0?@?pH,\Z?Ȥr?l:??h2??X1?!H?@x? )*??Ϣ??{n\'FNH{?x8?&????M!_%)?%??%M_?)
? ?L??
???L}?\0&??L\nf\'?\'_?)?\nLt??K?t??m??f??^Ʀ_fl?*l?`*??\rB$^?*?B?JDD\ZDY??????BA\0;', 1, 1, 1, 'icon-crown-red.gif', 'GIF89a\r\0\0?\0\0?f\\?++?@A?NP?\0?\0?\0?\0?\0\n?\0?\0??GM?\0?\0\r?\0?\0?\0?\0?\0?\0?\0?\0?\0 ?\0\r?\0?\0??%?4>?\0?\0?\0?\0?\0?\0?\0 ?\0?\0?\0?\0?\0?\0?\0?\0?\0?%?\0?\0?\ 0?\0\Z?\0\Z?\0?\0?\0?\0?\0?\0?\0?\0?)??->?=
\0?????\0;', 'Pacman Champion', '#FF0000', '$pacmanscore', 5, '');
INSERT INTO arcadegames VALUES (4, 'spaceinvaders', 'Space Invaders', 'Drop down, increase speed, and reverse direction!', 'invaders.swf', 'thumb-invaders.gif', 'GIF89a\0\0?\0\0???????????????????????????????? ?????????????????????????????????????????????????? ???????????????????????????????? ??????????????????????????????~~~|||uuutttooonnnmm mkkk```\\\\\\XXXUUUQQQMMMLLLJJJGGGBBB@@@9997776663 33---,,,(((%%%"""  


\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\ 0\0c\0,\0\0\0\0\0\0\0??c??????????b??????????b? ????????? ?`UVa?]N]??bP?B\0>+??[=JW,(:T?aA3#Ea;H???M4?A G??b\\2˃?M7Z\r\0\r?\0Cb
0܂?\r/D\0?\0\06??o???H???o@#?\0lԩ B\0Z@? ??11??@ē(
?(??)Q\nHb??#(?0B?O%2\0Ѐ?+)8 ???[??QcȗHOp??e??F+&0?t?\0+???L?j K??????j?רv??͋???E?L8Q \0;', 1, 1, 52, 'icon-crown-purple.gif', 'GIF89a\r\0\0?\0\0?\\ÿ+??@ϾNȰ\0Ƭ\0ż\0Ҹ\0??\0??\0??\0?? ??Gǥ\0¢\0??\0ֲ\0Ѿ\0??\0??\0Ժ\0׸\0??\0??\0??\ 0??\0??\0??????4ѧ\0ǧ\0Ǣ\0±\0Ҳ\0??\0??\0??\0 ??\0ھ\0??\0??\0??\0??\0??\0??\0????\0Ĝ\0??\0ի\ 0Ե\0޸\0޸\0ޱ\0ٰ\0ӵ\0ۯ\0׽\0??\0??)׸-ս<? \0ɦ\0ϫ\0կ\0?+\0ػ\0????8??@ϐIJ??y????\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0!?
\0\0K\0,\0\0\0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Space Invaders Champion', '#FF0000', '$invadersscore', 5, '');
INSERT INTO arcadegames VALUES (5, 'snake', 'Snake', 'Eat as much as you can without hitting the walls or your own tail!', 'snake.swf', 'thumb-snake.gif', 'GIF89a\0\0?\0\07K78L8/@/G`G???~?~c?c[z[QmQOjOLfL4F4?㪢٢ ? ?Ӟ?ҝ?ϛ?˘?Ǖ?Ò???t?tq?qn?nm?mk?kVsVSoS5G5?䫩� ��ܥ?ڤ ? ?ӟ?Ҟ?ѝ?М?Ϝ?Λ?͚?̙?˙?ē?’????????????????? ??+??~?~|?|{?{w?ws?sr?ro?ol?la?aZxZTpTOiOKdK=Q=6 H6 ? ?ȗ??????c?cVrVMfMDZD","  \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0!?
\0\0U\0,\0\0\0\0\0\0\0??U???? ??????40??????4?,???????0???0 ???????????+???????U????????????-(#??&?#IŢ\'5N??;M?NѝT??S?Tݜ$\Z?TBG?F????????$?
??I 1
?\0v??Pʀy*????ō?7Ȱq?"?%?(D!?J?($?Xib?J ?.?IБ @@bL8%,??\'T??B%G ??J??@
?3R ]??\r?d\0?•?M+&`r
E?O?\ZI?@???I?*-?K??ݻ?
\0;', 1, 1, 274, 'icon-crown-green.gif', 'GIF89a\r\0\0?\0\0x??T?Ye?in?q\r???? "?&*?,2?4A?Ch?i?\0??????\Z??$? #*?)-?.<?<@?@C?BO?O]?]?\0?\0?\0\r? ??\Z???\Z"??,?(,?(7?26?45?3M?L?\0???????? ?\Z"?\Z/?)8?1[?V\\?Yh?e?\0??\Z? ?(?U?MZ?Wj?eQ?C???b?D???\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!?
\0\0K\0, \0\0\0\0\r\0\0\0c?K????H?F?J \Z?\n?)?(?#03BC8,K*\r1A?25?;$! /4@6&-?E:$%"\'7D9+.?фIG<>=
\0?????\0;', 'Snake Champion', '#FF0000', '$snakescore', 5, '');
mysql error: You have an error in your SQL syntax near ';
INSERT INTO arcadegames VALUES (2, 'breakout', 'Breakout', 'A simple Arkanoid' at line 1
mysql error number: 1064
Date: Saturday 03rd of January 2004 11:12:36 AM
Script: /forumz/admin/query.php
Referer: http://www.theforumz.com/forumz/admin/query.php

Can somebody help me? I am trying to do it through the "Run a SQL query" hack I have integrated into my VB admin CP. I'm doing it that way because I don't know how to do it straight from the server.

Can somebody please help me? I really want to get this hack working. Thanks.

[Seby]

hey futureal, will we see a vb3 release any time soon?

[MindTrix]

Gutspiller from my knowledge alot of them MYSQL in admin cp hacks dont work properly If you know the link to your hosts CP then i can take a look for you and run the MYSQL query for you before i go to bed (3:25am here lol)

[gmarik]

we want vb3 .... we want vb3 .... we want vb3 ....