Arcade Pass Hack v2.0

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

[chavalo2]

Installed By: 62 users

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

respond someone??

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

[Link14716]

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

[sql]ALTER TABLE `user` ADD `arcadepass` INT(255) DEFAULT '0' NOT NULL;[/sql][sql]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');[/sql][sql]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; [/sql][sql]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';[/sql]

[chavalo2]

well for the record I am running MySQL 3.23.54


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

For

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

I get errors that say:

SQL-query : [Edit]

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

MySQL said:


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

Back

[Link14716]

I said phpMyAdmin, not MySQL

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

[chavalo2]

That was phpMyAdmin

Welcome to phpMyAdmin 2.2.0
MySQL 3.23.54 running on localhost

Still get those errors.

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

Database error in vBulletin Control Panel 2.3.0:

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

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

mysql error number: 1064

And on the next code:

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

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

and with phpmyadmin:

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

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

MySQL said: 


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

Back

[DigitalDesktops]

hmm try doing this:

[sql] ALTER TABLE user ADD arcadepass INT(255) DEFAULT '0' NOT NULL;[/sql]

[chavalo2]

Today at 04:04 AM DigitalDesktops said this in Post #116
hmm try doing this:

[sql] ALTER TABLE user ADD arcadepass INT(255) DEFAULT '0' NOT NULL;[/sql]

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

[chavalo2]

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

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

Here is the 4th working one also:

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

Number 2 has me baffled.

[chavalo2]

Here is the one I cant get:

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

[GaleForce]

Looks nice, going to install it right now.