Import categories to phplinkdirectory v 3.05 or 3.06

This article was written on 2006-08-04.

Yes, I bought the phplinkdirectory,
v 3.06. That was the easy part, creating all of those categories
is not. It's extremelly time consuming. I modified an earlier
SQL-query that creates / imports 456 categories so that it also fits v 3.06.
This directory
is an example (might have changed a bit since I wrote this).

Some remarks / warnings / disclaimer:

This category structure is based on a free SQL dump from a real
directory.

This SQL is for an installed but entirelly EMPTY phplinkdirectory
v 3.05 or 3.06. Never use it on a populated directory. If you
do, then say goodnight. ;)

The procedures takes about 1 minute if you know your way around
in phpMyAdmin.

Use the SQL on your own risk. It works fine for me but I'm not
giving you any garantues.

Please remember that use these categories only as a starting
point. Always modify the categories to fit your demands or niche,
it's for the good of your directory. If you don't then your directory
will not stand out from the crowd.

Do not ask me for any free help. I'm sorry, but I really don't
have the time.

If you are willing to pay then I'll do it for $100. Hey, I live
in Sweden. =)

Importing the categories

The following instructions are for MySQL-database. (If
you use another database then you probably know how to use the following instruction
anyway.)

Log on to your database. The server address and login are the
same that you stated when you installed phplinkdirectory.

Click on "PLD_CATEGORY" in the left menu. The structure
of "PLD_CATEGORY" will be presented.

If "Browse" can't be clicked on proceed to step 4.

Click "Browse" if you havn't already done this.
(This step has to be done if your PLP_CATEGORY is not empty.)

If there is one single row that is empty (no TITLE) then
delete it (click the delete button that is on the same row
as the entry). WARNING: If there is anything
else than one row then your directory might not be empty,
you should not proceed unless you know exactly what you are
doing.

Click "Browse" if you havn't already done this.
(This step has to be done if your "PLD_CATEGORY_SEQ"
is not empty.)

If there is one single row then delete it (click the delete
button that is on the same row as the entry). WARNING:
If there is anything else than one row then your directory
might not be empty, you should not proceed unless you know
exactly what you are doing.

Now the table "PLD_CATEGORY_SEQ" is empty.

Click "PLD_CATEGORY_SEQ".

Click "Insert". Replace "0" with "456". Click "Go".

Log out from phpMyAdmin.

If you liked this then please set up a link to www.marcinnowak.se
... but this is optional =)

Congratulation! You now have 456 categories
in your phplinkdirectory. But remember, modify and personilize!