PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[mystic414]

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

[Belfedia]

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').

[typhoon]

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.

[mystic414]

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.

[Angelox]

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

Thanks

[Angelox]

Originally Posted by Angelox

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.

[Angelox]

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.

[EliteSting]

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

[paaco]

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

[Angelox]

Originally Posted by EliteSting

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

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

[EliteSting]

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.

[Fighter05]

How do you source the files into the database?

[Angelox]

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

Originally Posted by EliteSting

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

[gernblan]

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.

[gernblan]

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.