There is no item editor implemented yet, however I am currently working on it. I have no eta yet, but I am hoping I can get something committed shortly.

great! the ability to copy items and edit a few basic properties would rock!

keep up the great work :-)

I plan on adding support to add, copy, and edit all columns for items.

This would be really awesome. Thank you for all your hard work Cavedude!

Not sure if i ever did but i wanted to say :

THANK YOU

for this tool. Similar to Georges Tools, these help make EQEMu a success.
Looking forward to the Item Editor. :)

<3 u cd can't wait :-)

Alright, full item support has been added to the editor. I am not 100% happy with the layout, and a couple of other small things, plus the code is a mess I know but it's good enough for now. I won't nitpick as I need to get back to LDoN full time.

I think it's pretty self explanatory, and I tried to dig up as much data for drop downs as possible. In some cases I went item by item on 13th floor to figure out what the values mean (or probably mean.)

Great!! Thanks again Cavedude!

Good job again - just tried this out. Copy and paste of an existing item takes now roughly 0.1 sec compared to minutes using George tool remote- saying that's a huge improvement is a total understatement ;)

Couple of questions or suggestions.

When you copy and paste an item (or generally) - could the Item ID be displayed beside being in the URL? Copy and pasting this is doable but a hassle.

Restrictions - A button for all races and all classes would be nice

Stats - I'd like to see classic stats (Str/Sta/Agi etc), Resists, PoTime Mods etc seperated for ease of use. Currently its one big cluster for all stats.

Spells Area - Focus/Worn/Proc type - does it make sense to use drop down lists here? Afaik using anything else than type 6 for a Focus effect or type 2 for a worn effect might even crash the client. Also, Scroll Type is always 7 or am i mistaken?

Again, take this as suggestion and feedback, not as complained! I know you said this is a basic draft and needs some work still.All is working very stable, never crashed one btw.

The item ID is displayed at the top of the window, right above the item name. You'll see Edit Item <id>

I was planning on adding a ALL and NONE button later on for all bitwise fields.

The stats is the part of the layout I am unhappy with the most. I'll probably use fields to break them up.

Yes, I can create separate dropdowns for worn, focus, and scroll. They would be 0 or the proper value.

I'm glad you like it! I am planning a LDoN release a week from today, at which point I'll revisit items and get all these changes plus others I have in mind in!

Perhaps I have some unique requirements here, but anyone have this working on a remote db through WAMP? I'm getting errors when I go to add tasks for the dropdown menus.

Apache error logs:
(repeats a few hundred times)

The errors I get from php in the dropdown menu say "Notice: Undefined variable:" startzone, repeatable, and rewardmethod.

I'm running the mysql connection through a tunnel set up by PuTTy. It can access the DB no problem, since it authenticates properly. I looked through the code there and can't see why it would say it's undefined unless it's not being loaded properly earlier in the code.

Greats new CD!

One more suggestion - would it be possible to add a mechanism to change the
statistcs of all mobs at once in a given zone?

Let's say, i want to change faction across the board, want to make all mobs stun immune, remove the ability to flee etc. Currently i have to click each and every mob which is rather exhausting.

Thanks!

Manual SQL would be more efficient than writing custom code to do what you are asking...

No doubt,

but lots more foolproof would be the solution via the PEQFrontend. Beside not everyone is an SQL Wiz ;)

Don't need to be a wiz.. post what you want to do and you will get SQL.

Change the faction from an entire zone to a specific one

Make all mobs (not) immune to stun

These 2 would be huge.

This is an example. Let's say I want to change all the NPC factions in Butcherblock Mountains to be on Clan Runnyeye:

Don't forget that will get things like the boat or hidden spawns...

Again, an example. To remove UNSTUNABLE from all NPCs:

Remember, this will also catch the pets. If you want pets to stay unstunable, you would add "WHERE id >= 1000"

The item editor looks great, thanks for all your hard work.

Are there any plans to make a more complete spell editor?
I've done, and am still doing, quite a bit of research on spell values and enumerations. I have some framework for my own web-based spell editor / spells_us.txt exporter and will be doing some testing within the next few days.
After looking around at the PEQ Editor source I think it would be easy, and just make more sense, to apply my work there. I'd be happy to send you a patch when I'm done if you're interested.

Spell Editor
 

The spell editor at least has basic functionality, search, edit, and copy spells. You can also export a current spells_us.txt file and download it through the browser.

The interface could probably use a bit better organization, but it gets the job done. For my copy I moved Spells to Spell Sets and made the Spells tab reference the editor and lookup.

