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.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-28-2007, 04:45 PM
Amra's Avatar
Amra
Hill Giant
 
Join Date: May 2006
Posts: 117
Default

please delete wrong thread.

Last edited by Amra; 07-29-2007 at 12:48 AM..
Reply With Quote
  #2  
Old 07-28-2007, 05:27 PM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

http://hmproject.org/files/AA_Data.rar

The source updates don't include it because it's SQL, should see if someone could host a current one or something since CVS takes forever and ever to update.. if you don't have SVN access you're kinda SOL atm. =(

This pretty much fills out the AAs that were in the source before I fiddled with them a while back. Just so they're there, only a few work like before.. still working on getting many PoP ones to work. Extra spell slot gogo.

Still missing a bunch of AAs from GoD to Omen.
Reply With Quote
  #3  
Old 07-28-2007, 05:32 PM
Amra's Avatar
Amra
Hill Giant
 
Join Date: May 2006
Posts: 117
Default

Woohoo thanks KLS
Reply With Quote
  #4  
Old 07-28-2007, 06:34 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Is there some other repository than sourceforge? I'd certainly host any files at my site, but the only stuff I usually see is from sourceforge cvs... so I figured everyone had access to that already.

Mirror:
http://eq.mmoemulators.com/files/AA_Data.rar
Reply With Quote
  #5  
Old 07-29-2007, 05:42 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Same here, I'll host this also, along with other esoteric stuff people still use


GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #6  
Old 07-31-2007, 08:21 AM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

I notice that in the data in the table aa_actions there is a field missing... cast_time

Therefore, it cannot be merged without padding it with a 0 or deleting that field in my db. Unless the fact that I have that field is now useless?

Does anyone know if I need to delete that field to merge, or is the new aa_data.sql itself wrong?

Thank you
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast

Last edited by gernblan; 07-31-2007 at 04:33 PM..
Reply With Quote
  #7  
Old 07-31-2007, 08:42 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

If it's a newer schema to support newer code, I imagine the old fields can be removed.

For safety, you could change the queries to specify each column for your data, and perform an update or replace into instead. But, Drop/Create is always better.
Reply With Quote
Reply


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 12:10 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