Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
[MOD] v3 Arcade Categories Mod 1.3a Details »»
[MOD] v3 Arcade Categories Mod 1.3a
Version: 1.00, by Oxygen Oxygen is offline
Developer Last Online: Oct 2006 Show Printable Version Email this Page

Version: 3.0.1 Rating:
Released: 06-07-2004 Last Update: 06-07-2004 Installs: 64
 
No support by the author.

_/?\_/?\_/?\_/?\_/?\_/?\_/?\_/?\_/?\__/?\_

v3 Arcade Categories Mod
Version 1.3a
For v3Arcade - Wonderful Arcade Hack!

By Sean T. Boyette
[sboyette@tampabay.rr.com]

?\_/?\_/?\_/?\_/?\_/?\_/?\_/?\_/?\_/??\_/?

Thanks to John, and the work he has done on this hack.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #42  
Old 03-02-2005, 11:20 PM
AuroraMike AuroraMike is offline
 
Join Date: Jan 2005
Location: Denver, CO
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I updated to VB 3.0.7 last week and everything is working fine EXCEPT for this. Now the file edits are still there in arcadeadmin.php (obviously since that's not updated). However I just added 27 new games and I cannot add them to a category. I can edit my other 150+ games but I can't "categorize" these new ones.

I want to stress that everything else w/ the arcade is working. the only change was the 3.0.7 update and I only uploaded the changed files and even then, after I had merged my 3.0.6 hacks into the clean 3.0.7 files. Ppl can play games, record scores, I can access the arcade admin, clear zero scores, remove games, even recategorize existing games.

We can even play the new games w/o issue. But they're in the wrong category. Any ideas?
Reply With Quote
  #43  
Old 03-02-2005, 11:53 PM
AuroraMike AuroraMike is offline
 
Join Date: Jan 2005
Location: Denver, CO
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

************************************************** ***

interesting, it seems that any and all new games that I add cause errors with the arcadeadmin.php. The problem is that all the category fields are greyed out. See the screenshot for what I'm referring to.

The errors that are popping up in IE are:
Expected identifier
Expected ';'

there are 54 errors in total, 27 of each. They all point to lines that describe the newly installed games. The catch is, I cannot find any difference between these new additions and the existing arcade games. The lines look the same between the old and new games. Anyone else?

One of the lines that it's complaining is this:
PHP Code:
            </tr><tr onClick="document.getElementById('id').innerHTML = 5milestogoid;document.getElementById('descr').innerHTML = 5milestogodescr;document.getElementById('title').innerHTML = 5milestogotitle;document.getElementById('showaward').innerHTML = 5milestogoshowaward;document.getElementById('challenabled').innerHTML = 5milestogochallenabled;document.getElementById('playpanel').innerHTML = 5milestogoplaypanel;document.getElementById('active').innerHTML = 5milestogoactive;document.getElementById('netplay').innerHTML = 5milestogonetplay;document.getElementById('uptbut').innerHTML = 5milestogoupbuttext;document.getElementById('categorytitle').innerHTML = 5milestogocategorytitle;">
            <
td><img src="../images/arcade/file.gif"></td>
            <
td>5 Miles To Go &nbsp;</td>
            </
tr></table
says its expecting a ';' at char 44 which is the "d" in document.get. Now if I look at a working arcade game:

PHP Code:
            </tr><tr onClick="document.getElementById('id').innerHTML = radialsnakeid;document.getElementById('descr').innerHTML = radialsnakedescr;document.getElementById('title').innerHTML = radialsnaketitle;document.getElementById('showaward').innerHTML = radialsnakeshowaward;document.getElementById('challenabled').innerHTML = radialsnakechallenabled;document.getElementById('playpanel').innerHTML = radialsnakeplaypanel;document.getElementById('active').innerHTML = radialsnakeactive;document.getElementById('netplay').innerHTML = radialsnakenetplay;document.getElementById('uptbut').innerHTML = radialsnakeupbuttext;document.getElementById('categorytitle').innerHTML = radialsnakecategorytitle;">
            <
td><img src="../images/arcade/file.gif"></td>
            <
td>Radial Snake &nbsp;</td
I don't see a difference and thus why there is an error...
Reply With Quote
  #44  
Old 03-07-2005, 04:21 PM
sitka's Avatar
sitka sitka is offline
 
Join Date: Feb 2005
Location: Sitka, Alaska
Posts: 54
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
$game = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games A, gamescat B WHERE A.categoryID = B.categoryID ORDER BY gameid ");
I have no problem with any other area of the arcade. I can even change the game categories around in the "Game Categories" link in the admincp "Add Game Category" works too.

BUT when i click on the "game settings" in the admincp I get this ERROR

I have the correct names these are just x'd out.
xxxxxx = my prefix
xxxxxx_xxxxxx = database name

Database error in vBulletin 3.0.x:

Invalid SQL: SELECT * FROM xxxxxx_games A, gamescat B WHERE A.categoryID = B.categoryID ORDER BY gameid
mysql error: Table 'xxxxxx_xxxxxxx.gamescat' doesn't exist

mysql error number: 1146

Date: Saturday 05th of March 2005 03:27:29 PM
Script: http://www.xxxxxx.com/forum/admincp/...n.php?do=games
Referer: http://www.xxxxxx.com/forum/admincp/index.php?do=nav
Username: Me
IP Address: xxx.xxx.xxx.xxx

do i need to modify that line of code?
There shouldn't be a . between the prefix and the table name. This isn't the only hack that has issues w/ prefixes. I wish someone could explain how to prevent issues like this.
Reply With Quote
  #45  
Old 03-29-2005, 12:48 PM
YLP1 YLP1 is offline
 
Join Date: Aug 2004
Posts: 417
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am running ver 3.0.7 as well..... were these syntax issues fixed?

I am getting this error on the execute query:

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


INSERT INTO `gamescat` VALUES (1, 'General', 'General G
Thanks in advance for the info.
Reply With Quote
  #46  
Old 04-06-2005, 03:53 PM
Digikilla Digikilla is offline
 
Join Date: Sep 2003
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am running 3.0.7. Everything installed fine and I get no errors, but When i move the games into diffrent catagories, the game get turned off and it won't let me turn them back on threw game settings. Help Plz!

I can however turn them on if I manualy do so inside the database.
Reply With Quote
  #47  
Old 04-06-2005, 04:01 PM
Digikilla Digikilla is offline
 
Join Date: Sep 2003
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
I am running ver 3.0.7 as well..... were these syntax issues fixed?

I am getting this error on the execute query:

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


INSERT INTO `gamescat` VALUES (1, 'General', 'General G

Thanks in advance for the info.
I got the same error when trying to run the DB Queries threw the VB Admin Area. Try Running each query seporatly and it shoudl work fine. It just doesn't liek you running more that one query at a time.
Reply With Quote
  #48  
Old 04-12-2005, 02:57 AM
JoeLouie JoeLouie is offline
 
Join Date: Mar 2005
Location: NS, Canada
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

great hack. installed fine on 3.0.7 for me
Reply With Quote
  #49  
Old 04-12-2005, 03:10 AM
rjordan's Avatar
rjordan rjordan is offline
 
Join Date: Sep 2004
Posts: 326
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I believe that your issues with games are beginning with numbers, right? I think that is a known issue. I am learning as I go, but have always wanted to get into the code to see about correcting that. I think it is a problem in the javascript and dealing with numbers as the first character. Someone correct me if I am wrong, though!
Reply With Quote
  #50  
Old 04-13-2005, 06:13 AM
CommunityZ CommunityZ is offline
 
Join Date: Mar 2005
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Help!

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM vb3_games A, gamescat B WHERE A.categoryID = B.categoryID ORDER BY gameid
mysql error: Table 'forum_testvb.gamescat' doesn't exist

mysql error number: 1146

I follow all the instruction except i changed the table prefix for it from CREATE TABLE `gamescat` ( to CREATE TABLE `vb3_gamescat` ( and INSERT INTO `gamescat` to INSERT INTO `vb3_gamescat` because my forum table prefix is vb3. How to fix this problem?
Reply With Quote
  #51  
Old 04-13-2005, 06:41 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
SELECT FROM vb3_games Agamescat B 
You did change the table prefix for 'games', but not for the 'gamescat'.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.12185 seconds
  • Memory Usage 2,320KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (3)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete