I've made significant changes to my Lists table, so if you want me to upload a more current version of my db, just let me know.MoDementia wrote:The fact that I was using one of your databases to test the script makes me think that the ---more--- is not required.
I noticed that but I thought I must have been doing something wrong again. But this is not a major problem for me because I use Bex's Remove Unused Genre/Classifications script as a part of my weekly db cleanup. However, it is a pain in the arse to go through alot of trouble to remove these from the Lists table to find they are still showing up in the Lists of the dropdown boxes. I have noticed that most, if not all, of the values are showing up both before and after the --More--, so I really would like it if they were only showing up once. Especially in the Moods Classification, the list is already long enough without adding more to it.MoDementia wrote:I did a couple of additions and they were added to the lists table, but deletions are not removed from it
Personally, I only want the active classifications to show and I would prefer whatever method would ensure the alpha sorting is permanent regardless of what I do to the db. I assume it is not possible to make this a user-definable option?MoDementia wrote:So I need some feedback from users on what to include.
Just active values or include previously used (and MM defaults) which is sort of what it does now.
Obvously the SortOrder can be corrupted? so that is no longer in alpha order so the change listed above may need to be permanent.
PS This applies to all classification fields just depends how you have been using them as to whether the script works with them or not
Nyn