|
|
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/q1.jpg) |
|
![](/forums/images/Darkness/misc/q1-1.jpg) |
![](/forums/images/Darkness/misc/q4.jpg) |
|
![](/forums/images/Darkness/misc/q4-1.jpg) |
![](/forums/images/Darkness/misc/a1.jpg) |
|
![](/forums/images/Darkness/misc/a1-1.jpg) |
|
Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-09-2015, 11:58 PM
|
Dragon
|
|
Join Date: Apr 2009
Location: California
Posts: 814
|
|
Here's a little item editor
I've been digging into the item table to figure out how all the different fields are used, seeing how they might be laid out in such a way as to somehow make 283 or so columns sanely editable, to help with EOC UX. Also wanted to get an item window renderer working.
I figured as long as I was figuring out field usage and layout and stuff, I may as well make it functional to save and create items as well.
Here's what I put together over the last week. It's a little raw and the fields need to be split into more tabs so they're not so claustrophobic, but it's fully functional, and speedy (after the initial db/icon loading at startup).
It's fun to play with.
https://github.com/Shendare/EQEmuItemEditor/releases/
Screenshot:
![](https://cloud.githubusercontent.com/assets/12705257/9159183/b5a2359c-3ed8-11e5-9e19-c288c4bb5407.png)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-10-2015, 12:13 AM
|
![Akkadius's Avatar](image.php?s=eba5709d38099c3f021a21aa1caf719f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,072
|
|
Quote:
Originally Posted by Shendare
I've been digging into the item table to figure out how all the different fields are used, seeing how they might be laid out in such a way as to somehow make 283 or so columns sanely editable, to help with EOC UX. Also wanted to get an item window renderer working.
I figured as long as I was figuring out field usage and layout and stuff, I may as well make it functional to save and create items as well.
Here's what I put together over the last week. It's a little raw and the fields need to be split into more tabs so they're not so claustrophobic, but it's fully functional, and speedy (after the initial db/icon loading at startup).
It's fun to play with.
https://github.com/Shendare/EQEmuItemEditor/releases/
Screenshot:
![](https://cloud.githubusercontent.com/assets/12705257/9159183/b5a2359c-3ed8-11e5-9e19-c288c4bb5407.png)
|
Looks good!
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-10-2015, 12:19 AM
|
Dragon
|
|
Join Date: Apr 2009
Location: California
Posts: 814
|
|
Thanks! I appreciate the appreciation. ![Smile](http://www.eqemulator.net/forums/images/smilies/icon_smile.gif)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-10-2015, 12:22 AM
|
Hill Giant
|
|
Join Date: Jul 2012
Location: Oklahoma
Posts: 222
|
|
Cool. Tagging in.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-10-2015, 08:28 AM
|
![N0ctrnl's Avatar](image.php?s=eba5709d38099c3f021a21aa1caf719f&u=71931&dateline=1448399969) |
Discordant
|
|
Join Date: Jan 2007
Posts: 443
|
|
Very nice!
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-11-2015, 09:49 AM
|
Hill Giant
|
|
Join Date: Apr 2010
Posts: 169
|
|
This looks legit. Thanks, Shendare. Gonna play with this this evening when I get home from work. I don't mind making the items through SQL or the Peq editor, but I'm always on the lookout for other tools to do stuff like this.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-11-2015, 10:17 AM
|
Demi-God
|
|
Join Date: Mar 2012
Posts: 1,105
|
|
Throwback to Jamella's editor ![Smile](http://www.eqemulator.net/forums/images/smilies/icon_smile.gif)
__________________
"No, thanks, man. I don't want you fucking up my life, too."
Skype:
Comerian1
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-11-2015, 05:48 PM
|
Dragon
|
|
Join Date: Apr 2009
Location: California
Posts: 814
|
|
Had some downtime today and was able to get a bunch of glitch fixes and improvements in. Version 1.1 is up.
https://github.com/Shendare/EQEmuItemEditor/releases/
Release Notes:
Version 1.1 - 8/11/2015
- Fixed: Error setting '[NumericField]' to ".
- Fixed: "Lore Group: #1 (Oops!)" showing on new items
- Fixed: Unrecognized tab could be populated with the same bunch of controls multiple times
- Fixed: Smartened SQL encoding of various field types
- Fixed: Added jpeg and removed targa from the Icon loader to match actual .Net support
- Fixed: Vastly improved handling of app's edit-state and what item is being previewed/edited
- Fixed: Handling of broken database connection at first startup
- Fixed: Mismatched Preview of "Must Equip" and "Any Slot/Can Equip" click effect types
- Added: Implemented cloning and deleting (with confirmation) multiple items at once
- Added: Version number to window title
- Improved: Better default values for some fields when creating New item from scratch
- Improved: Unchangeable non-click spell effects on items now display as obviously unchangeable
- Improved: Cloned items will now be named with a number after to denote that it's a duplicate
- Improved: Clarified discard changes prompt for items where the ID has been changed
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-11-2015, 09:19 PM
|
Dragon
|
|
Join Date: Apr 2009
Location: California
Posts: 814
|
|
Man, it's always something. 283 fields is a lot for one table. Quick bug fix.
#Release Notes:
8/11/2015 - Version 1.1.1
* Fixed: Set maximum lengths on text fields based on the columns in the database, to prevent errors saving when text is too long. The maximum lengths are not being sent over by the database (they show -1), so I had to hard-code them.
* Fixed: Waist and Ammo armor slot checkboxes weren't displaying correctly.
* Fixed: The New item button was confusing the search list and preview window. Straightened it out.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-11-2015, 10:27 PM
|
![Akkadius's Avatar](image.php?s=eba5709d38099c3f021a21aa1caf719f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,072
|
|
All I have to say is make sure your tool doesn't break if fields aren't present or new fields are added so that it does dynamic iteration and will live beyond schemes changes and doesn't need to be updated every time something happens to a field, other than that A+
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-11-2015, 10:32 PM
|
Dragon
|
|
Join Date: Apr 2009
Location: California
Posts: 814
|
|
Yeah. It'll skip over any input fields that it can't find a column for in the table based on its name (textEditCharmFile == items.charmfile, listEditItemType == items.itemtype, etc.), and any leftover columns that it doesn't find input fields for it dumps as textboxes in the Unrecognized tab.
It also dynamically recognizes the type of each column (int, float, date, varchar) and formats inputs appropriately to avoid errors as much as possible.
Should work pretty well no matter what.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-12-2015, 12:02 AM
|
![Akkadius's Avatar](image.php?s=eba5709d38099c3f021a21aa1caf719f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,072
|
|
Quote:
Originally Posted by Shendare
Yeah. It'll skip over any input fields that it can't find a column for in the table based on its name (textEditCharmFile == items.charmfile, listEditItemType == items.itemtype, etc.), and any leftover columns that it doesn't find input fields for it dumps as textboxes in the Unrecognized tab.
It also dynamically recognizes the type of each column (int, float, date, varchar) and formats inputs appropriately to avoid errors as much as possible.
Should work pretty well no matter what.
|
A+
/10char
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-13-2015, 11:20 PM
|
Dragon
|
|
Join Date: Apr 2009
Location: California
Posts: 814
|
|
It was noted to me that it isn't 100% clear what you're supposed to do once you enter your database info and icon folder in the Options screen.
Once the options are filled out, click Search. If the database was accessed successfully, the app will show "Loading . . ." and start loading in a list of item names and spell names to aid in the item editing process, then present you with the search screen.
If the database connection was unsuccessful, you'll be sent back to the Options screen.
I will make this process clearer by adding a "Test" button on the Options screen and an error/confirmation message depending on the results of the connection attempt.
Sorry for any confusion there. The process made sense in my head, but nobody has ESP to know what I was thinking when I made it.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-14-2015, 12:23 AM
|
![N0ctrnl's Avatar](image.php?s=eba5709d38099c3f021a21aa1caf719f&u=71931&dateline=1448399969) |
Discordant
|
|
Join Date: Jan 2007
Posts: 443
|
|
Quote:
Originally Posted by Shendare
Sorry for any confusion there. The process made sense in my head, but nobody has ESP to know what I was thinking when I made it.
|
Sounds like you need a Tom Smykowski working for you!
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 11:26 AM.
|
|
![](/forums/images/Darkness/misc/s1.jpg) |
|
![](/forums/images/Darkness/misc/s1-1.jpg) |
|
|
|
![](/forums/images/Darkness/misc/z1.jpg) |
|
![](/forums/images/Darkness/misc/z1-1.jpg) |
|
![](/forums/images/Darkness/misc/side3.jpg) |