New SoF Item Stats

[trevius]

Oh, I had assumed those had been in for a long time. My items table was probably over a year old when I added the extra fields for the resists and new stats. I guess that since the heroics weren't previously being used, it wasn't required before like it is now. I didn't really think about that. Is there a way to add fields only if they don't already exist via SQL queries? If so, I could have just added that to the SQL file as well. I know you can do a "delete such and such if it exists", but is there an "add such and such only if it doesn't already exist"?

Sorry, I am not all that SQL savvy.

You should be able to run the following if you don't already have these fields:

ALTER TABLE `items` 
ADD COLUMN `dsmitigation` smallint(6) NOT NULL default '0',
ADD COLUMN `heroic_str` smallint(6) NOT NULL default '0' AFTER `dsmitigation`,
ADD COLUMN `heroic_int` smallint(6) NOT NULL default '0' AFTER `heroic_str`,
ADD COLUMN `heroic_wis` smallint(6) NOT NULL default '0' AFTER `heroic_int`,
ADD COLUMN `heroic_agi` smallint(6) NOT NULL default '0' AFTER `heroic_wis`,
ADD COLUMN `heroic_dex` smallint(6) NOT NULL default '0' AFTER `heroic_agi`,
ADD COLUMN `heroic_sta` smallint(6) NOT NULL default '0' AFTER `heroic_dex`,
ADD COLUMN `heroic_cha` smallint(6) NOT NULL default '0' AFTER `heroic_sta`,
ADD COLUMN `heroic_pr` smallint(6) NOT NULL default '0' AFTER `heroic_cha`,
ADD COLUMN `heroic_dr` smallint(6) NOT NULL default '0' AFTER `heroic_pr`,
ADD COLUMN `heroic_fr` smallint(6) NOT NULL default '0' AFTER `heroic_dr`,
ADD COLUMN `heroic_cr` smallint(6) NOT NULL default '0' AFTER `heroic_fr`,
ADD COLUMN `heroic_mr` smallint(6) NOT NULL default '0' AFTER `heroic_cr`,
ADD COLUMN `heroic_svcorrup` smallint(6) NOT NULL default '0' AFTER `heroic_mr`,
ADD COLUMN `healamt` smallint(6) NOT NULL default '0' AFTER `heroic_svcorrup`,
ADD COLUMN `spelldmg` smallint(6) NOT NULL default '0' AFTER `healamt`,
ADD COLUMN `clairvoyance` smallint(6) NOT NULL default '0' AFTER `spelldmg`,
ADD COLUMN `backstabdmg` smallint(6) NOT NULL default '0' AFTER `clairvoyance`;