diff options
| author | Shauren <shauren.trinity@gmail.com> | 2014-07-01 17:20:48 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2014-07-01 17:20:48 +0200 |
| commit | 2a3546ca36468b81d673bdb27315006144af3165 (patch) | |
| tree | 21e7c391111547d233d3ea4dabcb49d00b3c7aa3 /sql/updates/characters | |
| parent | d4cec6b397839ee7ff8bc501c5069dad31787116 (diff) | |
Core/Skills: Use SkillLineAbility.dbc to determine player initial spells - skill assignment done in a new table `playercreateinfo_skills`
* Removed DK start skill hacks
* Resolved missing skills in character skill tab
Closes #12311
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/2014_07_01_00_characters_character_skills.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/characters/2014_07_01_00_characters_character_skills.sql b/sql/updates/characters/2014_07_01_00_characters_character_skills.sql new file mode 100644 index 00000000000..1987adb064c --- /dev/null +++ b/sql/updates/characters/2014_07_01_00_characters_character_skills.sql @@ -0,0 +1,4 @@ +-- Set fist weapon skill equal to current unarmed skill value +UPDATE character_skills cs_unarmed INNER JOIN character_skills cs_fist ON cs_unarmed.guid = cs_fist.guid +SET cs_fist.value = cs_unarmed.value, cs_fist.max = cs_unarmed.max +WHERE cs_unarmed.skill = 162 AND cs_fist.skill = 473; |