PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[mixxit]

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?

[cavedude]

Originally Posted by mixxit

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?

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.

[mixxit]

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

keep up the great work

[cavedude]

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

[Lillu]

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

[Nagus69]

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.

[mixxit]

<3 u cd can't wait

[cavedude]

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

[mixxit]

Great!! Thanks again Cavedude!

[Nagus69]

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.

[cavedude]

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!

[pfyon]

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:

[Fri May 07 14:21:21 2010] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: startzone in C:\\wamp\\www\\eqemueditor\\templates\\tasks\\tasks.add.tmpl.php on line 27, referer: http://localhost/eqemueditor/index.php?editor=tasks

(repeats a few hundred times)

[Fri May 07 14:21:21 2010] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: repeatable in C:\\wamp\\www\\eqemueditor\\templates\\tasks\\tasks.add.tmpl.php on line 35, referer: http://localhost/eqemueditor/index.php?editor=tasks
[Fri May 07 14:21:21 2010] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: repeatable in C:\\wamp\\www\\eqemueditor\\templates\\tasks\\tasks.add.tmpl.php on line 36, referer: http://localhost/eqemueditor/index.php?editor=tasks
[Fri May 07 14:21:21 2010] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: rewardmethod in C:\\wamp\\www\\eqemueditor\\templates\\tasks\\tasks.add.tmpl.php on line 53, referer: http://localhost/eqemueditor/index.php?editor=tasks
[Fri May 07 14:21:21 2010] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: rewardmethod in C:\\wamp\\www\\eqemueditor\\templates\\tasks\\tasks.add.tmpl.php on line 53, referer: http://localhost/eqemueditor/index.php?editor=tasks
[Fri May 07 14:21:21 2010] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: rewardmethod in C:\\wamp\\www\\eqemueditor\\templates\\tasks\\tasks.add.tmpl.php on line 53, referer: http://localhost/eqemueditor/index.php?editor=tasks

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.

[Nagus69]

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!

[cavedude]

Originally Posted by Nagus69

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!

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.

[Nagus69]

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!