PDA

View Full Version : Arcade Pass Hack v3!


Link14716
02-29-2004, 10:00 PM
11/09/04 - Installer upgraded, nothing more.

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

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

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

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

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

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

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

This hack currently supports the following arcade/versions:

vB2:
vbProArcade Beta 2

vB3:
v3 Arcade (1.0)

Screenshots below.

Link14716
03-01-2004, 06:02 AM
EDIT: Screens moved to first post.

PixelFx
03-01-2004, 06:09 AM
kewl, I'll looking forward to this when Futureal finishes his vb3 pro arcade :) thanks for working on this again :) I clicked install, even though I'm waiting for futureals proarcade.

Link14716
03-01-2004, 06:10 AM
Yeah, right now there are two versions, but when futureal releases the new vB2 version and the vB3 version, it'll have 4... that'll be fun to maintain. ;)

Fi_InCogNiTo
03-01-2004, 02:56 PM
Seems to work fine.

*clicks install

Fi_InCogNiTo
03-01-2004, 03:05 PM
If I set it to 0 points needed to play a game, it still doesn't show the play game link. I disabled the acrcade pass option and enabled pay per play in admincp.

Enable Arcade Passes? No
Enable Pay Per Game? Yes

And if I set Arcade Pass cost to 0, it still says "You do not have enough points for this." when I click it.


EDIT: Another thing:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET uttpoints=uttpoints+505 WHERE userid='1'
mysql error: Unknown column 'uttpoints' in 'field list'

mysql error number: 1054

Date: Monday 01st of March 2004 09:10:09 AM
Script: http://www.pc-nerd.com/arcade.php

Happens when you finish a game and it goes to enter the score on the scoreboard. Even when the master switch is off.

EDIT: The above problem was solved by doing this query:
ALTER TABLE `user` ADD `uttpoints` BIGINT( 15 ) NOT NULL ;

However, even though my jackpot was 500, it gave me 555. And after I played the game, the jackpot reset to 525.

Link14716
03-01-2004, 07:02 PM
As I said, this does not come with a point system, you must have one already installed and configure the settings to use it.

Not sure what is causing any other errors, though.

PixelFx
03-01-2004, 07:54 PM
does this work with yoshi's store system? or can you add support for it, once he's release 4.0 ?

Link14716
03-01-2004, 08:04 PM
It works with any point system that has its point field in the user or usergroup table. So yeas. (Although it integrates more closely with the uTT Store Hack that me and Zachery will be releasing sometime soon.)

gmarik
03-02-2004, 04:21 PM
Interesting add-on, if only my vB3 arcade installation would work, something does not fits ....

Red Blaze
03-05-2004, 01:27 PM
I posted this in the wrong vb Arcade Pass Hack (the vb2 version). Here's my... minor annoyance rather than a problem:

Installed it and works great. Just a question though. Why does it leave the comments saying
// [Start Arcade Pass Hack blah blah blah
// [End Arcade Pass Hack blah blah blah

For all edit changes in adminarcade.php? The coding works great, no damage done, but it leaves the comments there.

Link14716
03-05-2004, 03:07 PM
I posted this in the wrong vb Arcade Pass Hack (the vb2 version). Here's my... minor annoyance rather than a problem:
It's one bad thing about the HTL, it doesn't let me disable those goddamned comments.

Search for those comments in arcadeadmin.php and remove them.

Red Blaze
03-05-2004, 03:09 PM
Well, I didn't really have a problem with the other HTL compatible hacks I installed. I'll remove them anyway.

Link14716
03-05-2004, 03:10 PM
Because the other HTL compatible hacks didn't modify code that was being echo'd. ;)

PixelFx
04-07-2004, 11:26 AM
any eta on your point system? :) *twitches a bit more*

lasto
04-07-2004, 01:33 PM
looks good but will wait for a store hack to be releashed like everyone else is :)

then will have this :)

Zelda-King
04-13-2004, 11:37 AM
The arcade_main_games_bit template edits don't appear compatible with vB3 Gold. I get that 'parse problem but you can continue if you want' prompt.

James Collins
04-13-2004, 06:21 PM
I dont get that, but what I do get is that when someone wins the "Jackpot" the "Jackpot" defaults back to 500 for me - then it goes to 255, then 500 again :o

Which part defines the score, maybe I left something out? This was after setting them all to 20 in the CP first off.

Either way, nice first addition for the shop - even if this did come before your shop :)

Zelda-King
04-13-2004, 07:14 PM
Well I got that template working. I have Arcade Pass working just fine with the uShop from what I can tell.

James Collins
04-13-2004, 07:21 PM
Do you get the jackpot problem I have?

hmm, maybe I need to install again - will wait for your input :)

dstruct2k
04-14-2004, 12:07 AM
My jackpots are turning into HUGE decimal numbers... (Probably from people coming in third and dividing by 3) Squall, any ideas for a fix?

(My idea: X by 100, floor, ? by 100) :)

dstruct2k
04-14-2004, 03:05 AM
ALTER TABLE `games` CHANGE `arcadepass_jackpot` `arcadepass_jackpot` DECIMAL( 20, 2 ) DEFAULT '0.00' NOT NULL
This query fixed the super-long decimals, and made it so that the jackpots ALWAYS have 2 decimal points, like a real dollar amount.

Change the underlined number 2 to how many decimals you want and run the query to fix long decimal values. :)

Leah
04-14-2004, 11:49 AM
There seem to be a problem here.
Does anyone have any idea what I need to do to fix this?

James Collins
04-14-2004, 04:21 PM
Does anyone get the Jackpot to work after it has been played a few times. Like I said I reset the Jackpot to 50, but it always goes back to 500 again after someone has "won" the jackpot.

500 is far 2 much imho to start off with...

NameWolf
04-16-2004, 12:40 AM
Hello,

I am trying to do a manual install on vb3.0 after installing links' store hack. Unfortunately I ran setting.sql before settingphrase.sql and now I get ;

Error

SQL-query :

INSERT INTO `vb3_phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` )
VALUES ( 6472, 0, 'settinggroup_arcadepass', 'Arcade Pass Hack v3 Settings', 5000 )

MySQL said:

#1062 - Duplicate entry '6472' for key 1

----

How can I fix this situation ?

Thanks in advance .

NW

Leah
04-17-2004, 09:28 PM
Ok, now I got the templatething working. But the arcade pass doesn't stop people from playing if they have the URL to the game or find it on the highscore.

Or have I missed something here?

Cyricx
04-18-2004, 01:40 AM
If they don't have the pass they pay the "cost fee" I believe, if they do have the pass, they don't have to pay the "cost fee". At least, thats how I'm understanding it =/

msimplay
04-18-2004, 08:08 AM
I dont get that, but what I do get is that when someone wins the "Jackpot" the "Jackpot" defaults back to 500 for me - then it goes to 255, then 500 again :o

Which part defines the score, maybe I left something out? This was after setting them all to 20 in the CP first off.

Either way, nice first addition for the shop - even if this did come before your shop :)
i have a similar problem where i set the jackpot to 100 and set the jackpot increase to 0 yet it still increases

lasto
04-18-2004, 08:29 AM
so does this hack not work proper with the Ustore then ?

Seany
04-18-2004, 05:55 PM
Hello,

I am trying to do a manual install on vb3.0 after installing links' store hack. Unfortunately I ran setting.sql before settingphrase.sql and now I get ;

Error

SQL-query :

INSERT INTO `vb3_phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` )
VALUES ( 6472, 0, 'settinggroup_arcadepass', 'Arcade Pass Hack v3 Settings', 5000 )

MySQL said:


#1062 - Duplicate entry '6472' for key 1

----

How can I fix this situation ?

Thanks in advance .

NW
I get the same problem. Link, any help here? Can we continue the install if we get that error?

NameWolf
04-18-2004, 11:14 PM
Well I was trying to manually delete the entries and I just realised that entry 6472 is used by another entry that that does not belong to Arcade pass. None of the IDs are actually free. They are all used by previous hacks or entries.

NW

Seany
04-19-2004, 12:56 AM
So what exactly did you do to get it working? Or did you get it working? Also, which entried do I delete if I wanted to get rid of it? Thanks.

NameWolf
04-19-2004, 07:22 AM
Well I did not get it working because I did not delete the entries 6472 and above. All the IDs were also taken up to around 13500. I wonder if we can change them and assign higher ids such as 14000 etc. Link ?

NW

Davey-UK
04-19-2004, 06:32 PM
When clicking on the buy an arcade pass link, it just takes me to page unnavailable, but when i buy one in the shop it works fine.


When i hover over the buy pass link above the avatar, it says arcadepass.php as the link, which i have uploaded to the correct place.

Any ideas? :o

Ive sussed it out!!...

You cannot have the pass enabled in the Utt store, or it seems to conflict with the arcade pass hack

msimplay
04-19-2004, 06:40 PM
yep find

header("Location: uttstore.php?do=a&aid=$action[actionid]");


and change it to


header("Location: ushop.php?do=a&aid=$action[actionid]");

Seany
04-19-2004, 11:37 PM
Well I did not get it working because I did not delete the entries 6472 and above. All the IDs were also taken up to around 13500. I wonder if we can change them and assign higher ids such as 14000 etc. Link ?

NW
I wanna remove the queries I performed up and till the point I got that error. Any way I can do that? Thanks.

lasto
04-24-2004, 06:13 PM
quick question - arcade vb3 installed
store installed

installing this hack will it then work to make members pay or is there people still having probs with it and the store ?

msimplay
04-24-2004, 06:26 PM
quick question - arcade vb3 installed
store installed

installing this hack will it then work to make members pay or is there people still having probs with it and the store ?
it works to make members pay however i have this problem

check this post
https://vborg.vbsupport.ru/showpost.php?p=500123&postcount=18

weaver
04-25-2004, 12:04 AM
It seems to be working fine for me after running the query dstruct2k provided. But I'm wondering if there is a way to have a notification when someone wins part of the jackpot telling them how much they have won. Also, maybe a list of recent jackpot winners similar to the "latest arcade scores" box.

lasto
04-25-2004, 12:09 AM
msimplay cheers m8 so it dont work to an extent where it forces people to pay to use the arcade as thats all im bothered about at moment as im fed up with people parking thier behinds in the arcade all day and totally by passing the board.

Wait till tournament arcade comes along LOL will be nobody posting :)

msimplay
04-25-2004, 07:52 AM
msimplay cheers m8 so it dont work to an extent where it forces people to pay to use the arcade as thats all im bothered about at moment as im fed up with people parking thier behinds in the arcade all day and totally by passing the board.

Wait till tournament arcade comes along LOL will be nobody posting :) yeh its a great addition i've used the query but it doesn't fix the jackpot fluctuating

i wanted mine to be at 100 jackpot however it always defaults back to 500 and then goes doo lally with the increase on winning the jackpot even tho i didn't set one and at times i've tried setting it to 0 but this seems to have no effect

this seriously needs to be fixed

sabret00the
04-25-2004, 08:31 PM
is this the one already included in the ushop or another one?

msimplay
04-25-2004, 08:45 PM
theres not one included in ushop this is the only arcade pass hack available for vb3

Zachery
04-25-2004, 08:48 PM
is this the one already included in the ushop or another one?
Its not included in ushop, however the two work together :)

msimplay
04-25-2004, 08:58 PM
Its not included in ushop, however the two work together :)
yeh what he said :p

sabret00the
04-25-2004, 09:27 PM
so how comes i got the action included in my ushop then :confused:

msimplay
04-25-2004, 10:01 PM
so how comes i got the action included in my ushop then :confused:
am not sure on that one but my guess is that the shops ready to intergrate with the arcade pass hence the settings being their already

but i'm guessing to finish the hack to work with the points u have to download this hack and install it
but don't take my word for it coz am not too sure
wait for the official word lols :p

Zachery
04-25-2004, 10:02 PM
am not sure on that one but my guess is that the shops ready to intergrate with the arcade pass hence the settings being their already

but i'm guessing to finish the hack to work with the points u have to download this hack and install it
but don't take my word for it coz am not too sure
wait for the official word lols :p
Basiculy we left it as a default action, it can be turned off or removed if you dont want to use it, however if you do want to make use of it you would need to install this hack as well.

sabret00the
04-25-2004, 10:41 PM
oooh goody, i'll isntall tomorrow then :)

sabret00the
04-26-2004, 08:29 PM
installed btw :)

Seany
04-26-2004, 10:22 PM
Its not included in ushop, however the two work together :)
What about the prob me and LoneWolf or whatever are having? Any idea how we can fix that? Cause I really want this mod to work.

JagFan
04-27-2004, 12:04 AM
What about the prob me and LoneWolf or whatever are having? Any idea how we can fix that? Cause I really want this mod to work.
I am also getting the same error that Seany & NameWolf are getting...I really like this hack and hope to get it working as well :)

Cyricx
04-28-2004, 09:25 PM
In your vboptions there is a section for arcade and you set what the default would be too.

I'd like to see this have an implementation that let's people bet money in challenges.

teksigns
04-30-2004, 02:38 AM
my board is setup with 3 groups .....

regular members
donators1
and donators2
and staff

i would like to make it so that

staff, donators1 , and donators2 groups all can play arcade without having a arcade pass.

i would like the regular members still be required to buy pass.

can this be done ?

Lostnode
05-02-2004, 07:35 AM
How about addind Jack pots to the Arcade Challeneg feature... When you challenge somoen you can wager 300 points, if you lose, you lose 300 pts to your apponent, if you win, you get 300 points of his/hers...

weaver
05-02-2004, 03:09 PM
Well my arcade pass has expired but I'm still able to play games. What is the fix for this?

gwhooooey
05-02-2004, 09:55 PM
I'm getting this error when trying to play a new game I installed

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE user SET uttpoints=uttpoints- WHERE userid='1'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='1'' at line 1

mysql error number: 1064

Not quite sure why...anyone help?

msimplay
05-02-2004, 11:26 PM
I'm getting this error when trying to play a new game I installed

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE user SET uttpoints=uttpoints- WHERE userid='1'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='1'' at line 1

mysql error number: 1064

Not quite sure why...anyone help?
if u have installed a new game make sure u set the points for that game
ie the jackpot amount and
cost of play

gwhooooey
05-02-2004, 11:53 PM
Is that definately the problem? I think I did that, might have been with another game that was already installed though. I undid the template/file edits because of this...so if that's definately the problem...I'll re-do it.

Thanks

msimplay
05-03-2004, 12:15 AM
Is that definately the problem? I think I did that, might have been with another game that was already installed though. I undid the template/file edits because of this...so if that's definately the problem...I'll re-do it.

Thanks
i get a database error when clicking on new games
until i set the cost and jackpot so i think it is that but i'm not totallly sure because i cant remember the query but it looks like the same one

deathemperor
05-03-2004, 09:33 AM
the features are good but with so many problems ppl got I can't risk my board installing it along with UCS.
The problems occour but no one appears to answer.

msimplay
05-03-2004, 10:02 AM
the features are good but with so many problems ppl got I can't risk my board installing it along with UCS.
The problems occour but no one appears to answer.
i hear ya , quite frustrating
i wish they'd release a quick fix
but then again this hack has been labelled beta

insanctus
05-03-2004, 10:27 AM
I have yet to have an issue with this hack, I guess I am lucky

msimplay
05-03-2004, 11:52 AM
I have yet to have an issue with this hack, I guess I am lucky
ur forums don't seem to have jackpot set thats probably why u haven't had a problem

gwhooooey
05-06-2004, 02:08 AM
Okay, seems to have worked.

What happens when users run out of points/cash? Does it just show a no permission page?

If so...can somebody make it so it goes to a page that says you don't have enough points to play, you can get points by doing either of the following things...and then have it show the things that have been enabled, such as how many points per thread made, per reply, referal etc.

Could anyone do that?

gwhooooey
05-06-2004, 02:12 AM
Just signed in as a user with 0 posts and it says you need more points to play. It would still be good if you could get it to say how to get the points, and the amount you get for doing such things

