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)

TJFweb 09-19-2004 06:19 AM

Quote:

Originally Posted by Wapture
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

Quote:

Originally Posted by TJFweb
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/a...rcadeadmin.php
Referer: http://www.dfwsportbike.com/forums/a...n.php?do=games
Username: Richie
IP Address: 24.0.215.67

richier 09-26-2004 09:06 PM

Quote:

Originally Posted by richier
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/a...rcadeadmin.php
Referer: http://www.dfwsportbike.com/forums/a...n.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

Quote:

Originally Posted by TJFweb
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/showthrea...&highlight=htl

Lionel 10-19-2004 09:02 PM

OK, all my issues seemed to be resolved.

Bigwrenn 10-24-2004 03:09 AM

Quote:

Originally Posted by Bigwrenn
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

Quote:

Originally Posted by teksigns
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
Quote:

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

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 10:51 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.01348 seconds
  • Memory Usage 1,837KB
  • 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
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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