ORGANIZE YOUR V3Arcade CATEGORIES

[frankenberrie]

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:
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:
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:
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:
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/showthread.php?t=65967&highlight=Arcade+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/showthread.php?t=65967&highlight=Arcade+Category

[KW802]

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

[hackindave]

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

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