5.0 Item Editor 1.1 (NEW 1.5!!)

[mangoo]

Ok I know it has only been about an hour since the release of 1.0, but I thought these changes were too urgent to wait.

http://www.fliphost.net/item/ItemEditor12.zip

Changes in 1.1:
Menu items (excluding minimize/exit) will do nothing if program isn't connected to the database. This will save crashes from those who like to click things when not connected. :D

New Item and Delete Item will be disabled until connection with a database is found.

Program will no longer crash if "settings.ini" is not found.

When loading, if program is unable to connect to a database, the "Save Settings" dialog will appear allowing you to change your database information and will try to connect again.


That is it for now, please reply to this topic with any feedback and/or bugs. Thank you.

[DeletedUser]

Nice job with the fast updates. :D

[Kroeg]

awesome efforts mangoo... I can't wait to get home and play with it! I'm really surprised you haven't had more compliments!

Thanks a lot for your time and energy!

[mangoo]

Thanks for the replies guys, I really appreciate it. I'd like to note a known bug though :( . Apostrophies in the fields (e.g. Mob's Sword) will cause queries to fail, so an item will not save properly. This is being worked on, in the meantime, please leave out any apostrophies.

[mangoo]

Hi again everyone, got a new version for you all that fixes the error with apostrophies. I apologize for all the new releases so quickly and any inconvenience this has caused. You can get 1.2 here: http://www.fliphost.net/item/ItemEditor12.zip. The above link has also been changed to target 1.2 download.

[DeletedUser]

uhhh. Apologize? You silly tard.. more updates = better. :P
I'll scam through it later for errors. So far so good though.

[a_Guest03]

mangoo, if you apologize for fast releases again, I'm going to pummel you! Thanks for the code fixes, and for the extra tool.

*bows*

[mangoo]

Sorry :P

[a_Guest03]

*reaches across the forum and strangles the boy*

Why you little!

[DeletedUser]

mangoo, any plan on releasing source later on? Because a bunch of good item editors always die out when the makers get lazy with the updates. :P

[mangoo]

I will be releasing the source, I'm going to put up a nice little page on my website for all of the EQEmu tools and whatnots shortly. Before I release the source I want to clean it up a bit and comment much it to make it easier to read :D .

[mangoo]

Just looked at the error log on my website and notice lots of hits to ItemEditor10.zip still going on :P . So in light of that I was able to add a redirect to the correct file for those still clicking on the link in the news.

[Kebleertunes]

Hey
Sorry if I sound like a total tard im new to this stuff but what and how do I use this program? :shock:

[arkaria]

Correct me if I'm wrong but this utility is used to Modify/Create items for an EQemu server DB.

[exzapel]

how do we use this if its for ops or server owners or what not that should be posted otherwise how do i use this

how do we use this if its for ops or server owners or what not that should be posted otherwise how do i use this

It's for server admins only, not if you are playing on someone elses server.

[exzapel]

ok im not griping but shouldnt that be posted somewhere? like on the main post where you get this from?

[mattmeck]

Its in 3'rd party tools...people dont need anything from here to play. Being in this forum says its not needed to play.

[exzapel]

oh well dont really mind just wondering

[mangoo]

It is an item editor, you would have to have database access to edit an item on a server.

[exzapel]

well i dunno im new to eq and anything related to eq i have no clue on how to do such things and about such things i wouldnt know

[mangoo]

Welcome to Version 1.3 folks! 2 updates to this one, 1. Fixed a typo in Bard Instrument types :P 2. Added a search window.

Get it here: http://www.fliphost.net/item/ItemEditor13.zip

[mattmeck]

Mangoo = THE ONE

[mangoo]

hehe :D hi there matt

[Magick]

Awesome work Mangoo!!!

[mangoo]

Thanks Magick

[Kgaul]

Your Awesome! thanks mangoo!!


Kgaul

[Kroeg]

Once again I am amazed by all the work you've whipped out :shock:

[mangoo]

Thank guys

[Daeklaz]

I think that if you have a title that allows you to edit item stats in-game, (ie. Steward) you can. I've tried before WITHOUT the editor and it says something about not having a program, or I'm not in the right mode. Correct me if I'm wrong, but this may be the program needed to use the in-game item editor. I just saw it under #help and tried it, didn't work. So, this MIGHT be what the computer wants, for you to edit items. Just a guess, will try when I get home.

Daeklaz,
:twisted: :twisted:

[mangoo]

:?: :?: :?:

[a_Guest03]

Eh? What the hell are you talking about?

[Edgar1898]

I think that if you have a title that allows you to edit item stats in-game, (ie. Steward) you can. I've tried before WITHOUT the editor and it says something about not having a program, or I'm not in the right mode. Correct me if I'm wrong, but this may be the program needed to use the in-game item editor. I just saw it under #help and tried it, didn't work. So, this MIGHT be what the computer wants, for you to edit items. Just a guess, will try when I get home.

Daeklaz,
:twisted: :twisted:

Trying to edit items ingame==bad. I think what your referring to is the item edit function that was left over from the days before shared memory. Shared memory is static and should never be changed after a server has started, if it were possible to change it, you would get all kinds of wierd errors.

[mangoo]

