Release : EQBuilder v1.3

[sandy]

Hello another tool for worldbuilders it's EQBuilder ! =) it works with hackerquest's eqcollector

Here are the files :
eqbuilder-1.3.zip
eqbuilder-1.3-source.zip

What's eqbuilder ?

It's simple, eqcollector collect eqlives datas and dump it into txt logs, eqbuilder create doors, teleports, npc_types, spawns and grids sql files from these logs for eqemu, in the next release it will be able to update directly the eqemu database
But in the difference with other parsers, it tries to build the most accurate database possible, there's some modifiers and filters that the user can tweak in this purpose
It creates directly a moving database =)

Installation :

Part 1 - Eqbuilder

1) just extract the files in the directory of your choice
2) source the 3 sql files into your server database :
- races.sql ( it's the races of everquest npcs )
- logs.sql ( it's a table to store eqcollector logs configurations )
- classes.sql ( it's an eqemu classes table )
if you don't source these files, eqbuilder won't start and will send a windows crash error

Part 2 - Connection to the database

1) just launch EQBuilder
2) go in database/connect
3) enter you database parameters
4) and connect =)
( you see you are connected when zones appear in the zone combo box )

Part 3 - Eqcollector
you can download it from hackerquest forum at this url :
http://hackersquest.org/boards/viewforum.php?f=14

for installation, it's explained in a txt file
and how to use it, here's a nice tutorial :
http://www.projecteq.com/badk0re/collect-tut.zip

How to use eqbuilder ?

A tutorial is given in the zip file that explains how to use EqBuilder, it explains the 2 methods to build a db, the quick method and the advanced method =) It explains also the different type of logs you can collect with EQCollector .

Logs distribution

if you want to distribute a log, you should give infos about its type and its content for example like this :
"potactics-raid-all boss up !.txt"
where :
potactics is the zone short name
raid is the type of the log ( pathing, npctypes, or raid )
all boss up is infos of the content

read the tutorial given with eqbuilder for more infos

Feedback

To contact me, come on #npcmovdb channel on mirc at french hours, or use the forum to PM me =)

Thx to projecteq, eqbuilder and looteditor are hosted by projecteq
And thx to zordon who created eqcollector =)

[Monrezz]

Your link is broken, use:

http://www.projecteq.com/sandy/eqbui...uilder-1.0.zip


Great work Sandy that is *very* useful

[samandhi]

Wow that sounds like an AWESOME proggy.. Unfortunately I dont have a live account to use it...:(

Great job!

[RexChaos]

Can someone give me a Live account PLZ PLZ PLZ! Can I be a GM in this program too?!?!?! How can you kill teh sleeper????


Okay I'm done being an ass. This program does sound sweet, but like samandhi, I have no live account any more. I hope that it does help people out with gathering data though. It sounds liek it has a lot of potential!

On a side note...I'm chomping at the bit waiting for a stable 5.5 release. Please hurry! I'm beginning to get so bored I randomly search teh databases for equipment I had seen in the game at some point in time to be sure it's there. Hehe...

[badk0re]

Very very nice Sandy, works like a charm, spittin sql files all over the place now, all u gotta do now is make a program that oragnizes my desktop and d: drive.... ohh the mess....

[sandy]

hey if you downloaded already the files before this message =) redownload plz because there was a major bug ! =)
and ...
you don't need an eqlive account, you need logs and I hope people will distribute these logs =)

[Turath]

sweet program, this and your loot editor are great programs, but found 1 problem in this, if anyone else isn't having this problem please let me know, but so far the other zones I've done worked fine just plane of tranquility keeps making the program crash with a windows crash error, have tried it 3 times, have 2 of my logs still, if you need them to look at or anything just lemme know a place to send them

oh and was wondering, how come the delete button stays greyed out and I can't mark moving mobs?

thanks for these 2 great programs, good luck on any other work you plan to do

[Turath]

hmm, dunno what's going on here

I been hanging out in PoJ today while people been doing trials

I have 2 PoJ files, I've tried doing this with both selected and just the one, but neither time will it add the mob

I read through the log file and he is in there, the boss for the exe trials

Received:
Zone. Add Mob.
Mob: 0562 (1) #Prime_Executioner_Vathoch00 L: 65, G: 2, HP: 100%, Owned: 0000, Size: (10.00, 0.67-1.25)
Race: Guard of Justice, Type: 1, Class: Warrior, Deity: NONE, Position: 100
Movement: Pos: (-1157.00 195.00 82.00). Anim: 0.00, Dir: 0.00, Rot: 0.00, Speed: (0.00 0.00 0.00)
Invis: 0, Sneak: 0, PVP: 0, Light: 0, Anon: 0, AFK: 0, LD: 1, GM: 0, Breath: 3, Armor: 0, Helm: -1, Guild: -1(0)
Equipment: 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0)
(color) hair: -1, beard: -1, leye: -1, reye: -1. (style) hear: -1, beard: -1
U_P01: 00, U_P02: 00, U_P03: 00, U_P04: 00, U_P05: 00, U_P06: FF, U_P07: 00000000

