diff options
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; |