PDA

View Full Version : Arcade Pass Hack v2.0


Link14716
18 Sep 2002, 22:16
Arcade Pass Hack v3 is here!
vB2: http://www.vbulletin.org/forum/showthread.php?t=62060 (for futureal's vbProArcade Beta 2)
vB3: http://www.vbulletin.org/forum/showthread.php?t=62059 (for John's v3 Arcade)

Link14716
18 Sep 2002, 22:16
Screen 1

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

Link14716
18 Sep 2002, 22:17
Screen 2

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

Link14716
18 Sep 2002, 22:17
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
18 Sep 2002, 22:17
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
18 Sep 2002, 22:17
Screen 5

Link14716
18 Sep 2002, 22:18
Screen 6

Link14716
18 Sep 2002, 22:18
Screen 7

Link14716
18 Sep 2002, 22:18
Screen 8

Link14716
18 Sep 2002, 22:18
Screen 9

Link14716
18 Sep 2002, 22:20
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
18 Sep 2002, 22:36
looks awesome, i'll install it later today :)

Dark Jim
18 Sep 2002, 23:45
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
18 Sep 2002, 23:49
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
18 Sep 2002, 23:57
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
19 Sep 2002, 00:01
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='$championactive',championtext='$champi ontext',championcolor='$championcolor',playcost='$playcost',jackpot='$jackpot',j ackpotinc='$jackpotadd'
WHERE gameid='$gameid'");
--------------------------------------------------------------------
It just doesn't seem right to me.

Link14716
19 Sep 2002, 00:05
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
19 Sep 2002, 00:22
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
19 Sep 2002, 00:24
If you didn't modify the store.php, proarcade.php and proarcadeadmin.php more than with your own hack, could you upload those?

Link14716
19 Sep 2002, 00:27
ok then, I will, hold on.........

Link14716
19 Sep 2002, 00:31
proarcade

Link14716
19 Sep 2002, 00:31
proarcadeadmin

Link14716
19 Sep 2002, 00:32
store

Link14716
19 Sep 2002, 00:35
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
19 Sep 2002, 00:41
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
19 Sep 2002, 00:43
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
19 Sep 2002, 00:52
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
19 Sep 2002, 00:54
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
19 Sep 2002, 01:00
Ok, attachment back up. Dark Jim, use your proarcade.php and see if the instructions in the new zip work.

Dark Jim
19 Sep 2002, 09:29
I'll check it out tonight.

ZiRu$
20 Sep 2002, 03:13
will install in a few days :) thx homie

Keta
20 Sep 2002, 08:27
well i already added the beta. i should of waited for the full release. but good job!

Link14716
20 Sep 2002, 13:55
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
22 Sep 2002, 01:15
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
22 Sep 2002, 22:42
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
08 Oct 2002, 02:36
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
08 Oct 2002, 23:05
anyone?

mewgood
09 Oct 2002, 04:34
help pleas.

mewgood
09 Oct 2002, 22:33
hello?

netware
10 Oct 2002, 08:58
what about new Games !

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

Link14716
10 Oct 2002, 22:19
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
11 Oct 2002, 00:22
I did
but it just the same
it won't change..

Link14716
11 Oct 2002, 01:20
-+-+-+
Find:
-+-+-+

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',usekingicon='$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',usekingicon='$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
11 Oct 2002, 01:57
no
not working
here ism y proarcadeadmin.php

Link14716
11 Oct 2002, 02:32
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
11 Oct 2002, 02:38
what codes?
I dont think it really matters the vb version

Link14716
11 Oct 2002, 02:46
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',usekingicon='$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_name,"."),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_name,"."),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',usekingicon='$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
11 Oct 2002, 03:30
hey
it workd!!!
Thx:D

Link14716
11 Oct 2002, 21:20
Your Welcome. Remember to hit the "Install" buton! ;)

mewgood
12 Oct 2002, 01:17
yep
just did:D

Issy_X
31 Oct 2002, 20:12
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
31 Oct 2002, 20:18
How many points do you charge?

Issy_X
31 Oct 2002, 20:20
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
31 Oct 2002, 20:33
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
08 Nov 2002, 07:03
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
08 Nov 2002, 22:24
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
18 Nov 2002, 05:44
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
20 Nov 2002, 11:01
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
21 Nov 2002, 08:19
^bumb^

Link14716
21 Nov 2002, 11:24
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
21 Nov 2002, 11:36
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
21 Nov 2002, 14:00
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
21 Nov 2002, 14:31
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
23 Nov 2002, 18:59
It works now Link!!!
Sorry, ... it was a mistake i made :( ;)

