Here's a little item editor

[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

[Akkadius]

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!

[Shendare]

Thanks! I appreciate the appreciation. :)

[rhyotte]

Cool. Tagging in.

[N0ctrnl]

Very nice!

[Shendare]

There was a glitch with creating new items and with changing an item's id.

Release 1.0.1 has the fix.

https://github.com/Shendare/EQEmuItemEditor/releases/

[Leetsauce]

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.

[Maze_EQ]

Throwback to Jamella's editor :)

[Shendare]

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

[Shendare]

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.

[Akkadius]

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+

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

[Akkadius]

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

[Shendare]

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.

[N0ctrnl]

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!

[Maze_EQ]

He'd probably hire Michael Bolton and accidently replace a decimal point.

Always mundane details.

[Shendare]

https://github.com/Shendare/EQEmuItemEditor/releases/

Release Notes:

8/14/2015 - Version 1.1.2

* Fixed: The Slots checklist logic has been completely redone. It should no longer be flakey.

* Improved: Clarified the database connection process, which was somewhat obtuse before. There is now a Test Connection button below the database setting fields, and clicking it will result in a confirmation or error message, depending on the results of the connection test. You must test a new or modified connection before performing a search.

* Improved: After performing a search, the Search button will disable itself until you make a change to the search terms or database connection. This will prevent accidental multi-clicks and will let you know if a search was successfully performed and there were simply no matches.

[Shendare]

BTW, the one prerequisite for this app is the MySQL ODBC 5.3 Driver:

https://dev.mysql.com/downloads/connector/odbc/

I installed it so long ago that I forgot it doesn't get installed by default along with MySQL. You'll get a "Data source not found and no default driver specified" error if you don't have the DB driver installed.

[Shendare]

Ack! Didn't realize I never uploaded the fix for post-SoF icons not loading and displaying.

https://github.com/Shendare/EQEmuItemEditor/releases/

#Release Notes:

8/19/2015 - Version 1.1.3

* Fixed: Post-SoF item icons in the icon folder will now load and display properly.

[Shendare]

https://github.com/Shendare/EQEmuItemEditor/releases/

Release Notes:

9/12/2015 - Version 1.2

* Added: Option to auto-set item Class restrictions when you choose an ItemType. Default is ON.

Note: Some items are exceptions to the standard class restrictions (e.g., Druids and scimitars). You'll need to add any non-standard classes to the restriction list after they're auto-set from itemtype.

* Added: Option to auto-set item 3D model when you choose an Item Icon. Default is ON.

Note: A good number of icons were made with a specific item model in mind. Those have been chosen where possible. Plenty weren't, though, and those I've tried to find the most appropriate model to represent. With some there simply isn't anything, though, so they get the default bag (IT63). I also was working with only SoF icons and models. It looks like options really opened up for non-weapon, non-armor icons and models with SoD or Underfoot.

* Improved: Search panel will no longer lose track of which item you're editing after an item is Saved.

* Improved: A successful Database test in Options will now automatically switch you to the Search screen.

* Changed: Now that there are more than just Database options, changed "Test Database" button to "Apply Settings".

[Xaeyr]

Hi all. I just downloaded this and it seems to be working great, but I can't seem to get the icons to load. I thought I had it pointed to the correct icons folder, but I guess not. What folder should it be pointed to?

Thanks!

[Shendare]

You should be able to point the icon folder to any location that has item icons in it, provided they're compatible graphics files (.png, .gif. .bmp). It won't work with the straight .tga or .dds dragitemxx files from your EQ game folder.

If you have your icons separated out into subfolders of the icons folder (blunt, slash, shields, etc.), the icon picker will sort them into categories in a drop-down for you.

If you need separate .png icons, one of the earlier releases included the item icons up through Secrets of Faydwer, separated into categories.

[Xaeyr]

Ah ok. Thank you. Loving this program!! :)

[Shendare]

Glad you're finding it useful!

I hope to eventually have a model picker similar to the icon picker, where you can choose, say, a two-hand-slash-sword icon and pick from pictures of all of the two-hand-slash models available in the game.

[fault]

Just wanted to say, Downloaded, works great. Pretty self explainatory, even someone without scripting knowledge would be able to use it

[Fridgecritter]

I would like to request a feature on this. I would like to be able to export an item to an sql file and insert the items later.

[mmohon]

I think Im missing something. I edit items, but nothing actually shows up in the game edited. Like I dont see new stats or anything. I'm very new so I might be missing a step.

[Splose]

I think Im missing something. I edit items, but nothing actually shows up in the game edited. Like I dont see new stats or anything. I'm very new so I might be missing a step.

Have you restarted your server or reloaded shared memory via #hotfix?

A bit late on this but this tool is pretty legit.. thanks a lot!

[mmohon]

Restarting server did it. Doh, feel like I shoulda known that.

[phentop]

I was getting a lot of errors trying to load the required MySQL-connector-odbc that the link takes you to. After trial and error - if you select an older version of the x64 version of the connector (ie.5.3.2) it will load and bypass all the errors. Love this editor. It saves a ton of time.

[Tegila]

got your editor to work after a lot of battling to get 5.3 installed, but i'm wondering if you have a way to change the same value on multiple items at one? I've been trying ot change the vendor prices on the entire lineup of defiant gear, and i'd really rather not have to do it in code. I havent found any editor including georges merchant tool, that actually lets you edit the prices of the items ON the merchants. Is there a secret way to use yours en masse? if price was on first tab it wouldnt be so bad, but click item then click tab then click price then paste then repeat, its a lot for as many as i need to change. i wouldnt be tryign ot change them all just some, if the prices werent so all over the place lol (some elegant stuff is cheaper than some crude etc)

[GRUMPY]

I use this editor myself, I like it a lot.
In the items table there is two columns to control the pricing of any items on merchants.
One is price and the other is sellrate. The sellrate value can, (and does) increase the base price you set
on an item. If the sellrate is set to 1, then it won't mod the base price. If you want a query to practice
with, it would be like this:


UPDATE items SET price = 100000 WHERE name LIKE '%crude defiant';
UPDATE items SET sellrate = 1 WHERE name LIKE '%crude defiant';


Of course you would need to add lines for the other named defiant gear.

[Tegila]

looks great for editing or creating new items and i'm sure I'll be using it for lot of things like that.

now that i've wrapped my mind around the structure of the coding at least the basics in sql, i wont be asking so many questions long as i can find the relevant columns etc.

i really like the editors. georges merchant one is soo much better than using sql to build an inventory for sure, and i sought this one out because his suite didnt have an item editor (the one he did have on his page wouldnt load for me) The spawn editor too will be useful. All these tools are great, but some things are just easier done in code if you know how to make it. Long way to go but glad i got past that initial learning leap with that part at least. Not overly familiar with what all is and isnt on the tables or where yet to know where to look for things like the sellrate, or to even look for it at all.

[GRUMPY]

I meant to post this "glitch" awhile back, but it's not a big issue for me. Just thought I would
mention it for anyone else who's interested in the info about it.

When I first started using the last available version of this editor, I was getting this run-time
error everytime I tried starting it.

https://image.ibb.co/dhyuCH/runtime_error.png

But as I soon discovered, all I have to do (each time I fire it up), is click the "Editor music off"
button and it works, no-fail. I have no big desire for solution, because it's only one extra "lazy"
click to do at the start screen. :P

https://image.ibb.co/mcWmRc/editor_start_screen.png

[Uleat]

You running a windows server os?

[GRUMPY]

You running a windows server os?

Yes, win 7 (64) I have the mysql-connector-odbc-5.3.10-winx64 installed as well.

[Uleat]

I can't remember which tool set..but, one of them had problems running on the server os due to a missing sound-related file that's not included, but..is present in the normal win os.

[GRUMPY]

Oh ok. Well, I've never worried too much about sound in any kind of program or software. As a preference,
I live in a home of peace and serenity, haha

https://image.ibb.co/buU1sH/Muted_Home.png (https://imgbb.com/)

[Uleat]

Do they make those that work over a 25-mile radius!?


EDIT: Those darn transient vehicles are a pima!!

[hawkbs]

Does this work with MariaDB? I tried installing the ODBC connectors but it doesnt seem to want to work. Also got hold of the MariaDB ODBC Connectors installed them and nothing.

If someone knows how to get this to work with mariaDB please let me know exactly how you did it.

[Cusser]

Did you install ODBC 5.3.10 ? That's the one you need. Not sure about windows 10 compatibility, that's one of those OS's that
should be simple freeware posted on sourceforge with a disclaimer, so I stick to win 7.

In the db.ini (for the item editor), did you set these for connection to your database ? (values may be different than example below)

host=127.0.0.1
user=root
password=eqemu
database=peq
everquest_folder=

[hawkbs]

Actually I just got the bloody thing working!
Still get a message about not connecting. However it does connect and everything seems to load.

Had to get tricky, lucky I have the main DB running on a dedicated server and a backup for development on a VM. I went into the VM version deleted MariaDB and installed the latest MySQL then the ODBC Connector. Exported the DB out of mariaDB on the Server and imported it into my VM server. (Which is Win 10 x64)

So now Im having a little play about with Georges Tools.

Been a very very long time since I last played with EQServer Development. In fact I even had a different name on here way back when lol. This was one of my pieces of work I uploaded to the community to use years and years ago however the file has since disappeared from the dl location. http://www.eqemulator.org/forums/showthread.php?t=2838

Edit: OMG I just noticed my signature on my old login name lmao

Just as an FYI Im using the latest version of the server from here https://github.com/EQEmu/Server/wiki/Windows-Server

This is alot easier than working with the leaked sourcecode from SWG lol its like a walk in the park compared.

[Cusser]

Usually when I read about common issues like these, just by coincidence, many seem to mention the use of VM's and/or windows 10.
I don't use either. I stick to windows 7 on a dedicated box with straight MySQL and I never have problems with installing or
running the necessary apps to compile or run the server, along with 3rd party database editing tools. I don't need to run an extra
database for development, I just edit the one I am playing on and frequently run a backup from a batch file I made and put it in
the folder where I want the backups to go. I just call it Dump.bat with this in it:
mysqldump --routines -u root -p***** peq > peq_backup.sql (I usually rename that output file with date added after)
Most database edits can be applied on the fly without restarting the server, by running shared_memory or using ingame #commands.

[hawkbs]

Usually I like to stick to straight MySQL however the Installer itself for the latest version of the Emu which I got from the guide I linked above installed MariaDB.
Which is where the problem was for me. However saying that none of these are the headache that Oracle is that SOE used,
which is used for SWG. Now thats a real pain to get to know and understand.

[nge2006]

I have some problems for using GeorgeS_EqEmu_Files tool.the db.ini seting is：
host=127.0.0.1
user=root
password=eqemu
database=peq
everquest_folder=D:\game\EQ\EverQuestSOD
and the mysql-connector-odbc-5.3.11-winx64 installed for win7.
but issues：
“MYSQL Connection FAILED！- Check DB.INI OR MYODBC Drivers not installed”--ok
“Error in Connecting to the Database-Did you register all the files？”

[nge2006]

logfile：
creating log entry
Completed getting user info
credential output to screen ok
Call to ODBC open connection completed
Splash returned an error-connection fail
Splash request to load MAIN program started
MAIN program started init LOAD-RACE-CLASS-BODY
MAIN program init LOAD-RACE-CLASS-BODY-ok
Splash request to load MAIN program done. Splash unloaded ok

[Akkadius]

Guys this is not a support thread for Georges tools, this is Shendare's item editor, if you have questions regarding Shendare's tool this is the thread for it, otherwise please find the proper support thread for the tool you are having issues with

[Shendare]

Tested with the latest MariaDB ODBC connector (3.0.6 as of 8/15/2018).

https://downloads.mariadb.com/Connectors/odbc/

Note that different connectors will require different connection string settings, which are usually easily Googled.

The MariaDB 3.0 connector requires the following Driver parameter in the connection string:

Driver={MariaDB ODBC 3.0 Driver}

[pharone1]

Tested with the latest MariaDB ODBC connector (3.0.6 as of 8/15/2018).

https://downloads.mariadb.com/Connectors/odbc/

Note that different connectors will require different connection string settings, which are usually easily Googled.

The MariaDB 3.0 connector requires the following Driver parameter in the connection string:

Driver={MariaDB ODBC 3.0 Driver}

Thanks for the info on getting it to work with MariaDB. I installed it yesterday, and I am loving this tool.

[kolamer]

I have installed this tool and love it for editing items. I can't seem to locate item icons though. I point the folder to default in uisettings but that doesn't seem to work. Any item I edit ends up looking like a pearl necklace.

[ChaosSlayerZ]

Is the latest version up to date with current DB?
Says released this on Sep 13, 2015

[Huppy]

I have installed this tool and love it for editing items. I can't seem to locate item icons though. I point the folder to default in uisettings but that doesn't seem to work. Any item I edit ends up looking like a pearl necklace.

I use this all the time and I get the item icons no problem. In my db.ini for the editor, I have the "everquest_folder=" path set to the eqemu folder location. (not the client folder). Other than that, not sure if your issue is same ?

When you open an item in the editor, click on the icon to bring up the icon window. Click on an icon of your choice and it will replace the one on item. Then save it.

https://i.ibb.co/rxx3SD9/iconedit.jpg

Here's an example. I used an unwanted item, 127553. It's a trophy whatever, but if you look it up and see the original icon, this is what I changed it to, (visible ingame on item info view).

https://i.ibb.co/XSn4crZ/trophyicon.jpg

[Cougartown]

Trying to get help for this phenomenal tool. Not sure what's changed between last year and now but I can't get passed this error after a successful connection:

"An item with the same key has already been added"