but it's not showing him in the list of mobs in the middle area and it's not dumping him out to the npc sql file, so is this program only putting in the sql what is loaded in when you first enter the zone?

but it can't be that I guess, just checked and it does put this mob to the sql that spawns after I been in the zone

Received:
Zone. Add Mob.
Mob: 0508 (67) A_violet_rose00 L: 50, G: 2, HP: 100%, Owned: 0000, Size: (6.00, 0.00-0.00)
Race: Human, Type: 1, Class: Warrior, Deity: NONE, Position: 100
Movement: Pos: (-286.13 133.88 -1.25). Anim: 0.00, Dir: 0.75, Rot: 0.00, Speed: (0.00 0.00 0.00)
Invis: 0, Sneak: 0, PVP: 0, Light: 0, Anon: 0, AFK: 0, LD: 1, GM: 0, Breath: 3, Armor: 0, Helm: -1, Guild: -1(0)
Equipment: 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0)
(color) hair: -1, beard: -1, leye: -1, reye: -1. (style) hear: -1, beard: -1
U_P01: 00, U_P02: 00, U_P03: 00, U_P04: 00, U_P05: 00, U_P06: FF, U_P07: 00000000

but it won't do that other guy, so I dunno

here's another one that I found didn't add into the npc sql file

Received:
Zone. Add Mob.
Mob: 0563 (3) wraith_of_retribution01 L: 49, G: 2, HP: 100%, Owned: 0000, Size: (6.00, 0.67-1.25)
Race: Spectral Banshee, Type: 1, Class: Warrior, Deity: NONE, Position: 100
Movement: Pos: (-494.00 223.00 -25.50). Anim: 0.00, Dir: 22.00, Rot: 0.00, Speed: (0.00 0.00 0.00)
Invis: 0, Sneak: 0, PVP: 0, Light: 0, Anon: 0, AFK: 0, LD: 1, GM: 0, Breath: 3, Armor: 0, Helm: -1, Guild: -1(0)
Equipment: 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0)
(color) hair: -1, beard: -1, leye: -1, reye: -1. (style) hear: -1, beard: -1
U_P01: 00, U_P02: 00, U_P03: 00, U_P04: 00, U_P05: 00, U_P06: FF, U_P07: 00000000


conclusion

well, after a bit more playing around I found that it's not reading any logs past the first one in the list even if I uncheck the other logs and only the last one it still only reads in the first one.

what I did was I dumped the logs table and remade it, then I moved out my other 2 PoJ logs from the folder I keep them all in and I used one of the bigger logs, was 12 meg log this time it loaded in 227 mobs instead of just 196 when I had them all selected since it was really only reading the first one, even when the others were unchecked it was still reading only that first one it also loaded in more spawns this time too

well hope that helps you to fix this problem

another odd problem I found

I closed and restarted the program, I dumped and resourced the logs table too, even after doing that when I took my old number 1 log file and renamed it 3 (remember now the number 1 file had 196 npc's and the number 3 had 227 npc's) I went and started the program, I selected plane of justice from the menu I clicked on add and I selected log number 3, which was actually log number 1 renamed to 3 and I clicked compile and it still would show 227 npc's and even after clicking the output to npc types button it would show the npc's from the old file, so it's like it's storing the stuff in memory and not removing it even when the program is closed or actually reading a log over again even after hitting compile again.

do you think this could be the problem causing the problem with it not reading more than one file?

well hope all this info helps

[sandy]

lol ok thx
in fact in the log window where the logs are displayed
the check boxes before the log names are not supported yet and do nothing =)
sorry for that

you can't select several logs and compile them at the same time right now
you have to select a log => compile => select another log => compile
yes it adds datas in memory

I'll add checkbox options for multiple compilation in the future when bugs will be removed and grids implemented

[Turath]

ah ok, they don't work yet that'd make sense why it wasn't working hehe


what about the thing though where even after closing the program and deleting/moving the old log file and using another with the same name and then restarting the program it still shows the npc/spawn info from the old log file, that a bug or something I'm missing?

sorry about all my long posts, but as you can see I don't post very often anyway lol

but don't want you to forget I do love this program and very much appriciate your work you've done on it

[Turath]

me again, lol

well was wondering, is does your your program look to the races table to identify a race name in the log to a race number?

if so might wanna update it with

