diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/01_characters_character_spell.sql | 9 | ||||
| -rw-r--r-- | sql/updates/02_mangos_playercreateinfo_action.sql | 9 | ||||
| -rw-r--r-- | sql/updates/03_mangos_playercreateinfo_spell.sql | 10 | ||||
| -rw-r--r-- | sql/updates/TBC-WLK_characters.sql | 29 |
4 files changed, 57 insertions, 0 deletions
diff --git a/sql/updates/01_characters_character_spell.sql b/sql/updates/01_characters_character_spell.sql new file mode 100644 index 00000000000..fa17e0c4c33 --- /dev/null +++ b/sql/updates/01_characters_character_spell.sql @@ -0,0 +1,9 @@ +DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); + +INSERT INTO character_spell SELECT characters.guid as guid, 28880, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; +INSERT INTO character_spell SELECT characters.guid as guid, 59542, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; +INSERT INTO character_spell SELECT characters.guid as guid, 59543, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3; +INSERT INTO character_spell SELECT characters.guid as guid, 59544, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; +INSERT INTO character_spell SELECT characters.guid as guid, 59545, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; +INSERT INTO character_spell SELECT characters.guid as guid, 59547, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; +INSERT INTO character_spell SELECT characters.guid as guid, 59548, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8; diff --git a/sql/updates/02_mangos_playercreateinfo_action.sql b/sql/updates/02_mangos_playercreateinfo_action.sql new file mode 100644 index 00000000000..834753dcd71 --- /dev/null +++ b/sql/updates/02_mangos_playercreateinfo_action.sql @@ -0,0 +1,9 @@ +DELETE FROM `playercreateinfo_action` WHERE `action` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); +INSERT INTO `playercreateinfo_action` VALUES +(11,1,74,28880,0,0), +(11,2,3,59542,0,0), +(11,3,3,59543,0,0), +(11,5,3,59544,0,0), +(11,6,6,59545,0,0), +(11,7,3,59547,0,0), +(11,8,3,59548,0,0);
\ No newline at end of file diff --git a/sql/updates/03_mangos_playercreateinfo_spell.sql b/sql/updates/03_mangos_playercreateinfo_spell.sql new file mode 100644 index 00000000000..cd55d875aec --- /dev/null +++ b/sql/updates/03_mangos_playercreateinfo_spell.sql @@ -0,0 +1,10 @@ +DELETE FROM `playercreateinfo_spell` WHERE `Spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); + +INSERT INTO `playercreateinfo_spell` VALUES +(11,1,28880,'Gift of the Naaru',1), +(11,2,59542,'Gift of the Naaru',1), +(11,3,59543,'Gift of the Naaru',1), +(11,5,59544,'Gift of the Naaru',1), +(11,6,59545,'Gift of the Naaru',1), +(11,7,59547,'Gift of the Naaru',1), +(11,8,59548,'Gift of the Naaru',1);
\ No newline at end of file diff --git a/sql/updates/TBC-WLK_characters.sql b/sql/updates/TBC-WLK_characters.sql index d7a90514207..cf7819d96e3 100644 --- a/sql/updates/TBC-WLK_characters.sql +++ b/sql/updates/TBC-WLK_characters.sql @@ -1,3 +1,32 @@ +DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); +INSERT INTO character_spell SELECT characters.guid as guid, 28880, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; +INSERT INTO character_spell SELECT characters.guid as guid, 59542, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; +INSERT INTO character_spell SELECT characters.guid as guid, 59543, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3; +INSERT INTO character_spell SELECT characters.guid as guid, 59544, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; +INSERT INTO character_spell SELECT characters.guid as guid, 59545, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; +INSERT INTO character_spell SELECT characters.guid as guid, 59547, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; +INSERT INTO character_spell SELECT characters.guid as guid, 59548, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8; + +DELETE FROM `playercreateinfo_action` WHERE `action` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); +INSERT INTO `playercreateinfo_action` VALUES +(11,1,74,28880,0,0), +(11,2,3,59542,0,0), +(11,3,3,59543,0,0), +(11,5,3,59544,0,0), +(11,6,6,59545,0,0), +(11,7,3,59547,0,0), +(11,8,3,59548,0,0); + +DELETE FROM `playercreateinfo_spell` WHERE `Spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); +INSERT INTO `playercreateinfo_spell` VALUES +(11,1,28880,'Gift of the Naaru',1), +(11,2,59542,'Gift of the Naaru',1), +(11,3,59543,'Gift of the Naaru',1), +(11,5,59544,'Gift of the Naaru',1), +(11,6,59545,'Gift of the Naaru',1), +(11,7,59547,'Gift of the Naaru',1), +(11,8,59548,'Gift of the Naaru',1); + alter table `character_pet` drop column `trainpoint`, drop column `loyaltypoints`, |