View Single Post
  #4  
Old 03-04-2008, 08:55 PM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

IMO, you can do one of 3 ways (all non-code related, just DB related):
  1. Leave it in (grandfathered in if you will)
  2. Put together a list of everyone who has the duplicates, and deal with them on a case-by-case basis
  3. 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.
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote