#1 (permalink)  
Old 09-07-2008, 01:11 PM
Registered User
 
Join Date: Sep 2008
Posts: 3
sportsfindit is on a distinguished road
Default Possible Mod?

Is there are mod to delete a category and all subcategories and links under the categorey with a single click?

I have extracted DMOZ and have a LOT of links I want to remove. For example:

FOOTBALL > RUGBY UNION.

I want to delete "Rugby Union", but there are at least 17 categories and 1,739 links I want to delete.

Any ideas?
Reply With Quote
  #2 (permalink)  
Old 09-07-2008, 01:26 PM
esm's Avatar
esm esm is offline
Active Member
 
Join Date: Apr 2003
Location: Atlanta GA
Posts: 3,411
esm is on a distinguished road
Default

nope. but I guess you could use SQL to delete the cats, subcats, links.

NOT TESTED. DO A BACKUP.

delete from idx_link where category=x
delete from idx_category parent_id where category=x
delete from idx_category category_id where category=x

and x has to be the same for all three.

"should" work.

rerun the cat path and # of links
__________________
esm
"The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."

.
Reply With Quote
  #3 (permalink)  
Old 09-07-2008, 01:30 PM
Registered User
 
Join Date: Sep 2008
Posts: 3
sportsfindit is on a distinguished road
Default

Solid idea. I'll back up and test it.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

HACKER SAFE certified sites prevent over 99.9% of hacker crime.

All times are GMT -5. The time now is 07:19 PM.


Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO
SSL Certificate