Properties.xls - Revision history

Sunjammer: Converted to new format

2016-04-03T17:22:46Z

Converted to new format

Sunjammer at 20:30, 23 November 2014

2014-11-23T20:30:03Z

Sunjammer: Creating a Remarks section for Georg's engine information

2014-11-23T20:29:27Z

Creating a Remarks section for Georg's engine information

Show changes

BryanDerksen: Category:XLS files

2010-01-28T17:37:15Z

Category:XLS files

Georg Zoeller at 19:40, 27 October 2009

2009-10-27T19:40:24Z

Georg Zoeller: Added some information on the hardcoded engine link functionality.

2009-10-27T19:39:44Z

Added some information on the hardcoded engine link functionality.

BryanDerksen: Created page with 'Depletable properties will be updated by their "combat" every 2 seconds and their "non-combat" values every 5 seconds. EngineLink: * 00 - DerivedDefault * 01 - DerivedAttack * 0...'

2009-07-30T23:05:45Z

Created page with 'Depletable properties will be updated by their "combat" every 2 seconds and their "non-combat" values every 5 seconds. EngineLink: * 00 - DerivedDefault * 01 - DerivedAttack * 0...'

New page

Depletable properties will be updated by their "combat" every 2 seconds and their "non-combat" values every 5 seconds.

EngineLink:
* 00 - DerivedDefault
* 01 - DerivedAttack
* 02 - DerivedDefense
* 03 - DerivedArmor
* 04 - DerivedAP
* 05 - DerivedSpellPower
* 06 - DerivedHealth
* 07 - DerivedManaStamina
* 08 - DerivedResistancePoison
* 09 - DerivedResistanceMind
* 10 - DerivedResistanceEnergy

{{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 above}}
{{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}}

{{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}}

{{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}}

[[Category:2DAs]]

@@ Line 1: / Line 1: @@
 Depletable properties will be updated by their "combat" every 2 seconds and their "non-combat" values every 5 seconds.
-===Properties ==
+== Properties ==
 {{2da start|Properties}}

← Older revision		Revision as of 17:37, 28 January 2010
Line 117:		Line 117:
	{{2da end}}		{{2da end}}

−	[[Category:~~2DAs~~]]	+	[[Category:XLS files]]

@@ Line 15: / Line 15: @@
 * 02 - DerivedDefense: Each point of DEX above 10 adds +1.0 defense
 <dascript>
-   FLOAT32 fDexBonus = (FLOAT32) max( (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_DEXTERITY) -10)   , 0.0) ;
+   return (FLOAT32) max( (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_DEXTERITY) -10)   , 0.0) ;
 </dascript>

@@ 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>
 [[Category:XLS files]]

@@ Line 2: / Line 2: @@
 EngineLink:
-* 00 - DerivedDefault
+* 00 - DerivedDefault : No modification of stats
-* 01 - DerivedAttack
+<dascript>
-* 02 - DerivedDefense
+  return 0; // Nothing
-* 03 - DerivedArmor
+</dascript>
 * 04 - DerivedAP
-* 05 - DerivedSpellPower
+* 01 - DerivedAttack: Each point of STR and DEX above 10 adds + 0.5 attack
-* 06 - DerivedHealth
+<dascript>
-* 07 - DerivedManaStamina
+ return (FLOAT32) ( max( (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_STRENGTH) -10.0f)/2.0f   , 0.0) +
-* 08 - DerivedResistancePoison
+                       max( (cPropertiesList.GetValue(PROPERTY_ATTRIBUTE_DEXTERITY) -10.0f)/2.0f   , 0.0));
-* 09 - DerivedResistanceMind
+</dascript>
-* 10 - DerivedResistanceEnergy
 {{2da start|Properties}}