Arcade Pass Hack v2.0

[Link14716]

Arcade Pass Hack v3 is here!
vB2: https://vborg.vbsupport.ru/showthread.php?t=62060 (for futureal's vbProArcade Beta 2)
vB3: https://vborg.vbsupport.ru/showthread.php?t=62059 (for John's v3 Arcade)

[Link14716]

Screen 1

This is in vBProArcade General Options. See the new options you have? ;)

[Link14716]

Screen 2

This is when editing a game. There are 3 new fields to configure.

[Link14716]

Screen 3

This is the main arcade page where Arcade Passes and the hack itself are turned on and the user has a valid arcade pass.

[Link14716]

Screen 4

This is the main arcade page where Arcade Passes and the hack itself are turned on and the user does NOT have a valid arcade pass.

[Link14716]

Screen 5

[Link14716]

Screen 6

[Link14716]

Screen 7

[Link14716]

Screen 8

[Link14716]

Screen 9

[Link14716]

FAQ:

What versions of the Store hack is this compatable with?
This hack is compatible with v1.3 and v2 of the store hack.

Enjoy! :banana:

[joeboo]

looks awesome, i'll install it later today :)

[Dark Jim]

2 things I found that are somehow not correct.

1. In the install file it says you use "jackpotinc" a few times where it should be "jackpotadd" which is what you use.

2. Updating the main arcade options didn't work anymore so instead of replacing the sql queries I just put the new stuff before this stuff: .iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'",",
You should look at those parts.

Also this is not correct in the upgrade from my hack instructions:

-+-+-+
Find:
-+-+-+

$playcost = $gameinfo[playcost];
$jackpot = $gameinfo[jackpot];
$jackpotinc = $gameinfo[jackpotinc];

$storepoints = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]");
$points=$storepoints[storep];
if ($points > 0)
{$points -= $playcost;
$DB_site->query("UPDATE user SET storep=$points WHERE userid=$bbuserinfo[userid]");

$jackpot += $playcost + $jackpotinc;
$DB_site->query("UPDATE arcadegames SET jackpot=$jackpot WHERE name='$game'");

// query string and param lists must be eval'd since it contains PHP vars
eval("\$vpa_qstring = \"$gameinfo[querystring]\";");
eval("\$vpa_oparams = \"$oparams\";");
eval("\$vpa_eparams = \"$eparams\";");

// get the code to call the game, then send the page
eval("\$gamecode = \"".gettemplate("vbproarcade_playgame_flashcode")."\";");
eval("dooutput(\"".gettemplate('vbproarcade_playgame')."\");");
}
else
{eval("dooutput(\"".gettemplate('vbproarcade_playgame_nopoints')."\");");}

-+-+-+-+-+-+
REMOVE IT!
-+-+-+-+-+-+

It should be:

-+-+-+
Find:
-+-+-+

$playcost = $gameinfo[playcost];
$jackpot = $gameinfo[jackpot];
$jackpotinc = $gameinfo[jackpotinc];

$storepoints = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]");
$points=$storepoints[storep];
if ($points > 0)
{$points -= $playcost;
$DB_site->query("UPDATE user SET storep=$points WHERE userid=$bbuserinfo[userid]");

$jackpot += $playcost + $jackpotinc;
$DB_site->query("UPDATE arcadegames SET jackpot=$jackpot WHERE name='$game'");

// query string and param lists must be eval'd since it contains PHP vars
eval("\$vpa_qstring = \"$gameinfo[querystring]\";");
eval("\$vpa_oparams = \"$oparams\";");
eval("\$vpa_eparams = \"$eparams\";");

// get the code to call the game, then send the page
eval("\$gamecode = \"".gettemplate("vbproarcade_playgame_flashcode")."\";");
eval("dooutput(\"".gettemplate('vbproarcade_playgame')."\");");
}
else
{eval("dooutput(\"".gettemplate('vbproarcade_playgame_nopoints')."\");");}

-+-+-+-+-+-+
Replace with:
-+-+-+-+-+-+

// query string and param lists must be eval'd since it contains PHP vars
eval("\$vpa_qstring = \"$gameinfo[querystring]\";");
eval("\$vpa_oparams = \"$oparams\";");
eval("\$vpa_eparams = \"$eparams\";");

// get the code to call the game, then send the page
eval("\$gamecode = \"".gettemplate("vbproarcade_playgame_flashcode")."\";");
eval("dooutput(\"".gettemplate('vbproarcade_playgame')."\");");

[Link14716]

Firstly, I use jackpotadd, and it says to replace the jackpotinc, which you use.

Second, whoops, got a little lazy by the time I was making the upgrade file. Hold on.....

[Link14716]

I am wondering how that happened. I took the code straight from my proarcadeadmin, and mine was right :confused:

Oh, and the part you mentioned is corrected. On a superfluos note, you forgot the } and the end. :)
ZIP Updated.

[Dark Jim]

Uhm:
-----------------------------------------------
ALTER TABLE `arcadegames` ADD `playcost` int(255) NOT NULL default '10', ADD `jackpot` int(255) NOT NULL default '0', ADD `jackpotadd` int(255) NOT NULL default '5';
-----------------------------------------------
-+-+-+-+-+-+-+-+
Replace With:
-+-+-+-+-+-+-+-+