InsaneContender
05-07-2004, 10:14 PM
Does the pass expire over a period of time?

PixelFx
05-08-2004, 11:30 PM
Bit of a Fix for your starting points in the arcade:

up this query on your forum



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



note you can change the base cost from 25 per game to what you want, and jackpot from 100 to what ever ya want.

hope that helps a bit :)

weaver
05-09-2004, 02:36 AM
Bit of a Fix for your starting points in the arcade:

up this query on your forum



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



note you can change the base cost from 25 per game to what you want, and jackpot from 100 to what ever ya want.

hope that helps a bit :)
I tried to run that query but I received this error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

teksigns
05-09-2004, 02:58 PM
i have my jackpost all set at 50 with a 5 point increase ....

however its doing a 25 point increase instead ......

anyone know how to fix?

teksigns
05-09-2004, 03:05 PM
i have my jackpost all set at 50 with a 5 point increase ....


however its doing a 25 point increase instead ......


anyone know how to fix?


i fixed it :

i changed the line in arcade.php

from:

$addtojackpot = ($game['arcadepass_cost'] + $game['arcadepass_increase']);


to:

$addtojackpot = $game['arcadepass_increase'];

its was adding the cost of the game to the increase setting then adding
it to the jackpot .......

Bigwrenn
05-10-2004, 07:53 AM
I have one small problem, after installing everything and running the queries I still don't have a Arcade pass hack option in the admincp. Also the arcade will still let you play games even with the price set at 1000. It's kind of weird, games that have been played have a link to play them and games that have not been played do not have a link! Any help or pointers would be greatly appreciated.
Thanks,
Bigwrenn

EDIT- I now have the Arcade pass hack options in the admincp but still have problems with the game links being active on certain games!

deathemperor
05-12-2004, 03:48 AM
Bigwrenn do you have UCS installed ?
nice work teksigns, I am going to install this and UCS at a time.

Bigwrenn
05-12-2004, 04:04 AM
UCS? If you mean a points system, yes.

weaver
05-27-2004, 02:14 AM
I'm still having an issue with the jackpots being reset to 500 even though in my admin settings I have it set to 50. The initial jackpot is correct, but once someone wins it the jackpot goes up to 500.

paulomt1
05-28-2004, 11:05 PM
I have installed the hack Arcade_Pass_Hack_v3_[2004-03-01]_30_Beta and this hack, but when I type this url in my browser I only get a 404 error.

anyone know what is the problem?

msimplay
05-29-2004, 06:38 AM
I'm still having an issue with the jackpots being reset to 500 even though in my admin settings I have it set to 50. The initial jackpot is correct, but once someone wins it the jackpot goes up to 500.
go to vbulletin options and in the listbox there should be an option to set arcade pass

change that value to the same as u want ur games
that is the 500 that it keeps resetting to

msimplay
05-29-2004, 07:48 AM
i fixed it :

i changed the line in arcade.php

from:

$addtojackpot = ($game['arcadepass_cost'] + $game['arcadepass_increase']);


to:

$addtojackpot = $game['arcadepass_increase'];

its was adding the cost of the game to the increase setting then adding
it to the jackpot .......

thank you that fixed all of my arcade pass problems i've been having

weaver
05-29-2004, 06:06 PM
go to vbulletin options and in the listbox there should be an option to set arcade pass

change that value to the same as u want ur games
that is the 500 that it keeps resetting to
Thanks! That was very simple to fix. I don't know how I missed it since I had just changed the price of an arcade pass last week. :ermm:

007
05-31-2004, 05:31 PM
It would be cool if there was an option for FREE PLAY mode. People who chose this mode won't see the price or the jackpot, since they couldn't quality for it. If you wanted a shot at the pot, you'd have to pay for a ticket. How hard would this be?

weaver
06-01-2004, 01:53 AM
A member suggested today receiving an email to inform them when their pass expires.

msimplay
06-01-2004, 02:48 PM
A member suggested today receiving an email to inform them when their pass expires.
to expand on this although a great idea
it would be better if they were allowed to choose what kind of notification they recieved for it ie checkbox in usercp / options
Notification of Arcade Pass Expiration
Pm
Email

its a checkbox so if they don't check anything it would mean no notification at all

cashpath
06-05-2004, 06:21 PM
can anyone help me possibly fix this... I had about 8 games installed.. I installed this... everything works except that... it does not charge people to play the games... And yes I do have that option set to charge in the cp

cashpath
06-05-2004, 07:00 PM
I am thinking that this should happen when the prson clicks to play the game... it should subtract the points from their account... and I just can't find that in the file edits (arcade.php) anywhere??

I haven't seen anyone else complain of it not working so it MUST be in there.... so if anyone knows please at least tell me which edit it is that controls this??

Thanks!!

cashpath
06-06-2004, 04:37 AM
anyone?

msimplay
06-06-2004, 07:17 AM
try in the game settings and also turning the arcade pass on

cashpath
06-06-2004, 03:40 PM
No thats not it.. could someone tell me the line that in the file edits that controls this please?

cashpath
06-06-2004, 06:39 PM
ok.. at first I thought I had left something out.. now I have been scouring my code to find this part and I think I finally find it.. now this sucks, cause it IS in my code... which means it is not a simple fix that I just missed it...

else {
if (!isset($show['arcadepass'])) {
$DB_site->query("UPDATE ".TABLE_PREFIX . $vboptions['arcadepass_pointtable']." SET ".$vboptions['arcadepass_pointsfield']."=".$vboptions['arcadepass_pointsfield']."-".$thisGame['arcadepass_cost']." WHERE userid='$bbuserinfo[userid]'");
}

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

Link

I am wondering if you could further explain how the jackpot works. As I understand the above text, if someone places 1st place in a game, they get the jackpot automatically? Or am I wrong? Is it on a "Time-Delay" ?

HoC

msimplay
06-10-2004, 08:57 AM
Link

I am wondering if you could further explain how the jackpot works. As I understand the above text, if someone places 1st place in a game, they get the jackpot automatically? Or am I wrong? Is it on a "Time-Delay" ?

HoC they have to get first to get full jackpot

but it is configurable to allow for example the top 3 to obtain a prize

weaver
06-10-2004, 11:25 AM
to expand on this although a great idea
it would be better if they were allowed to choose what kind of notification they recieved for it ie checkbox in usercp / options
Notification of Arcade Pass Expiration
Pm
Email

its a checkbox so if they don't check anything it would mean no notification at all
Great idea! PM notification didn't occur to me but I'm sure many would prefer it over email. :)

kall
06-26-2004, 04:19 AM
my board is setup with 3 groups .....

regular members
donators1
and donators2
and staff

i would like to make it so that

staff, donators1 , and donators2 groups all can play arcade without having a arcade pass.


i would like the regular members still be required to buy pass.




can this be done ?
Yep. Check my signature. :)

Littlebit
07-19-2004, 02:17 PM
I've noticed that all you have to do is aquire the amount of points needed for a pass in order for the arcade games to become enabled for use. But you don't actually have to buy the pass.
Did I mess up part of the install?

Littlebit
07-23-2004, 01:15 PM
Kal, is my above posts issue a known bug?

Holidazed
07-23-2004, 02:15 PM
OK, so here is my question. If my user buys this pass, is it a lifetime pass or does it expire in xx hours or xx days?

Littlebit
07-26-2004, 03:35 PM
I user doesn't have to buy the pass, but just needs the amount of points a pass costs to play the games and when a user who didn't buy the pass loses the amount of points required to buy the pass, database errors occur each time that user attempts to play.
Is anyone else having this issue?

Holidazed
07-26-2004, 04:34 PM
OK, so here is my question. If my user buys this pass, is it a lifetime pass or does it expire in xx hours or xx days?
Is anybody going to answer my question?

netrosearch
07-30-2004, 10:54 PM
How long is the arcade pass good for? It is good forever, or for a set period of time?

netrosearch
07-30-2004, 11:21 PM
I have now lost the ability to use my Remove Game hack. Can someone help me please? Here is where I think the problem is...

