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

2 files changed, 94 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;
diff --git a/sql/updates/world/2014_07_01_02_world playercreateinfo_skills.sql b/sql/updates/world/2014_07_01_02_world playercreateinfo_skills.sql
new file mode 100644
index 00000000000..8eb452afa96
--- /dev/null
+++ b/sql/updates/world/2014_07_01_02_world playercreateinfo_skills.sql
@@ -0,0 +1,90 @@
+DROP TABLE IF EXISTS `playercreateinfo_spells`;
+
+DROP TABLE IF EXISTS `playercreateinfo_skills`;
+CREATE TABLE `playercreateinfo_skills` (
+  `raceMask` int(10) unsigned NOT NULL,
+  `classMask` int(10) unsigned NOT NULL,
+  `skill` smallint(5) unsigned NOT NULL,
+  `rank` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `comment` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`raceMask`,`classMask`,`skill`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+INSERT INTO `playercreateinfo_skills` VALUES
+(0,0,95,0,'Defense'),
+(0,0,162,0,'Unarmed'),
+(0,0,183,0,'GENERIC (DND)'),
+(0,0,415,0,'Cloth'),
+(0,0,777,0,'Mounts'),
+(0,0,778,0,'Companion Pets'),
+(0,1,26,0,'Warrior - Arms'),
+(0,1,256,0,'Warrior - Fury'),
+(0,1,257,0,'Warrior - Protection'),
+(0,2,184,0,'Paladin - Retribution'),
+(0,2,267,0,'Paladin - Protection'),
+(0,2,594,0,'Paladin - Holy'),
+(0,4,50,0,'Hunter - Beast Mastery'),
+(0,4,51,0,'Hunter - Survival'),
+(0,4,163,0,'Hunter - Marksmanship'),
+(0,8,38,0,'Rogue - Combat'),
+(0,8,39,0,'Rogue - Subtlety'),
+(0,8,176,0,'Thrown'),
+(0,8,253,0,'Rogue - Assassination'),
+(0,16,56,0,'Priest - Holy'),
+(0,16,78,0,'Priest - Shadow'),
+(0,16,613,0,'Priest - Discipline'),
+(0,32,129,4,'Death Knight - First Aid'),
+(0,32,229,0,'Polearms'),
+(0,32,293,0,'Plate'),
+(0,32,762,0,'Death Knight - Riding'),
+(0,32,770,0,'Death Knight - Blood'),
+(0,32,771,0,'Death Knight - Frost'),
+(0,32,772,0,'Death Knight - Unholy'),
+(0,35,55,0,'Two-Handed Swords'),
+(0,35,413,0,'Mail'),
+(0,37,44,0,'Axes'),
+(0,37,172,0,'Two-Handed Axes'),
+(0,39,43,0,'Swords'),
+(0,40,118,0,'Dual Wield'),
+(0,64,373,0,'Shaman - Enhancement'),
+(0,64,374,0,'Shaman - Restoration'),
+(0,64,375,0,'Shaman - Elemental'),
+(0,67,433,0,'Shield'),
+(0,128,6,0,'Mage - Frost'),
+(0,128,8,0,'Mage - Fire'),
+(0,128,237,0,'Mage - Arcane'),
+(0,256,354,0,'Warlock - Demonology'),
+(0,256,355,0,'Warlock - Affliction'),
+(0,256,593,0,'Warlock - Destruction'),
+(0,400,228,0,'Wands'),
+(0,1024,134,0,'Druid - Feral'),
+(0,1024,573,0,'Druid - Restoration'),
+(0,1024,574,0,'Druid - Balance'),
+(0,1107,54,0,'Maces'),
+(0,1135,414,0,'Leather'),
+(0,1488,136,0,'Staves'),
+(1,0,754,0,'Human - Racial'),
+(2,0,125,0,'Orc - Racial'),
+(4,0,101,0,'Dwarf - Racial'),
+(4,0,111,0,'Language: Dwarven'),
+(8,0,126,0,'Night Elf - Racial'),
+(8,0,137,0,'Language: Thalassian'),
+(16,0,220,0,'Undead - Racial'),
+(16,0,673,0,'Language: Forsaken'),
+(32,0,113,0,'Language: Darnassian'),
+(32,0,124,0,'Tauren - Racial'),
+(36,4,46,0,'Guns'),
+(64,0,313,0,'Language: Gnomish'),
+(64,0,753,0,'Gnome - Racial'),
+(128,0,315,0,'Language: Troll'),
+(128,0,733,0,'Troll - Racial'),
+(512,0,115,0,'Language: Taurahe'),
+(512,0,756,0,'Blood Elf - Racial'),
+(650,4,45,0,'Bows'),
+(690,0,109,0,'Language: Orcish'),
+(735,1293,173,0,'Daggers'),
+(1024,0,759,0,'Language: Draenei'),
+(1024,0,760,0,'Draenei - Racial'),
+(1024,4,226,0,'Crossbows'),
+(1061,3,160,0,'Two-Handed Maces'),
+(1101,0,98,0,'Language: Common');