AA-data.sql?

gernblan · #1 07-28-2007, 07:49 AM

I really appreciate KLS working on AAs. I even gave him some SQL before. I'm wondering though, when AA-data.sql gets updated, according to the changelog, why it is not then included in the source download of the nightly and doesn't seem to be available or posted anywhere?

Please, is it possible to include that .sql in the source so that people can actually obtain it and use it?

If I am a dork and it is posted somewhere and I am just blind, please feel free to slap me.

Thanks!

Amra · #2 07-28-2007, 08:11 AM

I agree. I haven't been able to locate it either.

If anyone has it please post a link.

Thanks

**GeorgeS** · #3 07-28-2007, 01:03 PM

Only link I have is a bunch of sql to make 0.07 db schema compatible to current.

http://66.159.225.58/eqemu/sql_chang...o0.7.0.992.txt

GeorgeS

Amra · #4 07-28-2007, 01:09 PM

We are looking for the new aa_data sql referred to in the changelog of the latest release 1018.

Thanks George.

Amra · #5 07-28-2007, 04:45 PM

please delete wrong thread.

**KLS** · #6 07-28-2007, 05:27 PM

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.

Amra · #7 07-28-2007, 05:32 PM

Woohoo thanks KLS

John Adams · #8 07-28-2007, 06:34 PM

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

**GeorgeS** · #9 07-29-2007, 05:42 AM

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

GeorgeS

gernblan · #10 07-31-2007, 08:21 AM

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

John Adams · #11 07-31-2007, 08:42 AM

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.

Zandig · #12 08-01-2007, 01:49 AM

I merged it into the PEQ database I grabbed a few days ago from the CVS and it merged with no problems.

Also there is no 'cast_time' field in the 'aa_actions' table. Just the following fields:

reuse_time
spell_id
target
nonspell_action
nonspell_mana
nonspell_duration
redux_aa
redux_rate

oghog · #13 08-02-2007, 02:31 AM

Sourced the new AAs and didnt have any issues.

GeorgeS, tried to download it from your site and got file not found. Just an FYI,

Thanks for all the work on these KLS!

endra · #14 08-05-2007, 09:05 AM

Is fury of magic functional? I've gotten two ranks in it but my crits are still very sparce, how much is it supposed to increase the percentage anyway?