DB/World: Cherry-pick 27 commits from 3.3.5

221a874d707d0a9982db230cb3db524eb9e879c0 DB/Quest: Rivenwood Captives By Killyana, closes #3648 dbaf88566be7083408fb8324d7886dc3e0a45cc0 DB/Text: Fix wrong broadcast text id f5530c719b71309bd476aff528b0d3e1220ca49b DB/Misc: Megzeg Nukklebust By @tkrokli Closes #14863 d08524cfeb9028ead9c378cf18ddf21c63c88a2a DB/Path: Sunreaver Hawkrider in Crystalsong Forest b067f20f4a0e5ba02b4026a7edae3a5d161e46c6 DB: Fix date for file 0d66b1917e53b38f5a0b6ee44c59e76315405bd6 DB/Path: Silver Covenant Horseman in Crystalsong Forest/Windrunner's Overlook 89c6e5dcf4d8a4168802171b80dca2a3330d2d19 DB/Misc: Various fixes * Quest rewards for Kael'thas and the Verdant Sphere - Closes #14452 * Quest rewards for The Cipher of Damnation - Closes #14879 * VOA Meeting stone - Closes #10502 * Fix a db error 6af3bc69970d3009a8e193fd2d3041232fbbd3e7 Fix file name 170ba68e63c46323f8624ecff24e6de1d38bd97b DB/Quest: Hellfire Fortifications By tkrokli, closes #14887 d5c84d5aaafdb3960e0f497168bcf87c0ae93702 DB/Path: Gundrak Savage pathing 20e3da1e5b3e366dc3f79d869078862e6f399f78 Fix file name c8ee638517777d1a0e14c55f26341da8fa6d1f21 DB/Quest: Fix 2 swapped values of midsummer event a29433fbab6e6fe023413af1c9d2d850328f6ac0 DB/Quest: I've Got a Flying Machine Closes https://github.com/TrinityCore/TrinityCore/issues/14965 By Killyana 791356c27e8ec68a49018009d7d1202d9efea2f5 DB/Oculus: mob missing spells / visuals e243df4df92e477509c37ac4fd54e49c71e79cd0 DB/Oculus: typo in sql 813a903746c9e5d8915453309c38259a635c086a DB/Misc: Fix startup errors By Killyana, updates #14730 7e5307b9f36bb2afb4c368e1a09ff96cf5d9af4f DB/Creature: Innkeeper Keldamyr By MrSmite, closes #12474 77d083eb16758832bf465d460ff6275ba8de8445 DB/Quest: The Perfect Dissemblance By Killyana, closes #12439 9132cfe5e317f8fc4c58a7eb2c39d4f0e82002df DB/Quest: A Race Against Time By Killyana, closes #1074 d3590f92c21b7a36bd2410eb17dfde068510e22a DB/Quest: Master the Storm By Killyana, closes #1883 3720be33e15426ddc3a52edf0a31044d01a8d63e DB/Gameobject: Silithyst Mound By Killyana, closes #14637 5b6cbe88d3fda2dc2097319d912204dba8f3233d Update 2015_06_28_02_world.sql 6527046ede419d35a769621bc55d911e52744494 DB/Misc: Fix a runtime error By Killyana, updates #14730 5ff80739ef0031c1a93c6550062742bf2efd209e DB/Creature: Fixing some auras set with a wrong event By Killyana, closes #14875 7c7d258482cb541b9a57fd9ff9b64f01c51cf4cb DB/Misc: Brewfest - Wrong item in vendors By sirikfoll, closes #14989 fd299c53dc491de4dd7b8cfaa2c5b07e31dbd4be DB/Misc: Spawn several missing gameobjects and creatures in The Eye - Several pack of mobs and triggers spawned - Spawned doors at Kael's room - Corrected spawn coords for Kael'thas and his advisors from sniffs - Removed improper spawns of Ember of Alar b4a293fd346d622e25e30fca8fe5206be2da3745 SQL: Quickfix a typo
author: DDuarte <dnpd.dd@gmail.com> 2015-07-12 23:21:24 +0100
committer: DDuarte <dnpd.dd@gmail.com> 2015-07-12 23:21:42 +0100
commit: 828e2bdd02b1f31db47746e76aa7cd2c9c4e65b9 (patch)
tree: da07903f61bbb17a34c6257ec4ba4e5deaf8eb24
parent: ebd081abaeeb72ed89ff6e09949630d6665cdccf (diff)
21 files changed, 1018 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_12_33_world_2015_06_06_12.sql b/sql/updates/world/2015_07_12_33_world_2015_06_06_12.sql
new file mode 100644
index 00000000000..06ff734a74c
--- /dev/null
+++ b/sql/updates/world/2015_07_12_33_world_2015_06_06_12.sql
@@ -0,0 +1,2 @@
+--
+UPDATE `creature_template` SET `unit_flags`=4, `flags_extra`=2 WHERE `entry`=24210;
diff --git a/sql/updates/world/2015_07_12_34_world_2015_06_08_00.sql b/sql/updates/world/2015_07_12_34_world_2015_06_08_00.sql
new file mode 100644
index 00000000000..c375b89aa72
--- /dev/null
+++ b/sql/updates/world/2015_07_12_34_world_2015_06_08_00.sql
@@ -0,0 +1 @@
+UPDATE `creature_text` SET `BroadcastTextId`=24497 WHERE  `entry`=25256 AND `groupid`=6 AND `id`=0;
diff --git a/sql/updates/world/2015_07_12_35_world_2015_06_11_00.sql b/sql/updates/world/2015_07_12_35_world_2015_06_11_00.sql
new file mode 100644
index 00000000000..2e5e4786c13
--- /dev/null
+++ b/sql/updates/world/2015_07_12_35_world_2015_06_11_00.sql
@@ -0,0 +1,4 @@
+-- Set correct npcflag for NPC ID 21283, Megzeg Nukklebust
+-- He is neither a vendor nor repair NPC
+UPDATE `creature_template` SET `npcflag` = 3 WHERE `entry`= 21283;
+UPDATE `creature_template_addon` SET `bytes2` = 257 WHERE `entry`= 21283;
diff --git a/sql/updates/world/2015_07_12_36_world_2015_06_12_00.sql b/sql/updates/world/2015_07_12_36_world_2015_06_12_00.sql
new file mode 100644
index 00000000000..2ed3766deae
--- /dev/null
+++ b/sql/updates/world/2015_07_12_36_world_2015_06_12_00.sql
@@ -0,0 +1,65 @@
+DELETE FROM `creature_formations` WHERE `leaderGUID`=101017;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(101017, 101017, 0, 0, 1),
+(101017, 101016, 2, 45, 2);
+
+-- Pathing for Sunreaver Hawkrider Entry: 30265 'TDB FORMAT' 
+SET @NPC := 101017;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5586.633,`position_y`=-658.4381,`position_z`=204.5775 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,28889,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,5586.633,-658.4381,204.5775,0,0,0,0,100,0),
+(@PATH,2,5585.409,-655.815,203.7495,0,0,0,0,100,0),
+(@PATH,3,5584.759,-647.1207,202.7112,0,0,0,0,100,0),
+(@PATH,4,5589.797,-633.0928,200.7699,0,0,0,0,100,0),
+(@PATH,5,5598.13,-621.1475,198.2848,0,0,0,0,100,0),
+(@PATH,6,5592.634,-628.2191,199.8846,0,0,0,0,100,0),
+(@PATH,7,5585.994,-641.5278,201.9498,0,0,0,0,100,0),
+(@PATH,8,5584.441,-650.3018,203.0215,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=100987;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(100987, 100987, 0, 0, 1),
+(100987, 100986, 2, 45, 2);
+
+-- Pathing for Sunreaver Hawkrider Entry: 30265 'TDB FORMAT' 
+SET @NPC := 100987;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5615.299,`position_y`=-711.0152,`position_z`=206.286 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,28889,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,5615.299,-711.0152,206.286,0,0,0,0,100,0),
+(@PATH,2,5608.708,-695.2381,206.6548,0,0,0,0,100,0),
+(@PATH,3,5598.26,-684.2681,206.6482,0,0,0,0,100,0),
+(@PATH,4,5595.715,-675.8694,206.6474,0,0,0,0,100,0),
+(@PATH,5,5589.645,-664.4355,205.7086,0,0,0,0,100,0),
+(@PATH,6,5593.898,-670.5458,206.5087,0,0,0,0,100,0),
+(@PATH,7,5596.294,-679.0742,206.6474,0,0,0,0,100,0),
+(@PATH,8,5606.79,-693.2242,206.6536,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=100984;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(100984, 100984, 0, 0, 1),
+(100984, 100985, 2, 45, 2);
+
+-- Pathing for Sunreaver Hawkrider Entry: 30265 'TDB FORMAT' 
+SET @NPC := 100984;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5603.461,`position_y`=-753.2111,`position_z`=198.3089 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,28889,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,5603.461,-753.2111,198.3089,0,0,0,0,100,0),
+(@PATH,2,5609.75,-744.6108,201.4747,0,0,0,0,100,0),
+(@PATH,3,5614.047,-736.9058,203.5394,0,0,0,0,100,0),
+(@PATH,4,5617.86,-725.5508,204.9431,0,0,0,0,100,0),
+(@PATH,5,5618.354,-717.699,205.5509,0,0,0,0,100,0),
+(@PATH,6,5618.291,-721.7224,205.229,0,0,0,0,100,0),
+(@PATH,7,5616.521,-730.5341,204.4404,0,0,0,0,100,0),
+(@PATH,8,5613.125,-738.7379,203.1023,0,0,0,0,100,0);
diff --git a/sql/updates/world/2015_07_12_37_world_2015_06_13_00.sql b/sql/updates/world/2015_07_12_37_world_2015_06_13_00.sql
new file mode 100644
index 00000000000..b360ce4e3bc
--- /dev/null
+++ b/sql/updates/world/2015_07_12_37_world_2015_06_13_00.sql
@@ -0,0 +1,112 @@
+DELETE FROM `creature_formations` WHERE `leaderGUID`=100887;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(100887, 100887, 0, 0, 1),
+(100887, 100888, 2, 90, 2);
+
+-- Pathing for Silver Covenant Horseman Entry: 30263 'TDB FORMAT' 
+SET @NPC := 100887;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5067.709,`position_y`=-623.0535,`position_z`=216.2992 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,2410,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,5067.709,-623.0535,216.2992,0,0,0,0,100,0), -- 20:33:40
+(@PATH,2,5064.371,-619.6366,217.7106,0,0,0,0,100,0), -- 20:33:46
+(@PATH,3,5064.18,-607.0121,219.5005,0,0,0,0,100,0), -- 20:33:50
+(@PATH,4,5065.22,-602.5242,220.0495,0,0,0,0,100,0), -- 20:33:56
+(@PATH,5,5064.4,-593.0133,220.2778,0,0,0,0,100,0), -- 20:33:59
+(@PATH,6,5062.952,-571.7712,220.2518,0,0,0,0,100,0), -- 20:34:08
+(@PATH,7,5062.632,-572.1309,220.0737,0,0,0,0,100,0), -- 20:34:17
+(@PATH,8,5062.766,-572.0648,220.3171,0,0,0,0,100,0), -- 20:34:24
+(@PATH,9,5064.708,-593.1912,220.1846,0,0,0,0,100,0), -- 20:34:32
+(@PATH,10,5063.012,-612.4286,219.0811,0,0,0,0,100,0), -- 20:34:36
+(@PATH,11,5066.325,-621.582,216.7641,0,0,0,0,100,0), -- 20:34:42
+(@PATH,12,5067.825,-623.082,216.2641,0,0,0,0,100,0); -- 20:34:42
+-- 0x1C392447601D8DC000000C000077FF13 .go 5067.709 -623.0535 216.2992
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=100898;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(100898, 100898, 0, 0, 1),
+(100898, 100899, 2, 90, 2);
+
+-- Pathing for Silver Covenant Horseman Entry: 30263 'TDB FORMAT' 
+SET @NPC := 100898;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5076.637,`position_y`=-639.3936,`position_z`=210.1455 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,2410,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,5076.637,-639.3936,210.1455,0,0,0,0,100,0), -- 11:59:49
+(@PATH,2,5079.917,-659.7036,200.968,0,0,0,0,100,0), -- 12:00:00
+(@PATH,3,5079.445,-679.8152,193.9069,0,0,0,0,100,0), -- 12:00:08
+(@PATH,4,5081.471,-688.5268,190.5579,0,0,0,0,100,0), -- 12:00:17
+(@PATH,5,5091.792,-703.2252,184.7582,0,0,0,0,100,0), -- 12:00:22
+(@PATH,6,5099.77,-708.3243,181.946,0,0,0,0,100,0), -- 12:00:29
+(@PATH,7,5094.969,-706.1178,183.7631,0,0,0,0,100,0), -- 12:00:34
+(@PATH,8,5082.577,-691.327,189.5212,0,0,0,0,100,0), -- 12:00:36
+(@PATH,9,5080.255,-683.3011,192.4193,0,0,0,0,100,0), -- 12:00:45
+(@PATH,10,5080.166,-662.0288,199.9953,0,0,0,0,100,0); -- 12:00:49
+-- 0x1C392447601D8DC000000C000077FF7B .go 5076.637 -639.3936 210.1455
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=100889;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(100889, 100889, 0, 0, 1),
+(100889, 100890, 2, 90, 2);
+
+-- Pathing for Silver Covenant Horseman Entry: 30263 'TDB FORMAT' 
+SET @NPC := 100889;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5060.026,`position_y`=-538.408,`position_z`=220.0076 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,2410,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,5060.026,-538.408,220.0076,0,0,0,0,100,0), -- 12:00:56
+(@PATH,2,5059.559,-537.8341,220.0076,2.070161,0,0,0,100,0), -- 12:00:57
+(@PATH,3,5058.987,-537.1638,220.0076,0,0,0,0,100,0), -- 12:00:57
+(@PATH,4,5057.041,-534.8303,219.9673,0,0,0,0,100,0), -- 12:00:58
+(@PATH,5,5055.152,-532.5667,219.8454,0,0,0,0,100,0), -- 12:00:59
+(@PATH,6,5053.768,-528.5505,219.8488,0,0,0,0,100,0), -- 12:01:01
+(@PATH,7,5054.296,-525.5225,219.4218,0,0,0,0,100,0), -- 12:01:02
+(@PATH,8,5055.446,-521.4495,219.3181,0,0,0,0,100,0), -- 12:01:03
+(@PATH,9,5057.875,-519.7457,218.8674,0,0,0,0,100,0), -- 12:01:04
+(@PATH,10,5059.473,-518.8138,218.6286,0,0,0,0,100,0), -- 12:01:05
+(@PATH,11,5061.776,-517.084,217.916,0,0,0,0,100,0), -- 12:01:07
+(@PATH,12,5064.104,-515.4176,217.0972,0,0,0,0,100,0), -- 12:01:08
+(@PATH,13,5065.635,-514.3111,215.9073,0,0,0,0,100,0), -- 12:01:09
+(@PATH,14,5068.912,-512.2123,214.4262,0,0,0,0,100,0), -- 12:01:10
+(@PATH,15,5070.144,-511.1482,213.5484,0,0,0,0,100,0), -- 12:01:12
+(@PATH,16,5073.149,-509.0605,212.3315,0,0,0,0,100,0), -- 12:01:13
+(@PATH,17,5074.678,-507.9399,211.4917,0,0,0,0,100,0), -- 12:01:14
+(@PATH,18,5078.117,-505.9191,209.5764,0,0,0,0,100,0), -- 12:01:15
+(@PATH,19,5079.734,-505.1035,208.2059,0,0,0,0,100,0), -- 12:01:16
+(@PATH,20,5082.03,-503.8705,206.9615,0,0,0,0,100,0), -- 12:01:18
+(@PATH,21,5085.192,-502.0856,205.0636,0,0,0,0,100,0), -- 12:01:19
+(@PATH,22,5087.563,-500.825,203.5342,0,0,0,0,100,0), -- 12:01:20
+(@PATH,23,5088.891,-500.0888,202.8326,0,0,0,0,100,0), -- 12:01:21
+(@PATH,24,5090.603,-499.18,201.682,0,0,0,0,100,0), -- 12:01:23
+(@PATH,25,5090.519,-499.2244,201.7328,-2.536886,0,0,0,100,0), -- 12:01:23
+(@PATH,26,5089.623,-499.7004,202.2772,0,0,0,0,100,0), -- 12:01:24
+(@PATH,27,5088.674,-500.0867,202.9039,0,0,0,0,100,0), -- 12:01:25
+(@PATH,28,5085.627,-501.6739,204.7783,0,0,0,0,100,0), -- 12:01:26
+(@PATH,29,5083.288,-502.9158,206.4351,0,0,0,0,100,0), -- 12:01:27
+(@PATH,30,5081.008,-504.1263,207.5976,0,0,0,0,100,0), -- 12:01:29
+(@PATH,31,5078.845,-505.3429,208.9937,0,0,0,0,100,0), -- 12:01:30
+(@PATH,32,5076.814,-506.5785,210.2388,0,0,0,0,100,0), -- 12:01:31
+(@PATH,33,5073.882,-508.545,211.8869,0,0,0,0,100,0), -- 12:01:32
+(@PATH,34,5072.41,-509.5816,212.7734,0,0,0,0,100,0), -- 12:01:33
+(@PATH,35,5069.576,-511.4619,214.2128,0,0,0,0,100,0), -- 12:01:35
+(@PATH,36,5067.752,-512.8409,215.1404,0,0,0,0,100,0), -- 12:01:36
+(@PATH,37,5064.977,-514.6848,216.6034,0,0,0,0,100,0), -- 12:01:37
+(@PATH,38,5063.138,-516.0745,217.341,0,0,0,0,100,0), -- 12:01:38
+(@PATH,39,5060.213,-518.0273,218.5601,0,0,0,0,100,0), -- 12:01:40
+(@PATH,40,5056.744,-520.0189,219.1413,0,0,0,0,100,0), -- 12:01:41
+(@PATH,41,5054.522,-524.2232,219.3947,0,0,0,0,100,0), -- 12:01:42
+(@PATH,42,5053.996,-527.2253,219.6623,0,0,0,0,100,0), -- 12:01:43
+(@PATH,43,5053.982,-531.1642,219.9596,0,0,0,0,100,0), -- 12:01:44
+(@PATH,44,5056.037,-533.6272,219.9433,0,0,0,0,100,0), -- 12:01:46
+(@PATH,45,5058.094,-536.0921,219.9923,0,0,0,0,100,0), -- 12:01:47
+(@PATH,46,5060.026,-538.408,220.0076,0,0,0,0,100,0); -- 12:01:48
+-- 0x1C392447601D8DC000000C0000F7FF07 .go 5060.026 -538.408 220.0076
diff --git a/sql/updates/world/2015_07_12_38_world_2015_06_13_01.sql b/sql/updates/world/2015_07_12_38_world_2015_06_13_01.sql
new file mode 100644
index 00000000000..a04fed7e0ff
--- /dev/null
+++ b/sql/updates/world/2015_07_12_38_world_2015_06_13_01.sql
@@ -0,0 +1,42 @@
+-- Rewards for Kael'Thas and the Verdant Sphere
+
+UPDATE `quest_template` SET
+`RewardChoiceItemId1`=30018, -- Lord Sanguinar's Claim
+`RewardChoiceItemId2`=30017, -- Telonicus' Pendant of Mayhem
+`RewardChoiceItemId3`=30007, -- The Darkener's Grasp
+`RewardChoiceItemId4`=30015, -- The Sun King's Talisman
+`RewardChoiceItemQuantity1`=1,
+`RewardChoiceItemQuantity2`=1,
+`RewardChoiceItemQuantity3`=1,
+`RewardChoiceItemQuantity4`=1 WHERE `Id`=11007;
+
+-- Rewards for The Cipher of Damnation
+
+UPDATE `quest_template` SET
+`RewardItem1`=31074, -- Amulet of the Torn-Heart
+`RewardChoiceItemId1`=31073, -- Borak's Reminder
+`RewardChoiceItemId2`=31071, -- Grom'tor's Charge
+`RewardChoiceItemId3`=31072, -- Lohn'goron, Bow of the Torn-Heart
+`RewardChoiceItemId4`=31036, -- Oronok's Ancient Scepter
+`RewardChoiceItemId5`=31062, -- Torn-Heart Axe of Battle
+`RewardChoiceItemId6`=31038, -- Staff of the Redeemer
+`RewardAmount1`=1, 
+`RewardChoiceItemQuantity1`=1,
+`RewardChoiceItemQuantity2`=1,
+`RewardChoiceItemQuantity3`=1,
+`RewardChoiceItemQuantity4`=1,
+`RewardChoiceItemQuantity5`=1,
+`RewardChoiceItemQuantity6`=1 WHERE `Id`=10588;
+
+-- Voa Summon Stone
+
+SET @OGUID=35834;
+DELETE FROM `gameobject` WHERE `id` IN (195013);
+INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`position_x`,`position_y`,`position_z`,`orientation`, `rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
+(@OGUID,195013,571,65,5476.19,2861.76,418.675,0,1,300,255,1);
+
+UPDATE `creature` SET `position_x`=5407.84,`position_y`=2819.29, `position_z`=418.676,`orientation`=0.471239 WHERE `id`=32620;
+
+-- DB Error
+
+UPDATE `creature_template` SET `NpcFlag`=3 WHERE `entry`=14325;
diff --git a/sql/updates/world/2015_07_12_39_world_2015_06_14_00.sql b/sql/updates/world/2015_07_12_39_world_2015_06_14_00.sql
new file mode 100644
index 00000000000..74c3f1f40fd
--- /dev/null
+++ b/sql/updates/world/2015_07_12_39_world_2015_06_14_00.sql
@@ -0,0 +1,4 @@
+--
+DELETE FROM `quest_request_items` WHERE `ID`=13411 AND `VerifiedBuild`=0;
+INSERT INTO `quest_request_items` (`ID`, `CompletionText`) VALUES
+(13411, 'Return to me after you have helped capture each fort!');
diff --git a/sql/updates/world/2015_07_12_40_world_2015_06_21_00.sql b/sql/updates/world/2015_07_12_40_world_2015_06_21_00.sql
new file mode 100644
index 00000000000..709f78fca92
--- /dev/null
+++ b/sql/updates/world/2015_07_12_40_world_2015_06_21_00.sql
@@ -0,0 +1,37 @@
+DELETE FROM `creature_formations` WHERE `leaderGUID`=203571;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(203571, 203571, 0, 0, 1),
+(203571, 203559, 2, 90, 2);
+
+-- Pathing for Gundrak Savage Entry: 29235 'TDB FORMAT' 
+SET @NPC := 203571;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6332.113,`position_y`=-4009.055,`position_z`=457.2701 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,6332.113,-4009.055,457.2701,0,0,0,0,100,0), -- 13:57:18
+(@PATH,2,6354.536,-4030.933,457.2702,0,0,0,0,100,0), -- 13:57:30
+(@PATH,3,6372.311,-4048.536,457.2703,0,0,0,0,100,0), -- 13:57:40
+(@PATH,4,6386.682,-4062.151,457.2303,0,0,0,0,100,0), -- 13:57:49
+(@PATH,5,6406.021,-4081.781,457.2282,0,0,0,0,100,0), -- 13:57:59
+(@PATH,6,6414.187,-4095.374,457.6551,0,0,0,0,100,0), -- 13:58:06
+(@PATH,7,6400.186,-4088.764,457.0648,0,0,0,0,100,0), -- 13:58:12
+(@PATH,8,6383.09,-4071.84,457.2628,0,0,0,0,100,0), -- 13:58:21
+(@PATH,9,6371.94,-4060.654,457.0837,0,0,0,0,100,0), -- 13:58:29
+(@PATH,10,6361.409,-4050.251,457.4023,0,0,0,0,100,0), -- 13:58:35
+(@PATH,11,6346.225,-4035.04,457.3448,0,0,0,0,100,0), -- 13:58:43
+(@PATH,12,6325.968,-4014.103,457.2808,0,0,0,0,100,0), -- 13:58:54
+(@PATH,13,6306.042,-3994.58,457.2701,0,0,0,0,100,0), -- 13:59:05
+(@PATH,14,6264.928,-3950.012,457.2701,0,0,0,0,100,0), -- 13:59:22
+(@PATH,15,6262.15,-3946.607,457.2701,0,0,0,0,100,0), -- 13:59:32
+(@PATH,16,6241.434,-3927.12,457.2723,0,0,0,0,100,0), -- 13:59:44
+(@PATH,17,6216.531,-3899.659,458.7351,0,0,0,0,100,0), -- 13:59:54
+(@PATH,18,6221.433,-3900.517,457.7585,0,0,0,0,100,0), -- 14:00:00
+(@PATH,19,6228.114,-3903.022,457.1964,0,0,0,0,100,0), -- 14:00:05
+(@PATH,20,6245.55,-3922.648,457.2741,0,0,0,0,100,0), -- 14:00:16
+(@PATH,21,6265.786,-3942.583,457.2701,0,0,0,0,100,0), -- 14:00:26
+(@PATH,22,6283.895,-3961.789,457.2701,0,0,0,0,100,0), -- 14:00:37
+(@PATH,23,6311.935,-3990.581,457.2701,0,0,0,0,100,0); -- 14:00:53
+-- 0x1C393047601C8CC000000D000079A937 .go 6332.113 -4009.055 457.2701
diff --git a/sql/updates/world/2015_07_12_41_world_2015_06_23_02.sql b/sql/updates/world/2015_07_12_41_world_2015_06_23_02.sql
new file mode 100644
index 00000000000..e4965449f51
--- /dev/null
+++ b/sql/updates/world/2015_07_12_41_world_2015_06_23_02.sql
@@ -0,0 +1,3 @@
+--
+-- UPDATE `quest_template` SET `RequiredRaces`=1101 WHERE `ID`=11580;
+-- UPDATE `quest_template` SET `RequiredRaces`=690 WHERE `ID`=11581;
diff --git a/sql/updates/world/2015_07_12_42_world_2015_06_28_00.sql b/sql/updates/world/2015_07_12_42_world_2015_06_28_00.sql
new file mode 100644
index 00000000000..3991d639615
--- /dev/null
+++ b/sql/updates/world/2015_07_12_42_world_2015_06_28_00.sql
@@ -0,0 +1,17 @@
+--
+UPDATE `creature` SET `position_x`=1997.263,`position_y`=-3256.643, `position_z`=149.723,`orientation`=6.116 WHERE `guid`=105997;
+UPDATE `creature` SET `position_x`=2091.723,`position_y`=-3245.161, `position_z`=161.245,`orientation`=3.312 WHERE `guid`=105998;
+DELETE FROM `smart_scripts` WHERE `entryorguid`= -105997 AND `source_type`=0;
+UPDATE  `smart_scripts` SET `event_param1`=43892, `action_type`=11, `target_type`=1, `target_param1`=0, `target_param2`=0  WHERE `entryorguid` IN (24439) AND `source_type`=0 AND `id`=1;
+UPDATE  `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=0  WHERE `entryorguid` IN (24439) AND `source_type`=0 AND `id`=4;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (24439);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(22,2,24439,0,0, 29,0,15214,1,0,0,0,'','event 1 for 24439 require npc 15214 at 1 yard');
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=43770;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(43770,43892,1,'Steel Gate Drop Off Check');
+
+DELETE FROM `creature` WHERE `guid` IN (104706, 104705);
+UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `guid`=104704;
+UPDATE `creature_template` SET `npcflag`=16777216 WHERE `entry`=24418;
diff --git a/sql/updates/world/2015_07_12_43_world_2015_06_28_01.sql b/sql/updates/world/2015_07_12_43_world_2015_06_28_01.sql
new file mode 100644
index 00000000000..850b1f295e8
--- /dev/null
+++ b/sql/updates/world/2015_07_12_43_world_2015_06_28_01.sql
@@ -0,0 +1,23 @@
+DELETE FROM  `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceGroup` = 1 AND `SourceEntry` IN ( 50036,51518,50087);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`) VALUES
+(13, 1, 50036, 31, 3, 27641),
+(13, 1, 51518, 31, 3, 27641),
+(13, 1, 50087, 31, 3, 27641);
+
+--- DELETE FROM `spelldifficulty_dbc` WHERE `id` = 50044;
+--- INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`) VALUES (50044, 50044, 59213);
+
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=27641;
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (27641,30905);
+INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES 
+(27641,'50044'),
+(30905,'59213');
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 27639 AND `source_type` = 0 AND `id` = 16;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 27640 AND `source_type` = 0 AND `id` = 2;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 27641 AND `source_type` = 0 AND `id` = 0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(27639, 0, 16, 0, 1, 0, 100, 0, 1000, 1000, 0, 0, 11, 51518, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ring-Lord Sorceress - Out of Combat - Cast Beam Visual'),
+(27640, 0, 2, 0, 1, 0, 100, 0, 1000, 1000, 0, 0, 11, 51518, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ring-Lord Conjurer - Out of combat - Cast Visual'),
+(27641, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 50088, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Centrifuge Core - Out of Combat - Cast Energy Link');
+\ No newline at end of file
diff --git a/sql/updates/world/2015_07_12_44_world_2015_06_28_02.sql b/sql/updates/world/2015_07_12_44_world_2015_06_28_02.sql
new file mode 100644
index 00000000000..0b376442393
--- /dev/null
+++ b/sql/updates/world/2015_07_12_44_world_2015_06_28_02.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `creature_addon` WHERE `guid` IN (104706, 104705);
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (53099, 54640, 55288);
+DELETE FROM `spell_scripts` WHERE `id` IN (53099, 55288);
+INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
+(53099,0,0,15,53098,0,0,0,0,0,0),
+(55288,0,0,15,55289,0,0,0,0,0,0);
diff --git a/sql/updates/world/2015_07_12_44_world_2015_06_28_03.sql b/sql/updates/world/2015_07_12_44_world_2015_06_28_03.sql
new file mode 100644
index 00000000000..ff6dfc6330f
--- /dev/null
+++ b/sql/updates/world/2015_07_12_44_world_2015_06_28_03.sql
@@ -0,0 +1,2 @@
+--
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=1293 AND `id`=3;
diff --git a/sql/updates/world/2015_07_12_45_world_2015_06_28_04.sql b/sql/updates/world/2015_07_12_45_world_2015_06_28_04.sql
new file mode 100644
index 00000000000..9e96b40fa0b
--- /dev/null
+++ b/sql/updates/world/2015_07_12_45_world_2015_06_28_04.sql
@@ -0,0 +1,34 @@
+--
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (27405, 27406);
+UPDATE `spell_area`  SET `quest_start` =0, `quest_start_status` =0, `quest_end_status` =0 WHERE `spell`  IN (48761, 48763);
+
+UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=27202 AND `source_type`=0 AND `id` =3;
+UPDATE `smart_scripts`  SET `link` =16 WHERE `entryorguid`=27202 AND `source_type`=0 AND `id` =12;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27405, 27406) AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2740500, 2740600) AND `source_type`=9;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=27202 AND `source_type`=0 AND id>15 ;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(27202, 0, 16, 17, 61, 0, 100, 0, 0, 0, 0, 0, 11, 48654, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Raven Priest - On Spellhit Banshee''s Magic Mirror - Cast The Perfect Dissemblance: Summon Priest''s Footman (No Repeat)'),
+(27202, 0, 17, 18, 61, 0, 100, 0, 0, 0, 0, 0, 85, 48763, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Raven Priest - On Spellhit Banshee''s Magic Mirror - Cast Scarlet Raven Priest Image'),
+(27202, 0, 18, 19, 61, 0, 100, 0, 0, 0, 0, 0, 85, 48761, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Raven Priest - On Spellhit Banshee''s Magic Mirror - Cast Scarlet Raven Priest Image'),
+(27202, 0, 19, 0, 61, 0, 100, 0, 0, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Raven Priest - On Spellhit Banshee''s Magic Mirror - Set faction'),
+(27405, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, 2740500, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - On just summoned - Action list'),
+(2740500, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - Action list - Set faction'),
+(2740500, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - Action list - Talk text1'),
+(2740500, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 40, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - Action list - Start attack'),
+(27405, 0, 1, 0, 0, 0, 100, 0, 2000, 2000, 28000, 28000, 11, 50713, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - IC - Unrelenting Onslaught '),
+(27406, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, 2740600, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - On just summoned - Action list'),
+(2740600, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - Action list - Set faction'),
+(2740600, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - Action list - Talk text1'),
+(2740600, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 40, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - Action list - Start attack'),
+(27406, 0, 1, 0, 0, 0, 100, 0, 2000, 2000, 28000, 28000, 11, 50713, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onslaught Footman - IC - Unrelenting Onslaught ');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (27202);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(22,18,27202,0,0,20,1,0,0,0,0,0,0,'','Onslaught Raven Priest SAI event 17 require a male character'),
+(22,19,27202,0,0,20,1,1,0,0,0,0,0,'','Onslaught Raven Priest SAI event 17 require a female character');
+
+DELETE FROM `creature_text` WHERE `entry` IN (27405, 27406);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(27405,0,0,'What''s going on here, sarge?',12,0,100,0,0,0,'Onslaught Footman', 26541),
+(27406,0,0,'I don''t know. Better kill them both to be on the safe side!',12,0,100,0,0,0,'Onslaught Footman', 26542);
diff --git a/sql/updates/world/2015_07_12_46_world_2015_06_28_05.sql b/sql/updates/world/2015_07_12_46_world_2015_06_28_05.sql
new file mode 100644
index 00000000000..b01701a74bd
--- /dev/null
+++ b/sql/updates/world/2015_07_12_46_world_2015_06_28_05.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2558400) AND `source_type`=9 AND `id`>2;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(2558400, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 45775, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Inquisitor Salrand - On Script - Remove Aura'),
+(2558400, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 30, 0, 0, 0, 0, 0, 0,'Inquisitor Salrand - On Script - Start attack');
diff --git a/sql/updates/world/2015_07_12_47_world_2015_06_28_06.sql b/sql/updates/world/2015_07_12_47_world_2015_06_28_06.sql
new file mode 100644
index 00000000000..f8937aaf081
--- /dev/null
+++ b/sql/updates/world/2015_07_12_47_world_2015_06_28_06.sql
@@ -0,0 +1,13 @@
+--
+DELETE FROM `spell_area` WHERE `spell` IN(46424);
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES 
+(46424, 4119, 11896, 0, 0, 0, 2, 1, 10, 0),
+(46424, 4035, 11896, 0, 0, 0, 2, 1, 10, 0),
+(46424, 4146, 11896, 0, 0, 0, 2, 1, 10, 0),
+(46424, 4116, 11896, 0, 0, 0, 2, 1, 10, 0),
+(46424, 4117, 11896, 0, 0, 0, 2, 1, 10, 0),
+(46424, 4037, 11896, 0, 0, 0, 2, 1, 10, 0);
+
+DELETE FROM `spell_scripts` WHERE `id`=46550;
+INSERT INTO `spell_scripts` (`id`, `effIndex`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
+(46550, 0, 0, 14, 46424, 0, 0, 0, 0, 0, 0);
diff --git a/sql/updates/world/2015_07_12_48_world_2015_06_28_07.sql b/sql/updates/world/2015_07_12_48_world_2015_06_28_07.sql
new file mode 100644
index 00000000000..20bddf5597c
--- /dev/null
+++ b/sql/updates/world/2015_07_12_48_world_2015_06_28_07.sql
@@ -0,0 +1,2 @@
+--
+UPDATE `gameobject_template` SET `faction`=1673 WHERE `entry` IN (181597);
diff --git a/sql/updates/world/2015_07_12_49_world_2015_07_01_00.sql b/sql/updates/world/2015_07_12_49_world_2015_07_01_00.sql
new file mode 100644
index 00000000000..1ab4caae8c9
--- /dev/null
+++ b/sql/updates/world/2015_07_12_49_world_2015_07_01_00.sql
@@ -0,0 +1,8 @@
+--
+UPDATE `creature_template` SET `trainer_type`=2 WHERE `entry` IN (33996);
+DELETE FROM `npc_trainer` WHERE `ID`=33996;
+INSERT INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES
+(33996, 2373, 500, 182, 50, 0),
+(33996, 3571, 5000, 182, 125, 10),
+(33996, 11994, 50000, 182, 200, 25),
+(33996, 2372, 10, 0, 0, 0);
diff --git a/sql/updates/world/2015_07_12_50_world_2015_07_01_01.sql b/sql/updates/world/2015_07_12_50_world_2015_07_01_01.sql
new file mode 100644
index 00000000000..483f3539f29
--- /dev/null
+++ b/sql/updates/world/2015_07_12_50_world_2015_07_01_01.sql
@@ -0,0 +1,538 @@
+--
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-113551, -113550);
+UPDATE `smart_scripts` SET `event_type`=1, `event_flags`=1 WHERE `entryorguid` IN (-88704, -88703, -88702, -88701) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `target_param1`=113551, `target_param2`=26298 WHERE `entryorguid` IN (-113549) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `target_param1`=113550, `target_param2`=26298 WHERE `entryorguid` IN (-113548) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-113551, -113478) AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(-113551, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 45, 0, 1, 0, 0, 0, 0, 10, 113549, 26298, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny - on respawn - set data'),
+(-113478, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 45, 0, 1, 0, 0, 0, 0, 10, 61994, 26298, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny - on respawn - set data');
+DELETE FROM `creature_template_addon` WHERE `entry`=26298;
+DELETE FROM `creature_addon` WHERE `guid` IN (88704, 88703, 88702, 88701);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
+(88704,0,0,0,1,0,'52485 51666'),
+(88703,0,0,0,1,0,'52485 51666'),
+(88702,0,0,0,1,0,'52485 51666'),
+(88701,0,0,0,1,0,'52485 51666');
+UPDATE `creature` SET `position_x`=6831.778,`position_y`=-4534.357, `position_z`=444.178,`orientation`=0.127 WHERE `guid`=113550;
+UPDATE `creature` SET `position_x`=6829.298,`position_y`=-4515.533, `position_z`=444.178,`orientation`=4.679 WHERE `guid`=113551;
+UPDATE `conditions` SET `ConditionValue2`=26298 WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry` IN (52834, 52833, 52837, 52838) AND `ConditionTypeOrReference`=31;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry` IN (52834, 52833, 52837, 52838) AND `ConditionTypeOrReference`=35;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,52833,0,0,35,0,1,5,3,0,0,'','Spell Akali''s Chains - Right Rear Paw target distance must be 5y or more'),
+(13,1,52834,0,0,35,0,1,5,3,0,0,'','Spell Akali''s Chains - Right Rear Paw target distance must be 5y or more'),
+(13,1,52837,0,0,35,0,1,5,3,0,0,'','Spell Akali''s Chains - Right Rear Paw target distance must be 5y or more'),
+(13,1,52838,0,0,35,0,1,5,3,0,0,'','Spell Akali''s Chains - Right Rear Paw target distance must be 5y or more');
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (69, 299);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (69, 299);
+UPDATE `creature_template_addon` SET `auras`='71764' WHERE `entry` IN (69, 299);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (677) AND `source_type`=0 AND `id`=2;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(677, 0, 2, 0, 0, 0, 100, 1, 8000, 8000, 8000, 8000, 11, 7979, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Venture Co. Tinkerer - IC - Cast Compact Harvest Reaper (no repeat)');
+UPDATE `smart_scripts` SET `event_type`=25, `event_flags`=0, `comment`='Mosh''Ogg Spellcrafter - On Reset - Cast Frost Armor (No Repeat)' WHERE `entryorguid` IN (710) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (853) AND `source_type`=0;
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry` IN (853); 
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (853);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1642) AND `source_type`=0;
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry` IN (1642); 
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (1642);
+UPDATE `smart_scripts` SET `event_type`=25, `event_flags`=0, `comment`='Foreman Bonds - On Reset - Cast Devotion Aura' WHERE `entryorguid` IN (2305) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `event_flags`=0, `comment`='Dun Garok Mountaineer - On Reset - Cast Devotion Aura' WHERE `entryorguid` IN (2344) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `event_flags`=0, `comment`='Shadowy Assassin - On Reset - Cast Stealth' WHERE `entryorguid` IN (2434) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2522) AND `source_type`=0;
+UPDATE `creature_template_addon` SET `auras`='30831 12787' WHERE `entry` IN (2522); 
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (2522);
+UPDATE `smart_scripts` SET `event_type`=25, `event_flags`=0, `comment`='Unseen - On Reset - Cast Unseen' WHERE `entryorguid` IN (3094) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `action_type`=75, `comment`="Saltspittle Puddlejumper - On Reset - Add aura 'Battle Stance' (No Repeat)" WHERE `entryorguid` IN (3737) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`="7164" WHERE `entry`=3739;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Foulweald Warrior - On Reset - Cast 'Corrupted Strength Passive' (No Repeat)" WHERE `entryorguid` IN (3743) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Foulweald Den Watcher - On Reset - Cast 'Corrupted Stamina Passive' (No Repeat)" WHERE `entryorguid` IN (3746) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Foulweald Shaman - On Reset - Cast 'Corrupted Intellect Passive' (No Repeat)" WHERE `entryorguid` IN (3748) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Foulweald Ursa - On Reset - Cast 'Corrupted Strength Passive' (No Repeat)" WHERE `entryorguid` IN (3749) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Foulweald Totemic - On Reset - Cast 'Corrupted Intellect Passive' (No Repeat)" WHERE `entryorguid` IN (3750) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Felmusk Shadowstalker - On Reset - Cast 'Sneak' (No Repeat)" WHERE `entryorguid` IN (3763) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Forsaken Assassin - On Reset - Cast 'Sneak' (No Repeat)" WHERE `entryorguid` IN (3807) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Forsaken Intruder - On Reset - Cast 'Sneak' (No Repeat)" WHERE `entryorguid` IN (3804) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Forsaken Infiltrator - On Reset - Cast 'Sneak' (No Repeat)" WHERE `entryorguid` IN (3806) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `action_type`=75, `comment`="Wildthorn Lurker - On Reset - Add aura Hide" WHERE `entryorguid` IN (3821) AND `source_type`=0 AND `id`=0;
+UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `id`=3821;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Thistlefur Totemic - On Respawn - Cast 'Coat of Thistlefur'" WHERE `entryorguid` IN (3922) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Thistlefur Den Watcher - On Reset - Cast 'Coat of Thistlefur'" WHERE `entryorguid` IN (3923) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Thistlefur Shaman - On Reset - Cast 'Coat of Thistlefur'" WHERE `entryorguid` IN (3924) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Thistlefur Avenger - On Reset - Cast 'Coat of Thistlefur'" WHERE `entryorguid` IN (3925) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=4, `event_param3`=0, `event_param4`=0, `comment`="Uthil Mooncall - On aggro - Cast 'Bear Form'" WHERE `entryorguid` IN (3941) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Son of Cenarius - On Reset - Cast Summon Treant Ally (Self)" WHERE `entryorguid` IN (4057) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Highperch Wyvern - On Reset - Cast 'Poison Proc' (No Repeat)" WHERE `entryorguid` IN (4107) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Highperch Consort - On Reset - Cast 'Poison Proc' (No Repeat)" WHERE `entryorguid` IN (4109) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Highperch Patriarch - On Reset - Cast 'Poison Proc' (No Repeat)" WHERE `entryorguid` IN (4110) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Venomous Cloud Serpent - On Reset - Cast 'Deadly Poison' (Phase 1) (No Repeat)" WHERE `entryorguid` IN (4118) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (4196) AND `source_type`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (4196);
+UPDATE `creature_template_addon` SET `auras`='6590' WHERE `entry` IN (4196); 
+UPDATE `creature_template_addon` SET `auras`='7165' WHERE `entry` IN (4420); 
+UPDATE `creature_template_addon` SET `auras`='7165' WHERE `entry` IN (4436);
+UPDATE `smart_scripts` SET `event_type`=25, `action_type`=75, `comment`="Captain Flat Tusk - On Reset - Add aura 'Battle Stance' (No Repeat)" WHERE `entryorguid` IN (5824) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Henze Faulk - On Reset - Cast 'Permanent Feign Death'" WHERE `entryorguid` IN (6172) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Narm Faulk - On Reset - Cast 'Permanent Feign Death'" WHERE `entryorguid` IN (6177) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (6508) AND `source_type`=0;       
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (6508);
+UPDATE `creature_template_addon` SET `auras`='14108' WHERE `entry` IN (6508); 
+UPDATE `creature_template_addon` SET `auras`='14111' WHERE `entry` IN (6509, 6510, 6511, 6512); 
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (6517) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`='14178' WHERE `entry` IN (6517, 6518, 6519, 6527); 
+UPDATE `creature_template_addon` SET `auras`='6408' WHERE `entry` IN (6886); 
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Stitched Golem - On Reset - Cast 'Disease Cloud' (No Repeat)" WHERE `entryorguid` IN (8545) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`='3417' WHERE `entry` IN (9164, 9167); 
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Blazerunner - On Reset - Cast 'Blazerunner's Aura'" WHERE `entryorguid` IN (9376) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Azurous - On Reset - Cast 'Damage Immunity: Arcane'" WHERE `entryorguid` IN (10202) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Spellmaw - On Reset - Cast 'Damage Immunity: Arcane' (No Repeat)" WHERE `entryorguid` IN (10662) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Manaclaw - On Reset - Cast 'Damage Immunity: Arcane' (No Repeat)" WHERE `entryorguid` IN (10663) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Scryer - On Reset - Cast 'Damage Immunity: Arcane' (No Repeat)" WHERE `entryorguid` IN (10664) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (11286, 11281, 11280, 11279, 11278, 11277) AND `source_type`=0;       
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (11286, 11281, 11280, 11279, 11278, 11277);
+UPDATE `creature_template_addon` SET `auras`='17622' WHERE `entry` IN (11286, 11281, 11280, 11279, 11278, 11277); 
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Wildspawn Shadowstalker - On Reset - Cast 'Sneak'" WHERE `entryorguid` IN (11456) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`='16577' WHERE `entry` IN (11885);
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry` IN (12160); 
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Shadowglen Sentinel - On Respawn - Cast 'Invisibility and Stealth Detection' (No Repeat)" WHERE `entryorguid` IN (12160) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Enraged Foulweald - On Reset - Cast 'Corrupted Strength Passive' (No Repeat)" WHERE `entryorguid` IN (12921) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`='21337' WHERE `entry` IN (13142); 
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid` IN (14363, 14365, 14367, 14438, 14439, 14376, 14423, 14404, 14375, 14377, 14402, 14403) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Huntress Skymane - On Respawn - Cast 'Invisibility and Stealth Detection'" WHERE `entryorguid` IN (14378) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid` IN (14484, 14485) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Eris Havenfire - On Reset - Cast Ancestor Invisibility" WHERE `entryorguid` IN (14494) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid` IN (16226, 16232) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid` IN (16424) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`='29152' WHERE `entry` IN (16517, 16537, 16922);
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `action_param1` IN (18950);
+UPDATE `creature_template_addon` SET `auras`='32900' WHERE `entry` IN (16805);
+UPDATE `creature_template_addon` SET `auras`='33908' WHERE `entry` IN (16863); 
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `action_param1` IN (33900);
+UPDATE `creature_template_addon` SET `auras`='32737' WHERE `entry` IN (16954);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (17048, 17049) AND `source_type`=0;       
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (17048, 17049);
+UPDATE `creature_template_addon` SET `auras`='29402' WHERE `entry` IN (17048, 17049);
+UPDATE `creature_template_addon` SET `auras`='12550' WHERE `entry` IN (17160); 
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (17478) AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(17478, 0, 0, 0, 0, 0, 100, 6, 1000, 1000, 3000, 4000, 11, 12471, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - IC - Cast Shadow Bolt'),
+(17478, 0, 1, 0, 0, 0, 100, 6, 5000, 10000, 10000, 15000, 11, 30615, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - IC - Cast Fear'),
+(17478, 0, 2, 0, 25, 0, 100, 6, 0, 0, 0, 0, 11, 31059, 0, 0, 0, 0, 0, 19, 17281, 20, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - On Reset - Cast Hellfire Channeling');
+UPDATE `smart_scripts` SET `event_type`=25, `action_type`=75, `comment`= "Blood Elf Bandit - On Reset - Add aura 'Shadowstalker Stealth'" WHERE `entryorguid` IN (17591) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18139, 18140, 18358, 18382, 17856, 17857, 17866, 17923, 17924, 17925) AND `source_type`=0;       
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (18139, 18140, 18358, 18382, 17856, 17857, 17866, 17923, 17924, 17925);
+UPDATE `creature_template_addon` SET `auras`='35230' WHERE `entry` IN (18139, 18140, 18358, 18382, 17856, 17857, 17866, 17923, 17924, 17925);
+UPDATE `smart_scripts` SET `link`=0, `event_type`=25, `action_type`=75 WHERE `entryorguid`=23090 AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18152) AND `source_type`=0;
+UPDATE `creature_template_addon` SET `auras`='24983' WHERE `entry` IN (18152); 
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18297) AND `source_type`=0;       
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (18297);
+UPDATE `creature_template_addon` SET `auras`='32199' WHERE `entry` IN (18297); 
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18424) AND `source_type`=0;       
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (18424);
+UPDATE `creature_template_addon` SET `auras`='32423' WHERE `entry` IN (18424); 
+UPDATE `creature_template_addon` SET `auras`='32423' WHERE `entry` IN (18437);
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid` IN (18482) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Unliving Soldier - On Reset - Cast 'Protection Aura' (Phase 1) (No Repeat) (Dungeon)" WHERE `entryorguid` IN (18498) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18560) AND `source_type`=0;       
+UPDATE `creature_template` SET `InhabitType`=4, `AIName` = '', `flags_extra`=130 WHERE `entry` IN (18560);
+UPDATE `creature_template` SET  `InhabitType`=4, `AIName` = 'SmartAI', `flags_extra`=130 WHERE `entry` IN (18563);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18563) AND `source_type`=0 AND `id`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(18563, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 32573, 0, 0, 0, 0, 0, 19, 18560, 20, 0, 0, 0, 0, 0,'Justin''s Bunny Channeler - On reset - Cast Justin''s Zappy Channel');
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (32573);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,1,32573,0,0, 31,0,3,18560,0,0,0,'','Justin''s Zappy Channel effectt only on 18560');
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18564, 18581) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (18564, 18581);
+UPDATE `creature_template_addon` SET `auras`='32610' WHERE `entry` IN (18564);
+UPDATE `creature_template_addon` SET `auras`='32609' WHERE `entry` IN (18581); 
+UPDATE `creature_template` SET `InhabitType`=4, `AIName` = '' WHERE `entry` IN (18759);
+UPDATE `creature_template_addon` SET `auras`='32840' WHERE `entry` IN (18759);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18781) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (18781);
+UPDATE `creature_template_addon` SET `auras`='32951' WHERE `entry` IN (18781);
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Wrath Priestess - On Reset - Cast 'Summon Fel Imp' (No Repeat)" WHERE `entryorguid` IN (18859) AND `source_type`=0 AND `id`=0;
+DELETE FROM `creature` WHERE `id`=21135;
+UPDATE `creature_template_addon` SET `auras`='32942' WHERE `entry` IN (18884);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19027, 19030) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (19027, 19030);
+UPDATE `creature_template_addon` SET `bytes1`=0, `auras`='34664' WHERE `entry` IN (19027, 19030);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19224) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (19224);
+UPDATE `creature_template_addon` SET `auras`='33569' WHERE `entry` IN (19224);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19607, 21956) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (19607, 21956);
+UPDATE `creature_template_addon` SET `auras`='37691' WHERE `entry` IN (19607, 21956);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19719) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (19719);
+UPDATE `creature_template_addon` SET `auras`='32648' WHERE `entry` IN (19719);
+UPDATE `creature_template_addon` SET `auras`='24313' WHERE `entry` IN (19847);
+UPDATE `creature_template_addon` SET `auras`='35848' WHERE `entry` IN (19926);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21663, 21453, 19985, 19945) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (21663, 21453, 19985, 19945);
+UPDATE `creature_template_addon` SET `auras`='12550' WHERE `entry` IN (30179, 19985, 19945, 21663, 21453);
+DELETE FROM `creature_template_addon` WHERE `entry` IN (29690, 29733);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(29690, 1, '12550'),
+(29733, 1, '12550');
+UPDATE `creature_addon` SET `auras`='12550' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN(21453, 19985));
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20086, 20114) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (20086, 20114);
+UPDATE `creature_template_addon` SET `auras`='34840' WHERE `entry` IN (20086);
+UPDATE `creature_template_addon` SET `auras`='34858' WHERE `entry` IN (20114);
+UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (26688, 21976, 22073, 22380, 28466, 34810, 20769, 26579); 
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19421) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20134) AND `source_type`=0 AND `id`=14;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20139) AND `source_type`=0 AND `id`=15;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18855) AND `source_type`=0 AND `id`=14;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20248) AND `source_type`=0 AND `id`=5;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(20248, 0, 5, 0, 1, 0, 50, 0, 10000, 20000, 15000, 30000, 11, 34397, 0, 0, 0, 0, 0, 19, 19421, 30, 0, 0, 0, 0, 0,'20248 - Ooc - Cast Red Beam'),
+(18855, 0, 14, 0, 1, 0, 50, 0, 10000, 20000, 15000, 30000, 11, 34397, 0, 0, 0, 0, 0, 19, 19421, 30, 0, 0, 0, 0, 0,'18855 - Ooc - Cast Red Beam'),
+(20139, 0, 15, 0, 1, 0, 50, 0, 10000, 20000, 15000, 30000, 11, 34397, 0, 0, 0, 0, 0, 19, 19421, 30, 0, 0, 0, 0, 0,'20139 - Ooc - Cast Red Beam'),
+(20134, 0, 14, 0, 1, 0, 50, 0, 10000, 20000, 15000, 30000, 11, 34397, 0, 0, 0, 0, 0, 19, 19421, 30, 0, 0, 0, 0, 0,'20134 - Ooc - Cast Red Beam');
+UPDATE `conditions` SET `ConditionValue2`=19421 WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=34397;
+UPDATE `creature` SET `position_x`=-3692.053, `position_y`=2685.259, `position_z`=108.866, `Orientation`=3.696 WHERE `guid`=74614;
+UPDATE `smart_scripts` SET `event_type`=23, `event_param1`=37539, `event_flags`=0, `comment`="Socrethar - Has aura - Cast 'Nether Protection' (Phase 1) (No Repeat)" WHERE `entryorguid` IN (20132) AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20154) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`='24313' WHERE `entry` IN (20154);
+UPDATE `creature_template_addon` SET `auras`='8279' WHERE `entry` IN (22282, 21941, 20330);
+UPDATE `creature_addon` SET `auras`='8279' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN(22282, 21941, 20330));
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20451) AND `source_type`=0 AND `id`=0;       
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (20451);
+UPDATE `creature_template_addon` SET `auras`='16592' WHERE `entry` IN (20451);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20483) AND `source_type`=0;       
+UPDATE `creature_template_addon` SET `auras`='28126' WHERE `entry` IN (20483);
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(20483, 0, 0, 0, 0, 0, 100, 0, 10000, 15000, 25000, 30000, 11, 36146, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Naberius - IC - Cast Chains of Naberius'),
+(20483, 0, 1, 0, 0, 0, 100, 0, 1000, 4000, 4000, 4000, 11, 15497, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Naberius - IC - Cast Frostbolt'),
+(20483, 0, 2, 0, 0, 0, 100, 0, 2000, 5000, 10000, 12000, 11, 36148, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Naberius - IC - Cast Chill Nova');
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20501) AND `source_type`=0 AND id=2;       
+UPDATE `creature_template_addon` SET `auras`='35242' WHERE `entry` IN (20501);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20520) AND `source_type`=0 AND id=0;       
+UPDATE `creature_template_addon` SET `auras`='32566' WHERE `entry` IN (20520);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (20668);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20668) AND `source_type`=0 AND id=0;       
+UPDATE `creature_template_addon` SET `auras`='37816' WHERE `entry` IN (20668);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20673) AND `source_type`=0 AND id=0;       
+UPDATE `creature_template_addon` SET `auras`='19514' WHERE `entry` IN (20673);
+UPDATE `creature_addon` SET `auras`='19514' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN(20673));
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(20673, 0, 0, 0, 0, 0, 100, 0, 2000, 5000, 4000, 6000, 11, 36594, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Swiftwing Shredder - IC - Cast Lightning Breath');
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20806) AND `source_type`=0 AND id=0;       
+UPDATE `creature_template_addon` SET `auras`='35242' WHERE `entry` IN (20806);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20825) AND `source_type`=0 AND `id`=0;       
+UPDATE `creature_template_addon` SET `auras`='32567' WHERE `entry` IN (20825);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20845) AND `source_type`=0 AND `id`=0;       
+UPDATE `creature_template_addon` SET `auras`='33345' WHERE `entry` IN (20845);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (20880);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20880) AND `source_type`=0 AND `id`=0;       
+UPDATE `creature_template_addon` SET `auras`='27987' WHERE `entry` IN (20880);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (20879);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20879) AND `source_type`=0; 
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (20882);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20882) AND `source_type`=0 AND `id`=0;       
+UPDATE `creature_template_addon` SET `auras`='16380' WHERE `entry` IN (20882);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20899) AND `source_type`=0 AND `id`=0;       
+UPDATE `creature_template_addon` SET `auras`='35242' WHERE `entry` IN (20899);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21073);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21073) AND `source_type`=0 AND `id`=0;       
+UPDATE `creature_template_addon` SET `auras`='36113' WHERE `entry` IN (21073);
+UPDATE `smart_scripts` SET `event_type`=25, `comment`="Dormant Infernal - On Reset - Cast 'Stationary Infernal Ball'" WHERE `entryorguid` IN (21080) AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=18793, `target_param2`=10 WHERE `entryorguid`=21159 AND `source_type`=0 AND `id`=0;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (36220);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,1,36220,0,0, 31,0,3,18793,0,0,0,'','Containment Beam only on 18793');
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=21170 AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21181) AND `source_type`=0 AND `id`=13;       
+UPDATE `creature_template_addon` SET `auras`='17327' WHERE `entry` IN (21198, 21200, 21870, 21814, 21324);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21814, 21870);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21814, 21870) AND `source_type`=0 AND `id`=0;     
+UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=21200 AND `source_type`=0 AND `id`=4;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=21316 AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21337);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21337) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21349);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21349) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='36575' WHERE `entry` IN (21349);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21404);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21404) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='16245' WHERE `entry` IN (21404);
+UPDATE `creature_addon` SET `auras`='16245' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN(21404));
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21414);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21414) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='36728' WHERE `entry` IN (21414);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21450);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21450) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='36978' WHERE `entry` IN (21450);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21651);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21651) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='37411' WHERE `entry` IN (21651);
+UPDATE `creature_addon` SET `auras`='37411' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN(21651));
+UPDATE `smart_scripts` SET `event_type`=54 WHERE `entryorguid` IN (21735) AND `source_type`=0 AND `id`=0;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (36384);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,1,36384,0,0, 31,0,3,21211,0,0,0,'','Skartax Purple Beam only on 21211');
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21737, 21757);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21737, 21757) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='37248' WHERE `entry` IN (21737, 21757);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21761);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21761) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='36716' WHERE `entry` IN (21761);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21787, 23067, 23068, 21763, 23066);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21787, 23067, 23068, 21763, 23066) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='37411' WHERE `entry` IN (21787, 23067, 23068, 21763);
+UPDATE `creature_addon` SET `auras`='37411' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (21787, 23067, 23068, 21763));
+UPDATE `creature_template_addon` SET `auras`="37411 11919" WHERE `entry` IN (23066);
+UPDATE `creature_addon` SET `auras`="37411 11919" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (23066));
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21788);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21788) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='37467' WHERE `entry` IN (21788);
+UPDATE `creature_template_addon` SET `auras`='22578' WHERE `entry` IN (21837);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21935, 21942, 21944);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21935, 21942, 21944) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='33356' WHERE `entry` IN (21935, 21942, 21944);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (21950, 21951);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21950, 21951) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='22650' WHERE `entry` IN (21950, 21951);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (22060);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22060) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='34189' WHERE `entry` IN (22060);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (22093);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22093) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='37119' WHERE `entry` IN (22093);
+UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (22018) AND `source_type`=0 AND `id`=2;
+UPDATE `creature` SET `position_x`=-3584.313,`position_y`=1854.726, `position_z`=47.24,`orientation`=2.478 WHERE `guid`=84940;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (22438, 22439, 22094, 22437, 22440);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22438, 22439, 22094, 22437, 22440) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='37119' WHERE `entry` IN (22438, 22439, 22094, 22437, 22440);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (22214);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22214) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (22221, 22289);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22221, 22289) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`='39102' WHERE `entry` IN (22221, 22289);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (22242);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22242) AND `source_type`=0;     
+UPDATE `creature_template_addon` SET `auras`="38857 38860" WHERE `entry` IN (22242);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (22389);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22389) AND `source_type`=0;     
+UPDATE `creature_template_addon` SET `auras`="16245" WHERE `entry` IN (22389);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (23326);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23326) AND `source_type`=0;
+UPDATE `creature_addon` SET `auras`='32732' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (23326));
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (23557);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23557) AND `source_type`=0;     
+UPDATE `creature_template_addon` SET `auras`="42472" WHERE `entry` IN (23557);
+UPDATE `creature_addon` SET `auras`='42472' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (23557));
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23564) AND `source_type`=0 AND `id`=12;     
+UPDATE `creature_template_addon` SET `auras`="21862" WHERE `entry` IN (23564);
+UPDATE `creature_addon` SET `auras`='21862' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (23564));
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24199) AND `source_type`=0 AND `id`=10;     
+UPDATE `creature_template_addon` SET `auras`="21862" WHERE `entry` IN (24199);
+UPDATE `creature_addon` SET `auras`='21862' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (24198));
+DELETE FROM `creature_template_addon` WHERE `entry` IN (24198);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(24198, 1, '21862');
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (23583);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23583) AND `source_type`=0 AND `id`=0;     
+UPDATE `creature_template_addon` SET `auras`="42175" WHERE `entry` IN (23583);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (23698);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23698) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_addon` SET `auras`='43905' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (23698));
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=23730 AND `source_type`=0 AND `id`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24078) AND `source_type`=0 AND `id`=4;     
+UPDATE `creature_template_addon` SET `auras`="43929" WHERE `entry` IN (24078);
+UPDATE `creature_addon` SET `auras`='43929' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (24078));
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=24335 AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (24345);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24345) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_addon` SET `auras`='43312' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (24345));
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (24438);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24438) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (24438);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(24438, 1, '43890');
+DELETE FROM `creature_template_addon` WHERE `entry` IN (24464);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(24464, 1, '43874');
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (24567);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24567) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (24567);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(24567, 1, '8876');
+UPDATE `creature_addon` SET `auras`='36151' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (24601));
+DELETE FROM `creature_template_addon` WHERE `entry` IN (24601);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(24601, 1, '36151');
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (24677);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24677) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (24677);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(24677, 1, '44366');
+UPDATE `smart_scripts` SET `event_type`=25, target_type=19, target_param1=25670, target_param2=25, target_param3=0 WHERE `entryorguid`=24957 AND `source_type`=0 AND `id`=1;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=25001 AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (25355);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25355) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (25355);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(25355, 1, '50637');
+DELETE FROM `creature_template_addon` WHERE `entry` IN (25851, 25599, 25597, 25595, 25837,25592,25509, 25508, 25506, 25486, 25485, 25483,25867, 25824, 25373, 25593, 25371, 25370, 25369, 25368, 25367, 25798, 25363, 25799);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(25851, 4097, '45769'), (25599, 4097, '45769'), (25597, 4097, '45769'), (25595, 4097, '45769'), (25837, 4097, '45769'), (25592, 4097, '45769'), (25867, 4097, '45769'), (25824, 4097, '45769'),  (25373, 4097, '45769'), (25593, 4097, '45769'), (25367, 4097, '45769'), (25798, 4097, '45769'), (25509, 4097, '45769'), (25508, 4097, '45769'), (25506, 4097, '45769'), (25486, 4097, '45769'), (25485, 4097, '45769'), (25483, 4097, '45769'), (25371, 4097, '45769'), (25370, 4097, '45769'), (25369, 4097, '45769'), (25368, 4097, '45769'), (25363, 4097, '45769'), (25799, 4097, '45769');
+UPDATE `creature_addon` SET `auras`='45769' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (25851, 25599, 25597, 25595, 25837,25592,25509, 25508, 25506, 25486, 25485, 25483,25867, 25824, 25373, 25593, 25371, 25370, 25369, 25368, 25367, 25798, 25363, 25799));
+UPDATE `creature_template_addon` SET `auras`="45658" WHERE `entry` IN (34839, 25613, 25479);
+UPDATE `creature_addon` SET `auras`='45658' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (34839, 25613, 25479));
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (34839, 25613, 25479) AND `source_type`=0;       
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(34839, 0, 0, 0, 0, 0, 100, 0, 2000, 3000, 9000, 11000, 11, 49816, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,"Kvaldir Mist Binder - In Combat - Cast 'Mist of Strangulation'"),
+(25613, 0, 0, 0, 0, 0, 100, 0, 2000, 3000, 9000, 11000, 11, 49816, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,"Skadir Mistweaver - In Combat - Cast 'Mist of Strangulation'"),
+(25479, 0, 0, 0, 0, 0, 100, 0, 2000, 3000, 9000, 11000, 11, 49816, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,"Kvaldir Mistweaver - In Combat - Cast 'Mist of Strangulation'");
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (25484);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25484) AND `source_type`=0 AND `id`=0;  
+UPDATE `creature_template_addon` SET `auras`="34189" WHERE `entry` IN (25484);
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=25584 AND `source_type`=0 AND `id`=5;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=25651 AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (25668);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25668) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (25668);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(25668, 1, '46695');
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (25679);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25679) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (25679);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(25679, 1, '36151');
+UPDATE `creature_addon` SET `auras`='36151' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (25679));
+DELETE FROM `creature_template_addon` WHERE `entry` IN (25791);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(25791, 1, '45948');
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (25817, 25748, 25750);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25817, 25748, 25750) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (25817, 25748, 25750);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(25817, 1, '45948'),
+(25748, 1, '45948'),
+(25750, 1, '45948');
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=25955 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=26167 AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (26169);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26169) AND `source_type`=0 AND `id`=0;
+UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `id`=25762;
+UPDATE `creature_template` SET `InhabitType`=4 WHERE `Entry`=25762;
+DELETE FROM `creature` WHERE `guid` IN (111130, 111128, 111131, 111129, 111127, 111132, 111133, 111136, 111134, 111135, 111138, 111139, 111142, 111141, 111076, 111074, 111079, 111078, 111077, 111081, 111083, 111080, 111082, 111084, 111094);
+DELETE FROM `vehicle_template_accessory` WHERE `entry` = 25762;
+INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
+(25762,25760,0,1,'Kvaldir Raider',8,0),
+(25762,25760,1,1,'Kvaldir Raider',8,0),
+(25762,25760,2,1,'Kvaldir Raider',8,0),
+(25762,25760,3,1,'Kvaldir Raider',8,0),
+(25762,25760,4,1,'Kvaldir Raider',8,0),
+(25762,25760,5,1,'Kvaldir Raider',8,0),
+(25762,25760,6,1,'Kvaldir Raider',8,0);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (26197);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26197) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (26197);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(26197, 1, '15088');
+UPDATE `creature_addon` SET `auras`='15088' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26197));
+DELETE FROM `creature_template_addon` WHERE `entry` IN (26343);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(26343, 1, '32423');
+DELETE FROM `creature_template_addon` WHERE `entry` IN (26417);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(26417, 1, '47329');
+UPDATE `creature_addon` SET `auras`='47329' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26417));
+DELETE FROM `creature_template_addon` WHERE `entry` IN (26467);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(26467, 1, "47677");
+UPDATE `creature_addon` SET `auras`="47677" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26467));
+DELETE FROM `smart_scripts` WHERE `entryorguid`=26467 AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(26467, 0, 0, 0, 0, 0, 100, 0, 2000, 3000, 12000, 15000, 11, 51879, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,"Jormungar Tunneler - IC - Cast 'Corrode Flesh'"),
+(26467,0,1,0,0,0,100,0,4000,6000,19000,21000,11,32738,0,0,0,0,0,2,0,0,0,0,0,0,0,'Jormungar Tunneler  - In Combat - Cast Bore');
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (26511);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26511) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (26511);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(26511, 1, "8876");
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26543) AND `source_type`=0 AND `id`>0; 
+UPDATE `creature_template_addon` SET `auras`="43167 47119" WHERE `entry` IN (26543);
+UPDATE `creature_template` SET `faction`=1985 WHERE `entry`=26816;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26787) AND `source_type`=0 AND `id`>0;
+UPDATE `creature_template_addon` SET `auras`="43167 47119" WHERE `entry` IN (26787);
+UPDATE `smart_scripts` SET `event_type`=1, `event_flags`=1, `target_type`=19, `target_param1`=27292, `target_param2`=50, `action_param3`=0, `action_param2`=64, `comment`="Flamebringer's Chain - OOC no repeat- Cast 'Flamebringer's Chain'" WHERE `entryorguid`=27297 AND `source_type`=0 AND `id`=0;
+DELETE FROM `creature_template_addon` WHERE `entry` IN (27500);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(27500, 257, "15088");
+UPDATE `creature_addon` SET `auras`="15088" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (27500));
+UPDATE `creature_addon` SET `auras`="49343" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (27693));
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=27736 AND `source_type`=0;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (28158);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28158) AND `source_type`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (28158);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(28158, 1, "54450 45857");
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=28161 AND `source_type`=0 AND `id`=2 AND `link`=3 ;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (28440);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28440) AND `source_type`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (28440);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(28440, 1, "51583");
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=28504 AND `source_type`=0 AND `id`=0 ;
+DELETE FROM `creature_template_addon` WHERE `entry` IN (28521);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(28521, 1, "51868 61438");
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28557) AND `source_type`=0 AND `id`=1;
+UPDATE `creature_template_addon` SET `auras`="48356" WHERE `entry` IN (28557);
+UPDATE `smart_scripts` SET `event_type`=23, `event_param1`=48356 WHERE `entryorguid`=28608 AND `source_type`=0 AND `id`=0 ;
+UPDATE `smart_scripts` SET `event_type`=23, `event_param1`=48356 WHERE `entryorguid`IN (28936, 28609, 28611) AND `source_type`=0 AND `id`=3 ;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (28752) AND `source_type`=0 AND `id` IN (0, 15) ;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (28754) AND `source_type`=0 AND `id` IN (0) ;
+UPDATE `creature_template_addon` SET `auras`="54582 54262 54263" WHERE `entry` IN (28779);
+DELETE FROM `smart_scripts` WHERE `entryorguid`=28779 AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(28779, 0, 0, 0, 0, 0, 100, 0, 2000, 3000, 9000, 11000, 11, 54580, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,"Blood of Mam'toth - IC - Cast 'Coagulate'");
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (28854) AND `source_type`=0 AND `id` IN (0);
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (29344) AND `source_type`=0 AND `id` IN (0) ;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (29648);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29648) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (29648);
+UPDATE `creature_addon` SET `auras`="57764" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (29648));
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (29821) AND `source_type`=0 AND `id` IN (0) ;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (29848);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29848) AND `source_type`=0 AND `id`=0; 
+UPDATE `creature_template_addon` SET `auras`="55474" WHERE `entry` IN (29848);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (29953);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29953) AND `source_type`=0 AND `id`=0; 
+UPDATE `creature_addon` SET `auras`="55587" WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (29953));
+UPDATE `creature_template_addon` SET `auras`="55587" WHERE `entry` IN (29953);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (30228);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30228) AND `source_type`=0 AND `id`=0;
+UPDATE `creature_template_addon` SET `auras`="56682" WHERE `entry` IN (30228);
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (30279) AND `source_type`=0 AND `id` IN (0) ;
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (30283) AND `source_type`=0 AND `id` IN (0, 1) ;
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (30617, 30627);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30617, 30627) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (30617, 30627);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(30617, 1, "41408"),
+(30627, 1, "41408");
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (30632) AND `source_type`=0 AND `id` IN (0);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (30947);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30947) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (30947);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(30947, 1, "58540");
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (31900) AND `source_type`=0 AND `id` IN (0);
+UPDATE `creature_template` SET  `AIName` = '' WHERE `entry` IN (33361, 33403, 33379, 33373, 33372);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (33361, 33403, 33379, 33373, 33372) AND `source_type`=0 AND `id`=0;  
+DELETE FROM `creature_template_addon` WHERE `entry` IN (33361, 33403, 33379, 33373, 33372);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES 
+(33361, 1, "63433"),
+(33403, 1, "63436"),
+(33379, 1, "63403"),
+(33373, 1, "63430"),
+(33372, 1, "63399");
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (33429) AND `source_type`=0 AND `id` IN (6);
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`IN (34127) AND `source_type`=0 AND `id` IN (5, 8);
diff --git a/sql/updates/world/2015_07_12_51_world_2015_07_01_02.sql b/sql/updates/world/2015_07_12_51_world_2015_07_01_02.sql
new file mode 100644
index 00000000000..59238432ba9
--- /dev/null
+++ b/sql/updates/world/2015_07_12_51_world_2015_07_01_02.sql
@@ -0,0 +1,3 @@
+-- Replaces deprecated items for the new ones
+UPDATE `npc_vendor` SET `item`=37736 WHERE `entry` IN (23710,27478) AND `item`=37571; -- Belbi Quikswitch/Larkin Thunderbrew
+UPDATE `npc_vendor` SET `item`=37737 WHERE `entry`=27489 AND `item`=37599; -- Ray'ma
diff --git a/sql/updates/world/2015_07_12_52_world_2015_07_06_00.sql b/sql/updates/world/2015_07_12_52_world_2015_07_06_00.sql
new file mode 100644
index 00000000000..9cde1a359a9
--- /dev/null
+++ b/sql/updates/world/2015_07_12_52_world_2015_07_06_00.sql
@@ -0,0 +1,95 @@
+SET @OGUID := 29829;
+SET @CGUID := 144096;
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+8;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(@OGUID+0, 184325, 550, 1, 676.5166, -44.52248, 48.28133, 2.530723, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184325 (Area: -1)
+(@OGUID+1, 184324, 550, 1, 676.6985, 43.16431, 48.28136, 0.6108655, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184324 (Area: -1)
+(@OGUID+2, 184069, 550, 1, 743.0566, 4.634431, 137.7959, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 184069 (Area: -1)
+(@OGUID+3, 184597, 550, 1, 744.0448, 42.35362, 46.661, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 184597 (Area: -1)
+(@OGUID+4, 184329, 550, 1, 544.6263, 141.888, 26.34531, 2.879789, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184329 (Area: -1)
+(@OGUID+5, 184327, 550, 1, 544.538, -143.1392, 26.34531, 3.403396, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184327 (Area: -1)
+(@OGUID+6, 184328, 550, 1, 654.1292, 75.33163, 48.19505, 0.6108655, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184328 (Area: -1)
+(@OGUID+7, 184326, 550, 1, 654.1447, -76.82803, 48.19501, 2.530723, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184326 (Area: -1)
+(@OGUID+8, 184596, 550, 1, 744.0446, -44.63448, 46.66097, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1); -- 184596 (Area: -1)
+
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+58;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+-- OLDWorld Trigger (DO NOT DELETE)
+(@CGUID+0, 15384, 550, 1, 330.3438, -1.1002, 42.86049, 3.176499, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+1, 15384, 550, 1, 335.6376, 59.48792, 17.93191, 1.832596, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+2, 15384, 550, 1, 332.723, -61.15897, 17.97906, 3.647738, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+3, 15384, 550, 1, 388.7913, -33.10595, 20.26358, 4.852015, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+4, 15384, 550, 1, 388.7511, 31.73123, 20.26364, 4.625123, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+5, 15384, 550, 1, 276.0723, -0.578703, 26.20747, 2.111848, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+6, 15384, 550, 1, 259.2285, 35.87902, 20.26298, 5.009095, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+7, 15384, 550, 1, 258.9592, -38.68707, 20.26289, 5.72468, 7200, 0, 0), -- 15384 (Area: -1)
+-- World Invisible Trigger
+(@CGUID+8, 12999, 550, 1, 425.4077, -0.379617, 80.36799, 0.9250245, 7200, 0, 0), -- 12999 (Area: -1)
+-- Bloodwarder Marshal
+(@CGUID+9, 20035, 550, 1, 639.83, 2.04339, 46.86218, 6.213372, 7200, 0, 0), -- 20035 (Area: -1)
+(@CGUID+10, 20035, 550, 1, 728.8043, -43.12828, 46.86215, 3.769911, 7200, 0, 0), -- 20035 (Area: -1)
+(@CGUID+11, 20035, 550, 1, 724.6683, 47.55159, 46.86216, 5.480334, 7200, 0, 0), -- 20035 (Area: -1)
+-- Crimson Hand Inquisitor
+(@CGUID+12, 20050, 550, 1, 730.1712, 45.34771, 46.86216, 3.438299, 7200, 0, 0), -- 20050 (Area: -1)
+(@CGUID+13, 20050, 550, 1, 639.6623, -3.341067, 46.86219, 0.05235988, 7200, 0, 0), -- 20050 (Area: -1)
+(@CGUID+14, 20050, 550, 1, 727.4787, -46.94502, 46.86214, 2.111848, 7200, 0, 0), -- 20050 (Area: -1)
+-- World Trigger (Large AOI)
+(@CGUID+15, 22517, 550, 1, 665.1088, -0.950598, 46.86217, 4.415683, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+16, 22517, 550, 1, 701.9359, 66.05067, 46.86216, 3.124139, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+17, 22517, 550, 1, 708.8086, -0.769152, 46.86216, 5.148721, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+18, 22517, 550, 1, 699.306, -67.62751, 46.86217, 1.518436, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+19, 22517, 550, 1, 732.9473, -0.566178, 46.86214, 3.612832, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+20, 22517, 550, 1, 798.8123, 61.56698, 115.3441, 3.769911, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+21, 22517, 550, 1, 785.4241, -52.29982, 134.9155, 4.712389, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+22, 22517, 550, 1, 775.7325, -61.36944, 119.4992, 5.8294, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+23, 22517, 550, 1, 799.8832, -39.79063, 86.04091, 3.316126, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+24, 22517, 550, 1, 800.0196, -62.71717, 109.6165, 1.605703, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+25, 22517, 550, 1, 799.4819, 38.38402, 84.18855, 3.839724, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+26, 22517, 550, 1, 851.5966, 17.91289, 109.8992, 1.27409, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+27, 22517, 550, 1, 847.8403, 14.67272, 64.72507, 3.787364, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+28, 22517, 550, 1, 844.8558, 6.185529, 65.86212, 0.2443461, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+29, 22517, 550, 1, 855.7502, -1.335043, 112.8265, 3.839724, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+30, 22517, 550, 1, 849.4088, 37.11266, 77.68398, 4.921828, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+31, 22517, 550, 1, 852.7165, -17.16145, 111.8991, 5.602507, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+32, 22517, 550, 1, 844.8883, -7.439569, 66.13985, 0.2443461, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+33, 22517, 550, 1, 846.6299, -37.76403, 84.40607, 2.617994, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+34, 22517, 550, 1, 847.9123, -16.27052, 64.80233, 4.660029, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+35, 22517, 550, 1, 848.437, 30.28408, 92.7951, 4.817109, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+36, 22517, 550, 1, 847.2033, -31.35966, 99.57969, 0.8203048, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+37, 22517, 550, 1, 766.7248, -0.726238, 50.13387, 0.1919862, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+38, 22517, 550, 1, 778.8183, 56.69846, 126.9899, 2.513274, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+39, 22517, 550, 1, 786.0614, 65.85825, 100.4249, 3.263766, 7200, 0, 0), -- 22517 (Area: -1)
+-- Crimson Hand Centurion
+(@CGUID+40, 20048, 550, 1, 645.0178, -81.17285, 46.95522, 4.08407, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+41, 20048, 550, 1, 651.8069, -89.19706, 46.88657, 3.769911, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+42, 20048, 550, 1, 723.4222, -42.63152, 46.86216, 5.340707, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+43, 20048, 550, 1, 642.194, -5.843318, 46.86219, 0.122173, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+44, 20048, 550, 1, 596.6088, -116.1815, 39.08448, 3.560472, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+45, 20048, 550, 1, 723.4005, 42.63834, 46.86216, 0.4363323, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+46, 20048, 550, 1, 601.6668, -127.0311, 39.08003, 3.193953, 7200, 0, 0), -- 20048 (Area: -1)
+-- Crimson Hand Battle Mage
+(@CGUID+47, 20047, 550, 1, 651.7038, -86.65275, 46.98884, 3.822271, 7200, 0, 0), -- 20047 (Area: -1)
+(@CGUID+48, 20047, 550, 1, 641.1581, -80.68994, 46.88804, 4.18879, 7200, 0, 0), -- 20047 (Area: -1)
+(@CGUID+49, 20047, 550, 1, 595.457, -133.0207, 36.76626, 2.984513, 7200, 0, 0), -- 20047 (Area: -1)
+(@CGUID+50, 20047, 550, 1, 587.3175, -118.0383, 37.48773, 3.769911, 7200, 0, 0), -- 20047 (Area: -1)
+-- Crimson Hand Blood Knight
+(@CGUID+51, 20049, 550, 1, 643.371, -78.52799, 46.8777, 4.153883, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+52, 20049, 550, 1, 654.1863, -91.09548, 46.82586, 3.682645, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+53, 20049, 550, 1, 722.7352, -47.12922, 46.86216, 0.4712389, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+54, 20049, 550, 1, 642.2731, 4.882175, 46.86217, 6.161012, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+55, 20049, 550, 1, 592.64, -116.0134, 38.14479, 3.665191, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+56, 20049, 550, 1, 598.7542, -130.3867, 37.92725, 3.089233, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+57, 20049, 550, 1, 728.1479, 39.56045, 46.86216, 1.692969, 7200, 0, 0), -- 20049 (Area: -1)
+-- World Trigger
+(@CGUID+58, 22515, 550, 1, 810.1933, -0.727374, 50.13386, 3.141593, 7200, 0, 0); -- 22515 (Area: -1)
+
+-- Correct some spawn positions with sniffed values
+UPDATE `creature` SET `position_x` = 792.7254, `position_y` = 12.77545, `position_z` = 48.81183, `orientation` = 3.595378 WHERE `guid` = 12568 AND `id` = 20063; -- Telonicus
+UPDATE `creature` SET `position_x` = 785.8074, `position_y` = 19.48621, `position_z` = 48.81183, `orientation` = 3.979351 WHERE `guid` = 12567 AND `id` = 20064; -- Thaladred
+UPDATE `creature` SET `position_x` = 792.4081, `position_y` = -13.24149, `position_z` = 48.81179, `orientation` = 2.687807 WHERE `guid` = 12569 AND `id` = 20062; -- Capernian
+UPDATE `creature` SET `position_x` = 785.7821, `position_y` = -20.39954, `position_z` = 48.81179, `orientation` = 2.303835 WHERE `guid` = 12570 AND `id` = 20060; -- Sanguinar
+UPDATE `creature` SET `position_x` = 795.4078, `position_y` = -1.604753, `position_z` = 48.8118, `orientation` = 3.141593 WHERE `guid` = 7987 AND `id` = 19622; -- Kael
+
+-- Improper spawns of Ember of Alar
+DELETE FROM `creature` WHERE `guid` IN (12481, 12482, 12483) AND `id` = 19551;
author	DDuarte <dnpd.dd@gmail.com>	2015-07-12 23:21:24 +0100
committer	DDuarte <dnpd.dd@gmail.com>	2015-07-12 23:21:42 +0100
commit	828e2bdd02b1f31db47746e76aa7cd2c9c4e65b9 (patch)
tree	da07903f61bbb17a34c6257ec4ba4e5deaf8eb24
parent	ebd081abaeeb72ed89ff6e09949630d6665cdccf (diff)