This is the code needed for the Arcade pass:

$menu .= "<tr onClick=\"document.getElementById('id').innerHTML = ".$games[shortname]."id;document.getElementById('descr').innerHTML = ".$games[shortname]."descr;document.getElementById('title').innerHTML = ".$games[shortname]."title;document.getElementById('cost').innerHTML = ".$games[shortname]."cost;document.getElementById('jackpot').innerHTML = ".$games[shortname]."jackpot;document.getElementById('increase').innerH TML = ".$games[shortname]."increase;document.getElementById('showaward').inne rHTML = ".$games[shortname]."showaward;document.getElementById('challenabled'). innerHTML = ".$games[shortname]."challenabled;document.getElementById('playpanel'). innerHTML = ".$games[shortname]."playpanel;document.getElementById('active').innerH TML = ".$games[shortname]."active;document.getElementById('netplay').innerHTM L = ".$games[shortname]."netplay;document.getElementById('removegame').inne rHTML = ".$games[shortname]."netplay;document.getElementById('uptbut').innerHTM L = ".$games[shortname]."upbuttext;document.getElementById('categorytitle') .innerHTML = ".$games[shortname]."categorytitle;\">

Here is the code before the arcade pass hack

//$menu .= "<tr onClick=\"document.getElementById('id')
.innerHTML = ".$games[shortname]."id;document.getElementById('descr')
.innerHTML = ".$games[shortname]."descr;document.getElementById('title')
.innerHTML = ".$games[shortname]."title;document.getElementById('showaward')
.innerHTML = ".$games[shortname]."showaward;document.getElementById('challenabled')
.innerHTML = ".$games[shortname]."challenabled;document.getElementById('playpanel')
.innerHTML = ".$games[shortname]."playpanel;document.getElementById('active')
.innerHTML = ".$games[shortname]."active;document.getElementById('netplay')
.innerHTML = ".$games[shortname]."netplay;document.getElementById('removegame')
.innerHTML = ".$games[shortname]."removegame;document.getElementById('uptbut')
.innerHTML = ".$games[shortname]."upbuttext;document.getElementById('categorytitle')
.innerHTML = ".$games[shortname]."categorytitle;\">

Any suggestions?

Holidazed
07-31-2004, 03:28 PM
How long is the arcade pass good for? It is good forever, or for a set period of time?I have asked this question as well, but it seems that either nobody knows or nobody cares to answer. This should have been a cusomozable field in the ACP.

I have now lost the ability to use my Remove Game hack. Can someone help me please?I think the correct entry is as follows
$menu .= "<tr onClick=\"document.getElementById('id').innerHTML =
".$games[shortname]."id;document.getElementById('descr').innerHTML =
".$games[shortname]."descr;document.getElementById('title').innerHTML =
".$games[shortname]."title;document.getElementById('cost').innerHTML =
".$games[shortname]."cost;document.getElementById('jackpot').innerHTML =
".$games[shortname]."jackpot;document.getElementById('increase').innerH TML =
".$games[shortname]."increase;document.getElementById('showaward').inne rHTML =
".$games[shortname]."showaward;document.getElementById('challenabled'). innerHTML =
".$games[shortname]."challenabled;document.getElementById('playpanel'). innerHTML =
".$games[shortname]."playpanel;document.getElementById('active').innerH TML =
".$games[shortname]."active;document.getElementById('netplay').innerHTM L =
".$games[shortname]."netplay;document.getElementById('removegame').inne rHTML =
".$games[shortname]."removegame;document.getElementById('uptbut')..inne rHTML =
".$games[shortname]."netplay;document.getElementById('uptbut').innerHTM L =
".$games[shortname]."upbuttext;document.getElementById('categorytitle') .innerHTML =
".$games[shortname]."categorytitle;\">

Regs
07-31-2004, 04:26 PM
You can set the time span of the pass in the admin options area > arcade pass options...

"Timeout for Arcade Passes?
Set this to the number of seconds after purchase that an arcade pass is valid. Set to 0 to disable. Default: 1209600 = 2 weeks."

Seems pretty self-explanatory to me :D

Cheers,

~Regs.

Holidazed
07-31-2004, 04:43 PM
You can set the time span of the pass in the admin options area > arcade pass options...

"Timeout for Arcade Passes?
Set this to the number of seconds after purchase that an arcade pass is valid. Set to 0 to disable. Default: 1209600 = 2 weeks."

Seems pretty self-explanatory to me :D

Cheers,

~Regs.Thanks for the reply. It may seem that way to you, but I did not see the option (and obviously others did not either) and I have asked the question at least 2 times so far and got no answer.

This would have been resolved if it had been answered to begin with.

Regs
07-31-2004, 07:31 PM
The first screen shot in the second post in this thread clearly shows the option you are/have been asking about... I'd call that answering your question pretty damn well before you even asked it!

Cheers,

~Regs.

Holidazed
08-01-2004, 01:53 PM
The first screen shot in the second post in this thread clearly shows the option you are/have been asking about... I'd call that answering your question pretty damn well before you even asked it!

Cheers,

~Regs.Well then why the hell did not somebody say that when I asked the question each and everytime. Had somebody bothered to point that out, I would not have asked the question the 2nd time and the other person who asked, would not have had too.

I am sorry that I bothered you with a question that evidently I was too blind to see the answer. I thought this was a "Community", but obviously I was wrong.

Regs
08-01-2004, 02:27 PM
You're welcome, it's the least I could do!

Cheers,

~Regs.

Littlebit
08-02-2004, 02:12 PM
Is this also a bug?
Many bought the pass while the timout was set to the default two weeks and I've changed the timeout to 0 disabled just recently, however the message in arcade saying Hang Pass Expired! Buy a new one! Still shows. Furthermore, when the users click and buy a new one, it still shows the same message when they revisit the arcade.
Has anyone else ran across this along with this issue in my previous post?
:surprised:

Holidazed
08-02-2004, 07:06 PM
I installed this on my vb3.01 system and it works fine. That is, until I install a new game. When I install a game after I have installed this hack and then a user runs the game, the following database error comes up.

Database error in vBulletin 3.0.1:
Invalid SQL: UPDATE user SET uttpoints=uttpoints- WHERE userid='1'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='1'' at line 1

mysql error number: 1064

All the other games seem to work just fine tho.

help

Littlebit
08-02-2004, 07:26 PM
I installed this on my vb3.01 system and it works fine. That is, until I install a new game. When I install a game after I have installed this hack and then a user runs the game, the following database error comes up.
help
You need to go to each new individual game you install and give it a jackpot cost etc. and that should stop those errors

Holidazed
08-02-2004, 07:50 PM
You need to go to each new individual game you install and give it a jackpot cost etc. and that should stop those errors
Thank you. That did the trick.

Littlebit
08-02-2004, 08:12 PM
Thank you. That did the trick. You're welcome :)

Littlebit
08-06-2004, 02:53 PM
Is there a newer thread out of beta for this hack that I'm not finding in my search?
I'm unable to fix the below issues with this hack ... or know if they have been reported elsewhere or addressed yet.
If anyone could direct me, I'd be obliged

I user doesn't have to buy the pass, but just needs the amount of points a pass costs to play the games and when a user who didn't buy the pass loses the amount of points required to buy the pass, database errors occur each time that user attempts to play.
Is anyone else having this issue? Many bought the pass while the timout was set to the default two weeks and I've changed the timeout to 0 disabled just recently, however the message in arcade saying "Hang Pass Expired! Buy a new one!" Still shows. Furthermore, when the user clicks to buy a new one, it still shows the same message when they revisit the arcade.

neroflorida
08-13-2004, 11:22 PM
Tip:

To get it to show on left hand panel in admincp, edit admincp/index.php

Find:
construct_nav_option("Challenges", 'arcadeadmin.php?do=challenges', '<br />');

Add Below:

construct_nav_option("Arcade Pass Settings", 'options.php?dogroup=arcadepass&do=options', '<br />');

After doing this, upload admincp/index.php

It should now be accesible from left hand menu under Arcade.