$DB_site->query("UPDATE arcadegames
SET name='$name', title='$title', description='$desc', filename='$filename',
".iif(($thumbdata != "") || ($deletethumb == 1),"thumbnailname='$thumbnail_name', thumbnaildata='$thumbdata',","")."
active='$active', scorevar='$scorevar', width='$width', height='$height',
codebase='$codebase', querystring='$querystring', objectparam='$objectparams',
embedparam='$embedparams',championactive='$champio nactive',championtext='$championtext',championcolo r='$championcolor',playcost='$playcost',jackpot='$ jackpot',jackpotinc='$jackpotadd'
WHERE gameid='$gameid'");
--------------------------------------------------------------------
It just doesn't seem right to me.

[Link14716]

As I said above, something with the instructions screwed up (dunno what, it was right on my proarcadeadmin.php), so the zip is updated.

[Dark Jim]

I have set all options to yes so you either need a pass or pay 1 credit. I tested this on the Tetris game where 1 user already is 1st (and got the jackpot). I then just quickly lost and ended 2nd. I didn't loose a credit. I also didn't buy a pass.

Also some of the jackpots have 10 credits in them but the jackpot column on the main arcade page is empty. What gives?

[Dark Jim]

If you didn't modify the store.php, proarcade.php and proarcadeadmin.php more than with your own hack, could you upload those?

[Link14716]

ok then, I will, hold on.........

[Link14716]

proarcade

[Link14716]

proarcadeadmin

[Link14716]

store

[Link14716]

Originally posted by Dark Jim
I have set all options to yes so you either need a pass or pay 1 credit. I tested this on the Tetris game where 1 user already is 1st (and got the jackpot). I then just quickly lost and ended 2nd. I didn't loose a credit. I also didn't buy a pass.

If the jackpot was 2 credits, then you would have gained a credit from 2nd place. Also, the 1 credit you lost was in the jackpot, and if it was the lone credit in the jackpot, 1/2 = 0.5 and it rounds to 1 Credit, so you regained that credit.

Also some of the jackpots have 10 credits in them but the jackpot column on the main arcade page is empty. What gives?
Make sure you edited vbproarcade_arcadebit template!

[Dark Jim]

Uhm I always gain 1 credit instead of losing one. If I get 0 points and not get to enter a comment then it takes one. Also why are the games in reversed order now?

Edit: Ok I see now but the cost column and jackpot show up now so it was definitely the instructions that are not complete or something.

[Link14716]

If you are using my file, they are because that's how I put it.

Hmm...... I tested it thouroughly and it worked perfect for me. :|

EDIT: If you get 0 points, you loose one, then it must be the jackpot add is giving you some.

Hmm.... Try getting into a very low position and see how much you gain, if jackpot divided by the poition is less than 0.5, then you'd get nothing, other than that, it'd still be rounded. remember, I tested it with the PPG Cost at 10 and the Jackpot Add at 5, so it must be the low cost and position rounding up a bit. If all else fails, raise the cost and/or raise the jackpot add.

[Dark Jim]

Ok ok I see. I guess I need to make everything more expenseive (but also increase the credits gained per post). :)

But in case you missed it from the above post, the cost and jackpot columns showed up right after I uploaded your files so the install instructions are somehow not complete.

[Link14716]

Maybe it was my fault trying to reduce queries, so let me pop back up my 3 query per arcade page version and see if you can get it to work. :)

[Link14716]

Ok, attachment back up. Dark Jim, use your proarcade.php and see if the instructions in the new zip work.

[Dark Jim]

I'll check it out tonight.

[ZiRu$]

will install in a few days :) thx homie

[Keta]

well i already added the beta. i should of waited for the full release. but good job!

[Link14716]

I included instructions to upgrade. This version is far superior to the beta release, many many more options.

My next version (v2.1) will reduce the queries created by this version (there are about 3 worthless queries on the play action and the arcade main page). But seriously....... UPGRADE! ;)

[Prophet2002]

great hack link although i do have one problem. After i got through installing it all the game/champion/scoreboard icons got messed up, some were distored other just disappeard. I reset them all and reimported them. The game icons are fine now, but the scoreboard and champion icon wont import. The scoreboard just shows a blank pic, and the champion icon shows as a missing pic (the square with the little x in the corner). Any idea whats goin on?

[Link14716]

I would be able to help you if you told me where it is happening. If it is in the admin, make SURE that you followed the instructions PERFECTLY. If it is in the arcade page, then this must be another problem, because this hack doesn't replace anything, and it doesn't even TOUCH the scoreboard pages. :)

[mewgood]

how come I can't edit the time for the password? When I change the number and click edit and it turns out the defult number again. As well when I try to change some functions in the arcradeadmin.php it will not change.

[mewgood]

anyone?

[mewgood]

help pleas.

[mewgood]

hello?

[netware]

what about new Games !

The existing Games are nice but old ! Anybody got new Games for this section ??

[Link14716]

This is not the thread to ask that in, netware.

Stop the repeated posting mewgod! I check up on my hacks but no one wanted to post here so it started going ignored. If you made all of the edits to proarcadeadmin.php, then it works.

[mewgood]

I did
but it just the same
it won't change..

[Link14716]

-+-+-+
Find:
-+-+-+

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'","")."
WHERE arcadeid='$arcadeid'");

-+-+-+-+-+-+-+-+
Replace With:
-+-+-+-+-+-+-+-+

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'",", passtimeout='$passtimeout', epergamecost='$epergamecost', earcadepass='$earcadepass', eaph='$eaph', ejackpot='$ejackpot'")."
WHERE arcadeid='$arcadeid'");


It works, trust me.

[mewgood]

no
not working
here ism y proarcadeadmin.php

[Link14716]

I dunno how you pulled this one over me.

It IS being submitted, I can tell you that.
But for some reason, yours won't update the field. Looking in my proarcadeadmin.php file, the problem line is exactly the same, which is what wonders me.

One notable difference I see are the versions - and that is all. Let me look at your code some more...

[mewgood]

what codes?
I dont think it really matters the vb version

[Link14716]

Ok, I found where the problem is, I just don't know how to tell you how to fix it without replacing an entire action (fun fun). All I can say is cross your fingers!

Find:
// ###################### Start GENERAL OPTIONS Update #######################
if ($action=="doupdateoptions") {

// only process the files if changes were made
if (is_array($HTTP_POST_FILES)) {

if ($HTTP_POST_FILES[scoreicon]['name'] != "")
$scoreicondata = vpaupload("scoreicon");
else
$scoreicondata = "";

if ($HTTP_POST_FILES[kingicon]['name'] != "")
$kingicondata = vpaupload("kingicon");
else
$kingicondata = "";

} else {

$scoreicondata = "";
$kingicondata = "";

}

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'",", passtimeout='$passtimeout', epergamecost='$epergamecost', earcadepass='$earcadepass', eaph='$eaph', ejackpot='$ejackpot'")."
WHERE arcadeid='$arcadeid'");

// update champ system setting separately (saves queries!)
$DB_site->query("UPDATE setting SET value='$champsystem' WHERE varname='vpa_champsystem'");

// must update templates so site will reflect change
$optionstemplate=generateoptions();
$DB_site->query("UPDATE template SET template='$optionstemplate' WHERE title='options'");

echo "<b>Arcade options updated!</b><br><br>";

// go back to change options screen
$action = "changeoptions";

}


Replace it ALL with:
// ###################### Start updateoptions #######################
if ($action=="doupdateoptions") {

// only process icons if changes were made
if ($scoreicon != "") {

// check for valid extension
$extension=strtolower(substr(strrchr($scoreicon_na me,"."),1));

if (($extension != "gif") and ($extension != "jpg") and ($extension != "jpeg") and ($extension != "png")) {

echo "vbProArcade Error: " . $scoreicon_name . " is not a valid file type for icons (only gif/jpg/png are supported)<br><br>";
$scoreicon = "";

} else {

// retrieve file data
$scorei_f = fopen($scoreicon, "r");
$scorei_d = addslashes(fread($scorei_f, filesize($scoreicon)));

}
}

// only process icons if changes were made
if ($kingicon != "") {

// check for valid extension
$extension=strtolower(substr(strrchr($kingicon_nam e,"."),1));

if (($extension != "gif") and ($extension != "jpg") and ($extension != "jpeg") and ($extension != "png")) {

echo "vbProArcade Error: " . $kingicon_name . " is not a valid file type for icons (only gif/jpg/png are supported)<br><br>";
$kingicon = "";

} else {

// retrieve file data
$kingi_f = fopen($kingicon, "r");
$kingi_d = addslashes(fread($kingi_f, filesize($kingicon)));

}
}

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'",", passtimeout='$passtimeout', epergamecost='$epergamecost', earcadepass='$earcadepass', eaph='$eaph', ejackpot='$ejackpot'")."
WHERE arcadeid='$arcadeid'");

// update champ system setting separately (saves queries!)
$DB_site->query("UPDATE setting SET value='$champsystem' WHERE varname='vpa_champsystem'");

// $DB_site->query("UPDATE template SET template=CONCAT(template,'vpa_champsystem = $champsystem') WHERE title='options'");

$optionstemplate=generateoptions();
$DB_site->query("UPDATE template SET template='$optionstemplate' WHERE title='options'");

echo "<b>Arcade options updated!</b><br><br>";

// go back to change options screen
$action = "changeoptions";

}

And I don't mean vB version, I mean arcade version.

[mewgood]

hey
it workd!!!
Thx:D

[Link14716]

Your Welcome. Remember to hit the "Install" buton! ;)

[mewgood]

yep
just did:D

[Issy_X]

This hack is just what I was looking for. I installed it and everything works except for one little thing. And that is that users are gaining the amount of points the have to pay instead of losing them. What did I do wrong. I followed every step exactly.

[Link14716]

How many points do you charge?

[Issy_X]

100 (I changed it to -100 just to see what it would do and it gave the user 5 points for playing a game, very strange)

[Link14716]

It gives the user money from the jackpot using a formula (this is after the game ends).

jackpot/position

So, when the user starts the game, they loose 100 points and that is added to the jackpot. So, if the jackpot is 500, for instance, and the got 2nd place, then they would get half of the jackpot, in this case it'd be 250 points. So they would end up with 150 more points than they had when they started the game.

[Deimos]

I do have one small problem with this hack.
After installing it, I lose user's usernames on every thread?
Um...here's a screenshot of Before and After....

http://www.adam.dresch.btinternet.co.uk/before.JPG

And here's after....

http://www.adam.dresch.btinternet.co.uk/after.JPG

[Link14716]

That is not related to my hack. My hack does not touch anything that deals with usenames. It is possible that the store hack part messed up. Make sure all store hack templates and all edits have been made correctly to functions.php (for the store). :)

[tpearl5]

Is there a way to make the jackpot value increase when a person with a pass plays a game? If everyone has a pass then they'll be no jackpot.

[Kars10]

Sorry Link, but this addon do not work for me. Please have a look at my Proarcade.
If a user is loggedin, unregistered or without a pass...he gets the Arcade-Playon template,...whats the error with it?
If i go to my Database and look at the usertable, all looks ok. I am the only user with a pass and this is written in my field arcadepass-field: 1037613669....
Please help.... :(

[Kars10]

^bumb^

[Link14716]

Originally posted by tpearl5
Is there a way to make the jackpot value increase when a person with a pass plays a game? If everyone has a pass then they'll be no jackpot.
When someone with a pass plays a game, the jackpot is increased *after* the game is over. This is to stop people from hitting the link into the game over and over and over...

[Link14716]

Originally posted by Minifreunde
^bumb^

I don't see anything wrong with your proarcade.php. Make sure that you ran all of the queries correctly, and check the options you set in the admin CP.

[Kars10]

I promise i run all Querys, ive done all File-edits and all seems fine. But this won?t work for me.
If i looged in, it always tells me "youve got a arcade-pass-play on!" For me this is right, but all other Members and Guests are without a pass, and they get the same message.
If i go to admin-panel and say: Jackpot off, its off. If i say Games per costing, the cost-cell is not there. What can the Problem be?
Is it the store 2 Version??
Im going crazy...:(

[tpearl5]

Originally posted by Link14716

When someone with a pass plays a game, the jackpot is increased *after* the game is over. This is to stop people from hitting the link into the game over and over and over...

Humm... it didn't seem to be doing that for me. I'll have to test it further.

[Kars10]

It works now Link!!!
Sorry, ... it was a mistake i made :( ;)

* Minifreunde klicks install!

[Link14716]

Originally posted by Minifreunde
It works now Link!!!
Sorry, ... it was a mistake i made :( ;)

* Minifreunde klicks install!

Glad to hear that it works now. :)

And thanks for confirming that this is compatible with Store v2! :)

[ad_uk6565]

<a href="http://www.nintendofire.com/forums/store.php?" target="_blank">http://www.nintendofire.com/forums/store.php?</a>

can someone click on that, and go to arcade pass and tell me why the heck it links to 'action=arcadepass' when that don't work, and it should be 'action=arcadepassadd'...? and how the heck do I change this?

[ad_uk6565]

damn link, your hack's screwed everything up on my forums..let me go back and do it again *sigh*

[The_Wanderer]

hmmm... this might be of use...

[bensonfactor]

I installed it but some of the users who bought a pass get this message:
"You do not have permission to access this page. This could be due to one of several reasons:
You do not have permission to access the page that you were trying to. Are you trying to edit someone else's post or trying to access administrative features? Check that you are allowed to perform this action in the Forum Rules.
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation. "

Any way I can fix this?

[Link14716]

I'd need more information to help you with that.

What page does the error appear on?
Before buying a pass, did they get that message?

[Automated]

What a great hack it stops people registering and not posting!

* Automated click install :p

[apokphp]

Benson, that is probably a conflict w/ vbProarcade, not the pass. Do you have custom usergroups in vb? If so, you have to change the switch in proarcade.php. You'll see what I mean near the top of the file...it will list all usergroups that can access the arcade.

Just add the custom usergroups to the list via copy/pasting the code lines.

Link: The hack works w/ exception of the Jackpot for me. It gives the player the FULL jackpot regardless of how they do in the game or their rank.

What could be the cause of this?

As I said earlier, it appears all else is ok. I'm still having my members test it out though. :)

[ethics]

I have a weird problem.

In the instructions, it says to:

-+-+-+
Find:
-+-+-+

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'","")."
WHERE arcadeid='$arcadeid'");

The only instance of "$DB_site->query("UPDATE arcadeconfig" I get in that file is the following:

$DB_site->query("UPDATE arcadeconfig
SET active='$active',path='$thepath'
".iif(($addgroup != 0) or ($delgroup != 0),",useraccess='$useraccess'","")."
,usescoreicons='$usescoreicons',usekingicon='$usek ingicon',usedetailicons='$usedetailicons'
".iif(($scoreicondata != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scoreicondata'","")."
".iif(($topscoreicondata != "") || ($deletetopscoreicon == 1),",topscoreiconname='$topscoreicon_name', topscoreicondata='$topscoreicondata'","")."
".iif(($kingicondata != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingicondata'","")."
".iif(($userdetailicondata != "") || ($deleteuserdetailicon == 1),",userdetailiconname='$userdetailicon_name', userdetailicondata='$userdetailicondata'","")."
".iif(($gamedetailicondata != "") || ($deletegamedetailicon == 1),",gamedetailiconname='$gamedetailicon_name', gamedetailicondata='$gamedetailicondata'","")."
WHERE arcadeid='$arcadeid'");

It's totally different.

I think this is why I get an SQL error when I try to change the dollar amount to play the game?

This is the error I get:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE arcadegames
SET name='breakout', title='Breakout', description='A simple Arkanoid-style game -- see how many balls you can keep going at once!', filename='breakout.swf',

active='1', scorevar='$breakoutscore', width='', height='',
codebase='', querystring='', objectparam='',
embedparam='',championactive='1',championtext='Bre akout Champion',championcolor='#ff0000',playcost='50',ja ckpot='20',jackpotadd='5'
WHERE gameid='2'
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

[Link14716]

What Arcade version? I think this only works with Beta 1.03 right now...

[ethics]

Originally posted by Link14716
What Arcade version? I think this only works with Beta 1.03 right now...

It's whatever your first post of this hack points to. Beta 2 I believe?

If that's the discrepancy, then I can see where the problem comes in.

Any date on the beta 2 integration?

[ethics]

Actually, the hack works, 95% of the way. What I did was use db queries to change the options I needed. :)

[DarkDraco07]

how come when people play snake it give them gil even though they dont get 1st

[Link14716]

It gives people a piece of the jackpot no matter what position they get. If they get 2nd, they get 1/2 of the jackpot, if they get third they get 1/3, fourth 1/4, and so on...

[DarkDraco07]

anyway to stop that?

[Link14716]

Untested but it should work...

Proarcade.php
Find:
if ($position == 1) {
$jackpotgiven_u=$DB_site->query("UPDATE user SET storep=storep+$jackpotgiven_j[jackpot] WHERE userid='$bbuserinfo[userid]'");
} else {
$jackpotgiven_u=$DB_site->query("UPDATE user SET storep=storep+$jackpotgiven_us WHERE userid='$bbuserinfo[userid]'");
}
$jackpotgiven_r=$DB_site->query("UPDATE arcadegames SET jackpot=jackpot-$jackpotgiven_us WHERE name='$game'");
Replace With:
if ($position == 1) {
$jackpotgiven_u=$DB_site->query("UPDATE user SET storep=storep+$jackpotgiven_j[jackpot] WHERE userid='$bbuserinfo[userid]'");
$jackpotgiven_r=$DB_site->query("UPDATE arcadegames SET jackpot='0' WHERE name='$game'");
}

[DarkDraco07]

thanks, trying it now

[Preech]

does anyone have the Tetris.swf file extracted? for some reason I can't pull it out of the zip file...

any help is appreciated.

[tpearl5]

Originally posted by ethics
I have a weird problem.

In the instructions, it says to:

-+-+-+
Find:
-+-+-+

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'","")."
WHERE arcadeid='$arcadeid'");

The only instance of "$DB_site->query("UPDATE arcadeconfig" I get in that file is the following:

$DB_site->query("UPDATE arcadeconfig
SET active='$active',path='$thepath'
".iif(($addgroup != 0) or ($delgroup != 0),",useraccess='$useraccess'","")."
,usescoreicons='$usescoreicons',usekingicon='$usek ingicon',usedetailicons='$usedetailicons'
".iif(($scoreicondata != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scoreicondata'","")."
".iif(($topscoreicondata != "") || ($deletetopscoreicon == 1),",topscoreiconname='$topscoreicon_name', topscoreicondata='$topscoreicondata'","")."
".iif(($kingicondata != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingicondata'","")."
".iif(($userdetailicondata != "") || ($deleteuserdetailicon == 1),",userdetailiconname='$userdetailicon_name', userdetailicondata='$userdetailicondata'","")."
".iif(($gamedetailicondata != "") || ($deletegamedetailicon == 1),",gamedetailiconname='$gamedetailicon_name', gamedetailicondata='$gamedetailicondata'","")."
WHERE arcadeid='$arcadeid'");

It's totally different.

I think this is why I get an SQL error when I try to change the dollar amount to play the game?

This is the error I get:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE arcadegames
SET name='breakout', title='Breakout', description='A simple Arkanoid-style game -- see how many balls you can keep going at once!', filename='breakout.swf',

active='1', scorevar='$breakoutscore', width='', height='',
codebase='', querystring='', objectparam='',
embedparam='',championactive='1',championtext='Bre akout Champion',championcolor='#ff0000',playcost='50',ja ckpot='20',jackpotadd='5'
WHERE gameid='2'
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

I'm having the same problem. I tried merging the code, but it didn't work. humm..

[Preech]

i get this same problem in the cp when I try to change options :(

[ethics]

I don't think this pass hack is compatible with version 2 of the arcade itself guys.

I would go to the database and make changes there. It's very easy and self explanatory when you brows through the queries.

[Ice Effect69]

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE arcadegames
SET name='asteroids2000', title='Z Asteroids2000', description='Astroids Arcade Game! Score Board Dont Work!', filename='Asteroids2000.swf',

active='1', scorevar='$Asteroids2000', width='', height='',
codebase='', querystring='', objectparam='',
embedparam='',championactive='1',championtext='Ast eroids2000 Champion',championcolor='#ff0000',playcost='10',ja ckpot='0',jackpotadd='5'
WHERE gameid='7'
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

Date: Monday 10th of February 2003 11:47:35 AM
Script: http://www.prowrestlingdirect.com/forums/forums/admin/proarcadeadmin.php
Referer: http://www.prowrestlingdirect.com/forums/admin/proarcadeadmin.php?action=modify


i keep getting that error in the admin. Link can you please edit my original proarcadeadmin to work with the arcade pass? everything else works, it is just the admin page. And can u please attach a file with the sql queries i would need to run?

[Link14716]

Beta 2 is not compatible and I haven't had time to make it compatible. Just hold on....

[Ice Effect69]

everything works with beta 2 besides for the admin section

[Ice Effect69]

link can you please make this capatible for for beta 2

[sabret00the]

this is a cool hack, should get my users off the arcade and posting more ^_^

[sabret00the]

ah man, no one zipped the templates for tbs easy installation, i might have to do it

/clicks install

[sabret00the]

the templates for you guys and gals

[lynda]

I had no problems at all getting this to work with beta2. The store.php changes remain the same.

Here are the differences I found:

In proarcade.php, instead of this: if ($newscoreid==$thisid) {
$foundscore = 1;
}

}

Find this: if ($newscoreid==$thisid)
That was the only change different than suggested for that file.

In proarcadeadmin.php find this:
$DB_site->query("UPDATE arcadegames
SET name='$name', title='$title', description='$desc', filename='$filename', hashoffset='$hashoffset',
".iif(($championdata != "") || ($deletechampicon == 1),"championpicname='$championicon_name', championpicdata='$championdata',","")."
".iif(($thumbdata != "") || ($deletethumb == 1),"thumbnailname='$thumbnail_name', thumbnaildata='$thumbdata',","")."
active='$active', scorevar='$scorevar', gamecode='$gamecode',championactive='$championacti ve',championtext='$championtext',championcolor='$c hampioncolor'
WHERE gameid='$gameid'");
Replace with this: $DB_site->query("UPDATE arcadegames
SET name='$name', title='$title', description='$desc', filename='$filename', hashoffset='$hashoffset',
".iif(($championdata != "") || ($deletechampicon == 1),"championpicname='$championicon_name', championpicdata='$championdata',","")."
".iif(($thumbdata != "") || ($deletethumb == 1),"thumbnailname='$thumbnail_name', thumbnaildata='$thumbdata',","")."
active='$active', scorevar='$scorevar', gamecode='$gamecode',championactive='$championacti ve',championtext='$championtext',championcolor='$c hampioncolor',playcost='$playcost',jackpot='$jackp ot',jackpotadd='$jackpotadd'
WHERE gameid='$gameid'");
Find this: $DB_site->query("INSERT INTO arcadegames (name,title,description,filename,active,hashoffset ,scorevar,gamecode,championactive,championtext,cha mpioncolor"
.iif($championdata != "",",championpicname,championpicdata","")
.iif($thumbdata != "",",thumbnailname,thumbnaildata","").")
VALUES ('$name','$title','$desc','$filename','$active','$ hashoffset','$scorevar','$gamecode','$championacti ve','$championtext','$championcolor'"
.iif($championdata != "",",'$championicon_name','$championdata'","")
.iif($thumbdata != "",",'$thumbnail_name','$thumbdata'","").")");

Replace with this: $DB_site->query("INSERT INTO arcadegames (name,title,description,filename,active,hashoffset ,scorevar,gamecode,championactive,championtext,cha mpioncolor,playcost,jackpot,jackpotadd"
.iif($championdata != "",",championpicname,championpicdata","")
.iif($thumbdata != "",",thumbnailname,thumbnaildata","").")
VALUES ('$name','$title','$desc','$filename','$active','$ hashoffset','$scorevar','$gamecode','$championacti ve','$championtext','$championcolor','$playcost',' $jackpot','$jackpotadd'"
.iif($championdata != "",",'$championicon_name','$championdata'","")
.iif($thumbdata != "",",'$thumbnail_name','$thumbdata'","").")");

Find this: $DB_site->query("UPDATE arcadeconfig
SET active='$active',path='$thepath'
".iif(($addgroup != 0) or ($delgroup != 0),",useraccess='$useraccess'","")."
,usescoreicons='$usescoreicons',usekingicon='$usek ingicon',usedetailicons='$usedetailicons'
".iif(($scoreicondata != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scoreicondata'","")."
".iif(($topscoreicondata != "") || ($deletetopscoreicon == 1),",topscoreiconname='$topscoreicon_name', topscoreicondata='$topscoreicondata'","")."
".iif(($kingicondata != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingicondata'","")."
".iif(($userdetailicondata != "") || ($deleteuserdetailicon == 1),",userdetailiconname='$userdetailicon_name', userdetailicondata='$userdetailicondata'","")."
".iif(($gamedetailicondata != "") || ($deletegamedetailicon == 1),",gamedetailiconname='$gamedetailicon_name', gamedetailicondata='$gamedetailicondata'","")."
WHERE arcadeid='$arcadeid'");

Replace with this: $DB_site->query("UPDATE arcadeconfig
SET active='$active',path='$thepath'
".iif(($addgroup != 0) or ($delgroup != 0),",useraccess='$useraccess'","")."
,usescoreicons='$usescoreicons',usekingicon='$usek ingicon',usedetailicons='$usedetailicons'
".iif(($scoreicondata != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scoreicondata'","")."
".iif(($topscoreicondata != "") || ($deletetopscoreicon == 1),",topscoreiconname='$topscoreicon_name', topscoreicondata='$topscoreicondata'","")."
".iif(($kingicondata != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingicondata'","")."
".iif(($userdetailicondata != "") || ($deleteuserdetailicon == 1),",userdetailiconname='$userdetailicon_name', userdetailicondata='$userdetailicondata'","")."
".iif(($gamedetailicondata != "") || ($deletegamedetailicon == 1),",gamedetailiconname='$gamedetailicon_name', gamedetailicondata='$gamedetailicondata'",", passtimeout='$passtimeout', epergamecost='$epergamecost', earcadepass='$earcadepass', eaph='$eaph', ejackpot='$ejackpot'")."
WHERE arcadeid='$arcadeid'");

The rest of the makeextrainputcode find/replaces are correct.

[Colon33]

Anyway to make this same hack work with the ITEMSHOP points system? To allow people to play the arcade only when enough posting points is acquired?

[Opie]

what query do a need to run to reset the highscores?

[Link14716]

@Colon - It should be simple enough to edit it work with the itemshop. I'll boot up Apache and work on it for you. :)

@Opie - DELETE FROM arcadescores;
DELETE FROM arcadetopscores;

[Opie]

I don't have those tables Link.

[Link14716]

Those are Beta 2 tables so I guess you're using Beta 1. In that case...

DELETE FROM arcade;

[Opie]

thanks

[DigitalDesktops]

Is there a way to make each game cost different?

Example:

Breakout 0
Pacman 0
Snake 0
Simon Says 5
Space Invaders 5
Tetris 5
Plasma 10
Worn 10
Hexxagon 10

EDIT: nvm i found it in the Arcade CP

[DigitalDesktops]

Invalid SQL: UPDATE arcadegames
SET name='asteroid_class', title='Asteroids', description='Classic game of Asteroids! ', filename='asteroids.swf',

active='0', scorevar='$asterscore', width='', height='',
codebase='', querystring='', objectparam='',
embedparam='',championactive='1',championtext='Ast eroids Champion',championcolor='#ff0000',playcost='10',ja ckpot='0',jackpotadd='5'
WHERE gameid='11'
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

I get this error everytime i try to modify a game via Admin CP.

i'm using this HTML code:


<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="600" height="800">
<param name="movie" value="$vpa_gameurl?location=$vpa_bburl&gamename=$game&gamehash=$gamehash&s=$session[sessionhash]">
<param name=loop value=false>
<param name=menu value=false>
<param name=quality value=high>
<param name=bgcolor value=#000000>
<embed src="$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="500">
</embed></object>

[PixelFx]

is it possible to make an updated install txt for arcade pass for vbarcade beta 2?

I've followed the info above, and the index.txt from this hack and although the admin section seems to work, the jackpot doesn't seem to visualy update, anyone else have this problem?

[dstruct2k]

Yea, the Jackpot won't update, and it says "Your Arcade Pass has been verified" when I don't even have the option in the store....

Note: Newest version of everything.

[kaotic]

I had 1 point. The jackpot for the game I played (breakout) was set to 1. The cost to play breakout was 1 point. I had earned 60 SCORE points after I finished playing breakout, and I received over 200 regular points for it... is that suppose to happen?

[Link14716]

I don't see how some of these errors are happening, all I can say is, double check all the instructions.

Beta 2 instructions will come when I have my FTP password reset, and when I am not too lazy to make a .txt file and ZIP it.

[gengar003]

hm... In my proarcadeadmin.php file, i'm supposed to replace


$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'","")."
WHERE arcadeid='$arcadeid'");



with



$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',useki ngicon='$usekingicon'
".iif(($scoreicon != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scorei_d'","")."
".iif(($kingicon != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingi_d'",", passtimeout='$passtimeout', epergamecost='$epergamecost', earcadepass='$earcadepass', eaph='$eaph', ejackpot='$ejackpot'")."
WHERE arcadeid='$arcadeid'");


but it's not there... the closest thing to it is:


$DB_site->query("UPDATE arcadeconfig
SET active='$active',path='$thepath'
".iif(($addgroup != 0) or ($delgroup != 0),",useraccess='$useraccess'","")."
,usescoreicons='$usescoreicons',usekingicon='$usek ingicon',usedetailicons='$usedetailicons'
".iif(($scoreicondata != "") || ($deletescoreicon == 1),",scoreiconname='$scoreicon_name', scoreicondata='$scoreicondata'","")."
".iif(($topscoreicondata != "") || ($deletetopscoreicon == 1),",topscoreiconname='$topscoreicon_name', topscoreicondata='$topscoreicondata'","")."
".iif(($kingicondata != "") || ($deletekingicon == 1),",kingiconname='$kingicon_name', kingicondata='$kingicondata'","")."
".iif(($userdetailicondata != "") || ($deleteuserdetailicon == 1),",userdetailiconname='$userdetailicon_name', userdetailicondata='$userdetailicondata'","")."
".iif(($gamedetailicondata != "") || ($deletegamedetailicon == 1),",gamedetailiconname='$gamedetailicon_name', gamedetailicondata='$gamedetailicondata'","")."
WHERE arcadeid='$arcadeid'");


soo... what should I replace w/ what?

[Link14716]

As I said before, those running Beta 2 of the vbProArcade hack MUST follow instructions posted earlier in this thread by a nice user (can't be bothered to get the username of this person while typing this). Note that those modifications for Beta 2 are not tested, and I will try to get a Beta 2 txt file up in the ZIP soon.

[DigitalDesktops]

here are the 15 new templates for the Arcade Pass. you need the Template Backup System in order to use them properly. :)
you will still have to modify the edited templates.

[dstruct2k]

So, wait a second.... My arcade is screwed then? I used the install instructions from the first post of this thread, and I've got Beta2 of the Arcade.

Could someone be kind enough to PM me a working copy of the proarcade.php file from Beta2? I really don't feel like re-hacking my files, and it's probably easier to just ask.

I don't have any other hacks for the Arcade installed, so pretty much anyone can send me it...

[chavalo2]

OK guys why is I cant even run this in mysql without errors.

Not sure how the rest of you are doing this as this is right from the 'how-to'

ALTER TABLE `user` ADD `arcadepass` INT(255) DEFAULT '0' NOT NULL;
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, 'arcadepass', 'Arcade Pass', '500', '0', 'images/arcade.gif', 'Buy a lifetime pass into the Arcade!', 'N', '0');

ALTER TABLE `arcadeconfig` ADD `passtimeout` BIGINT(255) DEFAULT '155520000' NOT NULL, ADD `epergamecost` TINYINT(1) DEFAULT '1' NOT NULL, ADD `earcadepass` TINYINT(1) DEFAULT '1' NOT NULL, ADD `eaph` TINYINT(1) DEFAULT '1' NOT NULL, ADD `ejackpot` TINYINT(1) DEFAULT '1' NOT NULL;

ALTER TABLE `arcadegames` ADD `playcost` int(255) NOT NULL default '10', ADD `jackpot` int(255) NOT NULL default '0', ADD `jackpotadd` int(255) NOT NULL default '5';

And here the errors from the mysql query :

SQL-query : [Edit]

ALTER TABLE `user` ADD `arcadepass` INT(255) DEFAULT \'0\' NOT NULL;
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, \'arcadepass\', \'Arcade Pass\', \'500\', \'0\', \'images/arcade.gif\', \'Buy a lifetime pass into the Arcade!\', \'N\', \'0\');

ALTER TABLE `arcadeconfig` ADD `passtimeout` BIGINT(255) DEFAULT \'155520000\' NOT NULL, ADD `epergamecost` TINYINT(1) DEFAULT \'1\' NOT NULL, ADD `earcadepass` TINYINT(1) DEFAULT \'1\' NOT NULL, ADD `eaph` TINYINT(1) DEFAULT \'1\' NOT NULL, ADD `ejackpot` TINYINT(1) DEFAULT \'1\' NOT NULL;

