Question about collecting

provocating · #1 12-20-2010, 02:17 PM

Well I uploaded it, guess I should had put my name on the filename but I did not.

http://www.peqtgc.com/logs/file.php?...eeportwest.zip

If someone could check it to make sure I did it right. I spent about 3-4 hours in freeportwest trying to make sure I opened every vendor and combed every inch of the zone, using the automap in EQ to make sure I touched all areas. If this is a way i can contribute then this is something I can and do not mind doing.

**Derision** · #2 12-20-2010, 03:38 PM

I just sourced in that log and can verify it is a good collect. You have a few more spawns than the previous collect (I think there are some Christmas mobs up at the moment), about 50 more merchants, and several more ground spawns (possibly seasonal, maybe added since the original collect, etc.), plus loads more pathing data.

So, good job

It's really up to you if you want to spend time collecting. I'm, sure the collect will come in useful, either to PEQ when they reach that expansion in the progression, or to other server ops who want to populate those zones sooner and not wait for PEQ.

provocating · #3 12-20-2010, 05:32 PM

Quote:

Originally Posted by Derision

It's really up to you if you want to spend time collecting.

I want to do anything to be useful instead of being a leech and using the product without chipping in, so yes I am going to continue this. My only issue is my guy hit level 65 and I never leveled him further. So I will collect every zone I can collect. I am going to start with Freeport and the adjacent zones, then spider out from there.

I just really wanted to know if I did it right, the last thing I want to do is spend hours and not get a good extraction. I am saving the pcap files to my server in case we need them in the future. Doing East Freeport as we speak.

provocating · #4 12-20-2010, 06:38 PM

Oh noooes. I was about 30 minutes done from a killer feed from East Freeport, wireshark crashed.

provocating · #5 12-20-2010, 10:29 PM

Okay East Freeport done, another large one, around 10mb.

Derision you seemed to have no issues getting the SQL into your Database. How did you know exactly what rows to delete so easily ?

provocating · #6 12-20-2010, 11:01 PM

I just checked before I imported the new West Freeport in. The original West Freeport had 378 spawn points, this new one has 433 spawn points. I just zoned into West Freeport and I repopped the zone, damn I am impressed. I actually got the group of guards pathing correctly. It is worth the effort just to see them pathing like they should. Whoever wrote the extractor, give them a raise.

My database went up 10mb in size too. I will do adjacent zones tomorrow.

UPDATE

I just checked my East Freeport collect after sourcing it in. I have a bunch of Tyker Renlin's and Plnorrick Spinecracker's apawning at the docks and pathing. Not sure what happened there. Also the boats are patching into the rocks, which that could be explained by me not knowing that I was collecting information about the boats, I can sit around the water next time. Any help on this would be welcome, not sure what I did wrong. Could this be caused by me passing by the same area twice or something ? I do not know enough about what goes on in the background to make an assumption on what I did wrong on the packet collect. I definitely took my time and tried to be thorough. West Freeport looks great so far, other than there are multiple spawns of like the Holiday spawns.

**Derision** · #7 12-21-2010, 01:52 PM

According to Allakazam, Tyker Renlin spawns and then despawns after 4 minutes, so getting multiple spawns is to be expected. I imagine the other NPC must similarly respawn frequently.

The problem with collecting pathing data is that Live sends updates less frequently the further away you are from a mob, so you can get fairly good pathing for the mobs that are nearby, but not the ones further away.

Problem is, if you sit near the docks to get good pathing for the boats, then the mobs on the other side of the zone will have poor pathing. There is no easy answer to this. I would just treat the collected pathing data as a 'rough guide' to be fixed by hand later.

Regarding me getting the West Freeport data sourced in quickly, that just happens to be the zone I used to test the collector after Live patches, so I had already nuked the PEQ data for that zone and so I just needed to source in your collect without worrying about having to delete rows first, as all my data from that zone was already numbered by the collector, and so the auto-generated DELETEs at the top of the SQL deleted everything.