DarkstarProject/darkstar — pull request #134 by starlightknight (2014-04-12 16:14:27+00:00)
Title: April Update: Attempt to Batch Update Shifted NPC Ids

I'm hoping this is pretty accurate an covered most zones that haven't been done yet

I used a scripted approach for this to cross-compare with POLUtils dump. The

1) Started with a known identified NPC in each zone that is named the same i

2) Calculates a trusted suggested offset by comparing this NPC in the SQL to

3) Rewinds and begins to evaluate every NPC for the zone.

4) Checks if it can match the NPC from our SQL to the new POLUtils dump if t

5) If found, the NPC is shifted. If not found, as long as no other NPC that

6) If anything disproves the suggested offset, NPC's that can't be directly

NOTE: I didn't run into this this time.

I did test this against some of the zones that are previously been done already and the before/after seemed the same, so hopefully this is good.

If anyone is interested in the script I can clean it up and check it in somewhere once we are sure it is working well.