Updated Tool - EqItems Item Editor

[Jeido]

Was playing around with making pre-set armor sets today and I ran into a few issues.

When trying to insert items into the inventory list then it does not always work. An example of a non-working item is spiritlight earring, but I've also had it happen with many others.

There doesn't appear to be a way to save a template straight from the eqitems program. You can load already pre-set profiles, but cannot save newly created ones.

Load Raid Bots doesn't work. If I load it, then select a bot, then the program crashes. The error code is: http://i.imgur.com/w5srK.jpg. Again, this only happens once I click on the bot name.

Hopefully I'm missing something and that's why I'm having these issues, but I was hoping to create a few armor templates after reading about it on your website.

Thanks for all the work you do!

[GeorgeS]

Thanks for the report. I am looking into this and hopefully it won't be a big problem to address.

GeorgeS

[GeorgeS]

Ok checked this out pretty extensively, and I can do everything as expected. No errors, and spiritlight earring works fine in the bots.

The error has to come from a null in your field somewhere. I am running v.1751

pre-set profiles can be saved buy going into the load bots button, and there's options to save.

You can check in your table why spiritlight earring causes problems. If there's a null somewhere or my table is too old then that could cause this.

GeorgeS

[madsalty]

Is there a guide or tutorial page that explains on how to get many of the EQEMU tools created by George to work? If so please provide the link. It would be much appreciated.

Okay, step one, I need to ensure that my db.ini is filled out correctly. Okay, right here I start to panic. My server is on a Debian Linux box, which is on the same network as my Windows 7 machine. So, would the host be the Linux box IP address?

database=peq, what does peq stand for and is this the default?

everquest_folders=(whatever). I assume this is where I put the location of the EQ files that are located on the Linux box, not my local machine that has the client?

What I am trying to do, if possible, is to use George's wonderful tools from my Windows 7 box to edit the files needed on my Linux box. Is this a possible task and if so, what are the appropriate steps needed to accomplish said task?

I would like to thanks everybody for their hard work and please excuse me if my questions are redundant.

[lerxst2112]

host=<ip address of the database machine>
user=<username in MySQL that you want to use>
password=<password for whoever the user is in the database>
database=<whatever you named your EQ database>
everquest_folder=<directory where you have your EQ client installed>

[Emmeric]

Originally Posted by lerxst2112

host=<ip address of the database machine>
user=<username in MySQL that you want to use>
password=<password for whoever the user is in the database>
database=<whatever you named your EQ database>
everquest_folder=<directory where you have your EQ client installed>

That made a difference.

I click it now and get a window with music. When I click start, the window disappears and nothing happens? Does it take a long time to load... or? In my processes window, the EQitems icon disappears.

Never mind, ocx registration....

[Emmeric]

Hmm. Got everything running.

Got a problem though. I made a change to the Archaic Blade of Battle to test things out. Changed the damage from 37 to 50 so I could easily spot it in the item entry. Hit save and go-back exited the program and opened the peq DB with Notepad++. The damage was still 37.

Opened the editor and brought up the blade. It still shows my change - a damage of 50 - while the DB still shows 37.



What am I missing here?

[lerxst2112]

The editor works on the database in MySQL, it doesn't change the dump you imported to initially create your database.

Item changes also require a restart of your server before they show up, so if you restart the server, enter the game, target yourself, and #gi <whatever the id is> you should be able to examine the item there.

[Emmeric]

Originally Posted by lerxst2112

The editor works on the database in MySQL, it doesn't change the dump you imported to initially create your database.

Item changes also require a restart of your server before they show up, so if you restart the server, enter the game, target yourself, and #gi <whatever the id is> you should be able to examine the item there.

That first part confused me. If it doesn't change the DB, even though the editor uses the DB for initial info, then what exactly does the editor change? Is not mysql just the interface language used to make changes to the DB?

You mentioned dump... the db_dump.sql is what I have been using for certain changes - namely the LDoN point cost for items that isn't shown anywhere else. Can't change LDoN cost in the editor. Is not the db_dump.sql the root of all this info used in running the server?

If I'm wasting my time editing the wrong file, lemme know!



EDIT: from reading your post a few times, you are saying my db_dump.sql is not the DB my game is using... where should I be looking for the one that is?

[Emmeric]

I get the impression the Archaic Blade of Battle would show up in my game with heightened damage, but still retain the original LDoN cost...

I would greatly appreciate a pointer to where my game DB is that is being used so I can alter the LDoN point costs.

[GeorgeS]

The editor uses the database specified in the db.ini file, whereas your eq game always uses the the database specified in eqemu_config.xml and/or login.ini.

Now if they are the same, then here's a disconnect somewhere. The editor always writes the data or it crashes/fails when it cannot write.

My guess you have more than 1 database.

GeorgeS

[Emmeric]

Originally Posted by GeorgeS

The editor uses the database specified in the db.ini file, whereas your eq game always uses the the database specified in eqemu_config.xml and/or login.ini.

Now if they are the same, then here's a disconnect somewhere. The editor always writes the data or it crashes/fails when it cannot write.

My guess you have more than 1 database.

GeorgeS

This is my db.ini file:

host=127.0.0.1
user=xxx
password=xxx
database=peq
everquest_folder=F:\Program Files (x86)\Sony\EverQuest

The only db file in my peq folder is the db_dump.sql.

The eqemu config shows the same:

<database>
<host>localhost</host>
<port>3306</port>
<username>xxx</username>
<password>xxx</password>
<db>peq</db>
</database>


So, the question is, if the db_dump.sql isn't the db file I should be editing for the LDoN point costs, then where should my n00b butt be looking?

[lerxst2112]

The dump file you sourced to create your server database is just a snapshot. You import that into a MySQL database which is what the server uses for it's data and what the various editors modify.

Making changes to the dump file doesn't do anything unless you import it into MySQL again. Doing so replaces your existing database with the dump again. Unless you really want to start from scratch this is the wrong thing to do.

To edit items in the MySQL database you can use the item editor you're already using, or you will need something like HeidiSQL or Navicat.

As an example, if you used HeidiSQL or Navicat you would be able to execute queries on your database to change items.

This would select a particular item:

SELECT `Name`,`ldonprice` FROM items WHERE `Name` LIKE "%Archaic Blade of Battle%"

And this would change its price to 75

UPDATE items SET `ldonprice` = 75 WHERE `Name` LIKE "%Archaic Blade of Battle%"

Depending on the tool you use you can also edit things in a grid like a spreadsheet and then save those changes back to the database.

[Emmeric]

Originally Posted by lerxst2112

To edit items in the MySQL database you can use the item editor you're already using, or you will need something like HeidiSQL or Navicat.

As an example, if you used HeidiSQL or Navicat you would be able to execute queries on your database to change items.

Depending on the tool you use you can also edit things in a grid like a spreadsheet and then save those changes back to the database.

Ok, so there isn't really a file I could just pop open with Notepad and create fire-breathing earrings...

Using the editor in this thread seems simpler than typing commands as you listed. Just opened the db items list with navicat. A bit clunky, but that answers my question nicely.

Thank you so much for your help

[Emmeric]

Edit - I feel stupid... there are pages in the db tables...

Does it matter if I load Titanium or SoF in the spell tool?