Anyone doing TBS?

I did the first couple of zones, but have since started working on other zones to get some zone_points and npc appearances working.

I have been doing TBS, but most of the zones are instanced, I have most of the statics though.

I've got almost PoR (is done I think), TBS and DoN statics completely done. I don't post them all until they are done otherwise if I upload them gradually I have no idea where I am with the way you have to upload to CD's repo.

1.5 is up with these changes:
I implemented the update for npc_types, but I have disabled it for now in the UI as I found some issues with it ...

First I was updating the size, then I found multiple NPCs with the same name but different sizes, so I took the size out of the update. Then I found multiple NPCs with the same name,
but some were wielding weapons and some not, e.g.
(this is with current live data, not existing PEQ tables).

Now my guess is there are multiple mobs with the same name but different facial features, but I didn't check that, so I'm really not sure what to do and await Cavedude's words
of wisdom on the matter :)

The melee textures, could that possibly be an item the NPC has on their loottable? If so, I don't think it would be a big deal to 0 out those columns after they have been sourced into the db. I'm mainly looking for textures on guards and player races as everything else is usually handled by loot. It's no big deal if I have to go back and manually fiddle with the melee columns.

About the size and face data... That's tricky. How about a way to check which columns you want to dump in the UPDATE? Maybe have the default the "safe" options, but also have choices for things like level or size which may not be as safe. Not sure how much work that would be, but I think that would make everybody happy.

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.

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:

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.

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.

Everything actually seems to work pretty smoothly after the recent large updates BTW.

1.6 is up with a couple of bug fixes
And I enabled the feature to update existing NPCs in the database, which doesn't generate new npc_types or spawn table entries, but updates existing npc_types as follows:

In other news :)

The zombie_catapults I mentioned in a previous post that were showing as humans are actually 'Destructable objects' that I think were introduced in Serpent's spine.

I can get the catapults to display properly if I hard code the same data as is in a live spawn packet (three strings and 53 bytes of as yet unidentified data).

I plan to look at the destructable objects some more at the weekend to see if I can figure out what those 53 bytes control so we can make some meaningful fields for them in
the npc_types table.

If anyone has any info on destructable objects, particuarly do some behave differently than others, do their graphics change as they get to various %s of hit points, are some immune
to melee, or spells, or certain types of spells, etc, that might possibly help identify what some of the data associated with them controls.

Here is a bit from Eqplayers :

Source: http://eqplayers.station.sony.com/ga...date=2/21/2006

I do remember breaking up catapults and watching them look more damaged, it was pretty cool :)

Unfortunately, I don't recall any specifics like what % the graphics changed, etc.

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.

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.

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.

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.

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 :)

1.7 up

If it helps any, I think a_training_dummy in the crescent log I sent is in the same boat. On live it appears as a training dummy and seems to be a chest object, but in the collect its race and bodytype is 0.

Thank you for getting those changes in. I can't think of a thing wrong now!

Yes they are, thanks! I wish I'd known that earlier, it would have saved me the trouble of sneaking my way across Blightfire Moors and Goru'kar Mesa to find an object to test with :)

I keep getting an error on some zones when using the extractor to read the pcap files. City of Dranik and The Void are the only zones I have seen this error occur on. I have tried extractor versions 1.4, 1.5 & 1.7 and all encounter the same problem.

What version of The Void did you use it in? It worked fine for me in Void A, B, & G.

If you are willing to email me one of the .pcap files that is causing the crash (DerisionEQ at gmail.com) I'll see what's causing the crash and fix it.

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

It is the one when you zone in from PoTime...no idea which version it is.

I just sent the file.

If you do a /who on yourself, it will say in the zonename. Depending on how far along you are with SoD progression determines what version of the zone you get sent to. Void A is the default version with no progression completed.

Are you guys camping out to character select after getting to each zone? Just wanted to make sure I wasn't doing something unneeded. And will multiboxing confuse the capture?

