Updated Tool - EqItems Item Editor

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

[Emmeric]

BTW, yes, the changes I have made using the editor do show up in-game. I altered Djerv's solo server Gate potion costs. He had some at 4300 plat. I altered it using the editor and it shows all the changes in-game.

So the question still remains, to where are the editor changes to my db being made so that I can alter the LDoN item costs?

I only have one peq folder and the only file of any size there is the db_dump.sql.



Well, that's okay if you're all busy. If the editor does indeed change the db and it does show in game (as it does), then the "Old Edit" contains a spot for LDoN pricing that the New Edit doesn't. I guess I shouldn't be overly concerned about it if I'm able to alter what I need.

Suggestion, throw in the LDoN pricing field somewhere in the new Edit!