EQExtractor2

[Akkadius]

Originally Posted by Derision

The only spawns that should not be included are players, pets and mercenaries. I'd be interested in looking at the .pcap or the hex dump produced by
the 'Dump Packets' button for the Void zone to figure out why Zebuxorok isn't being included, if you or Steve could email it to me at DerisionEQ at gmail.com

Done, let me know what you think.

[Derision]

Originally Posted by Akkadius

Done, let me know what you think.

There is nothing unusual about his spawn packet, and if I run that .pcap through an older, command-line version of the extractor, it generates SQL for Zebuxoruk just fine.

I'm at work right now and don't have the current source code with me, but it must be a simple bug that I will fix tonight. I'm thinking that maybe the extractor is always missing
the first NPC in the zone, and since Zeb is the only NPC in the Void, then it is noticeable.

[Derision]

Originally Posted by Akkadius

Done, let me know what you think.

Thanks for the .pcap. The problem with Zeb not appearing is fixed in v1.5. Could I possibly trouble you for a .pcap for Ocean Green Hills ? There are 'Zombie Catapults' in there
that are showing as humans with outstretched arms, so there must be something else in the spawn structure that we are not currently handling.

(Example of the human zombie catapult is at -631, 4868, 9).

[Akkadius]

Originally Posted by Derision

Thanks for the .pcap. The problem with Zeb not appearing is fixed in v1.5. Could I possibly trouble you for a .pcap for Ocean Green Hills ? There are 'Zombie Catapults' in there
that are showing as humans with outstretched arms, so there must be something else in the spawn structure that we are not currently handling.

(Example of the human zombie catapult is at -631, 4868, 9).

Derision I sent you my entire collection, the same link I sent to Cavedude. At your Gmail account.

[Derision]

Originally Posted by Akkadius

Derision I sent you my entire collection, the same link I sent to Cavedude. At your Gmail account.

Thanks. Much appreciated

[Akkadius]

Originally Posted by Derision

Thanks. Much appreciated

No sir, thank you, this is amazing, and I can do so so much with this, even though my server content is usually from scratch. And this greatly helps the entire community in any of their efforts.

EDIT: BTW your new compile is erroring out MYSQL syntax:

This is one of two that I have encountered, the same error as followed:

UPDATE zone set fog_density = 0.33 WHERE zoneidnumber = 342;
[Err] 1054 - Unknown column 'fog_density' in 'field list'

[Derision]

Originally Posted by Akkadius

EDIT: BTW your new compile is erroring out MYSQL syntax:

This is one of two that I have encountered, the same error as followed:

UPDATE zone set fog_density = 0.33 WHERE zoneidnumber = 342;
[Err] 1054 - Unknown column 'fog_density' in 'field list'

Yeah, that is a new column that KLS added to the zone table very recently (Rev1513), and the reason I put it in a separate update statement, so the first,
main, zone table row update will go through if you don't have that column, and the separate update for fog_density will error if you don't have it, but can be
safely ignored.

I meant to put a comment preceding the fog_density update to that effect, but forgot.

[Akkadius]

Originally Posted by Derision

Yeah, that is a new column that KLS added to the zone table very recently, and the reason I put it in a separate update statement, so the first, main, zone table row update will go through
if you don't have that column, and the separate update for fog_density will error if you don't have it, but can be safely ignored.

I meant to put a comment preceding the fog_density update to that effect, but forgot.

Yeah I haven't updated binaries in a few weeks only because I was scared of some of the repercussions some of the changes might have had.