New SoF Item Stats

[trevius]

I am going to take a shot at getting the new SoF item stats functioning. I am going to start with Heroic stats and maybe eventually add in the others like dsmitigation, healamt, spelldmg, clairvoyance, and backstabdmg.

Cavedude, if you see this, do you have any issues with me adding new fields to the database for Heroic Resists? I would name them all in the same format as the current Heroic fields such as; heroic_pr, heroic_dr, heroic_fr, heroic_cr, heroic_mr, heroic_svcorruption. These fields are not used on Live as far as I know and they are not in the 13th floor database either, but the client fully supports them and we have them identified in the item structure already. Since they are there for us, we might as well add in support to use them, I figure.

Once the new fields are all in the database for Heroic Resists, I will try to code in what is needed to be able to pull these fields for Serialization and also try to get calculate stats to observe these properly to exceed the caps on stats. I haven't messed with coding the handling of item fields before, but it isn't the first time I had to figure out how to do something new. Hopefully I don't break anything in the process, but I will make sure to test as well as possible before putting anything on the SVN for it.

Heroic stats should be pretty straight-forward, since all they do is increase the stat caps for normal stats and resists. The client observes these increases and it shouldn't be hard to reflect that on the server-side.

If I am able to figure out how to get Heroic stats in and it isn't too much of a pain to do, I might try adding in some of the other new stats as well. To do that, I need some input on them to make sure I understand each one properly. Here is the list of the new stats and what my current understanding of them is:

dsmitigation - I believe this is simply to reduce how much a damage shield lands for. I think it would be just a flat amount to subtract from the damage shield damage as long as it doesn't go lower than 0 value (essentially healing the character).

healamt - My guess is that this sets an amount to increase all healing spells for. I am also guessing that this is a flat rate, so if you have 100 total in healamt from items, all healing spells get increased by 100. Or maybe it is by percentage. Maybe it has restrictions too, like it might not work on CH. Could definitely use clarification on this.

spelldmg - I am guessing that this works the same or similar to healamt, accept this adds damage to spells. I don't know if there are restrictions, but I would guess that AE spells might not be affected by this.

clairvoyance - I really have no idea what this stat is or what it does.

backstabdmg - I am pretty sure that this is just a way to allow weapons to have different values to use for backstab vs just using the base damage on the weapon. All of my weapons on my Rog on Live had the same value for backstabdmg as they did for normal damage. So, when this is implemented, it would probably also be a good idea to add a SQL query that will update all piercers in the database to have a value for this field. The query should be as simple as checking if the weapon type is a 1hp, and then setting the backstabdmg to match the damage of the weapon if backstabdamage = 0. This would prevent it from overwriting any existing weapons that might have different values between the 2 fields. I think the main point of this field is so you could make really hard hitting piercers that aren't insanely overpowered for rogues using them to backstab. You could set the backstabdmg lower than damage if you want to do that, or you could set it higher for custom weapons that might not hit normal hits hard but land some amazing backstab damage to make the weapon more appealing to Rogues than to any other class.


I will probably start working on this tonight. Hopefully it isn't all too hard to get these fields to be used by the serialization. If anyone has suggestions or questions, lemme know. Also, if anyone wants to help get these all working, feel free!