Here I am again!
Could gender also be added to the update query? I have that Shroudkeeper in PoK and also many Crescent guards in mind with that request. Also, could you add the guard races to the list? Their weapons are a key piece of data I am looking for, and in most cases the guard races differ from the base race. Lastly, could you make it so that version also gets added to the WHERE statement? So if I select version 1, it would tack on "and version = 1" to the end of the query.
The list of guard races:
44 Freeport Guards
67 Highpass Guards
71 Qeynos Guards
77 Neriak Guards
78 Erud Guards
81 Rivervale Guards
90 Halas Guards
92 Grobb Guards
93 Oggok Guards
94 Kaladim Guards
106 Felguards
112 Fayguards
139 Cabilis Guards
183 Coldain
239 Vah Shir Guards
I believe that's it!
I have to say, I just updated Crescent and it looks beautiful now! All the NPCs have their proper robes, faces, heritage, and weapons. Thank you!
I think there may be a bug with certain zoneids parsing incorrectly, but I want to gather details before officially reporting it. Once I get that, I'll PM you with a log I see the issue with.