/me klicks install!

Link14716
23 Nov 2002, 19:22
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
01 Dec 2002, 06:41
http://www.nintendofire.com/forums/store.php?

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
01 Dec 2002, 07:09
damn link, your hack's screwed everything up on my forums..let me go back and do it again *sigh*

The_Wanderer
12 Dec 2002, 18:43
hmmm... this might be of use...

bensonfactor
18 Dec 2002, 21:00
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
19 Dec 2002, 20:55
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
22 Dec 2002, 18:16
What a great hack it stops people registering and not posting!

/me click install :p

apokphp
30 Dec 2002, 18:43
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
28 Jan 2003, 00:33
I have a weird problem.

In the instructions, it says to:

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

$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',usekingicon='$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='$usekingicon',usedetailicons='$used etailicons'
".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='Breakout Champion',championcolor='#ff0000',playcost='50',jackpot='20',jackpotadd='5'
WHERE gameid='2'
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

Link14716
28 Jan 2003, 00:37
What Arcade version? I think this only works with Beta 1.03 right now...

ethics
28 Jan 2003, 00:39
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
28 Jan 2003, 01:52
Actually, the hack works, 95% of the way. What I did was use db queries to change the options I needed. :)

DarkDraco07
28 Jan 2003, 03:23
how come when people play snake it give them gil even though they dont get 1st

Link14716
28 Jan 2003, 03:34
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
28 Jan 2003, 03:57
anyway to stop that?

Link14716
28 Jan 2003, 04:02
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
28 Jan 2003, 04:07
thanks, trying it now

Preech
07 Feb 2003, 12:02
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
07 Feb 2003, 19:58
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',usekingicon='$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='$usekingicon',usedetailicons='$used etailicons'
".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='Breakout Champion',championcolor='#ff0000',playcost='50',jackpot='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
09 Feb 2003, 06:22
i get this same problem in the cp when I try to change options :(

ethics
09 Feb 2003, 14:27
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
10 Feb 2003, 16:48
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='Asteroids2000 Champion',championcolor='#ff0000',playcost='10',jackpot='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
10 Feb 2003, 20:09
Beta 2 is not compatible and I haven't had time to make it compatible. Just hold on....

Ice Effect69
10 Feb 2003, 20:31
everything works with beta 2 besides for the admin section

Ice Effect69
19 Feb 2003, 16:50
link can you please make this capatible for for beta 2

sabret00the
23 Feb 2003, 18:29
this is a cool hack, should get my users off the arcade and posting more ^_^

sabret00the
25 Feb 2003, 10:36
ah man, no one zipped the templates for tbs easy installation, i might have to do it

/clicks install

sabret00the
25 Feb 2003, 10:55
the templates for you guys and gals

lynda
02 Mar 2003, 14:34
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='$championactive',championtext='$championtex t',championcolor='$championcolor'
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='$championactive',championtext='$championtex t',championcolor='$championcolor',playcost='$playcost',jackpot='$jackpot',jackpo tadd='$jackpotadd'
WHERE gameid='$gameid'");
Find this: $DB_site->query("INSERT INTO arcadegames (name,title,description,filename,active,hashoffset,scorevar,gamecode,championact ive,championtext,championcolor"
.iif($championdata != "",",championpicname,championpicdata","")
.iif($thumbdata != "",",thumbnailname,thumbnaildata","").")
VALUES ('$name','$title','$desc','$filename','$active','$hashoffset','$scorevar','$game code','$championactive','$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,championact ive,championtext,championcolor,playcost,jackpot,jackpotadd"
.iif($championdata != "",",championpicname,championpicdata","")
.iif($thumbdata != "",",thumbnailname,thumbnaildata","").")
VALUES ('$name','$title','$desc','$filename','$active','$hashoffset','$scorevar','$game code','$championactive','$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='$usekingicon',usedetailicons='$used etailicons'
".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='$usekingicon',usedetailicons='$used etailicons'
".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
10 Mar 2003, 02:52
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
11 Mar 2003, 04:31
what query do a need to run to reset the highscores?

Link14716
11 Mar 2003, 23:26
@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
13 Mar 2003, 05:03
I don't have those tables Link.

Link14716
13 Mar 2003, 15:45
Those are Beta 2 tables so I guess you're using Beta 1. In that case...

DELETE FROM arcade;

Opie
13 Mar 2003, 19:38
thanks

DigitalDesktops
23 Mar 2003, 13:54
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
23 Mar 2003, 17:05
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='Asteroids Champion',championcolor='#ff0000',playcost='10',jackpot='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
12 Apr 2003, 01:59
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
18 Apr 2003, 00:15
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
20 Apr 2003, 23:38
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
21 Apr 2003, 00:47
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
21 Apr 2003, 01:58
hm... In my proarcadeadmin.php file, i'm supposed to replace


$DB_site->query("UPDATE arcadeconfig
SET path='$thepath',usescoreicon='$usescoreicon',usekingicon='$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',usekingicon='$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='$usekingicon',usedetailicons='$used etailicons'
".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
21 Apr 2003, 02:03
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
21 Apr 2003, 03:34
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
21 Apr 2003, 06:33
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
24 Apr 2003, 08:20
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
24 Apr 2003, 20:34
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
24 Apr 2003, 23:29
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
25 Apr 2003, 02:47
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
25 Apr 2003, 03:17
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
25 Apr 2003, 04:00
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
25 Apr 2003, 04:04
hmm try doing this:

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

chavalo2
25 Apr 2003, 04:25
Today at 04:04 AM DigitalDesktops said this in Post #116 (http://www.vbulletin.org/forum/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
25 Apr 2003, 05:19
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
25 Apr 2003, 07:12
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
30 Apr 2003, 02:07
Looks nice, going to install it right now.

DigitalDesktops
30 Apr 2003, 02:22
04-25-03 at 08:12 AM chavalo2 said this in Post #119 (http://www.vbulletin.org/forum/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
05 May 2003, 00:37
Nope... Store is installed also.

Still no go :(

Reno
05 May 2003, 09:37
So this is compatible with vB 2.3 right?

chavalo2
05 May 2003, 16:50
I would say NO

PixelFx
16 May 2003, 09:12
any plans for an update when vb arcade 2.1 is released?

king sting
17 May 2003, 01:02
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='Breakout Champion',championcolor='#ff0000',playcost='10',jackpot='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
18 May 2003, 04:59
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
18 May 2003, 05:03
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='Breakout Champion',championcolor='#ff0000',playcost='10',jackpot='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
18 May 2003, 09:37
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
18 May 2003, 14:13
will that work with 2.30 ? and thanks for posting it :)

king sting
19 May 2003, 23:33
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
20 May 2003, 13:01
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
24 May 2003, 23:18
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
26 May 2003, 07:15
imo no

pie
05 Jun 2003, 08:44
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
05 Jun 2003, 14:24
Is there a user interface screenie?
Can't find any. All of them are admin or error msg warnings.

Exero
16 Jun 2003, 02:06
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
22 Jun 2003, 04:05
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
08 Jul 2003, 05:18
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
12 Aug 2003, 05:40
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
01 Sep 2003, 06:58
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
01 Oct 2003, 20:33
any updates planned in the future for this addon? :)

KingdomHeartsII
10 Oct 2003, 03:28
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
12 Oct 2003, 23:57
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
17 Oct 2003, 00:26
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
20 Oct 2003, 16:18
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
23 Oct 2003, 03:52
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
30 Nov 2003, 15:24
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
27 Dec 2003, 16:24
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
12 Jan 2004, 05:49
Yea, i was wondering the same thing, alot of people still want this hack for 2.3.* versions.

Link14716
12 Jan 2004, 05:51
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
12 Jan 2004, 05:56
great, cant wait

PixelFx
20 Jan 2004, 05:14
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
25 Jan 2004, 21:42
Does this work with the latest versions of both the required hacks?

Link14716
28 Jan 2004, 22:29
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
29 Jan 2004, 00:17
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
31 Jan 2004, 13:43
Sweet work man.

thanks

Link14716
01 Mar 2004, 04:47
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
01 Mar 2004, 07:02
I'd love to try it out :)

glo
07 Mar 2004, 20:49
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
07 Mar 2004, 20:52
Why are you posting in this thread? Post in this one instead: http://www.vbulletin.org/forum/showthread.php?t=62060

But to answer your question - yes. :)

glo
07 Mar 2004, 21:25
thanks, i have now posted in the correct thread!

.:.NetStartz.:.
24 Apr 2004, 08:20
Hi, can someone post the old arcade pass?
That works for me

Gary King
24 Apr 2004, 13:56
Try this: http://www.vbulletin.org/forum/showthread.php?t=62060