http://midian.homelinux.net/peqphpeditor.tar.gz

I was working off of svn from the 26th of May.

Anyway, I'm really grateful for the work you all put into these tools and I hope this is helpful. If anyone has any more information to plug into spellenums.php I would love to get all of that in one place. The wiki is sort of dated on the topic and I'd eventually like to reference that file to update it.

The beginning of that system has been put into place with AC. More stats are coming as we come up with formulas. You can now also update faction and loot in a zone by name or race. I'll probably do spells next, by name or class.

Thanks to Tabasco a full spell editor is now also in the editor, with the ability to generate and dump spells_us.txt.

These changes are all on SVN, and will be in the download package the next time it's updated. I want to get some more things in first.

wooooo!

awesome, will check it out later today! again i can't express my gratitude really. Without PEQ Editor and George Tools, EQEmu would be far from where it is today.

Thanks again!

CD, thanks for this awesome tool. I have a problem that I hope is an easy fix. After installing the newest version of the editor, i noticed a zone I am trying to populate was not in the list of zones in PEQ editor. I then was able to add the zone into the editor by editing the zones.php file.

The problem I am running into is when I create anything for that zone, it does not work properly. For example I tried creating an NPC, but it did not auto-populate the NPCID. I created my own NPCID but after I was done creating the NPC, it disapeared from the editor like the NPC doesn't exist.

Any ideas on how I can add a zone to the PEQ editor and have it work properly? For reference, I was trying to add the original tutorial zone.

Thanks in advance!

zones.php isn't used anymore, zones are queried from the database directly now. There is no longer a need to change that silly file when zones are added or changed. I let that system slip by far too long!

You can download the newest version from SVN (using a SVN client) that has this functionality, which was part of an overhaul to get the editor to support instances. Or, I was planning on posting the newest version for direct download tomorrow after I get a couple more small things in. The new version will be at least revision 172.

As for your other problem... Grab the newest version first and try to add a new NPC to your zone and see what happens. The original NPC you created may not show up if the NPCID you chose is out of the zone's range (One day I'll add the ability to toggle how the editor places NPCs into zones.) If a new NPC still does not get added, reply with the id, zoneidnumber, and version of the new zone you created.

Thanks for the prompt reply cavedude. I will give this a shot and let everyone know.

I posted the newest revision, 173 up for download.

The new version works great cavedude, i changed the zone I was working with from expansion 99 to 1 and it shows up in the editor now. Great job.

Ok so I got PEQ Editor to connect to my database however when I go to the editor page, it does not show the login/password box. Just the PEQ Editor logo at the top and the blue background. Any idea why? I have sourced the sql file and I am trying to access it locally. I have installed xAMP and I am running mysql 5.0.

It appears the Item Editor Portion of the PEQ Editor runs into an issue as it starts out with Item IDs around 119k. Anything beyond 120k will not be loaded from the EQEmu Server.

Can we tune in Items.php

to take the next FREE Item ID, like Georges? Alternatively, is there a reason the Server won't load Item IDs > 120k?

The installation guide really needs to be updated.

It isn't the editor at fault, the EQEmu code has a current limit of 120000, to prevent items from using too much shared memory. If you are able to compile the EQEmu code yourself, you'll need to change #define MMF_EQMAX_ITEMS 120000 in EMuShareMem/Items.h and recompile.

I finally got it to work using latest xampp.

Unfortunately it then just displays the logo. Nothing else.

I'm stuck at this point now.

Thanks for the answer CD and i agree of course. Would it still be possible that the next Item ID algorithm would behave similar to George? There are so many holes in Item IDs list that using that free space would offer enough without going over the 120k limit and without having to recompile it.

Am i being blind again or is the Item Editor Missing the possibility to assign
a proc rate modifier to weapon procs?

nm - found the reason for the error.

Seems with rev193 and later (just tried 195) i can no longer save edited Items. Neither by clicking submit at the bottom nor hitting Enter in a field which i just edited.

Maybe started even earlier, but that's the first rev i noticed this.

Been that way since r167. Fixed in r196.

Thank you joligario. Item editing/saving works with latest rev now, however we found a similar issue with zone data editing. Saving changes (let's say safe X: value) wont be saved upon clicking Submit Changes.

r203 seems to have issues with the queries used to copy items in the item editor. Lots of referenced columns that don't exist (the unknownXXX and UNKXXX ones).

Sorry about that, fixed in 204.