New SoF Item Stats

[John Adams]

In fact, it seems all these are missing:

	itbs.BackstabDmg = item->BackstabDmg;
	itbs.DSMitigation = item->DSMitigation;
	itbs.HeroicStr = item->HeroicStr;
	itbs.HeroicInt = item->HeroicInt;
	itbs.HeroicWis = item->HeroicWis;
	itbs.HeroicAgi = item->HeroicAgi;
	itbs.HeroicDex = item->HeroicDex;
	itbs.HeroicSta = item->HeroicSta;
	itbs.HeroicCha = item->HeroicCha;
	itbs.HeroicMR = item->HeroicMR;
	itbs.HeroicFR = item->HeroicFR;
	itbs.HeroicCR = item->HeroicCR;
	itbs.HeroicDR = item->HeroicDR;
	itbs.HeroicPR = item->HeroicPR;
	itbs.HeroicSVCorrup = item->HeroicSVCorrup;
	itbs.HealAmt = item->HealAmt;
	itbs.SpellDmg = item->SpellDmg;

There is an update in 665_heroic_resists.sql that fail because heroic_str is not already in place (the AFTER statement).

Hope I am not just rambling nonsensically... it's been known to happen.

[KLS]

I had the same problem when updating by hand back then, made me mad that Trev assumed everyone had updated item tables from peq... but I added them manually and forgot to yell at him for it.

[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`;

[Kilralpine]

What ever came of this trev? Id really like to see some of the new stats in action, i think it would bring a world of customization to eqemu... especially thru spell damage

[trevius]

I just haven't had time to get back to it. I definitely want to get at least the Heroic Stats working sometime soonish. The spell damage mod would probably be something better for KLS to do, since she has some changes to spells for her Spell Branch.

I'm not really sure about the other mods like Healing yet, but those will probably come eventually.

[Frosef]

Semi-related: Is there a place to read up on what all the stats do? I couldn't find anything with my Google-fu on the "newer" stats introduced with Planes of Power(?), but Alla's did have some information on SoF stats under their guide to SoF.

Heroic stats should be pretty straight-forward, since all they do is increase the stat caps for normal stats and resists.

According to Alla's the actually do more than just stat cap increases, by the way:

http://everquest.allakhazam.com/wiki/EQ:Heroic_Stats

Although it's lacking in specific numbers for certain stats.

[KLS]

http://everquest.allakhazam.com/wiki/eq:mod2%27s