{"id":399,"date":"2023-12-31T17:08:00","date_gmt":"2023-12-31T11:08:00","guid":{"rendered":"http:\/\/ebusinessgems.com\/blog\/?p=399"},"modified":"2023-12-31T17:08:00","modified_gmt":"2023-12-31T11:08:00","slug":"sports-directory-phpld-category-sql-dump","status":"publish","type":"post","link":"https:\/\/www.ebusinessgems.com\/blog\/website-promotion\/sports-directory-phpld-category-sql-dump\/","title":{"rendered":"Sports Directory 2.x to 4.x Phpld Category SQL Dump"},"content":{"rendered":"

7700+ Sports Directory 2.x to 4.x Phpld Category Dump<\/a> is a huge list of 7700+ categories for niche Sports directory for php Link Directory (phpld) script . The list is compatible with phpld version 2.x to version 4.x. That is the list and associated SQL statements will work for all php Link Directory versions from 2.0 to 4.1, versions in between and beyond (that is version 4.x).<\/p>\n

The categories come in the form of SQL script commonly known as phpld category sql dump. The script is ready to be run on any SQL browser or tool such as MySQL query browser. You will also get an Excel file having all the Sports category information for you to modify or create your own unique Sports directory. Below is the first level of category structure for the Sports web directory:
\n[download prod_url='”http:\/\/www.ebusinessgems.com\/catalog\/sports-directory-phpld-category-dump-p-124.html” target=”_blank”‘ prod_title=’Sports Directory 2.x to 4.x Phpld Category-SQL-Dump’]<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/tfoot>\n<\/table>\n

If you do not see some of the sports in the first level, do not worry, those are surely there in the second level of the “Sports Others” category. Also there is a “Sports A-Z” category for all the sports to be classified if missed out (in rare ocassion) in the first or second levels. “Sports Information” is a general category to publish sports related resources.<\/p>\n

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.<\/p>\n

This category dump is FOUR LEVELS deep and based on many premier Sports directory categories including dmoz Sports categories. This list is compiled to create a comprehensive Sports directory on the web. Number of categories in each levels are:<\/p>\n

1st Level – 50+ Categories
\n2nd Level – 990+ Categories
\n3rd Level – 2400+ Categories
\n4th Level – 4260+ Categories
\nTotal 7700+ Categories<\/p>\n

Each successive upper level is optional. For example if you want your directory to be setup only three levels deep you simply do not install 4th and 5th-level SQL script file (cat-level-4.sql and cat-level-5.sql).<\/p>\n

Data Format:<\/strong>
\nThe package contains list as a set of SQL INSERT Command statements doing the following:
\na) Insert records in the PLD_CATEGORY table
\nb) Instruction to insert a record in the PLD_CATEGORY_SEQ table<\/p>\n

Also included in this package is an Excel file containing the list of all categories and subcategries along with ID and PARENT ID. If you want to modify, append or create your own unique Sports catgory list this excel file is a must for you.<\/p>\n

Data Example:<\/strong>
\nINSERT INTO `PLD_CATEGORY` (`ID`,`TITLE`,`TITLE_URL`,`PARENT_ID`,`STATUS`) VALUES (1,’Badminton’,’Badminton’,0,2);
\nINSERT INTO `PLD_CATEGORY` (`ID`,`TITLE`,`TITLE_URL`,`PARENT_ID`,`STATUS`) VALUES (38,’Baseball’,’Baseball’,0,2);
\nINSERT INTO `PLD_CATEGORY` (`ID`,`TITLE`,`TITLE_URL`,`PARENT_ID`,`STATUS`) VALUES (462,’Basketball’,’Basketball’,0,2);
\nINSERT INTO `PLD_CATEGORY` (`ID`,`TITLE`,`TITLE_URL`,`PARENT_ID`,`STATUS`) VALUES (842,’Bowling’,’Bowling’,0,2);<\/p>\n

Keywords:<\/strong> phpld, category, dump, phpld4, categories, sports, games, web, directory, niche<\/p>\n

7700+ Sports Directory 2.x to 4.x Phpld Category Dump<\/a> – is an eBuisnessGems Product
\nCopyright \u00a9 eBuisnessGems.com, 2011<\/p>\n","protected":false},"excerpt":{"rendered":"

7700+ Sports Directory 2.x to 4.x Phpld Category Dump is a huge list of 7700+ categories for niche Sports directory for php Link Directory (phpld) script . The list is compatible with phpld version 2.x to version 4.x. That is the list and associated SQL statements will work for all php Link Directory versions from Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[4],"tags":[71,116,77],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n

First Level Categories
\nof the Sports
\nDirectory<\/th>\n		Category and
\nSubcategory
\nCount<\/th>\n<\/tr>\n<\/thead>\n
Badminton<\/td>\n36<\/td>\n<\/tr>\n
Baseball<\/td>\n423<\/td>\n<\/tr>\n
Basketball<\/td>\n379<\/td>\n<\/tr>\n
Bowling<\/td>\n101<\/td>\n<\/tr>\n
Boxing<\/td>\n21<\/td>\n<\/tr>\n
Business<\/td>\n33<\/td>\n<\/tr>\n
Cheerleading<\/td>\n65<\/td>\n<\/tr>\n
College and University<\/td>\n84<\/td>\n<\/tr>\n
Cricket<\/td>\n82<\/td>\n<\/tr>\n
Croquet<\/td>\n17<\/td>\n<\/tr>\n
Cue Sports<\/td>\n30<\/td>\n<\/tr>\n
Cycling<\/td>\n199<\/td>\n<\/tr>\n
Darts<\/td>\n60<\/td>\n<\/tr>\n
Disabled<\/td>\n40<\/td>\n<\/tr>\n
Equestrian<\/td>\n667<\/td>\n<\/tr>\n
Events<\/td>\n86<\/td>\n<\/tr>\n
Extreme Sports<\/td>\n13<\/td>\n<\/tr>\n
Fantasy<\/td>\n49<\/td>\n<\/tr>\n
Fencing<\/td>\n99<\/td>\n<\/tr>\n
Flying Discs<\/td>\n32<\/td>\n<\/tr>\n
Football<\/td>\n466<\/td>\n<\/tr>\n
Gaelic<\/td>\n60<\/td>\n<\/tr>\n
Games<\/td>\n402<\/td>\n<\/tr>\n
Golf<\/td>\n200<\/td>\n<\/tr>\n
Greyhound Racing<\/td>\n15<\/td>\n<\/tr>\n
Gymnastics<\/td>\n99<\/td>\n<\/tr>\n
Hockey<\/td>\n147<\/td>\n<\/tr>\n
Kids and Teens<\/td>\n106<\/td>\n<\/tr>\n
Lacrosse<\/td>\n67<\/td>\n<\/tr>\n
Laser Games<\/td>\n14<\/td>\n<\/tr>\n
Martial Arts<\/td>\n302<\/td>\n<\/tr>\n
Motorsports<\/td>\n244<\/td>\n<\/tr>\n
Multi-Sports<\/td>\n38<\/td>\n<\/tr>\n
Netball<\/td>\n15<\/td>\n<\/tr>\n
Paintball<\/td>\n153<\/td>\n<\/tr>\n
Rodeo<\/td>\n32<\/td>\n<\/tr>\n
Running<\/td>\n120<\/td>\n<\/tr>\n
Skateboarding<\/td>\n57<\/td>\n<\/tr>\n
Skating<\/td>\n171<\/td>\n<\/tr>\n
Soccer<\/td>\n496<\/td>\n<\/tr>\n
Society<\/td>\n65<\/td>\n<\/tr>\n
Softball<\/td>\n72<\/td>\n<\/tr>\n
Sports A to Z<\/td>\n26<\/td>\n<\/tr>\n
Sports Information<\/td>\n112<\/td>\n<\/tr>\n
Sports Others<\/td>\n198<\/td>\n<\/tr>\n
Sports Shopping<\/td>\n398<\/td>\n<\/tr>\n
Strength Sports<\/td>\n89<\/td>\n<\/tr>\n
Table Tennis<\/td>\n9<\/td>\n<\/tr>\n
Team Handball<\/td>\n23<\/td>\n<\/tr>\n
Tennis<\/td>\n232<\/td>\n<\/tr>\n
Track and Field<\/td>\n226<\/td>\n<\/tr>\n
Volleyball<\/td>\n107<\/td>\n<\/tr>\n
Water Sports<\/td>\n259<\/td>\n<\/tr>\n
Winter Sports<\/td>\n85<\/td>\n<\/tr>\n
Wrestling<\/td>\n78<\/td>\n<\/tr>\n<\/tbody>\n