I'm running a fresh copy using Akka's installer on Server2019 (also checked 2012R2). I've tried all combinations/versions of ODBC drivers both MySQL and MariaDB all give the same error after a successful connection and then it doesn't respond. I've also checked to see if all the keys for items were unique and they're fine.

On a related note, GeorgeS' tools don't work either whereas before they did. Had a local server going last year (sept2018) before I lost all the data and wanted to start rebuilding. EOC works fine but this guy made editing/searching quick and easy.

[RayKeith]

Trying to get help for this phenomenal tool. Not sure what's changed between last year and now but I can't get passed this error after a successful connection:

"An item with the same key has already been added"

I'm running a fresh copy using Akka's installer on Server2019 (also checked 2012R2). I've tried all combinations/versions of ODBC drivers both MySQL and MariaDB all give the same error after a successful connection and then it doesn't respond. I've also checked to see if all the keys for items were unique and they're fine.

On a related note, GeorgeS' tools don't work either whereas before they did. Had a local server going last year (sept2018) before I lost all the data and wanted to start rebuilding. EOC works fine but this guy made editing/searching quick and easy.

I am getting the same error as you.

Error details:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(Exceptio nResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKe y key, TValue value, Boolean add)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at EQEmuItemEditor.formMain.timerLoading_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndPr oc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9148 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
EQEmuItemEditor
Assembly Version: 1.2.0.0
Win32 Version: 1.2.0.0
CodeBase: file:///C:/EQEMU/EQEmuItemEditor_v1.2/EQEmuItemEditor.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9147 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.


Driver info:

<setting name="DBConn" serializeAs="String">
<value>DRIVER={MariaDB ODBC 3.0 Driver};Database={Database};Server={Server};Port={ Port};UID={Username};PWD={Password};</value>
</setting>

[Huppy]

I use this all the time. (win 64) I have (Oracle's ) ODBC 5.3.10 connector installed. Not sure about anyone else, but I have to click the "Editor Music" off on the splash startup for it to continue.

[RayKeith]

I use this all the time. (win 64) I have (Oracle's ) ODBC 5.3.10 connector installed. Not sure about anyone else, but I have to click the "Editor Music" off on the splash startup for it to continue.

Is this the driver you are using and have configured?

{MySQL ODBC 5.3 ANSI Driver}

That is what I had before changing to the mariaDB 3.0 driver, but I have the same issue with both drivers.

I then noticed you listed 5.3.10, the version I was able to get off the site was 5.3.13. I went to an archive site for MS and found 5.3.10 there: https://downloads.mysql.com/archives/c-odbc/

I had to uninstall the 5.3.13 connector from my system and install the 5.3.10 connector. Did that work? Nope. Same error:

An item with the same key has already been added.

Also, I don't see a "Editor Music" option on the splash screen.

The only options I see on the splash screen are 'Automatically set class limitations...' and 'Automatically set 3D model...'. I have both of those unchecked. When I click the 'Options' menu bar, no drop-down shows. I can initiate a connection to the DB, so it looks like the driver I am using is fine. It even gives me a reminder to set my 'Icon Location'. Whether I select a location or not I get the 'key has already been added' error. I recall from using this in the past it means that I am attempting to add an item that already exists, but since this is the initial start of the program no items should be being added.

[Huppy]

The connector I am using is by Oracle ( 5.3.10) That's been on my Win 64 box for a long time, it's all I needed to run it without errors.

[RayKeith]

Any chance you could share that out? The oracle site won't let me get a driver that old? If it's less than 8MB we can transfer via discord?

Edit: Thanks for sharing the file. Even with that I am still unable to connect. I am using the newest version of the EQEMU DB and this issue started when I updated.

[Uleat]

The references that I found online for this seemed to indicate that a merge query was pulling from two tables that had fields of the same name and they were not aliased.

[phentop]

The error I receive when trying to open the editor:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(Exceptio nResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKe y key, TValue value, Boolean add)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at EQEmuItemEditor.formMain.timerLoading_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndPr oc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9148 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
EQEmuItemEditor
Assembly Version: 1.2.0.0
Win32 Version: 1.2.0.0
CodeBase: file:///F:/Item%20Edit/EQEmuItemEditor.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9147 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.9136 (WinRelRS6.050727-9100)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[xarisd]

Did we ever resolve this issue or move it to a different thread? I haven't seen any updates to the EqEmuItem editor tool, and I'm having this same issue. Haven't found any duplicate keys anywhere, and from what Uleat said, it makes sense that would be happening. If there's a way to fix that, that would be awesome.

[Jackal2002]

can i get an installation guide on how to use this program? like where to install what to put into the icon location field when loading it ect. Thanks sorry i am un versed in all of this but trying to learn.