Road from ShowEQ_log --> EQSpawns.txt (eqnpc.exe format)

[meliudaj]

Just kinda gathering a procedure/ who, what, when, where for Going from a collected ShowEQ_log to a file that is in the right format to be viewed as an EQSpawns.txt file that is to be used with the EQNPC.exe made by Drawde.

Like always I will be using Blackburrow as my example.

First off the ShowEQ data format:

:name(spawnID):Level:Xpos:Ypos:Zpos:H.m.s:Ver:Zone :eqHour.eqMinute.eqMonth.eqDay.eqYear:killedBy(spa wnID)

Eg.
z:a_scrawny_gnoll18(95):5:-156,-82,-1122:19.56.28:3:blackburrow:21.19.06.06.3172:(0)
z:a_scrawny_gnoll17(94):4:-194,-65,-1122:19.56.28:3:blackburrow:21.19.06.06.3172:(0)
z:a_gnoll19(82):5:-285,-86,-620:19.56.28:3:blackburrow:21.19.06.06.3172:(0)
z:a_giant_snake09(81):7:-316,-76,-622:19.56.28:3:blackburrow:21.19.06.06.3172:(0)
z:a_giant_snake08(80):8:-323,-221,-622:19.56.28:3:blackburrow:21.19.06.06.3172:(0)


Next is the EQSpans.txt data format. (as found in his Readme)

Name (string), Zone(string), Level, HP, Gender, Size, Texture, Race(string), Faction, Loot Table, Class (string), Merchant ID, Number of spawn locations, X, Y, Z (repeat XYZ as many times as there are locations)

Eg.
a_gnoll_commander Blackburrow 14 380 2 0 0 Gnoll 360 339 Warrior 0 2 23 -340 3 254 366 3


What I would like this thread to be even though I think this is general info to some of you. Is just the best way to get from a ShowEQ_log to the EQNPC.exe

[meliudaj]

My first question is this.

Where is all that extra info coming from?

Eg.

The Data format for the EQspawns.txt is this:
Name (string), Zone(string), Level, HP, Gender, Size, Texture, Race(string), Faction, Loot Table, Class (string), Merchant ID, Number of spawn locations, X, Y, Z

Where do I get the info for HP, Gender, Size, Texture. ect...

All those fields that are requested for the EQSpawns.txt are not info that is found, or logged by ShowEQ.

Is this info just Guestimated?

Clarification on this would be very helpful to those just starting I think.

[Lurker_005]

Yea that extra stuff is why my new zones are all skeletons. I just fill them with temp values for the time being till I go back and clean it up.

Here is part of my macro, The complete text is in the attachment posted below. This is for the text editor ultraedit www.ultraedit.com

InsertMode
InsertMode
ColumnModeOff
HexOff
Top
Find RegExp "%?:[0-9]+*^p"
Replace All ""
Find RegExp "*'s corpse*^p"
Replace All ""
Find RegExp "*unknown*^p"
Replace All ""
Find RegExp " :name(spawnID)*^p"
Replace All ""
Find RegExp "?:^([a-zA-Z#!_'`^-]+^)[0-9]++([0-9]+):^([0-9]+^):^([0-9-]+^),^([0-9-]+^),^([0-9-]+^):[0-9.]+:[0-9.]+:^([a-z]+^):[0-9.]+:[a-zA-Z_#0-9'`]++([0-9]+)"
Replace All "^1 ^6 ^2 101 2 0 1 Skeleton 1 11 Warrior 0 1 ^3 ^4 ^5"
Find RegExp "?:^([a-zA-Z#!_'`^-]+^)[0-9]++_p[et]++[0-9]++([0-9]+):^([0-9]+^):^([0-9-]+^),^([0-9-]+^),^([0-9-]+^):[0-9.]+:[0-9.]+:^([a-z]+^):[0-9.]+:[a-zA-Z_#0-9'`]++([0-9]+)"
Replace All "^1_pet ^6 ^2 101 2 0 1 Skeleton 1 11 Warrior 0 1 ^3 ^4 ^5"
Find RegExp "%#"
Replace All ""
Find RegExp "%!"
Replace All ""
Find MatchWord "rivervale"
Replace All "Rivervale"

The unknown data I replaced with temp values so the spawns work. Then I work on getting the info correct. I only posted the one zone name, but you get the idea. I also find opening it into excel to be usefull, that is how I apply the formula I use for HP values.

[meliudaj]

Question:

In the ShowEQ_log data format... what does the

"h.m.s" stand for.. and what, if any is this data good for?

[Lurker_005]

hour minute second for finding anything related to spawn time/interval.

For our use it isn't very usefull without a lot longer spawn log (2 or 3 killings of the entire zone) and a lot of data crunching to figure out all the spawn intervals. :p

[Lurker_005]

The text version of the ultraedit macro I use to convert ShowEQ spawn logs to a format ready to be used by Drawde's EQNPC