[MOD] v3 Arcade Categories Mod 1.3a

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

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.

[AuroraMike]

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?

[AuroraMike]

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

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...

[sitka]

$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.

[YLP1]

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

I am getting this error on the execute query:

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.

[Digikilla]

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.

[Digikilla]

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

I am getting this error on the execute query:

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.

[JoeLouie]

great hack. installed fine on 3.0.7 for me

[rjordan]

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!

[CommunityZ]

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?

[Marco van Herwaarden]

PHP Code:

SELECT * FROM vb3_games A, gamescat B 


You did change the table prefix for 'games', but not for the 'gamescat'.