PEQ web-based database editor

[sotonin]

http://www.peqserver.com/view_files.php?filter=looted

FYI, the first thing you have to do is source the included .sql file into your eqemu server's database. Before any other steps.

This is a ongoing project i've been working on to make database work easier. We use this ourselves to work on the PEQ database. I feel that it's complete enough to release an intitial version. This version includes the following.

Loot-editor:
-- Create or search through existing loottables
-- Create or search through existing lootdrop tables
-- Add / Delete / Modify existing lootdrop item entries
-- Auto-balance percentages of items in a lootdrop table
-- Lucy click throughs for quick item stats

Npc-Editor:
-- Modify all npc_types fields
-- Modify npc's Primary Faction
-- Add / Delete / Modify existing faction hits

Spawn-Editor:
-- Display all spawn points in current zone for a selected npc
-- Add / Delete / Modify npcs within a spawngroup
-- Modify respawn time
-- Auto-balance npcs within a spawngroup
-- **More spawn2 editing in the future

Merchant-Editor:
-- View the merchants and their stocks
-- Editing will come in the future

Faction-Editor:
-- Display faction information for all factions
-- Modify all modifiers of a faction

*** Coming in the future. ***
-Tradeskill Editor
-Search by item merchant listing + editing capabilities

Suggestions welcome, always looking to make it more useful.

[Xothin]

Pardon my stupidity, but I can't seem to get it to work properly.

A) peq_backend.php never shows.
B) you have encryption on the password field
C) A lot of the info inside of the peq_editor.php file points to file:///my%20documents/web/peqserver.com

I have a php running smooth as silk and serving a totally different PHP application, so I know that my extensions are set correctly.

I can get the peq_backend.php to show, but it will never allow me to log into it.

[sotonin]

your php may not be setup correctly in php.ini is my only guess. works silky smooth for me and a couple other ppl ive given it too

and yes. encryption is intended. if you read the readme you'd know the password.

[sotonin]

Sorry about the path's fuckup. stupid program added that without my consent after i saved a copy of it. it's fixed and uploaded again.

[Scorpx725]

Nice job with this.

[Xothin]

Very nice job with it, just wish I could get the admin side of it.

Using PHP 4.0.5, am able to log into another web app that doesn't use MD5 password authentication.

Is there something that I should check via my MySQL, or in my php.ini file? I went through the entire thing, and it all looked kosher.

EDIT:

Got everything working as soon as I disabled MD5 on the login page.. not sure what I don't have set up correctly, but MD5 seems to fail every time with me.

[sotonin]

the default password for the backend is "backend" "password"

the default admin account is "admin" "admin" if you don't feel like adding new admin accounts via the backend

[Xothin]

I read the readme. ^.^ It's always one of the first things I do.

My problem is with MD5.

The other app I use also doesn't authenticate when MD5 is used.

Not sure what I've not got set up correctly, but everything works now that I have disabled MD5 in the PHP script.

[sdabbs65]

Fatal error: main(): Failed opening required 'file://peq/database.php' (include_path='.;C:\php-4.3.4-Win32\pear') in C:\Apache2\htdocs\peq\peq_editor.php on line 4



no clue all my functions work...hmmmm

[sotonin]

redownload it. i fixed the paths =)

**hmm ur's seems to be different that the wrong path that was set on it. Seems like it may be a config issue on your side somewhere.


btw, md5 is simply a method to encrypt a string. all php has this AFAIK, if you want to remove it feel free... it's not hard to edit that much of the few lines that deal with it and clear out the admin entry in the db. If md5 gives you issue i recommend getting a real version of php, yours is gimped. lol

[Xothin]

More than likely so. ^.^

Thanks Sotonin, once I disabled MD5, was able to log in fine. Looks wonderful and is very easy to maneuver around in.

Did you happen to get to take a look at my issue with adding quest packs to tradeskills? They seem... well urm.. broken. I can do a quest combine with a normal kit(ie Deluxe Sewing kit) but cannot make the combine with a quest kit(ie Leafrunners Assembly Kit). Not sure if this is a database issue(not knowing the proper codes for quest kit combines(ie 61 is tailoring, yadda yadda) or if maybe its something that SOE gimped and hasn't been fixed in code.

[sotonin]

tradeskills are fathernitwit and Lethalencounters area, sorry :cry:

[fathernitwit]

Originally Posted by Xothin

Did you happen to get to take a look at my issue with adding quest packs to tradeskills? They seem... well urm.. broken. I can do a quest combine with a normal kit(ie Deluxe Sewing kit) but cannot make the combine with a quest kit(ie Leafrunners Assembly Kit). Not sure if this is a database issue(not knowing the proper codes for quest kit combines(ie 61 is tailoring, yadda yadda) or if maybe its something that SOE gimped and hasn't been fixed in code.

this is primarily a database issue... it is possible that the containers are also not setup in emu, but id bet the DB is the bigger issue. This is the kind of thing which will need to be added by hand.

[Xothin]

I added the entry manually to the DB

When trying to combine, I get "You cannot combine these items in this container type" when using a quest container.

When switching out the quest container ID in the DB for a normal sewing kit, (deluxe sewing kit for instance) click combine, presto, my item combines.

Try it out for yourself. ^.^

[sdabbs65]

Originally Posted by sotonin

your php may not be setup correctly in php.ini is my only guess. works silky smooth for me and a couple other ppl ive given it too

and yes. encryption is intended. if you read the readme you'd know the password.

I dont think theres anything secret in it I could be wrong tho
can you post your php.ini I seem to be overlooking something..
I spent 4 hours last night looking thu it and found nothing wrong.
everything else I have works fine...shrug.