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.