'Course, you could create a separate group for it, too...

k40tic
08-27-2004, 08:52 PM
I'm not sure where to post this at but since it has to do with getting around having a pass or using points and wouldn't matter as much if you didn't use this hack I chose here. There is an exploit that will allow anyone who has the same game on their home pc to play without using a pass at all as if they are doing it from your website. This is how the person done it on my site and used it. It happened to be a friend so he warned me about it and told me how he done it. The info he sent me word for word:

You create an html file on your computer and embed the flash game like the arcade.php file does. You can either download the game and run it from your computer or run it from the web, either way. The key is to set this html tag to point to the same directory that the arcade.php file is in, which should be the forum root. Below is an example of the tag that was used on my site minus my real address.

<base href="http://www.yoursite.com/forums/">

He did use it a couple times but I caught on right away since I just payed for vbulletin a couple weeks ago and less then 24 hours ago added the store and arcade pass. There was no way he should have been able to have what he has so I asked him what he was doing and he told me. Is there a way to fix this or is it only happening on my site?

gfxhavenowner
09-02-2004, 02:25 PM
Error

SQL-query :

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` )
VALUES ( 6472, 0, 'settinggroup_arcadepass', 'Arcade Pass Hack v3 Settings', 5000 )

MySQL said:

Duplicate entry '6472' for key 1

Can someone please address this? 2 people have posted multiple times about it, and I'm getting the same error. Is 6472 taken up by another hack?

ambrosious
09-04-2004, 10:44 PM
Here's one for you, I have the pass installed and the UT shop and store hack but cannot get the pass to admit it needs to take points! Any ideas?

ambrosious
09-05-2004, 04:42 PM
Anyone?

venomx
09-07-2004, 12:44 AM
I will wait until this is working with no errors to install.. :(

ambrosious
09-07-2004, 01:39 AM
I have no errors, just can't turn the dang thing on!?

gfxhavenowner
09-07-2004, 11:07 PM
There's a very easy fix to get this all working.

Do everything via the TXT install, rather then the HTL install. Run db_queries and setting in MySQL first. Then, go through file_edits and template_edits. Finally, add the phrases via Download/Upload in the ACP. Point to arcadepass_phrases in the HTL folder. Do the same for the new templates, pointing to arcadepass_templates. This will work, and it works well.

As an added feature for the full release, how bout a field in the ACP to change the cost of the pass?

Wapture
09-18-2004, 04:37 PM
After trying to install this hack I received this error in Admincp for Import/Export

Database error in vBulletin:ImpEx Target 3.0.3:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

TJFweb
09-19-2004, 06:19 AM
After trying to install this hack I received this error in Admincp for Import/Export

Database error in vBulletin:ImpEx Target 3.0.3:

Link-ID == false, connect failed
mysql error:

mysql error number: 0
For some reason it's not deducting any points when I do "Pay Per Game"...

TJFweb
09-19-2004, 06:45 AM
For some reason it's not deducting any points when I do "Pay Per Game"...
I'm using uShop 0.95b by the way... I have the points fields and points tables set up correctly. People can use the Arcade and they get points for a Jackpot, however they are not charged anything for playing the game...

GamerJunk.net
09-24-2004, 08:48 PM
I installed it and now my arcade looks like this, just do you know I also have the arcade categories mod installed...

What can I do?

richier
09-26-2004, 07:54 PM
I get this when I try to save the game settings.. can some one help me here please



Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE games SET title='Snake',descr='The mobile phone classic, \"Snake\" can now be played on your PC! Save your phone battery and play to get a high score on the leaderboard.'arcadepass_cost='20',arcadepass_jackp ot='500',arcadepass_increase='5',gamesettings=29 WHERE gameid=1
mysql error: You have an error in your SQL syntax near 'arcadepass_cost='20',arcadepass_jackpot='500',arc adepass_increase='5',gamesettin' at line 1

mysql error number: 1064

Date: Sunday 26th of September 2004 03:46:59 PM
Script: http://www.dfwsportbike.com/forums/admincp/arcadeadmin.php
Referer: http://www.dfwsportbike.com/forums/admincp/arcadeadmin.php?do=games
Username: Richie
IP Address: 24.0.215.67

richier
09-26-2004, 09:06 PM
I get this when I try to save the game settings.. can some one help me here please



Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE games SET title='Snake',descr='The mobile phone classic, \"Snake\" can now be played on your PC! Save your phone battery and play to get a high score on the leaderboard.'arcadepass_cost='20',arcadepass_jackp ot='500',arcadepass_increase='5',gamesettings=29 WHERE gameid=1
mysql error: You have an error in your SQL syntax near 'arcadepass_cost='20',arcadepass_jackpot='500',arc adepass_increase='5',gamesettin' at line 1

mysql error number: 1064

Date: Sunday 26th of September 2004 03:46:59 PM
Script: http://www.dfwsportbike.com/forums/admincp/arcadeadmin.php
Referer: http://www.dfwsportbike.com/forums/admincp/arcadeadmin.php?do=games
Username: Richie
IP Address: 24.0.215.67

Fixed

rinkrat
09-26-2004, 11:41 PM
I wish that when people solved their problem that they would share the solution with the group instead of merely writing "fixed".

venomx
09-26-2004, 11:43 PM
yeah would be nice...

rinkrat
09-26-2004, 11:44 PM
I'm using uShop 0.95b by the way... I have the points fields and points tables set up correctly. People can use the Arcade and they get points for a Jackpot, however they are not charged anything for playing the game...


Users who "buy" the pass don't get charged per game ;) .

platnum
09-27-2004, 07:24 PM
When I goto run the "settingphrase" file.. I get this error message :(

"Error

SQL-query :

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` )
VALUES ( 6472, 0, 'settinggroup_arcadepass', 'Arcade Pass Hack v3 Settings', 5000 )

MySQL said:


#1062 - Duplicate entry '6472' for key 1"

I don't know what to do, please help me lol... Thanks a million! :D :D :D

Wapture
09-27-2004, 08:29 PM
I get the same problem.

Looking at the phrase database, entry 6472 is usergroup_add_edit_canseehidden_text

Breavis
09-30-2004, 07:54 AM
I guess I'm currently a newbie, and forgive me for asking but what is HTL? And what would I need to have it install using the HTL version?

mcyates
10-10-2004, 03:37 PM
Nothing has changed on my arcade why is this it doesn't show costs of the games it just looks normal and you can still play any game.

Also what i click on this: http://www.myfootballforum.com/arcadepass.php

Arcade passes are not enabled by the administrator.

But they are enabled?

Very weird

fly
10-12-2004, 12:02 AM
Okay, when running the settingphrase.sql, I get this error:

