vb.org Archive - Arcade Pass Hack v2.0

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Arcade Pass Hack v2.0 (https://vborg.vbsupport.ru/showthread.php?t=43700)

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

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]

well for the record I am running MySQL 3.23.54

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

For

Code:

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

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.

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.

Code:

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:

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:

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\');



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

hmm try doing this:

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

Quote:

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:

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

Code:

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:

Code:

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.

Here is the one I cant get:

Code:

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');

Looks nice, going to install it right now.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01312 seconds Memory Usage 1,746KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: