*Mangos Implement AURA_STATE_HEALTH_ABOVE_75_PERCENT use. By DiSlord.

*Mangos [7045]. More correct spell select for creatures if spell PreventionType == SPELL_PREVENTION_TYPE_SILENCE. Also add check for PreventionType == SPELL_PREVENTION_TYPE_PACIFY. By DiSlord.
*Mangos [7046] Do more security level checks in commands using HasLowerSecurity. Make use .account set addon safe for players. By Vladimir.
*Mangos [7047] Fix Draenei race spell add at client switch. By DiSlord.

--HG--
branch : trunk

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`,