(Why the hell should you have to delete empty tags by hand? That's what god invented mysql queries for! It might be a big, ugly query that needs to run slow in the background for days, but there's no earthly reason to make humans do it instead.)
Actually, this would not be that hard to fix. Since character/relationship are already child-ed to fandoms, it should be quite possible to "canonize" all of those in one fell mysql query, and even catch most character/relationship meta-tags. Same with fandom names. The Additionals will be more complicated, but if it's done in two steps, one query to "flatten" all Additional field sub-tags into their ultimate parent; and then a second query to move/change meta indicator all Additionals over a certain threshhold number into, I don't know, Genre/Flavor field...
Which would leave us with Character, Relationship, Genre/Flavor, Additional, with the first three being selected from a canonical pool and only the last one being completely freeform (subject to the blacklist).
It could be done. This thing could be fixed, without any incredibly burdensome hand-work. There would be some mistakes, but if users are informed and know to check their work after and have a promise of this making them easier to find... it could work.
Plus putting "index" and "landing" links next to each wrangler's list of tags. Plus putting breadcrumbs at the top of every index page, showing where in the tree it is. It would not be hard! The basic structure is already there!
Oh god, I want to wring N's neck so very badly for keeping this from happening for so long.
no subject
(Why the hell should you have to delete empty tags by hand? That's what god invented mysql queries for! It might be a big, ugly query that needs to run slow in the background for days, but there's no earthly reason to make humans do it instead.)
Actually, this would not be that hard to fix. Since character/relationship are already child-ed to fandoms, it should be quite possible to "canonize" all of those in one fell mysql query, and even catch most character/relationship meta-tags. Same with fandom names. The Additionals will be more complicated, but if it's done in two steps, one query to "flatten" all Additional field sub-tags into their ultimate parent; and then a second query to move/change meta indicator all Additionals over a certain threshhold number into, I don't know, Genre/Flavor field...
Which would leave us with Character, Relationship, Genre/Flavor, Additional, with the first three being selected from a canonical pool and only the last one being completely freeform (subject to the blacklist).
It could be done. This thing could be fixed, without any incredibly burdensome hand-work. There would be some mistakes, but if users are informed and know to check their work after and have a promise of this making them easier to find... it could work.
Plus putting "index" and "landing" links next to each wrangler's list of tags. Plus putting breadcrumbs at the top of every index page, showing where in the tree it is. It would not be hard! The basic structure is already there!
Oh god, I want to wring N's neck so very badly for keeping this from happening for so long.