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

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

unable to connect to database
 

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

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

unable to connect to database
 

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.

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.

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

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.

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

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!

crash
 

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?

http://www.everquestserver.com/forum...ic.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.

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

....

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?

that helped