ORGANIZE YOUR V3Arcade CATEGORIES
Mod Version: 1.00, by frankenberrie
This modification is in the archives.
| vB Version: 3.0.3 | Rating:  (1 vote - 5.00 average) |
Installs: 15 |
| Released: 28 Oct 2004 | Last Update: Never | Downloads: 0 |
 Not Supported
|
||
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:
If you wanna sort your categories by name, replace with:
If you wanna sort your categories by games available (least-most), replace with:
If you wanna sort your categories by games available (most-least), replace with:
Save your file and uload - Don't forget to click install if you use this mod.
EDIT:
this mod is required:
http://www.vbulletin.org/forum/showt...rcade+Category
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:
http://www.vbulletin.org/forum/showt...rcade+Category
Download
No files for download.