vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   Arcade Pass Hack v3! (https://vborg.vbsupport.ru/showthread.php?t=62059)

eNforce 12-19-2004 03:21 AM

Quote:

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:

Quote:

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:
Quote:

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

Quote:

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!


All times are GMT. The time now is 03:52 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01352 seconds
  • Memory Usage 1,741KB
  • 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
  • (4)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