phpld Category Dumps

Some phpld directory category dumps.

US States
US States – 50 States, default parent is ‘Top’ – for phpld v3.4
US States – 50 States, default parent is ‘Top’ – for phpld v3.3

US States – 50 States, default parent is ‘Top’ – for phpld v2.86 (free)

Remember – if you bulk import categories in phpld using phpmyadmin you will need to update the category count. You do this by running this sql query after you have imported them to your database backend:

update PLD_CATEGORY_SEQ
set id = (SELECT id
FROM PLD_CATEGORY
ORDER BY ID DESC
LIMIT 1)

700 Categories
Huge list of categories for kick-starting your directory.
700 Categories – phpld v3.4
700 Categories – phpld v3.3

700 Categories – phpld v2.86 (free)

NOTE – I’ve updated the sql so that the category sequence should be automatically updated when you import the 700 category sql file – but do check!

239 Country Categories
239 Countries of the world (iso list based) – for phpld v3.4
239 Countries of the world (iso list based) – for phpld v3.3

239 Countries of the world (iso list based) – for phpld v2.86 (free)

US States and Cities
Updated from v3.3 located here
US States and Cities – phpld v3.4

* US States and Cities – phpld v2.86 (free)

Canada
Upgraded from the phpld v3.3 version found here
Provinces and Cities Database Dump – phpld v3.4

* Provinces and Cities Database Dump – phpld v2.86

UK Regions
(Each country is parent category to the corresponding regions)
England, Scotland, Wales and Ireland – phpld v3.4
England, Scotland, Wales and Ireland – phpld v3.3

England, Scotland, Wales and Ireland – phpld v2.86
Note – I think I have them all but please let me know if I’ve missed any out.

* PHPLD FREE USERS – Warning! phpld 2.x free software does not have the caching facilities of the paid version (v3.x) and so using large category dumps may result in your directory overusing server resources and possible account suspension / termination by your host. You have been warned!

IMPORTANT – Use the files at your own risk! No warranty is implied and no support is offered.
These files are designed for use on a new installation.
Using them in a database that has link or category data in it already will probably break your directory!

The only data affected by these files is the categories – everything else is left ‘as is’

Make backups before you do ANYTHING!

THESE FILES ARE NOT FOR RESALE!

TIP – If you don’t already have it, download and install Notepad++. It can handle any type of programming file… including .php and .sql.

Other phpld topics you might be interested in:
phpld categories disappear