|
|
| Line 1: |
Line 1: |
| − | Depletable properties will be updated by their "combat" every 2 seconds and their "non-combat" values every 5 seconds.
| + | The [[Properties.xls]] file contains the [[2da]] files that define the core properties and trackable statistics for the game. |
| | | | |
| − | == Properties ==
| + | The workbook contains the following worksheets: |
| − | | + | |
| − | {{2da start|Properties}}
| + | |
| − | {{2da column|Stat|string|Human Readable statname. Spaces are not allowed in these strings}}
| + | |
| − | {{2da column|Type|string|SIMPLE, ATTRIBUTE, DEPLETABLE}}
| + | |
| − | {{2da column|Min|float|Minimum value possible}}
| + | |
| − | {{2da column|Max|float|Maximum value possible}}
| + | |
| − | {{2da column|UIMapping|int|
| + | |
| − | * 1 - Base resistances
| + | |
| − | * 2 - (deprecated)
| + | |
| − | * 3 - Elemental (%) resistances}}
| + | |
| − | {{2da column|NameStrId|int|}}
| + | |
| − | {{2da column|NameLowerStrId|int|}}
| + | |
| − | {{2da column|DescStrId|int|}}
| + | |
| − | {{2da column|Desc2StrId|int|Necessary for rows 4 - 9 ONLY. When hovering over the numerical values of the attributes in the character sheet, there should be detailed and technical text written that explains the effects of these stats. Need writing for: Strength, Dexterity, Willpower, Magic, Cunning, Constitution}}
| + | |
| − | {{2da column|NonCombatEffect|int|}}
| + | |
| − | {{2da column|CombatEffect|int|}}
| + | |
| − | {{2da column|EngineLink|int|See [[#Remarks]] below:
| + | |
| − | * 0 - DerivedDefault: No modification of stats
| + | |
| − | * 1 - DerivedAttack: Each point of STR and DEX above 10 adds 0.5 attack
| + | |
| − | * 2 - DerivedDefense: Each point of DEX above 10 adds 1.0 defence
| + | |
| − | * 3 - DerivedArmor: No special interaction
| + | |
| − | * 4 - DerivedAP: Each point of CUN above 10 adds (1/7) points of AP
| + | |
| − | * 5 - DerivedSpellPower: Each point of MAG above 10 adds 1.0 Spellpower
| + | |
| − | * 6 - DerivedHealth: Each point of CON above 10 adds 5 points of health
| + | |
| − | * 7 - DerivedManaStamina: Each point of WIL above 10 adds 5 points of Mana/Stamina
| + | |
| − | * 8 - DerivedResistanceMental: Each mental attribute point above 10 adds 0.5 Mental Resistance
| + | |
| − | * 9 - DerivedResistancePhysical: Each physical attribute above 10 adds 0.5 Physical Resistance}}
| + | |
| − | {{2da column|ToolsetName|string|}}
| + | |
| − | {{2da column|bShowInToolset|int|}}
| + | |
| − | {{2da column|Constant|comment|}}
| + | |
| − | {{2da column|bShowInPartyPicker|int|}}
| + | |
| − | {{2da column|Precision|int|Number of digits to display after the decimal place.}}
| + | |
| − | {{2da end}}
| + | |
| − | | + | |
| − | == HeroicStats ==
| + | |
| − | | + | |
| − | {{2da start|HeroicStats}}
| + | |
| − | {{2da column|Stat|string|Human Readable statname. Spaces are not allowed in these strings}}
| + | |
| − | {{2da column|Type|string|SIMPLE, ATTRIBUTE, DEPLETABLE}}
| + | |
| − | {{2da column|Min|float|Minimum value possible}}
| + | |
| − | {{2da column|Max|float|Maximum value possible}}
| + | |
| − | {{2da column|UIMapping|int|}}
| + | |
| − | {{2da column|NameStrId|int|}}
| + | |
| − | {{2da column|DescStrId|int|}}
| + | |
| − | {{2da column|NonCombatEffect|int|}}
| + | |
| − | {{2da column|CombatEffect|int|}}
| + | |
| − | {{2da column|EngineLink|int|See above}}
| + | |
| − | {{2da column|ToolsetName|string|}}
| + | |
| − | {{2da column|bShowInToolset|int|}}
| + | |
| − | {{2da column|Constant|comment|}}
| + | |
| − | {{2da column|bShowInPartyPicker|int|}}
| + | |
| − | {{2da column|SortOrder|int|Sorts ascending, negative values allowed}}
| + | |
| − | {{2da end}}
| + | |
| − | | + | |
| − | == HeroicPartyStats ==
| + | |
| − | | + | |
| − | {{2da start|HeroicPartyStats}}
| + | |
| − | {{2da column|Stat|string|Human Readable statname}}
| + | |
| − | {{2da column|Type|string|SIMPLE, ATTRIBUTE, DEPLETABLE}}
| + | |
| − | {{2da column|Min|float|Minimum value possible}}
| + | |
| − | {{2da column|Max|float|Maximum value possible}}
| + | |
| − | {{2da column|UIMapping|int|}}
| + | |
| − | {{2da column|NameStrId|int|}}
| + | |
| − | {{2da column|DescStrId|int|}}
| + | |
| − | {{2da column|NonCombatEffect|int|}}
| + | |
| − | {{2da column|CombatEffect|int|}}
| + | |
| − | {{2da column|EngineLink|int|See above}}
| + | |
| − | {{2da column|ToolsetName|string|}}
| + | |
| − | {{2da column|bShowInToolset|int|}}
| + | |
| − | {{2da column|Constant|comment|}}
| + | |
| − | {{2da column|bShowInPartyPicker|int|}}
| + | |
| − | {{2da column|SortOrder|int|Sorts ascending, negative values allowed}}
| + | |
| − | {{2da end}}
| + | |
| − | | + | |
| − | == Remarks ==
| + | |
| − | | + | |
| − | Relevant Eclipse engine code for the '''EngineLink''' column:
| + | |
| − | | + | |
| − | <cpp>
| + | |
| − | // DerivedDefault: No modification of stats
| + | |
| − | return 0;
| + | |
| − | | + | |
| − | // DerivedAttack: Each point of STR and DEX above 10 adds 0.5 attack
| + | |
| − | return (FLOAT32) (max((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_STRENGTH) - 10) / 2.0 , 0.0) +
| + | |
| − | max((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_DEXTERITY) - 10) / 2.0 , 0.0));
| + | |
| − | | + | |
| − | // DerivedDefense: Each point of DEX above 10 adds 1.0 defence
| + | |
| − | return (FLOAT32) max((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_DEXTERITY) - 10), 0.0);
| + | |
| − | | + | |
| − | // DerivedArmor: No special interaction
| + | |
| − | return 0;
| + | |
| − | | + | |
| − | // DerivedAP: Each point of CUN above 10 adds (1/7) points of AP
| + | |
| − | return (FLOAT32) max((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_CUNNING) - 10), 0.0) / 7;
| + | |
| − | | + | |
| − | // DerivedSpellPower: Each point of MAG above 10 adds 1.0 Spellpower
| + | |
| − | return (FLOAT32) max((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_MAGIC) - 10), 0.0);
| + | |
| − | | + | |
| − | // DerivedHealth: Each point of CON above 10 adds 5 points of health
| + | |
| − | return (FLOAT32) max((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_CONSTITUTION) - 10), 0.0) * 5;
| + | |
| − | | + | |
| − | // DerivedManaStamina: Each point of WIL above 10 adds 5 points of Mana/Stamina
| + | |
| − | return (FLOAT32) max((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_WILLPOWER) - 10), 0.0) * 5;
| + | |
| − | | + | |
| − | // DerivedResistanceMental: Each mental attribute point above 10 adds 0.5 Mental Resistance
| + | |
| − | return (FLOAT32) ((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_MAGIC) - 10) +
| + | |
| − | (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_WILLPOWER) - 10) +
| + | |
| − | (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_INTELLIGENCE) - 10)) / 2.0;
| + | |
| − | | + | |
| − | // DerivedResistancePhysical: Each physical attribute above 10 adds 0.5 Physical Resistance
| + | |
| − | return (FLOAT32) ((cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_STRENGTH) - 10) +
| + | |
| − | (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_CONSTITUTION) - 10) +
| + | |
| − | (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_DEXTERITY) - 10)) / 2.0;
| + | |
| − | </cpp>
| + | |
| | | | |
| | + | * [[Properties 2da|Properties]] |
| | + | * [[HeroicStats 2da|HeroicStats]] |
| | + | * [[HeroicPartyStats 2da|HeroicPartyStats]] |
| | + | * _readme |
| | + | * _Constants |
| | | | |
| | + | [[Category:Properties]] |
| | [[Category:XLS files]] | | [[Category:XLS files]] |
| | + | {{Languages}} |
