The PEQ Editor has been updated and completely recoded from the ground up! (again -cavedude)

It supports the latest database updates.

It features a number of bug fixes, improved sql logging, and enhancements to the user interface to make things more friendly and intuitive.

It allows you to edit:
NPCs
Loot tables
Spawns
Merchants
NPC Spellsets
Factions
Tradeskill recipes
Zone data
Misc entries like doors, objects, groundspawns, traps, forage, fishing
Adventures
Tasks
Server data (rules, running zones, petitions, bugs, hackers, reported players)
Spells
Items
Read only access to players, accounts, and guilds

This list will change frequently, and may not be up to date!


Find out more: http://www.peqtgc.com/phpBB2/viewforum.php?f=29

Official SVN (Currently maintained):
https://github.com/ProjectEQ/peqphpeditor

Nice good work mystic414, i download it quickly :) :) :)

Edit1:
A little bug, if you install peq_editor for the first time, remove the first line "DROP TABLE peq_admin;" on schema.sql (error 1050 at line 1 : Unknow table 'peq_admin').

mystic414,

Love the editor.. keep up the good work.

I found an error in the allspells.sql file and posted on the support forum for your tool on the projecteq. Basically not all the `s were replaced with \'s in the file so when you import it, alot of the spells are missing from the spells table.

I had these posts split into a new thread, since the old one was getting bloated.

I responded to the sql error in PEQ's forum too, but thought I'd mention here that I'm not having the problem sourcing that file. If anyone else is, please let me know, so that I know it's not just an isolated problem, and I'll look into it more.

I fixed a number of relatively minor bugs in the editor in the past few days, so you all might want to re-download it. The easiest way to upgrade is to make a backup of your config.php file, delete EVERYTHING in the editor's folder, and unzip the download into it. Then just copy your config.php file back in, and you should be fine.

If you don't want to have to re-download everything every time I make a bug fix, you might want to look into getting the editor via CVS.

Can't get past login
 

Anyone here have any idea why I would get the "Invalid username or password" error , with the default admin/password log in?

Thanks

I'll answer this one to myself again :)
What happened was, I forgot to type in the "USE peq" , before I sourced them - maybe add that to the schema.sql, for dummies like me.

Great editor BTW, but you probably already know that.

Just a footnote for anyone who is working the EQ database;
This editor also works almost perfectly with Cavedudes EQ database - only problems I have seen so far is, some of the higher zones don't appear in the drop-down menu, so you can't work on them (example: Harbingers Spire). Also I noticed spawns will not stick to the coordinates I make for them, but I can still make the NPC, then go in game and add them from the database.

Not sure if anyone has posted this yet or not , I can't find it using the search function. I added in the functionality to edit Omens of War zones , and also added in the new bodytypes for that expansion. Hope someone finds it usefull.

PEQ DB Editor v. 1.1

Angelox EDIT;
Revised Editors , Nov 2008
PEQ
AX_CLASSIC

Very nice Elite, I'm sure this will be appriciated by many :) I actually use this to make loot tables and factions sometimes, because I haven't found a quicker way :)

Have you updated it from CVS? if not I have one updated already and everything works, but if you added more stuff , maybe we can combine. heres mine;
Revised Edition Nov 2008

Also there might be a few bodytypes I found that you didn't - if you see anything to merge in to something better, please post.
Thanks :)

I like yours better Angelox. =P Thanks Mate. I'm in my first month of starting to figure out the techinical end of things , it's going well , but I have alot to learn.

How do you source the files into the database?

Easiest way, put them into your mysql/bin folder. Log into your mysql database from a command prompt and type source filename.sql;

editor trouble
 

I have to first set the path in cmd to get this to work correctly
mysql -u root mysql -p

when prompted for the password to get to the mysql prompt the password was denied, I did check winmysqladmin to see what the password was I did enter it in correctly
even tried changing it, I'm stuck on this part of it.

any ideas?

Curious, what license is the editor released under?

I mean if someone makes changes to it and wants to share them, is that allowed?

I change it all the time, but I do not share. That's the kinda guy I am. :p

I see no license info, but the ProjectEQ site will likely have more info. I believe it's their editor.

My copy is also heavily (and I mean heavily) modified.

I cannot help but think that it would benefit everyone if we actually had a place to share all of our "changes". From what i could gather from posting on their forums, PEQ seems only to be interested in making it compatible with their database. They don't seem to be all that concerned about what happens once you download their db and add content of your own to it. New spawns, for example, break it and won't show up without doing a mod to the editor (due to the fact that new spawns don't get assigned an NPCID that fits into their "range of zonenumber+0..999" focus). In other words, they key on NPCID (which is silly) rather than zone the mob is spawned in (which makes sense). There's a thread about it I started. Cavedude told me no, won't fix it in the default distrib, the editor is working as intended.

I guess I'm just not getting it.

I meant zonenumber+000..999 sorry... by the time I noticed that typo, my 5 minutes of editing my post grace expired.

I replied to your post, but basically after some testing your way does cause noticeable slow downs on machines with heavy load. When dealing with PHP you want things as fast as possible and an extra query will not do that.

I understand the issue concerning the IDs, and I'd assume other people would have the same issue. For that, feel free to distribute your change. That's the beauty of open source, if you need the program to do something other than what the author had intended, you can.

People who create mobs out of game using the editor or queries would benefit from the stock way. It creates a more tidy db and as I said the editor performs better under heavy loads. Those who rather build in-game would most certainly benefit from your change, which for many people is a lot more user friendly.

This link is dead, and I had lost his update when my server died some time ago - I restored from back up, but he had a lot more good data on his fixes.
does anyone have this and can post a link for me?
Thanks

Indeed, if I can finx that copy I am happy to combine with my fixes and I will even host it. I have bandwidth to burn.

Cavedude, thank you. I wasn't going to distribute any fixes or changes because I wasn't sure if it actually WAS open source.

Since you have now declared that it is, problem is solved. Everybody wins (as is always the case with open source). Thank you.

And yes, Angelox, let me know if you find that code. I'll combine it with my fixes (including many header updates, etc.) and put it up for everyone, on my dime.

I have a version that I did too that has everything all the way through Titanium (all expansions). All zones, all races, etc.

I'll prepare that for release now that I know that I can.

I'll also host any mods or changes that anyone else makes to it that will improve it, and of course will keep Cavedude in the loop.

My version will have the "edit the mob based on spawn location, not it's NPCID range" change made to it. For more info on that, see the PEQeditor forums on the PEQ site.

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

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

ok i see now thanks

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

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.

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.

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.

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

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.

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

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?

Make sure you have the editor connecting to the right database. It builds that query populating the drop-down list dynamically, so either refresh your browser cache or check the config.php.

I can't seem to create any spawns for mmca

Can someone try?

Ok, I am having allot of problems with this. Its proably because I don't understand the directions. It tells me to download all this stuff, and doesn't even tell me what machine to download it onto (Running the server on linux, and do all the admin work from a windows machine) Needless to say, I have downloaded both of the extras, on both machines (would like to know if they are needed on my windows machine) and sourced the file into the database, and I still get this in firefox:

set('javascript', $javascript); $tmpl->set('headbar', $headbar); $tmpl->set('searchbar', $searchbar); $tmpl->set('breadcrumbs', $breadcrumbs); $tmpl->set('body', $body); echo $tmpl->fetch('templates/index.tmpl.php'); ?>

There must be something I am missing. Some help please.

I thought I would also add that for kicks, I tried it on the linux machine. It simply wants to save the file (index.php)

I have the exact same error. anyone have any tips or updated step by step instructions?

ok im getting an error that says

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Web\classes\mysql.php on line 6
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

it was working before then i accidently changed the eq user password to something else, but changed it back to eq, and now its refusing to work. any ideas?

To all those who have troubles logging, follow this procedure. It will give admin access to anyone who enters the PEQ Admin(no matter the username and password).

a) Look for a folder named "classes"(inside your PEQ-Admin folder).
b) Make a backup of the file session.php
c) Open file session.php with your favorite text editor(not WordPad).
d) Locate these 3 functions: logged_in(), check_authorization() and is_admin().
e) Replace whatever those functions have with:
return true; (yes, the semi-colon too)

Here's an example of how should they look...
function logged_in(){
return true;
}


f) save the file

I see there's an items editor section but when I click on an item after doing a search nothing comes up. Does anyone else have this and is there any way of getting it going? If not, does anyone know of an version 8 item editor?