just to help out here are a few sample sub cats to get you started and give you a Idea on how to do it
Code:
INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'About a Girl');
INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'AMV');
INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'Battle Programer Shirase');
INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'Big O');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Action');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Adventure');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Americana');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Animation');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'Dreamcast');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'Game fixes/patches');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'GameCube');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'Linux');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Alternative');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Ambient');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Anime');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Asian');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Linux');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Mac');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Mobile phones');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Other operating systems');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '10 Items or Less');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '24');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '3 LBS');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '30 Days');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Flash/Shockwave');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Funny clips');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Other');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Podcasts');
to give you example on how to write new sql, the values are:
PHP Code:
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Podcasts');
7 is the id of the base category
the Others are the name of the base category
Podcasts is the name of the new subcategory you want to add the the Others category
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum
My Current Demo is here http://demo.btmanager.org/
Last edited by joeroberts; 8th August 2009 at 15:44.
|