*Update to Mangos 7151.

--HG--
branch : trunk

8 files changed, 52 insertions, 5 deletions

diff --git a/sql/updates/6958_01_mangos_spell_proc_event.sql b/sql/updates/6958_01_mangos_spell_proc_event.sql
index 06304a19e0e..7deab1f424a 100644
--- a/sql/updates/6958_01_mangos_spell_proc_event.sql
+++ b/sql/updates/6958_01_mangos_spell_proc_event.sql
@@ -20,7 +20,7 @@ CREATE TABLE `spell_proc_event` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- ----------------------------
--- Records 
+-- Records
 -- ----------------------------
 INSERT INTO `spell_proc_event` VALUES
 (324, 0x00000000, 0, 0x0000000000000000, 0x00000000, 0x00000000, 0, 0, 3),
@@ -703,4 +703,4 @@ INSERT INTO `spell_proc_event` VALUES
 (60572, 0x00000000, 11, 0x0000000090100000, 0x00000000, 0x00000000, 0, 0, 0),
 (60617, 0x00000000, 0, 0x0000000000000000, 0x00000000, 0x00000020, 0, 0, 0),
 (60826, 0x00000000, 15, 0x0000000001400000, 0x00000000, 0x00000000, 0, 0, 0),
-(61324, 0x00000000, 10, 0x0002000000000000, 0x00000000, 0x00000000, 0, 0, 0);
\ No newline at end of file
+(61324, 0x00000000, 10, 0x0002000000000000, 0x00000000, 0x00000000, 0, 0, 0);
diff --git a/sql/updates/7044_01_mangos_spell_proc_event.sql b/sql/updates/7044_01_mangos_spell_proc_event.sql
index 576d5611aef..8dc295b7316 100644
--- a/sql/updates/7044_01_mangos_spell_proc_event.sql
+++ b/sql/updates/7044_01_mangos_spell_proc_event.sql
@@ -14,4 +14,4 @@ INSERT INTO `spell_proc_event` VALUES (48111, 0x00, 0, 0x00000000, 0x00000000, 0
 
 -- (48113) Prayer of Mending (Rank 3)
 DELETE FROM `spell_proc_event` WHERE `entry` IN (48113);
-INSERT INTO `spell_proc_event` VALUES (48113, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000, 0); 
\ No newline at end of file
+INSERT INTO `spell_proc_event` VALUES (48113, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/7075_01_characters_character_spell.sql b/sql/updates/7075_01_characters_character_spell.sql
index 4e6ef7ea93b..0ec8e2f2558 100644
--- a/sql/updates/7075_01_characters_character_spell.sql
+++ b/sql/updates/7075_01_characters_character_spell.sql
@@ -10,4 +10,4 @@ DELETE FROM character_spell WHERE `spell` IN (
 
 /*old Shadow Resistance, leaned as racial passive of race 5 */
 DELETE FROM character_spell USING character_spell INNER JOIN characters ON character_spell.guid = characters.guid
-WHERE character_spell.spell = 20579 AND characters.race <> 5; 
+WHERE character_spell.spell = 20579 AND characters.race <> 5;
diff --git a/sql/updates/7078_01_mangos_spell_proc_event.sql b/sql/updates/7078_01_mangos_spell_proc_event.sql
index b5df2f7faa3..ba5369582a2 100644
--- a/sql/updates/7078_01_mangos_spell_proc_event.sql
+++ b/sql/updates/7078_01_mangos_spell_proc_event.sql
@@ -20,4 +20,4 @@ INSERT INTO `spell_proc_event` VALUES (44395, 0x00, 0, 0x00000000, 0x00000000, 0
 DELETE FROM `spell_proc_event` WHERE `entry` IN (44396);
 INSERT INTO `spell_proc_event` VALUES (44396, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000400, 0.000000, 0.000000, 0);
 
- 
\ No newline at end of file
+
diff --git a/sql/updates/7141_01_mangos_instance_template.sql b/sql/updates/7141_01_mangos_instance_template.sql
new file mode 100644
index 00000000000..b21905f3949
--- /dev/null
+++ b/sql/updates/7141_01_mangos_instance_template.sql
@@ -0,0 +1,12 @@
+ALTER TABLE db_version CHANGE COLUMN required_7133_02_mangos_spell_loot_template required_7141_01_mangos_instance_template bit;
+
+ALTER TABLE instance_template ADD maxPlayersHeroic tinyint(3) unsigned NOT NULL default '0' AFTER maxPlayers;
+
+UPDATE instance_template SET maxPlayersHeroic = maxPlayers;
+
+DELETE FROM instance_template WHERE map IN (533,615,616,624);
+INSERT INTO instance_template VALUES
+(533,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''),
+(615,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''),
+(616,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''),
+(624,0,80,0,10,25,0,NULL,NULL,NULL,NULL,'');
diff --git a/sql/updates/7147_01_mangos_creature_template.sql b/sql/updates/7147_01_mangos_creature_template.sql
new file mode 100644
index 00000000000..286718b8edb
--- /dev/null
+++ b/sql/updates/7147_01_mangos_creature_template.sql
@@ -0,0 +1,4 @@
+ALTER TABLE db_version CHANGE COLUMN required_7141_01_mangos_instance_template required_7147_01_mangos_creature_template bit;
+
+UPDATE creature_template
+  SET family = 0 WHERE entry = 1;
diff --git a/sql/updates/7149_01_mangos_spell_proc_event.sql b/sql/updates/7149_01_mangos_spell_proc_event.sql
new file mode 100644
index 00000000000..1dcaf8e5e3d
--- /dev/null
+++ b/sql/updates/7149_01_mangos_spell_proc_event.sql
@@ -0,0 +1,21 @@
+ALTER TABLE db_version CHANGE COLUMN required_7147_01_mangos_creature_template required_7149_01_mangos_spell_proc_event bit;
+
+-- (53501) Sheath of Light (Rank 1)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (53501);
+INSERT INTO `spell_proc_event` VALUES (53501, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
+
+-- (53502) Sheath of Light (Rank 2)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (53502);
+INSERT INTO `spell_proc_event` VALUES (53502, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
+
+-- (53503) Sheath of Light (Rank 3)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (53503);
+INSERT INTO `spell_proc_event` VALUES (53503, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
+
+-- (53228) Rapid Recuperation (Rank 1)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (53228);
+INSERT INTO `spell_proc_event` VALUES (53228, 0x00, 9, 0x00000020, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
+
+-- (53232) Rapid Recuperation (Rank 2)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (53232);
+INSERT INTO `spell_proc_event` VALUES (53232, 0x00, 9, 0x00000020, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/7150_01_mangos_playercreateinfo_spell.sql b/sql/updates/7150_01_mangos_playercreateinfo_spell.sql
new file mode 100644
index 00000000000..aba3540be32
--- /dev/null
+++ b/sql/updates/7150_01_mangos_playercreateinfo_spell.sql
@@ -0,0 +1,10 @@
+ALTER TABLE db_version CHANGE COLUMN required_7149_01_mangos_spell_proc_event required_7150_01_mangos_playercreateinfo_spell bit;
+
+DELETE FROM `playercreateinfo_spell` WHERE Spell = 58284;
+
+INSERT INTO `playercreateinfo_spell` VALUES
+(1,9,58284,'Chaos Bolt Passive'),
+(2,9,58284,'Chaos Bolt Passive'),
+(5,9,58284,'Chaos Bolt Passive'),
+(7,9,58284,'Chaos Bolt Passive'),
+(10,9,58284,'Chaos Bolt Passive');