Ok ok I promise I'll slow down a bit after this one.
http://emu.fliphost.net/files/ItemEditor14.zip

1.4 Changes:
-Fixed having the Summoned Flag being cutoff with New Items and Saved SQL files resulting in failed queries
-Added in the new icons from LDoN
-Added in the ability to load saved items from a .sql file
-Fixed a bug in saving of items
-Added a few error checks
-Added in missing status messages
-Recoded saving
-Reload DB will now bring up the connection dialog if not connected to a database
-Changed the menu up a little bit

[Kgaul]

You own!

<-- Fan


Kgual

[DeletedUser]

excellence...

note: this post was just stickified. You nasty devs. :P

[arkaria]

/bow

[Jeldorith]

Great work Mangoo, keep up the swift updates!

[mangoo]

The November 8th Item Database has a new field: Unknown113. What this means is Item Editor is now updated accordingly :D .

Download here: http://emu.fliphost.net/files/ItemEditor15.zip

1.5 Changes:
- New button added to "Save Settings" dialog that will help with getting your EQ directory
- Added in field for Unknown113
- Gave the main UI a facelift

In the works:
- Item Previewing
- Kaiyodo's Model Viewer integration

[arkaria]

Nice

[mangoo]

file temporarily down due to save to db not working for some reason...

[mangoo]

Ok, I figured out this morning that the problem wasn't the editor, but the 11-8 item dump was a bad cookie. Lethal has posted a fixed database (11-10). Please download new version of item editor and also the new item database, sorry for the delay.

Download: http://emu.fliphost.net/files/ItemEditor15.zip

[Vaelene]

I have tried to use versions 1.3, 1.4, and now 1.5 but some how i am not getting the correct settings for accessing the database. I am using mysql version 3.23. I created a database called eqemu with a user eqemu and password eqemu and the emulator works fine with this database and i am able to play on my network using it but i cant seem to get the item editor to connect to the database. I keep getting the error : unable to connect to Database. Could someone please give me a clue as to what the settings.ini should look like or post one as an example please. This is what my current settings.ini looks like although i have tried many different configurations.

DatabaseName = eqemu
DatabaseUser = eqemu
DatabasePass = eqemu
DatabaseHost = c:\mysql\data
EQDirectory = c:\eq_local

[Edgar1898]

databasehost is supposed to be an ip address of the database server.

[Vaelene]

I tried changing the DatabaseHost in the settings.ini to the ip of the system hosting mysql but am still having the same error : unable to connect to database. My settings.ini now looks like this although it is still not working.

DatabaseName = eqemu
DatabaseUser = eqemu
DatabasePass = eqemu
DatabaseHost = 192.168.1.3
EQDirectory = C:\EQ_Local

I must still be missing something. I also tried downloading and installing mysql version 4.01 on another system and then sourcing in the last tcs database and still have the same error using a different system so i have to be missing something when configuring the settings.ini. I am running both systems on windows 98SE if that has any effect. I am a computer technician and very computer literate but this project is my 1st time to use mysql.

[mangoo]

Not sure quite sure what exactly could be the problem here. You might want to check your permissions out and make sure that they allow a remote system to access MySQL. That and checking network settings are the other things that I can think of right now.

[ric0h]

unknown97 is the code for LDoN dungeon type, e.g. 3 is Mm, 4 is Ruj, etc.

unknown98 is the cost of the item in adventure points.

unknown99 is always 1 for these items. NOT SURE ABOUT WHAT IT'S USED FOR.

Note that some LDoN items that are not properly collected dont have this fields set.

LDoN sold items start at 42001

[Vaelene]

I finally figured the problem out. It was a permissions issue with Mysql. I had followed the setup guide for setting up a database and eqemu and had used the following example out of the guide for that purpose.

mysql -u root mysql
create database eq;
grant all privileges on *.* to test@localhost identified by 'test' with grant option;

The grant command in the example is enough to get eqemu up and working but not enough to use this program to access the database. I had to add another grant command and substitute test@localhost with my computer name@localhost to get the item editor to work. Additionally i believe that i can substitute localhost with the ip address of the system trying to connect to the database and use this program remotely. I will try that next.

Just wanted to let you know i got it working and say Congrats on a great program.

[mangoo]

Thanks Vaelene, glad to hear you got it going. And to ric0h, rawr! you da man!

[DeletedUser]

The search feature is kindve limited... is there anyway we could get it so it can search other values.. such as item price values? I could use this tool for a lot more then eqemu. :D

Keep up the good work mang00!

[mothlos]

I cannot get the item editor to run if I give it valid mysql information. I get a memory could not be 'read' error. No problem if I give it bad mysql info, but then I can't edit the database.

Any idea?

[Bug]

http://www.everquestserver.com/forums/viewtopic.php?t=11440

If you need, for some reason, to search other values, use mysql CC and follow the search format listed in the above post. Using a combination of CC and the item editor should be alright.

[Tattered]

--edit--
Nevermind actually.. Problem solved. :p

[Shadow-Wolf]

....

[infernal]

most of the versions i have try'd... i can get it to show me the list of items... but 1ce i click on 1 of them.. i get trouble shooting problems... any idea why? and how i can fix it?

[NarutoLegacy]

....

that helped