ORGANIZE YOUR V3Arcade CATEGORIES

ORGANIZE YOUR V3Arcade CATEGORIES

This 30 second mod that will help you organize your V3Arcade Categories. I have included a few different choices.

1) Sort categories by name
2) Sort categories by most games available
3) Sort categories by least games available


Files to modify: ARCADE.PHP - (very simple)
I cannot stress to you more - make sure you keep a backup of your original files




Find:

PHP Code:

SELECT A.categoryID,A.categorytitle,A.categorydescr, count(*) 'total' FROM " . TABLE_PREFIX . "gamescat A, " . TABLE_PREFIX . "games B WHERE A.categoryID = B.categoryID group by A.categoryID 


If you wanna sort your categories by name, replace with:

PHP Code:

SELECT A.categoryID,A.categorytitle,A.categorydescr, count(*) 'total' FROM " . TABLE_PREFIX . "gamescat A, " . TABLE_PREFIX . "games B WHERE A.categoryID = B.categoryID group by A.categoryID ORDER BY categorytitle ASC 


If you wanna sort your categories by games available (least-most), replace with:

PHP Code:

        SELECT A.categoryID,A.categorytitle,A.categorydescr, count(*) 'total' FROM " . TABLE_PREFIX . "gamescat A, " . TABLE_PREFIX . "games B WHERE A.categoryID = B.categoryID group by A.categoryID ORDER BY total ASC 


If you wanna sort your categories by games available (most-least), replace with:

PHP Code:

        SELECT A.categoryID,A.categorytitle,A.categorydescr, count(*) 'total' FROM " . TABLE_PREFIX . "gamescat A, " . TABLE_PREFIX . "games B WHERE A.categoryID = B.categoryID group by A.categoryID ORDER BY total DESC 


Save your file and uload - Don't forget to click install if you use this mod.

EDIT:
this mod is required:
https://vborg.vbsupport.ru/showthrea...rcade+Category

[KW802]

v3Arcade has categories?

[peterska2]

It does if you apply the category add on mod.

Technically this is an add-on for an add-on

I wouldn't mind but I sorted all mine out yesterday via phpmyadmin

Typical eh?

[frankenberrie]

Here is the Category mod:
https://vborg.vbsupport.ru/showthrea...rcade+Category

[KW802]

See, you guys were just trying to make me think I was going nuts or something!

[hackindave]

I have the catagories installed and would like to use this, however in my arcade.php I cannot find

PHP Code:

SELECT A.categoryID,A.categorytitle,A.categorydescr, count(*) 'total' FROM " . TABLE_PREFIX . "gamescat A, " . TABLE_PREFIX . "games B WHERE A.categoryID = B.categoryID group by A.categoryID 


I am running 3.5.4