Mouths of Insanity =281

if I find more I'll post them here incase you didn't get to find out what they are yet and need the names/number

jeez shouldn't post when tired since I don't check enough

you do have mouths of insanity in the races.sql and it's in my database as it should be, but when I dumped npc's out to a sql and sourced it in the race for anything in torment using that race was set to 0

lol edit edit edit, is all I do

noticed something else, their bodytype is blank

the number in the ( )

like
Mob: 002F (3) a_tormented_soul00 L: 47, G: 2, HP: 75%, Owned: 0000, Size: (6.00, 0.80-1.50)
Race: Skeleton New, Type: 1, Class: Warrior, Deity: NONE, Position: 100
Movement: Pos: (-576.25 -37.63 -45.25). Anim: 0.00, Dir: 374.00, Rot: 0.00, Speed: (0.00 0.00 0.00)
Invis: 0, Sneak: 0, PVP: 0, Light: 0, Anon: 0, AFK: 0, LD: 1, GM: 0, Breath: 3, Armor: 0, Helm: -1, Guild: -1(0)
Equipment: 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0)
(color) hair: -1, beard: -1, leye: -1, reye: -1. (style) hear: -1, beard: -1
U_P01: 00, U_P02: 00, U_P03: 00, U_P04: 00, U_P05: 00, U_P06: FF, U_P07: 00000000

see the Mob: 002F (3) part that 3 there is the bodytype, don't know if you noticed that or forgot to add it in or something isn't working right but just thought I'd point it out, currently all bodytypes are blank when I sourced in the sql

[sandy]

are you sure it's the bodytype ? i've never seen (0) but a lot of monsters are using bodytype 0

[Turath]

yeah it's bodytype

eh lets see if I can remember them all

3 is undead

1 is used for like players and npc types usually

21 is animal

5 is used for boats

66 is used for like invis npc's that shout things

67 is for things you walk near then they say something

like this one

Mob: 0A2D (67) A_warm00 L: 60, G: 0, HP: 100%, Owned: 0000, Size: (6.00, 0.00-0.00)
Race: Invisible Man, Type: 1, Class: Warrior, Deity: NONE, Position: 100
Movement: Pos: (1643.00 -532.00 -344.13). Anim: 0.00, Dir: 218.00, Rot: 0.00, Speed: (0.00 0.00 0.00)
Invis: 0, Sneak: 0, PVP: 0, Light: 0, Anon: 0, AFK: 0, LD: 1, GM: 0, Breath: 3, Armor: -1, Helm: -1, Guild: -1(0)
Equipment: 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0)
(color) hair: -1, beard: -1, leye: -1, reye: -1. (style) hear: -1, beard: -1
U_P01: 00, U_P02: 00, U_P03: 00, U_P04: 00, U_P05: 00, U_P06: FF, U_P07: 00000000

this guy is right at top of ramp from zone in of potorment

when you walk next to it then it says
A warm red mist falls from above. The slick substance has no time to settle before it is hungily absorbed by every surface.

and the freeport harbormaster he is an invis thing and he shouts over the zone about the boat pulling in and all that, you don't have to be near him to trigger what he says

Mob: 0004 (66) Freeport_Harbormaster00 L: 99, G: 0, HP: 100%, Owned: 0000, Size: (6.00, 0.67-1.25)
Race: Invisible Man, Type: 1, Class: Warrior, Deity: NONE, Position: 100
Movement: Pos: (126.00 -996.00 -24.13). Anim: 0.00, Dir: 239.00, Rot: 0.00, Speed: (0.00 0.00 0.00)
Invis: 0, Sneak: 0, PVP: 0, Light: 0, Anon: 0, AFK: 0, LD: 1, GM: 0, Breath: 3, Armor: -1, Helm: -1, Guild: -1(0)
Equipment: 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0), 0(0)
(color) hair: -1, beard: -1, leye: -1, reye: -1. (style) hear: -1, beard: -1
U_P01: 00, U_P02: 00, U_P03: 00, U_P04: 00, U_P05: 00, U_P06: FF, U_P07: 00000000

can see where he's a 66

and if you look at my other post you can see that skeleton guy has a number of 3 which is undead

and can see like all the zombies and skeleton and ghouls have a number of 3, they all undead

and if you look here at the bone handle scimitar
http://www.eqemulator.net/item.php?i...MuNTk3MjY5Mzc=

you'll see it has banedamagebody of 3, which is bane to undead

if you need more proof I'll look for more stuff I can show, but hope this helps

[sandy]

ok i'll change that then )

[Turath]

I got a question this time, figure you might know since you been looking at these log files for a while

do you know what the breath is for? I see alot of npc's set to 0 and some are 3, was wondering what the client uses that for?