ALTER TABLE `arcadegames` ADD `playcost` int(255) NOT NULL default \'10\', ADD `jackpot` int(255) NOT NULL default \'0\', ADD `jackpotadd` int(255) NOT NULL default \'5\';

MySQL said:


You have an error in your SQL syntax near '\'0\' NOT NULL;
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, ' at line 1

Back

HELP???

[chavalo2]

Installed By: 62 users

and everyone of those 62 users can run a faulty query??!!

respond someone??

I definately wont/cant install if there is no support or a valid query request

[Link14716]

Get your host to upgrade phpMyAdmin or run these queries seperately! It should work without seperating them, however, it seems as if it won't work like that for you.

ALTER TABLE `user` ADD `arcadepass` INT(255) DEFAULT '0' NOT NULL;INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, 'arcadepass', 'Arcade Pass', '500', '0', 'images/arcade.gif', 'Buy a lifetime pass into the Arcade!', 'N', '0');ALTER TABLE `arcadeconfig` ADD `passtimeout` BIGINT(255) DEFAULT '155520000' NOT NULL, ADD `epergamecost` TINYINT(1) DEFAULT '1' NOT NULL, ADD `earcadepass` TINYINT(1) DEFAULT '1' NOT NULL, ADD `eaph` TINYINT(1) DEFAULT '1' NOT NULL, ADD `ejackpot` TINYINT(1) DEFAULT '1' NOT NULL; ALTER TABLE `arcadegames` ADD `playcost` int(255) NOT NULL default '10', ADD `jackpot` int(255) NOT NULL default '0', ADD `jackpotadd` int(255) NOT NULL default '5';

[chavalo2]

well for the record I am running MySQL 3.23.54


As per your post above of the queries here are my results:

For

ALTER TABLE `user` ADD `arcadepass` INT(255) DEFAULT '0' NOT NULL;

I get errors that say:

SQL-query : [Edit]

ALTER TABLE `user` ADD `arcadepass` INT(255) DEFAULT \'0\' NOT NULL;

MySQL said:


You have an error in your SQL syntax near '\'0\' NOT NULL' at line 1

Back

[Link14716]

I said phpMyAdmin, not MySQL ;)

Try searching the Full Releases forum for one of the hacks that allow you to run queries from the admin center, install it, and run the queries seperate using that.

[chavalo2]

That was phpMyAdmin

Welcome to phpMyAdmin 2.2.0
MySQL 3.23.54 running on localhost

Still get those errors.

I installed and ran it through the admin CP as you stated and still get errors.

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: ALTER TABLE `user` ADD `arcadepass` INT(255) DEFAULT '0' NOT NULL;

mysql error: You have an error in your SQL syntax near ';
' at line 1

mysql error number: 1064

And on the next code:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource on line 27

Query Result - INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, 'arcadepass', 'Arcade Pass', '500', '0', 'images/arcade.gif', 'Buy a lifetime pass into the Arcade!', 'N', '0');

and with phpmyadmin:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource on line 27

Query Result - INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, \'arcadepass\', \'Arcade Pass\', \'500\', \'0\', \'images/arcade.gif\', \'Buy a lifetime pass into the Arcade!\', \'N\', \'0\');

MySQL said:


You have an error in your SQL syntax near 'Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resou' at line 1

Back

[DigitalDesktops]

hmm try doing this:

ALTER TABLE user ADD arcadepass INT(255) DEFAULT '0' NOT NULL;

[chavalo2]

Today at 04:04 AM DigitalDesktops said this in Post #116 (https://vborg.vbsupport.ru/showthread.php?postid=386752#post386752)
hmm try doing this:

ALTER TABLE user ADD arcadepass INT(255) DEFAULT '0' NOT NULL;


hmmm that one worked thanks... any help on the next few queries please :nervous:

[chavalo2]

I figured out the third Query on the 'to-do'

ALTER TABLE arcadeconfig ADD passtimeout BIGINT(255) DEFAULT 155520000 NOT NULL, ADD epergamecost TINYINT(1) DEFAULT 1 NOT NULL, ADD earcadepass TINYINT(1) DEFAULT 1 NOT NULL, ADD eaph TINYINT(1) DEFAULT 1 NOT NULL, ADD ejackpot TINYINT(1) DEFAULT 1 NOT NULL

Here is the 4th working one also:

ALTER TABLE arcadegames ADD playcost int(255) NOT NULL default 10, ADD jackpot int(255) NOT NULL default 0, ADD jackpotadd int(255) NOT NULL default 5;

Number 2 has me baffled.

[chavalo2]

Here is the one I cant get:

INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, 'arcadepass', 'Arcade Pass', '500', '0', 'images/arcade.gif', 'Buy a lifetime pass into the Arcade!', 'N', '0');

[GaleForce]

Looks nice, going to install it right now.

[DigitalDesktops]

04-25-03 at 08:12 AM chavalo2 said this in Post #119 (https://vborg.vbsupport.ru/showthread.php?postid=386791#post386791)
Here is the one I cant get:

INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, 'arcadepass', 'Arcade Pass', '500', '0', 'images/arcade.gif', 'Buy a lifetime pass into the Arcade!', 'N', '0');


hmm try this (Make sure you have the Store Hack installed :)):

INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (NULL, 'arcadepass', 'Arcade Pass', '500', '0', 'images/arcade.gif', 'Buy a lifetime pass into the Arcade!', 'N', '0');

[chavalo2]

Nope... Store is installed also.

