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

[CommunityZ]

$game = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games A, gamescat B WHERE A.categoryID = B.categoryID ORDER BY gameid ");

How to change so it makes gamescat to vb3_gamescat?

[Marco van Herwaarden]

PHP Code:

$game = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "games A, " . TABLE_PREFIX . "gamescat B WHERE A.categoryID = B.categoryID ORDER BY gameid "); 


PS Please use the [ php ] bb-code if posting code here.

[CommunityZ]

Sorry. Just now i try to use but i don't know how. Is it just out

PHP Code:

xwsnjka 


?

[maytrix]

I found a slight bug while installing a new arcade. In your arcade king section of code you need to ammend the query to read:

PHP Code:

        $mosthighscores = $DB_site->query("SELECT games.highscorerid, user.username, user.userid FROM " . TABLE_PREFIX . "games AS games
                                           LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = games.highscorerid WHERE games.highscorerid!=''"); 


instead of:

PHP Code:

        $mosthighscores = $DB_site->query("SELECT games.highscorerid, user.username, user.userid FROM " . TABLE_PREFIX . "games AS games
                                           LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = games.highscorerid"); 


or in the case you have more games without a highscorerid it will just loop the results and not show the arcade king.

[saint_seiya]

I ran all the queries perfectly fine and am running 3.0.7, but when I go into gamesettings, the games aren't there and they aren't on the arcade main page. I get this error:

Warning: Invalid argument supplied for foreach() in /admincp/arcadeadmin.php on line 331

Any idea? This line is like in the middle of the code you need to put in.

[RichieBoy67]

Nice Fix Matrix....

[Shill]

Hi Guys,

First off great add on..

Everything works fine apart from 1 thing. I have catagorised the default v3 arcade 5 games (fresh install) into 3 classic, 1 skill, 1 shooter. But when i click on any of the catagorys on the front end it is displaying all 5 games and not just the ones i have placed in that catagory.

Any help on which bit of code displays the catagorys and what to ammend would be greatful. The only other add on I have installed is the one that displays the catagorys in most games > fewest games. Which is just 1 line of code.

Any help would be appreciated.

My site can be found at www.manxarcade.com

Thanks

[MortysTW]

Now that I've done this Catergories hack, the main arcade page seems a little dull. I want to have the "latest 10 games" displayed. Basically give it the look it had BEFORE the categories hack was added but make it the NEWEST ADDED games. Any pointers in which direction I should go sniffing at code? Please and thank you.

[steadicamop]

I attempted to install this hack but didn't even get to finish it as half the code required to change just wasn't in the files!! It's a shame as it would have been pretty handy.

[waza]

Hey,
I can't edit my game settings anymore after I installed this hack...

I attached a screen.
I don't get any mysql errors, and the other things all work fine.

Btw, I think it has something to do with:

PHP Code:

$menu .= "<tr onClick="document.getElementById('id').innerHTML = ".$games[shortname]."id;document.getElementById('descr').innerHTML = ".$games[shortname]."descr;document.getElementById('title').innerHTML = ".$games[shortname]."title;document.getElementById('showaward').innerHTML = ".$games[shortname]."showaward;document.getElementById('challenabled').innerHTML = ".$games[shortname]."challenabled;document.getElementById('playpanel').innerHTML = ".$games[shortname]."playpanel;document.getElementById('active').innerHTML = ".$games[shortname]."active;document.getElementById('netplay').innerHTML = ".$games[shortname]."netplay;document.getElementById('uptbut').innerHTML = ".$games[shortname]."upbuttext;document.getElementById('categorytitle').innerHTML = ".$games[shortname]."categorytitle;">";