A comprehensive list of 8,500+ categories for phpLinkDirectory (phpLD) directory script.  The list is compatible with phpLD version 3.x to version 4.x. That is the list and associated SQL statements will work for all phpLinkDirectory versions from 3.0 to 4.0, versions in between and  beyond (that is version 4.x). The categories come in the form of SQL script, in other words, SQL category dump. The script is ready to be run on any SQL browser or tool such as MySQL query browser. We have the largest and in-depth collection of phpLD categories available on the net and this list is part of our comprehensive collection.

The SQL script is a set of SQL INSERT commands that will automatically create the category structure for your brand new phpLD directory. All you need is to load the script contents on to your tool (e.g. MySQL QueryBrowser) script window and execute. The detail loading or installation instruction is included in the pakage.

This category dump is three levels deep and based on dmoz categories. Number of categories in each of the levels are:

File cat-level-1.sql (1st Level) - 17 Categories
File cat-level-2.sql (2nd Level) - 667 Categories
File cat-level-3.sql (3rd Level) - 7896 Categories

Total categories - 8580 Categories

Each successive upper level is optional. For example if you want your directory to be setup only two levels deep you simply do not install the 3rd-level SQL script file (cat-level-3.sql).

Data Format:

The package contains list as a set of SQL INSERT Command statements doing the following:
a) Insert records in the PLD_CATEGORY table
b) Instruction to insert a record in the PLD_CATEGORY_SEQ table

Data Columns:

The list inserts values in the following fields:

• ID
• TITLE
• CACHE_TITLE
• TITLE_URL
• CACHE_URL
• PARENT_ID
• STATUS
• META_KEYWORDS

Data Example:

INSERT INTO `PLD_CATEGORY` `ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (1147, 'Trading', 'Arts: Music: Trading', 'Trading', 'index.php?c=1147', 55, 2, 'Trading');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (1148, 'Vocal', 'Arts: Music: Vocal', 'Vocal', 'index.php?c=1148', 55, 2, 'Vocal');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (1149, 'Weblogs', 'Arts: Music: Weblogs', 'Weblogs', 'index.php?c=1149', 55, 2, 'Weblogs');

Background FAQs:

What is Categories Dump?

If you have set up a new web directory using phpLD script, the first thing you will need before anyone can submit to your directory is a list of categories, sub-categories and sub-sub-categories and so on. Adding categories to your web directory is a tedious job. You may be able to manage creating 25 categories manually in 10 minutes. But how about creating 8,500 categories? Here is a time saver solution for you.

In the category dump, provided in this pack, not only the list of useful categories is alreday created for you, but also the SQL command is already written and ready to be executed. Therefore, this is the fastest and easiest way to create your php linkdirectory categories. All you need is just run the script.

It is really handy and easy to setup. In just few seconds, you will have your web directory up with more than 8,500 categories. Save your valuable time with this phpLD category dump.

Keywords and Phrases:

phpld category dump, phpld4 categories, phpld, phpld4, category, categories, dump, categories dump phpld, web directory categories, web directory, free categories dump

******************************************************************
List of 8500+ phpLinkDirectory 3.x to 4.x Category Dump
******************************************************************
Is an eBuisnessGems Product
Copyright © eBuisnessGems.com, 2011

Unauthorized copying, distribution and use of this product is strictly prohibited.
You can purchase and download this product from www.eBusinessGems.com.
You can use this product for your own purpose. You are not entitled to resell it.
If you find this product being distributed or sold from any other store, please
immediately inform sales@eBusinessGems.com. Thank you.