Still no go :(

[Reno]

So this is compatible with vB 2.3 right?

[chavalo2]

I would say NO

[PixelFx]

any plans for an update when vb arcade 2.1 is released?

[king sting]

I'm getting this error when I try to edit the amount of the jackpot in the modify games menu:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE arcadegames
SET name='breakout', title='Breakout', description='A simple Arkanoid-style game -- see how many balls you can keep going at once!', filename='breakout.swf',

active='1', scorevar='$breakoutscore', width='', height='',
codebase='', querystring='', objectparam='',
embedparam='',championactive='1',championtext='Bre akout Champion',championcolor='#ff0000',playcost='10',ja ckpot='60',jackpotadd='5'
WHERE gameid='2'
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

Date: Friday 16th of May 2003 09:00:02 PM
Script: http://www.cali-stylez.net/vb/vb/admin/proarcadeadmin.php
Referer: http://www.cali-stylez.net/vb/admin/proarcadeadmin.php?action=modify&


Any ideas?

[vB-Host.com]

i am getting this when trying to update the game or enter the arcade

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT score,username FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT 1
mysql error: Table 'sports_forum.arcade' doesn't exist

mysql error number: 1146

Date: Saturday 17th of May 2003 09:56:35 PM
Script: http://www.thesportsforum.net/proarcade.php?s=
Referer: http://www.thesportsforum.net

[vB-Host.com]

if i put make the files before the three files you said to update with in the beginning area of thus thread the acrade works but if i edit a game in admin i now get..

Invalid SQL: UPDATE arcadegames
SET name='breakout', title='Breakout', description='A simple Arkanoid-style game -- see how many balls you can keep going at once!', filename='breakout.swf',

active='1', scorevar='$breakoutscore', width='', height='',
codebase='', querystring='', objectparam='',
embedparam='',championactive='1',championtext='Bre akout Champion',championcolor='#ff0000',playcost='10',ja ckpot='60',jackpotadd='5'
WHERE gameid='2'
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

Date: Friday 16th of May 2003 09:00:02 PM
Script: http://www.thesportsforum.net/admin.arcadeadmin.php
Referer: http://www.

[vB-Host.com]

king sting and anyone else having problems with beta 2 on 2.2.9, download my attachement and upload all three files... proarcade, store and proarcadeadmin. after a few hours of code changing and testing it all works flawless. no more errors when trying to update a game in the admin, no more playing the game and it not subtracting your points and no more buying the arcade pass and it saying you don't have one even though it took the points.

[PixelFx]

will that work with 2.30 ? and thanks for posting it :)

[king sting]

Thanx a lot man, that got rid of the error, but now when i try to edit the jackpot value to 1000 points instead of 57points, it says it saved the new settings but then shows back up with the old ones like I never edited anything.. any ideas?

[DPoole]

ok i have the store hack installed and just installed Vbproarcade

is this hack ok to install now or is there still some issues with it ??

[DPoole]

ok real sorry to bump but im waiting on amswer to this before i install

Is it worth installing or is there to many problems with it ????

and finally does it work

[chavalo2]

imo no

[pie]

Ok I was getting the errors that VB Host was getting and then I downloaded and installed his 3 files.

It fixed the errors but now when I go to play breakout, all I get is a blank screen, yet it is only this game..

any ideas??

[gmarik]

Is there a user interface screenie?
Can't find any. All of them are admin or error msg warnings.

[Exero]

there are alot of things that are wrong with this hack...
when i tryed to install i was using deam weaver mx and i searched for the part i had to change it said NOT FOUND....alot of times...

[dark chii]

I got it successfully installed on my site at http://www.animechains.net! :bunny:


I use vb 2.3 and beta2 of the arcade. vB-Host.com's modified files helped very much. although the original files worked but I run into mysql errors trying to update the games.

thanks guys & gals for spending time making these hacks available for us. ^_^

[EWorld]

ok all of the stuff in the edit adminproardade.php thinger are like total waky .. u got to update that for v2 of the arcade. unless someone has done thie I NEED HELP!!!

- Speedy\

edit .. used updated zip

[Limpkinw]

if u are using 2.3.0 and beta 2 try this out no ones post was helpin me i kept gettin the same sql errors :( but this seems to work

[MaDCaT75]

My cost column has seem to have dissapeared on me.. help!

All my files and templates are intact also.... I dont know what's going on! www.sims2forums.com/proarcade.php

[PixelFx]

any updates planned in the future for this addon? :)

[KingdomHeartsII]

My problem is ... I don't have an arcade pass (like I didin't buy one on purpose and it says I am verifyed and when I play games it isn't taking money away from me. I thought maybe it was becuase I was an admin, so I rerestared and same thing. Any ideas?

- Kingdom Hearts II

[Lee Wisener]

Database error in vBulletin 2.3.2:

Invalid SQL: UPDATE user SET storep=storep- WHERE userid='1'
mysql error: You have an error in your SQL syntax near 'WHERE userid='1'' at line 1

mysql error number: 1064

Date: Monday 13th of October 2003 01:00:49 AM
Script: http://www.w1h.net/forum/forum/proarcade.php?action=main
Referer: http://w1h.net/forum/index.php?

I get this error when trying to access the acrade, any suggestions?

[gearshifter47]

definitely, someone needs to update this to work with the latest version of vbarcade... maybe wait for the next arcade version, which seems is coming soon

[Holidazed]

OK, I got it installed in the 2 beta. However, I cannot change the price of a game, the jackpot or the jackpot increase. anytime I try to change it, it just does not change. It does not give any errors tho.

[Link14716]

This hack is very old, bug-ridden, and worthless. I no longer have vB2 installed to update this addon, however, I will rewrite it when the arcade is re-written for vB3.

[PixelFx]

do you know if this hack will work with vbaracde 2.1 ? or if it's still being updated? I can help beta test if needed for the vb2.3.3. varient

[PixelFx]

any planned updates for this? for vb233 and store version 3.0 with pro arcade 2.1 ? seems a waste to let a script like this go..

[Marzas]

Yea, i was wondering the same thing, alot of people still want this hack for 2.3.* versions.

[Link14716]

I'm planning to do a full re-write when the vB3 Arcade is released, and then I'll back-port it to vB2.

[Marzas]

great, cant wait

[PixelFx]

sounds great let me know if you need any testers, I'm beta testing vbpro arcade 2.1 currently at orbsydia.com :) and I'd love to add it.

[Gary King]

Does this work with the latest versions of both the required hacks?

[Link14716]

No. If I could close this thread, I would.

Right now I am working on the Arcade Pass Hack v3.0 for vB3, and if there is enough demand, I'll probably back-port it to vB2.

[Gary King]

No. If I could close this thread, I would.

Right now I am working on the Arcade Pass Hack v3.0 for vB3, and if there is enough demand, I'll probably back-port it to vB2.
Seems to be working okay for me anyhow :)

[Chris|vB]

Sweet work man.

thanks

[Link14716]

Ok, I am removing the attachment from the main post. The Arcade Pass Hack v3 will be going into beta releases probably tommorow for both vB2 and vB3.

[PixelFx]

I'd love to try it out :)

[glo]

Hi Link14716,

Great hack, im planning to install this later this week! (already using lesanes store hack)

Could you tell me if this hack also rewards point to hi score winners from the games?
So that members can play games and earn point too!

[Link14716]

Why are you posting in this thread? Post in this one instead: https://vborg.vbsupport.ru/showthread.php?t=62060

But to answer your question - yes. :)

[glo]

thanks, i have now posted in the correct thread!

[.:.NetStartz.:.]

Hi, can someone post the old arcade pass?
That works for me

[Gary King]

Try this: https://vborg.vbsupport.ru/showthread.php?t=62060