IMO, you can do one of 3 ways (all non-code related, just DB related):
- Leave it in (grandfathered in if you will)
- Put together a list of everyone who has the duplicates, and deal with them on a case-by-case basis
- Remove the augments completely from the item if they are Lore duplicates (maybe put it on the cursor when they log back in)
1 is easy enough, because you don't have to do anything.
2 is a little more difficult, but not impossible. It would basically involve joining a few tables to see if the itemid in the augment fields are lore items. I was running over a few queries, and wasn't able to easily find what I was looking for, but it's not impossible.
3 is just taking 2 a step further, and actually making the changes. It would mainly involve changing the SELECT query to an UPDATE query, possibly even using a subquery.
Threaded Mode
