Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #1  
Old 08-25-2011, 07:23 PM
Emmeric
Sarnak
 
Join Date: Aug 2011
Posts: 72
Default

Quote:
Originally Posted by lerxst2112 View Post
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?
Reply With Quote
  #2  
Old 08-25-2011, 07:27 PM
Emmeric
Sarnak
 
Join Date: Aug 2011
Posts: 72
Default

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.
Reply With Quote
  #3  
Old 08-25-2011, 07:41 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #4  
Old 08-25-2011, 07:58 PM
Emmeric
Sarnak
 
Join Date: Aug 2011
Posts: 72
Default

Quote:
Originally Posted by GeorgeS View Post
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?
Reply With Quote
  #5  
Old 08-25-2011, 08:35 PM
Emmeric
Sarnak
 
Join Date: Aug 2011
Posts: 72
Default

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!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:25 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3