SQL-query :

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` )
VALUES ( 6472, 0, 'settinggroup_arcadepass', 'Arcade Pass Hack v3 Settings', 5000 )

MySQL said:

#1062 - Duplicate entry '6472' for key 1

edit: Does it matter what 'phraseid' I make it??? Looks like that SQL file walks all over my DB...

reedit: I appear to have fixed the problem, but I don't know if it was the right thing to do. I am awaiting a PM from Link14716 to let me know if its right. All I did was add a 1 in front of all the SQL queries for the settingphrase.sql file. So 6472 became 16472. Hopefully he'll reply here or to me in PM. I'd upload the SQL file, but it appears that I don't have permission to upload or something.

rereedit: haha. I figured out how to upload it, but I wouldn't run it if I were you until we hear from Link (or some vB hacker).

Lionel
10-18-2004, 05:07 AM
I have done and enabled everything by the book, but I cannot display the links. And when I try to access arcadepass.php directly, it tells me I do not have enough points for this. How do I make sure that the conditions below are enabled? I also have the categories hack installed.

<if condition="$show['arcadepass']">Arcade Pass Verified!<br /><br /><else /><if condition="$show['expiredpass']">Arcade Pass Expired! <a href="arcadepass.php?$session[sessionurl]">Buy a new one!</a><br /><br /><else /><if condition="$show['getpass']"><a href="arcadepass.php?$session[sessionurl]">Buy an arcade pass now!</a><br /><br /></if>

Bigwrenn
10-18-2004, 06:33 PM
I have searched this thread and manu others trying to find the solution to my problem. I have installed ushop and the arcade pass. I installed the arcade pass manually and everything went fine but now when a game is played by a verified pass holder the links to play become available to all afterwards. Anybody have an idea on what might be causing this???

I have checked everything 3 to 4 times and cannot find where the problem is. Any help will be greatly appreciated.

Thanks,
Bigwrenn




Breavis- Check this thread out, I think it will shed light on what your asking: https://vborg.vbsupport.ru/showthread.php?t=60735&highlight=htl

Lionel
10-19-2004, 09:02 PM
OK, all my issues seemed to be resolved.

Bigwrenn
10-24-2004, 03:09 AM
I have searched this thread and many others trying to find the solution to my problem. I have installed ushop and the arcade pass. I installed the arcade pass manually and everything went fine but now when a game is played by a verified pass holder the links to play become available to all afterwards. Anybody have an idea on what might be causing this???

I have checked everything 3 to 4 times and cannot find where the problem is. Any help will be greatly appreciated.

Thanks,
Bigwrenn






Anybody? :confused:

Mr.Haze
10-31-2004, 11:00 AM
I want to use Jackpot prizes, but I don't want users to have to bother with passes. If you turn off the arcade passes, can you still win points for top scores?

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

venomx
11-05-2004, 12:16 AM
Can we get this without the Hack Installer System being needed?

Link14716
11-05-2004, 12:24 AM
As said, it is included. Just act like it is just a standard installer.

The HIS does not need a seperate installation, and is completely included in the zip.

mrcancel
11-05-2004, 09:56 PM
when i installing this hack : "Click here to begin the installation process -->" then error : "Arcade Pass v3 build #1 contains no index.php containing hack information and cannot be installed." !
Why ? help me !

Link14716
11-05-2004, 11:20 PM
Unsuprisingly I've botched this release as well, leaving me wondering "Just where in the ++++ did those files go?"

Removing the attachment now to fix this problem. Son of a +++++.

Link14716
11-05-2004, 11:28 PM
Alright, the file is back up. Redownload it and reupload everything. The install should work then.

mrcancel
11-05-2004, 11:34 PM
yeah, i see ! Thank you !

xlr8ed
11-12-2004, 10:50 PM
my board is setup with 3 groups .....

regular members
donators1
and donators2
and staff

i would like to make it so that

staff, donators1 , and donators2 groups all can play arcade without having a arcade pass.


i would like the regular members still be required to buy pass.




can this be done ?


I am very interested in this also

idslamyou
11-21-2004, 04:17 AM
I need to uninstall this hack. I installed using the HTL version a while ago. I went in there and chose "uninstall hack" from the drop down menu, but nothing happens. Is there an easy way to uninstall this hack? I am getting DB errors such as this one

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

mysql error number: 1064. This happens when anyone tries to submit their scores. I would like to uninstll the hack and try reinstalling it. Can someone let me know what query to run to erase the db modifications.

Thanks

TTG
12-03-2004, 09:40 PM
Can someone post the file edits and template edits .. Ran the installer and screwed up somewhere and now can't re-run the installer again.

The Equivocate
12-11-2004, 07:52 PM
When I go into my AdminCP to edit a game, I am unable to click in or edit the Game Cost, Jackpot, or Jackpot Increase fields. They are empty and blank, and you can't click in them or hit tab from another field (it skips over them). I have no idea why it would be doing this...

Also I figure it might not even be that necessary, if there is just some MySQL query that I can run since I want all the games to have the same values for those fields anyways.

bahawolf
12-13-2004, 01:24 AM
I've traced the problems with the links to the template: arcade_main_games_bit

I fixed it!

I removed all of the following: '<if condition="!isset($show['nolink'])">' and the concluding '</if>' with it.. not sure why it made it not work, but the links work and I tested it and no problems so far.

eNforce
12-19-2004, 03:21 AM
Warning: main(../upgrade_queries_v3arcade.php): failed to open stream: No such file or directory in /home/badgerh/public_html/install/hacks/Arcade_Pass_v3/1/index.php on line 40

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

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

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

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

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

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

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

rich
x.russbo.com

docvader
12-19-2004, 09:48 PM
OK, fixed the looking for uttstore.php (it's in the arcade pass, very easy to find, change it to ushop.php).

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

Database error in vBulletin 3.0.3:

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

mysql error number: 1064

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


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

Where have I gone wrong?

Thanks
rich

docvader
12-19-2004, 10:14 PM
Fixed database error issue with PixelFX's fix from before:
UPDATE games SET arcadepass_cost='25', arcadepass_jackpot='100', arcadepass_increase='5';

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

rich

docvader
12-19-2004, 11:49 PM
Took it out temporarily, can't seem to get it all to work correctly. Hope the issues get ironed out, really want to use this.

rich

teamelusive
12-20-2004, 02:59 AM
during install....
Warning: Invalid argument supplied for foreach() in /www/teamelusive.com/html/forums/install/hacks/Arcade_Pass_v3/1/index.php on line 38

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

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

mysql error number: 1064

whats it all mean?

docvader
12-21-2004, 02:10 AM
Installed, and I think, working well.

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

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

msimplay
12-21-2004, 07:18 AM
will the arcade pass hack work with IB Arcade hack ?

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

arcade_main_games_bit
arcade_main

jbd
12-21-2004, 04:16 PM
Database error in vBulletin 3.0.3:

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


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

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

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

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

The install puts those closing brackets into the ADMIN CP / Arcade Pass hack control panel automatically. Not sure why he did that. Personally, I have issues with his install package, but that's another story. The brackets threw me for a while too. You need to go into your ADMIN CP, vboptions, arcade pass hack page, and take those closing brackets out.

Now, if only my Update button in the ADMIN CP / Arcade/ Game settings page would come back (this hack caused it to gray out and become unusable for some strange reason...)

Roxie
12-22-2004, 03:42 AM
It would be nice if the hack listed how much money you won or if you won any at all. Or told you how long the arcade pass lasted (for the members). Or if it told what place you had to come in to get a part of the jackpot...and how much you get.

Anyone know what I should edit to put that information in?

plubius
12-28-2004, 02:32 PM
I am getting this error

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE user SET arcadepass='1104250935' WHERE userid='1'
mysql error: Unknown column 'arcadepass' in 'field list'

mysql error number: 1054

Date: Tuesday 28th of December 2004 11:22:15 AM
Script: http://thegamelands.com/talk/ushop.php
Referer: http://thegamelands.com/talk/ushop.php?do=a&aid=13

MorrisMcD
01-16-2005, 01:53 AM
:crickets:

Any word on an upgrade?

mindbuster
01-17-2005, 03:08 AM
Anyone having this working on vB 3.0.5 with v3 arcade and uCS ?

MorrisMcD
01-17-2005, 03:43 AM
Anyone having this working on vB 3.0.5 with v3 arcade and uCS ?

Nope..

In fact.. I just upgraded from 3.0.1 a few nights ago to 3.0.5.. I had this installed and working before the upgrade, and now after the upgrade, I cannot change the prices or other options.. Those fields simply will not let me click in them.. I reinstalled and made all necessary edits as well..

mindbuster
01-19-2005, 06:20 AM
Nope..

I installed it and it's working, well, kinda working, when not buying an arcade pass there are no links to play the games eventhough i have the option for pay pr game enabled, only link available is the most recent hiscore link, and when clicking that it says i dont have enough money to play, although i have.

But when buying an arcade pass in uShop it works just fine, after applying some of the small fixes mentioned in this thread.

I need to test it some more though, with other accounts and such.

But so far its working, there was a few things in the instructions which didnt fit my version of the arcade (1.0.3) but got them sorted out, i guess.

Some places where it says "Add below" you need to "Add after" instead, in between certain places on one line, also in arcade.php there where 2 instances of the "no permission", i chose the first instance i found, the one farthest up in the file, not the one you find first when following the instructions step by step, when you come to the "no permission" edit place your cursor at the top of the file to find the first instance of "no permission", seemed more logical than the other option.

Maybe im gonna try with the other option if cant get the "pay pr game" to work, but it didnt look like it was there it was supposed to be, just guessing here though.

But again, i got it working fine with vB 3.0.5 arcade 1.0.3 and uCS .95b.

fly
01-19-2005, 11:12 AM
I gave up on pay-as-you-play long ago and disabled it.

ambrosious
01-21-2005, 09:22 PM
I had installed this a long time ago on 3.0.3 with utt Shop and never got it to work right, I was excited to see the self installer!

However, when it got to the db additions, it crashed (installer) due to the tables being in existance.

Is that the last step? Can I reinstall? Is there a solution? Also, I noticed in the options for Arcade Pass in my admin cp all of the numeric values had a ")" after them. Is that normal? Do I leave the ")" or take it out?

Thanks in advance for this!

mindbuster
01-21-2005, 09:53 PM
Also, I noticed in the options for Arcade Pass in my admin cp all of the numeric values had a ")" after them. Is that normal? Do I leave the ")" or take it out?




Take them out or they'll mess things up.

ambrosious
01-21-2005, 10:33 PM
Thanks! I appreciate it!

Sooner95
01-25-2005, 04:06 PM
this dead? doesnt seem like their is any support for it anymore.. to bad would be cool

mindbuster
01-25-2005, 06:00 PM
this dead? doesnt seem like their is any support for it anymore.. to bad would be cool

Except for the pay pr play it works fine, just read through the whole thread and pick up the small changes, most questions has already been answered, i got it working on vB 3.0.5/Arcade 1.0.3/uCS .95b by reading this thread.

blackpheonix
01-25-2005, 07:30 PM
does it work for 3.0.6

weaver
02-05-2005, 01:28 AM
The install puts those closing brackets into the ADMIN CP / Arcade Pass hack control panel automatically. Not sure why he did that. Personally, I have issues with his install package, but that's another story. The brackets threw me for a while too. You need to go into your ADMIN CP, vboptions, arcade pass hack page, and take those closing brackets out.

Now, if only my Update button in the ADMIN CP / Arcade/ Game settings page would come back (this hack caused it to gray out and become unusable for some strange reason...)

Thanks so much!!! I have been struggling with db errors all night. Too bad the hack itself isn't updated to correct the problem.

Creed
02-19-2005, 10:24 PM
Nevermind, found my problem ;)

EricaJoy
02-20-2005, 03:29 PM
Great hack! I was looking for this very thing. Thanks!

atrljoe
02-28-2005, 01:05 AM
Can Anyone help me I keep getting a 404 error when I try to access arcadepass.php it works if you buy it from UTTstore, but when you go to arcadepass.php it display a 404 Error, the file is upload, uploaded via FTP with ASCII so it should work but it displays 404 Error can anyone help?

Harry72
03-28-2005, 01:47 PM
Hi,

i have a little problem with uShop/uChash - Points and v3 Arcade Pass. The Arcade Pass works fine, but not pay for play.
Example:
I select 10 points for playing snake. I played it and looked at my points. But i`ve the same points before i played the game. No points will be taken off.

