diff options
| -rw-r--r-- | sql/base/characters_database.sql | 1 | ||||
| -rw-r--r-- | sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql | 1 | ||||
| -rwxr-xr-x | src/server/game/Entities/Player/Player.cpp | 5 |
3 files changed, 5 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 1351baae44f..0f8aa2fd9b0 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1055,6 +1055,7 @@ CREATE TABLE `character_stats` ( `attackPower` int(10) unsigned NOT NULL DEFAULT '0', `rangedAttackPower` int(10) unsigned NOT NULL DEFAULT '0', `spellPower` int(10) unsigned NOT NULL DEFAULT '0', + `resilience` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql b/sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql new file mode 100644 index 00000000000..24defd48f60 --- /dev/null +++ b/sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql @@ -0,0 +1 @@ +ALTER TABLE `character_stats` ADD `resilience` INT UNSIGNED NOT NULL DEFAULT 0; diff --git a/src/server/game/Entities/Player/Player.cpp b/src/server/game/Entities/Player/Player.cpp index 46325984ad2..738ff2abd97 100755 --- a/src/server/game/Entities/Player/Player.cpp +++ b/src/server/game/Entities/Player/Player.cpp @@ -18757,7 +18757,7 @@ void Player::_SaveStats(SQLTransaction& trans) std::ostringstream ss; ss << "INSERT INTO character_stats (guid, maxhealth, maxpower1, maxpower2, maxpower3, maxpower4, maxpower5, maxpower6, maxpower7, " "strength, agility, stamina, intellect, spirit, armor, resHoly, resFire, resNature, resFrost, resShadow, resArcane, " - "blockPct, dodgePct, parryPct, critPct, rangedCritPct, spellCritPct, attackPower, rangedAttackPower, spellPower) VALUES (" + "blockPct, dodgePct, parryPct, critPct, rangedCritPct, spellCritPct, attackPower, rangedAttackPower, spellPower, resilience) VALUES (" << GetGUIDLow() << ", " << GetMaxHealth() << ", "; for (uint8 i = 0; i < MAX_POWERS; ++i) @@ -18775,7 +18775,8 @@ void Player::_SaveStats(SQLTransaction& trans) << GetFloatValue(PLAYER_SPELL_CRIT_PERCENTAGE1) << ", " << GetUInt32Value(UNIT_FIELD_ATTACK_POWER) << ", " << GetUInt32Value(UNIT_FIELD_RANGED_ATTACK_POWER) << ", " - << GetBaseSpellPowerBonus() << ")"; + << GetBaseSpellPowerBonus() << ", " + << GetUInt32Value(PLAYER_FIELD_COMBAT_RATING_1 + CR_CRIT_TAKEN_SPELL) << ")"; trans->Append(ss.str().c_str()); } |