PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[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.

[cavedude]

Another bump to report that I just added grid support to the SVN.

[Asram]

The install instructions don't seem to jibe with the files in the SVN. The install instructions ask you to source allspells.sql. This file doesn't appear to be included with revision 21.

Not one to be discouraged. I picked up a copy from Angelox's pack, and the SQL code refers to a spells table that isn't created with a new REV384 distribution.

So where's the code currently to create a spells table in peq if you don't have one? This used to work back in 2007 when I last installed the editor, but much has changed since then.

All of my sources were downloaded last week and should be 3/15 or newer. I'm running PEQ atm.

[Asram]

Never mind. I found the memo that said that the new versions of the editor no longer need a spells table. Might want to update the readme in the current distro.

Thanks anyway.

Asram Baksh

[drakelord]

Hmm. Not sure if I'm doing something wrong here, but when I go to look at say, NPCs in a certain zone, rather than the ones that are currently entered in the database, it shows the defaults. I even dropped all of the npcs out of my database just to test, and it still showed defaults (probably from PEQ).

Is there a way to get it to show the actual NPCs in a zone when you select a zone and other such things from the dropdown menu?