In my admincp - Arcade Pass i have the following attitudes:

- Arcade Pass Masterswitch: ON
- Arcade Pass aktive: NO
- Pay for play: YES

I have the right settings, but nothing happens. What is wrong ? :ermm:

PixelFx
03-30-2005, 07:33 AM
I tried to get this working the othernight, finally had to uninstall it, I'm on vb3.0.7 .. heavely hacked arcade. Still that should effect it. Would be cool to see an update for this later.

fly
03-30-2005, 11:07 AM
I tried to get this working the othernight, finally had to uninstall it, I'm on vb3.0.7 .. heavely hacked arcade. Still that should effect it. Would be cool to see an update for this later.
If it helps, I never got pay-for-play to work, ever. But everything else worked fine. Dunno if that was the problem you had...

Harry72
03-30-2005, 11:20 AM
If it helps, I never got pay-for-play to work, ever. But everything else worked fine. Dunno if that was the problem you had...

Welcome in team. :nervous:

All works fine - only pay-for-play didn`t. :ermm:

lwhite
04-10-2005, 05:14 AM
Welcome in team. :nervous:

All works fine - only pay-for-play didn`t. :ermm:
I recently changed the price for the arcade pass and now users that had already bought passes show that their passes are expired (which they should), but it still letting them playing the game...Help?

sim tech
04-22-2005, 05:37 AM
Sorry if this was already covered, but I scanned thru the 13 pages of posts and didn't see anything...

I have the ushop hack installed, and my arcade.php was modded for a playing card layout, rather than the standard column layout of all of the games.

Will the auto installer screw things up here? (I'm backing up the entire site as I type this before I try).

Also, I'm not sure if I'll use the arcade pass part (I may activate it to menbers who help me with my site) but I do want something like 10 points per game to be deducted from the point system I have installed. The problem is I have close to 550 games on my site! Will I have to set up each game and jackpot?

msimplay
04-22-2005, 05:56 AM
Sorry if this was already covered, but I scanned thru the 13 pages of posts and didn't see anything...

I have the ushop hack installed, and my arcade.php was modded for a playing card layout, rather than the standard column layout of all of the games.

Will the auto installer screw things up here? (I'm backing up the entire site as I type this before I try).

Also, I'm not sure if I'll use the arcade pass part (I may activate it to menbers who help me with my site) but I do want something like 10 points per game to be deducted from the point system I have installed. The problem is I have close to 550 games on my site! Will I have to set up each game and jackpot?

i had to set mine up for every game

I wonder if theres way so that games have default values so you don't have to edit each game after installing it

spy0012
04-28-2005, 08:57 PM
Hi, I have a question, or help if anyone can provide.

I have implamented the arcade pass and credit / points usage, how can i make the challenge part take points from the person challenging as it's currently free no matter if you have points or not.

If anyone can make it charge points for challenges it would be appriciated, i am using ushop for the points, if it matters

m0nde
04-30-2005, 07:36 PM
This hack works...

But when a user wins a game and gets a highscore, I get this error:

Database error in vBulletin 3.0.7:

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

mysql error number: 1064


This error doesn't occur if they don't get a highscore and are getting the jackpot points.

It looks like it's got an extra ")" in the code somewhere which I must have added inadvertantly. Can someone tell me what to change to fix this?

:ermm:

- Sid

fly
05-02-2005, 11:23 AM
I don't think any of those ) are supposed to be there. Go back over the steps of the hack and take those out.

spy0012
05-02-2005, 12:48 PM
Hi, I have a question, or help if anyone can provide.

I have implamented the arcade pass and credit / points usage, how can i make the challenge part take points from the person challenging as it's currently free no matter if you have points or not.

If anyone can make it charge points for challenges it would be appriciated, i am using ushop for the points, if it matters


Anyone got any ideas how to help me figure this problem out, please

msimplay
05-21-2005, 02:21 PM
I don't seem to have those problems so try my arcadepass.php
see if that helps

steadicamop
05-21-2005, 04:59 PM
I get this error when I click the link to buy a pass from inside the arcade:

Multiple Choices
The document name you requested (/uttstore.php) could not be found on this server. However, we found documents with names similar to the one you requested.

Available documents:

* /uttstore?do=a&aid=13 (common basename)

Please consider informing the owner of the referring page about the broken link.

The only uttstore file I can find is the includes/functions.uttstore.php one, it looks to me like it's looking in the wrong place ... any ideas/suggestions?

My goof, it's a simple fix, just rename uttstore.php to ushop.php on line 38 in the arcadepass.php file

lifesbattles
05-28-2005, 11:53 AM
<a href="http://www.lifesbattles.com/forums/arcade.php?" target="_blank">http://www.lifesbattles.com/forums/arcade.php?</a>

i've got a problem, the links aren't working correctly, any ideas?

danb00
06-21-2005, 09:35 PM
i to get this error when trying to submit a high score

Invalid SQL: UPDATE user) SET uttpoints)=uttpoints)+275 WHERE userid='3'
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') SET uttpoints)=uttpoints)+275 WHERE userid='3'' at line 1

