Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-03-2012, 02:34 AM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

There's two things that it appears you want to do here.

1 - Perform an update query
2 - Read values from a 'CSV' file (import from an external source)

I don't know if MySQL is capable of performing a translation in a command-line script. If you are using Excel or some other spreadsheet
program, MySQL MAY be able to read from that table with no issues, but I can't say for sure.

Your best bet is to probably just create a custom table in your PEQ database and use it as your spreadsheet. This will make a query
much easier to code and run. Either Navicat or HeidiSQL are both excellent GUI database management tools and I know that
HeidiSQL will let you import 'CSV' files (comma seperated value.)

(You shouldn't lose this table on an update unless they sneak in a new table into the base with the same name.)

As far as coding it, that shouldn't be too hard, but I won't be much help to you there...

Also, remember to keep track of your characters vs. user account names. If you happen to include two (or more) character names from
the same user account, the last status to be updated will be the current value.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
 


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 03:56 AM.


 

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