Just an idea.

Add a column to lsql_Categories called Directory_Depth. This column would measure how deep the category is. For example Travel and Tourism/Lodging/Bed and Breakfasts would have a DD of 3. Tools/Hammers wouuld have a DD of 2. Top Level Categories - 1. Then have all the DD fields updated with each change, just like Number_of_links does.

Why have this?

Many reasons:

• Calculating cost of advertising in particular category... deeper mean less. Allows automated calcualtion as DD could be part of your formula.
• Calaculating editor responsibility.. summing up all the DD's and applying this figure to other factors such as number of links and number of categories under an editor's belt.
• Stats. Listing all categories which have a DD greater than 10 for example. See how deep your directory is getting.
• Maintenance - Removing categories which are getting too deep.

And so on.

Comments? (Except for: I wish this sooke guy would can it!)


http://www.iuni.com/...tware/web/index.html
Links Plugins