PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[teraphina]

noticed something, in the npc edit there isnt a field to edit the npcs mana pool can you guys add that?

[cavedude]

There is no mana stat. Mana is derived from a NPC's level, class, WIS/INT, etc exactly like players.

[teraphina]

ok i see now thanks

[Angelox]

I tried to sort out the stickys here - basically i wanted to keep up top what's being supported, since the tools quickly get out dated and troublesome once the support quits.
This tool here is probably one of the best "starter" editors , and always usable throughout your "EqEmu Career" - I've always used it from day one to now.
It's not supported by the author anymore, and I know many of you have updated it for your personal use.
It would be great to see any thing anyone has for this editor posted for the rest.
PEQ is the official database, so it needs to stay compatible with PEQ database.
maybe some of you can help keep it up to date

[Angelox]

Here's my revised and working editions of the PEQ Editor;
And my AX_CLASSIC Version.
They are mostly the same (have to be if you work with the latest source), I just changed the 'look' so I won't get confused , since sometimes work with both at the same time.

here's some things i can remeber I fixed/added;
tracking
seehide
seeIH
ATK
Accuracy:
'add a spawngroup' was completely broken, fixed and added
dist
delay
max_x
min_x
max_y
min_y
'add a spawngroup' now suggests a unique name, related to the zone (for mass querys and moves)
'Suggested ID' Now suggests the right spawngroup id number
runspeed suggests 1.25
respawn suggests 400


It's the most I ever did in PHP (learned a lot about PHP), looks to be working fine. This is my first database editor since day one with EqEmu, and I still use it all the time.

Since I finally decided to fix and update it, I thought I'd share it with you all, hope you enjoy it as a much as I do.

If you have any problems, find bugs or need direction, post here.

[Angelox]

For those of you asking about the missing zones in the ax_classic drop down menu, in 'lib/' , look for the zones*.php - what I did was crop out the zones I was not working with, so I could find them easier. zones.php is the active one, just rename one of the full ones to 'zones.php'. I think 'zonesFULL.php' has the most.

Remeber, your 'logs/sql_log.sql' needs full permissions if you are getting errors (pending on what permissions the assigned user has). If you notice, I have all my logs re-named and saved. These logs can be very useful, as they create usable MySql inserts of what ever work you have done.
So once you get this editor running, you can help us out by posting or sending in your log inserts. This is very simple, all you need to know is how to 'cut and paste' to the forums .

YOUR HELP IS IMPORTANT! There really is NOT a lot of people helping out, and most of what we have goes 'custom' and rouge, keeps all they do to themselves.
A group of us never keep ANYTHING we do to ourselves, and that's why you are able to play EqEmu at home, on a public server, etc.

If you have knowledge as an Everquest Live player, on these zones we are working on - if even there is just one NPC you know doesn't drop the right item, spawn properly, or whatever, we want to know about it; this Editors log will be the simplest way to port it over to us.

[cavedude]

Just a bump, I merged the work Angelox sent me with what I had running on PEQ and put up a SVN so multiple people can contribute. The link is in the first post.