EQExtractor2

**cavedude** · #1 06-03-2010, 04:25 PM

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.

**Derision** · #2 06-03-2010, 04:59 PM

Quote:

Originally Posted by cavedude

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.

I noticed the zoneids with the dranikhollowsc and ikkinz zones on the PEQ logs repo seems totally out of whack. I really need to see the .pcaps or logs produced by the 'Dump Packets' button to figure out what the issue is.

robinreg · #3 06-03-2010, 05:32 PM

I sent the pcaps to CD. you can get it from him for debugging purpose. the ikky zones are basically the same zone but they are different instances with different npcs for progression.

**Akkadius** · #4 06-03-2010, 06:26 PM

I posted the rest that I have for the most part, I halted doing any captures to get quite a few things done on my server. I will do more capturing when it's appropriate.

**cavedude** · #5 06-03-2010, 07:16 PM

Quote:

Originally Posted by Derision

I noticed the zoneids with the dranikhollowsc and ikkinz zones on the PEQ logs repo seems totally out of whack. I really need to see the .pcaps or logs produced by the 'Dump Packets' button to figure out what the issue is.

Was just sending you a link in fact, and also it appears 1.6 broke merchant dumps. I'm including a crescent log that dumps merchants for 1.5 and below, but not 1.6. It'll be in your PMs

**Derision** · #6 06-04-2010, 01:07 PM

1.7 up

Code:

Fixed bug introduced in v1.6 that broke merchant SQL generation.
Gender is now updated for existing npc_types.
Guard races are now included when updating existing npc_types.
Obtained the ZoneID number from the Player Profile instead of the NewZone_Struct.

**Derision** · #7 06-04-2010, 04:05 PM

Quote:

Originally Posted by cavedude

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.

Oops, I forgot this request. I'll put this in tomorrow.