mysql error number: 1064

Date: Tuesday 21st of June 2005 06:36:00 PM
Script: http://localhost/forum/arcade.php

KevinL
06-21-2005, 11:03 PM
I was going to try and install this manually but I dont have a table 'games' ...any ideas? :)

ALTER TABLE `games` ADD `arcadepass_cost` VARCHAR( 20 ) NOT NULL ,
ADD `arcadepass_jackpot` VARCHAR( 20 ) NOT NULL ,
ADD `arcadepass_increase` VARCHAR( 20 ) NOT NULL ;

UPDATE games SET arcadepass_cost='20', arcadepass_jackpot='500', arcadepass_increase='5';

ALTER TABLE `user` ADD `arcadepass` BIGINT( 15 ) NOT NULL ;

KevinL
06-23-2005, 11:54 AM
I was going to try and install this manually but I dont have a table 'games' ...any ideas? :)

ALTER TABLE `games` ADD `arcadepass_cost` VARCHAR( 20 ) NOT NULL ,
ADD `arcadepass_jackpot` VARCHAR( 20 ) NOT NULL ,
ADD `arcadepass_increase` VARCHAR( 20 ) NOT NULL ;

UPDATE games SET arcadepass_cost='20', arcadepass_jackpot='500', arcadepass_increase='5';

ALTER TABLE `user` ADD `arcadepass` BIGINT( 15 ) NOT NULL ;
Like I said I dont have a table games so it wont install I get an error....any help?

msimplay
06-23-2005, 12:42 PM
Like I said I dont have a table games so it wont install I get an error....any help?

Thats kind of weird since those queries alter the tables you should have . The games table should be there if you have got the v3arcade hack installed and the other one the user table is default in all installations of vbulletin3

KevinL
06-23-2005, 01:04 PM
Thats kind of weird since those queries alter the tables you should have . The games table should be there if you have got the v3arcade hack installed and the other one the user table is default in all installations of vbulletin3
Thanks for the reply :)

I dont have it because Im an idiot :laugh: I read it all wrong..I was looking at the wrong section. :nervous:

I have ibpro and was reading the v3arcade.

Is there anything like this for ibpro and Vb3? I want people to 'buy' the games and receive jackpots. I know there is something to 'pay to play' but didnt see anything like this in one package.

danb00
06-23-2005, 01:36 PM
Any fix to my error im getting? as of right now no one can submit scores to games (lol)

and yes i did all the file edits right

plus i got uashop installed as well

msimplay
06-23-2005, 01:41 PM
Thanks for the reply :)

I dont have it because Im an idiot :laugh: I read it all wrong..I was looking at the wrong section. :nervous:

I have ibpro and was reading the v3arcade.

Is there anything like this for ibpro and Vb3? I want people to 'buy' the games and receive jackpots. I know there is something to 'pay to play' but didnt see anything like this in one package.

not that i currently know of V3arcade is the only one that has the arcadepass for the moment unless of course someone converts the current hack to work with it

KevinL
06-23-2005, 05:50 PM
not that i currently know of V3arcade is the only one that has the arcadepass for the moment unless of course someone converts the current hack to work with it
I see...and how hard would something like that be?

danb00
06-24-2005, 01:42 PM
anyone got a fix for my error?

KevinL
06-24-2005, 05:32 PM
I think it was answered in this thread... the ' ) ' arent supposed to be there. Cant remember what was said to remove them though. Id have another look through the thread.

msimplay
06-24-2005, 05:55 PM
I see...and how hard would something like that be?

Shouldn't be that hard just need to tell it to use the tables in the IPB hack instead of V3arcade. But don't quote me on that since i haven't checked the code on both hacks properly

KevinL
06-24-2005, 08:39 PM
Shouldn't be that hard just need to tell it to use the tables in the IPB hack instead of V3arcade. But don't quote me on that since i haven't checked the code on both hacks properly
I'll take a look at them, dont think I'll get all that far but no harm in trying! :laugh:

Thank you :)

danb00
06-25-2005, 08:04 AM
i went over the topic and i cant find a fix, i need a fix for this anoying bug

KevinL
06-25-2005, 08:15 PM
I think if you read pages 9 through 12 there is some stuff that might help you. :)

o0Hubba0o
07-31-2005, 04:44 PM
i went over the topic and i cant find a fix, i need a fix for this anoying bug
I had that problem too, I re-read this thread a couple times before I found what everyone meant about the extra ")".

Go to your admin control panel, click on "vBoptions" and go to the "Arcade Pass Hack v3 Settings" and in all the fields remove the ")'s" from them, you should be good to go.


Now for my current problem, the arcade pass was working fine, I left for a week and during this time no one can purchase them anymore. I signed in on my test account, adjusted settings and it can't be purchases anymore.

When you click the "Buy" button it brings you to this page:
http://www.graphicsanonymous.net/images/arcadeprob.jpg

MorrisMcD
07-31-2005, 05:53 PM
Is there something I can do to reset the price of all the games to one value?

MorrisMcD
07-31-2005, 06:04 PM
Is there something I can do to reset the price of all the games to one value?

Actually I am getting an error whenever I try to save game settings of any kind.. People can play games that have a price set on them, but some games dont have a price and cannot be played.. In addition, any game.. Even the ones that work, cant have any changes saved...

Help? :(

This is the message when I try to update game settings

Invalid SQL: UPDATE games SET title='Snake',descr='The mobile phone classic, \"Snake\" can now be played on your PC! Save your phone battery and play to get a high score on the leaderboard.'arcadepass_cost='20',arcadepass_jackp ot='775',arcadepass_increase='5',gamesettings=28,c ategoryID= WHERE gameid=1
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'arcadepass_cost='20',arcadepass_jackpot='775',arc adepass_increa

mysql error number: 1064

MorrisMcD
08-06-2005, 03:25 PM
Actually I am getting an error whenever I try to save game settings of any kind.. People can play games that have a price set on them, but some games dont have a price and cannot be played.. In addition, any game.. Even the ones that work, cant have any changes saved...

Help? :(

This is the message when I try to update game settings
Bump

Anyone? Is this still supported?

Dorign
08-08-2005, 08:01 PM
Is there a way to shave off the jackpot decimals? It's saying the jackpot is 566.6666667. Anyway to round that down?

Dorign
08-10-2005, 04:16 AM
Anyone?

Drago912
08-13-2005, 06:01 PM
Does this work for Vb 3.0.8 and ibproarcade 2.5.1 yet?

blackpheonix
09-04-2005, 06:25 AM
can someone help i stuffed up my arcadeadmin.php sum how it doesnt show in admincp any more. i followed instruction but for sum reason it doesnt work heres my php file if it helps.


i nailed the problem to this bit of code can anyone see what wrong with it its exactly the same as in the install file

arcadepass_cost='$_POST[cost]',arcadepass_jackpot='$_POST[jackpot]',arcadepass_increase='$_POST[increase]',

hbalagh1
09-19-2005, 02:47 PM
i so much want this mod but like alot of other people i am getting the same problems with the

mysql error number: 1064

if anyone can help it would be greatly appreciated

EDIT: Never mind fixed my error, somehow i had added the lines before a "," instead of after and it messed everythign up..

hbalagh1
09-21-2005, 07:35 AM
no more support i guess for this mod?

dxguru
10-28-2005, 09:36 AM
Is there a way to shave off the jackpot decimals? It's saying the jackpot is 566.6666667. Anyway to round that down?
In arcade.php search for
$addpoints = ($game['arcadepass_jackpot'] / $position['position']);
and change to
$addpoints = round($game['arcadepass_jackpot'] / $position['position']);

BNdotcom
11-18-2005, 04:28 PM
When will 3.5 be released?

Stangsta
11-27-2005, 08:08 PM
Bump! Arcade had been released! Can someone port this?

trackpads
11-27-2005, 08:13 PM
Bump! Arcade had been released! Can someone port this?

Me too, willing to chip in $$ for it!

gwhooooey
01-11-2006, 04:28 PM
Bumparoonie. Really need this.