I just go to the zone that I want to do capture with. try to find a good spot preferebly in the center of the zone. then camp out to character select screen, start your sharkwire, then log on. Just sit around for 30 to 45 mins. then stop your sharkwire save your pcap. then generate the sql with the extractor. The program filters out all players characters, mercs, and pets. Just need to make sure there are no mob aggroing from anyone or you during the data collects. I did most SoF today and most zones were empty so I had the zone to myself. works out perfectly. The only 2 zone I had trouble with is Dragonscale and Loping Plains as there were other players killing mobs and such. So I just left that until I find a time that I have the whole zone to myself. Crystallos I need to get keyed for it. I just need a couple of items from Zeka and MMM then I can do the combine and I'll be able to access that zone.

I can get them all too when I get done with a few campaign things on my server.

I'm just nervous about how long I should stay in a zone to be sure I get all of the pathing. Are you staying 20 minutes in each zone?

I usually stay sometime between 30 to 45 mins to make sure I get all the pathing. move around a bit if it's big zone like commonlands.

5-10 minutes is fine really, to get the gist of pathing. Otherwise there's a new grid system function that KLS made that is phenomenal.

ah I was just following the suggested time that was posted on log repository. Or was for the old collecting?

Ideally, collects should have no one else in the zone if possible. Otherwise, pathing is going to be messed up by people pulling and killing spawns (one of the Relic collects shows this right when you zone in due to a player obviously training the zone in). Another thing I have noticed is that mounts show up pathing all over if people are in the zone and using them. That is easy enough to correct, though.

For doors, any door that is set to opentype 157 needs to be changed to 105 and have invertstate set to 1 for them to work correctly (steamfontmts and dragonscale for example).

As for collecting good pathing grids, it is a really good idea to use a rogue for collecting if possible. Many zones are accessible via a level 51 rogue on the Mayong Server. The reason it is good to use a rogue, is because you can move around most zones fairly freely as long as you consider anything you get near to make sure it can't see you. If you want good pathing, you will need to wander through the zone one section at a time so you get good pathing collects. The further away you are from an NPC, the less updates you get and the more choppy your pathing will be for them. But, if you move from spot to spot in a zone, you can get some pretty nice pathing collects. It does take a while to do that properly.

I am sure pathing will need to be cleaned up no matter what, but with a really good collect, that cleanup could be minimal. The collects we have so far are really great either way. If someone was planning to do some major work on a zone to make it fully playable, I would highly suggest making sure you have as good a collect as possible though.

Multiboxing can confuse the extractor and appears to be the cause of blackdragonsdg's crash.

What happens is the extractor reads each packet in the .pcap file looking for an SOE 'Session Request' packet (that the client send to the server).
When it sees a session request, it 'tentatively locks on' to that session and waits until it sees a particular packet (which was OP_NewZone and is
the packet in which the server sends various details about the zone) before deciding this is a valid EQ connection and permanently locking onto
this stream and ignoring all others.

What can happen, is if you zone in a second character before the server has sent the OP_NewZone to the first one, the extractor get's confused
by the crossed streams (oblig. Ghostbusters reference).

I've altered the extractor locally to 'permalock' to a stream when it sees an OP_ZoneEntry packet from the client to the server. This is the second
packet sent and so it is much less likely that multi-boxing will cause an issue, although of course, only the packets to/from the first client to
zone-in will be processed, but that shouldn't be an issue.

I'll push this version out later today when I've looked at another issue.

EDIT: Oh, and you don't need to camp out when you have finished. Just stop the capture and save it.

Derision: There's something very important I forgot to tell you.
Blackdragonsdg: What?
Derision: Don't cross the streams.
Blackdragonsdg: Why?
Derision: It would be bad.
Blackdragonsdg: I'm fuzzy on the whole good/bad thing. What do you mean, "bad"?
Derision: Try to imagine all life as you know it stopping instantaneously and every molecule in your body exploding at the speed of light.
Trevius: Total protonic reversal.
Blackdragonsdg: Right. That's bad. Okay. All right. Important safety tip. Thanks, Derision.

yeah I figured that it would not be a good idea to box on the same computer that is doing the collecting or running the wireshark. I have my 2nd account on my laptop while I go run my wireshark on my computer. Only reason I have 2nd account is to be able to do instances as you need 3 to get a group mission or expedition and the mercenary would count toward it. However, the mercenary would not be counted toward a raid expedition unfortunately.