Is there an easy way to do this? Perhaps with a SQL statement?
Sean
Sean
Sep 9, 2002, 8:13 AM
Veteran / Moderator (2577 posts)
Sep 9, 2002, 8:13 AM
Post #2 of 6
Views: 1717
I have done this, and no, it is not simple. The reason is, you have to check to see if the category has any subcategories before removing it.
In case you are wondering:
Create a new column called hasChildren. Write a script which sets hasChildren to YES or NO.
print "Total Categories: $total_categories<br>"; my $sth = $cat->select;
while (my $category = $sth->fetchrow_hashref) {
my $hc = ($cat->count( { FatherID => $category->{ID} } )) ? 'Yes' : 'No';
$cat->update( { haschildren => $hc }, { ID => $category->{ID} } );
}
In case you are wondering:
Create a new column called hasChildren. Write a script which sets hasChildren to YES or NO.
Code:
my $total_categories = $cat->count; print "Total Categories: $total_categories<br>"; my $sth = $cat->select;
while (my $category = $sth->fetchrow_hashref) {
my $hc = ($cat->count( { FatherID => $category->{ID} } )) ? 'Yes' : 'No';
$cat->update( { haschildren => $hc }, { ID => $category->{ID} } );
}
Sep 9, 2002, 8:17 AM
Veteran / Moderator (2199 posts)
Sep 9, 2002, 8:17 AM
Post #3 of 6
Views: 1699
The Number_of_Links column should give you the total of all links within that category (including subcategories). So if it's zero, you can savely delete (well, safely, try it on a testing installation first....)
Ivan
-----
Iyengar Yoga Resources / GT Plugins
Ivan
-----
Iyengar Yoga Resources / GT Plugins
Sep 9, 2002, 7:56 PM
Veteran (1187 posts)
Sep 9, 2002, 7:56 PM
Post #6 of 6
Views: 1694
Hi
I do this on regular basis to avoid Empty categories by editors:
Do:
1- Do Repair tables.
2- Make sure to validate any pending links
3- Go to Database> categories:Delete> Then endter Number of Links = 0
Max hits 100, Check match any,
Regards
KaTaBd
Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
I do this on regular basis to avoid Empty categories by editors:
Do:
1- Do Repair tables.
2- Make sure to validate any pending links
3- Go to Database> categories:Delete> Then endter Number of Links = 0
Max hits 100, Check match any,
Regards
KaTaBd
Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory