Thread: Mercenaries
View Single Post
  #176  
Old 03-07-2013, 11:27 AM
bad_captain
Developer
 
Join Date: Feb 2009
Location: Cincinnati, OH
Posts: 512
Default

I just realized the problem. On my 2/18 commit, I referenced the mercs.sql file from the svn folder, which KLS fixed by copying over and adding to a new commit with the spell lists, since I wasn't supposed to reference the old svn scripts.. The mercs.sql file also included a change to the merc_spell_list_entries table, which wasn't copied over.

To fix, change the spell_type column to be an int instead of tinyint. You should be able to run:

Code:
ALTER TABLE merc_spell_list_entries MODIFY spell_type INT UNSIGNED NOT NULL default '0';
You will then need to re-run the spell inserts, or update the table create script and drop and recreate before running the spell insert scripts.

I will be updating spell lists this week for dps caster, so I will fix this officially then. Let me know if this works.
Reply With Quote