Some spells/AAs arent updating
 

So basically what is happening is in multiple scenarios spells arent updating even though I am editing them on the database side (stuff like cast time, recast time, etc) AND dbl checking the changes are taking place. Every time I do this I make sure the server is not up and then start the server and then log in and check changes. The process goes as follows:

1.) Get an idea for a spell change
2.) log out character
3.) shut down the server
4.) hop to HeidiSQL and find the spell/AA then make appropriate changes
5.) verify change took place in the DB
6.) go to /bin/ folder of server and execute export client files
7.) copy/overwrite those client files to my EQ (client) folder
8.) log in and test changes

Here is whats happening and I will give some examples:

I changed Enchanter Dire Charm AA to instant cast, and it never updates - stays 15 seconds or whatever.
(In fact I changed all instances of "Dire Charm" in the DB to be cast time 0 to no effect)

I changed the "numhits" for druid AA Wrath of the Wild to 100 or 500 hits and changed the damage but it never updates the damage and the numhits finally increased to 100, but never 500 (not sure if there is a cap on numhits)

I changed some spells for druid, shm, SK and changed cast times and although the cast times work if you make a shm/SK/DRU player character, however any BOTS still follow the vanilla unchanged rules. The weird thing about this is, regarding bots - they DO now cast heals instantly (as heals were updated), but buffs (and I think DoT/DD spells, debuffs) it didn't change.

So I guess my question is:

Why are some bot spells not updating from the DB changes to spells? Arent they making calls to the spellsnew db for casting whatever spell is in their framework?

Also why are some AA abilities/spells so resistant to changes, even though I am making sure I am editing all ranks but they still wont update.

Last question and unrelated, but if anyone could help me it would be awesome: How do I make spell memming (as in the spell is in your book but not in your spellgems yet) faster?

Edit: I think I have this fixed, im still testing and making sure i have it resolved. If it is fixed ill post an update here in a bit.

Unable to edit the main post, but here is an update: I figured out why spells/AA were not updating, its because I was starting the server with the perl file "win_server_launcher.pl" and not the .bat file t_start_server_with_login_server instead. Apparently starting with the batch file (*.bat extension) makes a call to UpdateSQL, whereas the perl file doesnt.

Still working out why I cant autogrant AA on worldjoin though. I am getting about 90% of AA granted with no issues but Mastery of the Past seems to be a tricky one, no matter if I set cost in DB to 0 and make sure there are no pre-req's it still wont fire, or its firing and something is blocking it. I cant see any sort of log for quest/global/globalplayer.pl or anything so I am not sure whats happening or what I am doing wrong. For now having skill increase on level to maxskill is sufficing, but it kinda irks me that the server isnt doing what im telling it to do. As well.

There appears to be a weird bug or something in the sauce where if you make a DB edit and even reboot the server several times, some things like certain AA's dont get updated unless you make a new character. Reason I say this is I was struggling with getting mastery of the past autogranted so I set it at 0 AA cost available at level 1 with no pre-reqs. None of my current characters that were already made could buy it for 0 AA. As it was always set at 3 aa for Rk 1. I eventually forgot about it and went on to something else and made a new character for testing (BaseDiff) in spellsnew and happened to see the cost for mastery of the past at 0 AA. Wasnt autogranted but now it seems like the "0 aa cost" somehow took?

Not sure if its something I did, but during the interim of all of this ive expedited the clientfiles many times (upwards of 50+) and the cost for MoP never changed, until recently, so /shrug.