New SoF Item Stats

**trevius** · #1 06-15-2009, 03:50 AM

I am sure those will be added in eventually. But, adding in Heroic stats is my first priority. Once I know how to add one, the others should be cake. For spelldmg and healamt, each of those would have to be coded in separate places, so it would be different than coding in Heroic stuff, which is why I am not doing them all at the same time. After Heroic stats, I will probably try to see about doing backstabdmg next, because that is a pretty cool stat IMO, considering I played a rogue on live for years. I like the idea of being able to have hard hitting weapons that devs don't have to nerf down just because they don't want insane backstabs from Rogues. I looked through the PEQ items table and it looks like many/most of the piercers already have the backstabdmg setting set. I will still put up a simple MySQL query when I add it for databases that can't update to PEQ so Backstab will still work perfect for them. Basically, I think this would work well:

Code:

UPDATE items SET backstabdmg = damage WHERE backstabdmg = 0 AND itemtype = 2;

**trevius** · #2 06-15-2009, 07:30 AM

Well, I wasn't able to get to actually having the server make use of any of the new stats tonight, but I was able to get them all working to show up on items in game when using SoF.

I still plan to start the server side calculations by adding in Heroic stats first, but I am still not sure what exactly needs to be done to do it. From testing, I did verify that not only do Heroic stats increase the cap by the value set, but they also add that many of that particular stat for the value set. So, if you are capped at 300 STR and your items actually total 300 STR, and then you get an item that has 10 Heroic STR on it, you will then have 310 STR showing.

I will mess with it more tomorrow night and see if I can figure out how to handle the code for that stuff.

I also added in the field for normal (non-heroic) SV Corruption, since it wasn't coded yet. The Corruption and stuff will be the hardest stuff to add since it isn't anywhere in the source yet. At least the other stats are already everywhere they need to be and to code in Heroic stats should just mean making it add the extra values and increase the caps.

Majildian · #3 06-18-2009, 04:00 PM

Heroic stats actually do a lot more than increase the stat+cap, you can read about them and the other mods at http://www.evilgamer.net/forums/showthread.php?t=3508.

John Adams · #4 08-02-2009, 05:18 PM

backstabdmg does not appear to be in the sql/svn updates anywhere. I'm still searching here for what it should be, but wanted to let you know.

(i haven't updated since Apr '09, so this is an all-day project lol)

edit: ok, there are apparently a bunch of new Items fields on SVN code, not yet in DB updates. Maybe I shouldn't have been so zealous

John Adams · #5 08-02-2009, 05:29 PM

In fact, it seems all these are missing:

Code:

	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** · #6 08-02-2009, 05:44 PM

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** · #7 08-02-2009, 06:17 PM

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:

Code:

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