Arcade Pass Hack v3!

11/09/04 - Installer upgraded, nothing more.

11/05/04 8:28 PM EST: I botched the release because the important files "mysteriously" disappeared. I have updated the attachment.

11/04/04 9:00 PM EST: Changed to the Hack Installer System for installs. Just upload all the files in the upload folder and run forum/install/hack_install.php, chose Arcade Pass v3 and follow with the instructions. Should make a great replacement for the defunct HTL and the crappy TXT installer.

This is the Arcade Pass Hack v3. While it takes the name and feature set from it's predecessor, the Arcade Pass Hack 2.0 for vB2, the code has been improved, dependancies for the store removed, and the code completely re-written on vB3. The same code was then back-ported to vB2. Right now, the Arcade Pass Hack v3 supports both vB2 and vB3, and vbProArcade Beta 2 (for vB2) and the Arcade v3 (for vB3). When new versions of the arcades are released that have significantly changed code, another version of the Arcade Pass Hack v3 will be written for it.

The vB2 version contains a txt-based install as well as a vbHacker install, and the vB3 version uses the included Hack Installer System. Chose the appropriate vB version, then the appropriate arcade, and then chose the appropriate install and go from there. The arcadepass.php in the vB2 and vB3 folders must be uploaded to the root forums directory.

--------------------------------------

What does this hack actually do, you ask? It allows you, as an administrator, to force people to either buy an arcade pass for a set amount of points (point system not included - you'll have to install one from another hack and then configure this hack to use it) or make them pay a set amount per game (setable per game), or make them pay only if they do not have an arcade pass.

This hack also features a jackpot. First, a default jackpot (amount configurable) is set up, and after each game played, the cost of the game plus another amount (configurable per game) is added to the jackpot. If the user ends up with a high enough ranking (minimum ranking configurable), then they'll get a piece of the jackpot - if they are in 3rd place they'd get 1/3 of the jackpot, if they were in 50h, they'd get 1/50th of the jackpot, etc. Once someone takes 1st place, they default jackpot is entered back in and the lucky winner gets ALL of the jackpot.

This hack currently supports the following arcade/versions:

vB2:
vbProArcade Beta 2

vB3:
v3 Arcade (1.0)

Screenshots below.

[eNforce]

Warning: main(../upgrade_queries_v3arcade.php): failed to open stream: No such file or directory in /home/badgerh/public_html/install/hacks/Arcade_Pass_v3/1/index.php on line 40

Fatal error: main(): Failed opening required '../upgrade_queries_v3arcade.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/badgerh/public_html/install/hacks/Arcade_Pass_v3/1/index.php on line 40

This happens after I click 'done' after it Rebuilds Style Information

Ok somehow it worked itself out after re-uploading everything and running the install again but after the install it adds brackets behind the settings, see pic:

http://www.badgerhole.net/uploads/brackets.gif

Also the none of the settings were applied in the Arcade Games Settings section

[docvader]

Having problems with people not being able to submit their scores, they report getting a "blue screen". Also, usergroups that normally had access to the Arcade before installing this hack, now get the warning screen that they have to "obtain an Arcade pass", which, when clicking on that link, brings them to a blank page, looking for "uttstore.php" (what file edit is that mistake in?).

Three issues here, and I haven't even gotten into it. Any suggestions? I really need to have this in my forums . Thanks for the help!

rich
x.russbo.com

[docvader]

OK, fixed the looking for uttstore.php (it's in the arcade pass, very easy to find, change it to ushop.php).

When people try to submit their scores, this is the error message they get:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE user) SET uttpoints)=uttpoints)+43.75 WHERE userid='1'
mysql error: You have an error in your SQL syntax near ') SET uttpoints)=uttpoints)+43.75 WHERE userid='1'' at line 1

mysql error number: 1064

Date: Sunday 19th of December 2004 03:48:11 PM
Script: http://x.russbo.com/vb/arcade.php
Referer:
Username: xxxxx
IP Address: xxxxxxxxx

Still can't figure out why usergroups that have permission to use the arcade, have to buy an arcade pass.

Where have I gone wrong?

Thanks
rich

[docvader]

Fixed database error issue with PixelFX's fix from before:

UPDATE games SET arcadepass_cost='25', arcadepass_jackpot='100', arcadepass_increase='5';

Interesting, can't input text games jackpot, costs, etc, directly via admin cp now... LOL
(it never ends, does it)

rich

[docvader]

Took it out temporarily, can't seem to get it all to work correctly. Hope the issues get ironed out, really want to use this.

rich

[teamelusive]

during install....
Warning: Invalid argument supplied for foreach() in /www/teamelusive.com/html/forums/install/hacks/Arcade_Pass_v3/1/index.php on line 38

msg from email ....
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT varname, text FROM phrase WHERE varname IN () ORDER BY languageid DESC
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY languageid DESC' at line 1

mysql error number: 1064

whats it all mean?

[docvader]

Installed, and I think, working well.

Still watching what it does with the money. But, it is clear to me that having the Category hack is disruptive, and, you cannot do a simple copy and paste in one of the file edits. I copied the "changed" lines of code into my files, as opposed to doing a complete "find this and replace". (I think it was the arcadeadmin.php file)

Maybe an update with respect to the install is in order. Otherwise, nice job.

[msimplay]

will the arcade pass hack work with IB Arcade hack ?

[jbd]

Could someone post the Template Edits here? for some reason I can't access the template edits using the install file. It would be really useful to have the edited templates just pasted in here. I am referring to the following:

arcade_main_games_bit
arcade_main

[jbd]

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE user) SET uttpoints)=uttpoints)+18.4375 WHERE userid='1'
mysql error: You have an error in your SQL syntax near ') SET uttpoints)=uttpoints)+18.4375 WHERE userid='1'' at line 1

LOADS of people seem to be having similar issues. The problem here is the unecessary closing brackets after "user" and "uttpoints" (see above). I've tracked references to these irritating closing brackets to the database in "tables datastore" but I can't figure out how they end up there.

It would help lots of people if someone out there could figure this one out!