moonwell-core-vanilla/sql/migrations/20210515110157_world.sql

DROP PROCEDURE IF EXISTS add_migration;
delimiter ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20210515110157');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20210515110157');
-- Add your query below.


-- Stratholme - Wrath Phantom (credit cmangos)
UPDATE `creature_template` SET `faction` = 21, `base_attack_time` = 2000, `base_attack_time` = 2000, `dmg_school` = 5 WHERE `entry` = 10389;

-- Stratholme - Spiteful Phantom (credit cmangos)
UPDATE `creature_template` SET  `faction` = 21, `base_attack_time` = 2000, `base_attack_time` = 2000, `dmg_school` = 4 WHERE `entry` = 10388;

-- Stratholme - Runed Demonic Blade (credit cmangos)
UPDATE `gameobject_template` SET `size` = 2, `data0` = 1634, `data1` = 18015 WHERE `entry` = 181207;
UPDATE `gameobject_loot_template` SET `entry` = 18015 WHERE `entry` = 181207 and `item` = 22736;

-- The Barrens - Rathorian (credit cmangos)
UPDATE `creature_template` SET `dmg_school` = 5 WHERE `entry` = 3470;

-- Elwynn Forest - Fargodeep Mine - Narg the Taskmaster / Goldtooth (credit cmangos)
UPDATE `creature` SET `position_x` = -9733.9384765625, `position_y` = 115.4759368896484375, `position_z` = 24.58680152893066406, `orientation` = 1.514374375343322753, `wander_distance` = 1, `movement_type` = 1 WHERE `guid` = 80647;
UPDATE `creature` SET `position_x` = -9745.591796875, `position_y` = 87.60213470458984375, `position_z` = 12.82021617889404296, `orientation` = 1.686997294425964355, `wander_distance` = 1, `movement_type` = 1 WHERE `guid` = 80644;

-- Elwynn Forest - Forests Edge - Hogger (credit cmangos)
INSERT INTO `creature` (`guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `patch_max`) VALUES
(80731, 448, -9947.8779296875, 594.77252197265625, 39.60799789428710937, 5.193932056427001953, 180, 180, 15, 100, 0, 1, 10),
(81027, 448, -10107.1787109375, 618.212646484375, 38.20453262329101562, 3.78528451919555664, 180, 180, 15, 100, 0, 1, 10),
(81028, 448, -10085.3671875, 585.65655517578125, 39.27585601806640625, 1.303950071334838867, 180, 180, 15, 100, 0, 1, 10),
(81029, 448, -10018.634765625, 640.62945556640625, 39.06363296508789062, 1.332400083541870117, 180, 180, 15, 100, 0, 1, 10);
INSERT INTO `pool_creature_template` (`id`, `pool_entry`, `chance`, `description`) VALUES
(448, 1270, 0, 'Elwynn Forest - Forests Edge - Hogger (448)');
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(1270, 1, 'Elwynn Forest - Forests Edge - Hogger (448)');

-- Westfall - Dust Devil (credit cmangos)
UPDATE `creature` SET `position_x` = -11115.1083984375, `position_y` = 617.48870849609375, `position_z` = 37.60480499267578125, `orientation` = 4.004544258117675781, `wander_distance` = 45 WHERE `guid` = 48554;
UPDATE `creature` SET `position_x` = -10853.8818359375, `position_y` = 1680.4129638671875, `position_z` = 38.925048828125, `orientation` = 0.142995312809944152, `wander_distance` = 45 WHERE `guid` = 48555;
UPDATE `creature` SET `position_x` = -10617.1201171875, `position_y` = 818.68927001953125, `position_z` = 52.3733062744140625, `orientation` = 5.45745706558227539, `wander_distance` = 45 WHERE `guid` = 48556;
UPDATE `creature` SET `position_x` = -10214.4453125, `position_y` = 1778.2261962890625, `position_z` = 37.64616775512695312, `orientation` = 2.300807952880859375, `wander_distance` = 45 WHERE `guid` = 48557;
UPDATE `creature` SET `position_x` = -9916.6640625, `position_y` = 1612.09716796875, `position_z` = 40.00242996215820312, `orientation` = 1.225921034812927246, `wander_distance` = 45 WHERE `guid` = 48558;
UPDATE `creature` SET `position_x` = -10378.87890625, `position_y` = 1520.283447265625, `position_z` = 41.82687759399414062, `orientation` = 2.586306571960449218, `wander_distance` = 45 WHERE `guid` = 48872;
UPDATE `creature` SET `position_x` = -10549.564453125, `position_y` = 1852.3331298828125, `position_z` = 41.20833587646484375, `orientation` = 3.901455879211425781, `wander_distance` = 45 WHERE `guid` = 48873;
UPDATE `creature` SET `position_x` = -10215.8642578125, `position_y` = 888.76055908203125, `position_z` = 41.97357559204101562, `orientation` = 4.637966156005859375, `wander_distance` = 45 WHERE `guid` = 48874;
INSERT INTO `creature` (`guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `health_percent`, `mana_percent`, `movement_type`, `wander_distance`, `patch_max`) VALUES
(154, 832, -10350.7587890625, 1114.9698486328125, 37.03815078735351562, 0.915927052497863769, 300, 300, 100, 0, 1, 45, 10),
(155, 832, -10986.0615234375, 1815.8741455078125, 45.1251678466796875, 5.635118007659912109, 300, 300, 100, 0, 1, 45, 10),
(170, 832, -10550.6669921875, 1420.46337890625, 47.43852996826171875, 6.067455291748046875, 300, 300, 100, 0, 1, 45, 10),
(173, 832, -10785.8642578125, 1555.3922119140625, 48.61139297485351562, 4.12875223159790039, 300, 300, 100, 0, 1, 45, 10);

-- Blackthorn Ridge - Razormane Seer 
DELETE FROM `creature_movement` WHERE (`id` = 14480);
UPDATE `creature` SET `position_x` = -3734.420166015625, `position_y` = -1547.704833984375, `position_z` = 109.8757171630859375, `orientation` = 5.742133140563964843, `wander_distance` = 3 WHERE (`guid` = 14477);
UPDATE `creature` SET `position_x` = -3702.947509765625, `position_y` = -1580.9326171875, `position_z` = 92.1043853759765625, `orientation` = 5.755352973937988281, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14468);
UPDATE `creature` SET `position_x` = -3687.037353515625, `position_y` = -1596.4801025390625, `position_z` = 100.5415267944335937, `orientation` = 5.548810005187988281, `wander_distance` = 3 WHERE (`guid` = 14473);
UPDATE `creature` SET `position_x` = -3704.85986328125, `position_y` = -1606.4049072265625, `position_z` = 92.66349029541015625, `orientation` = 5.093235969543457031, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14474);
UPDATE `creature` SET `position_x` = -3680.6767578125, `position_y` = -1650.38427734375, `position_z` = 91.7571868896484375, `orientation` = 0.452244490385055541 WHERE (`guid` = 14465);
UPDATE `creature` SET `position_x` = -3722.87841796875, `position_y` = -1693.454833984375, `position_z` = 93.214447021484375, `orientation` = 0.910398006439208984 WHERE (`guid` = 14478);
UPDATE `creature` SET `position_x` = -3818.526123046875, `position_y` = -1516.234130859375, `position_z` = 109.3768844604492187, `orientation` = 1.402008533477783203, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14479);
UPDATE `creature` SET `position_x` = -3815.858154296875, `position_y` = -1551.2349853515625, `position_z` = 103.7778396606445312, `orientation` = 2.325322151184082031, `wander_distance` = 15 WHERE (`guid` = 14481);
UPDATE `creature` SET `position_x` = -3847.843017578125, `position_y` = -1480.9189453125, `position_z` = 125.04461669921875, `orientation` = 0.958988726139068603, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14480);
UPDATE `creature` SET `position_x` = -3849.216064453125, `position_y` = -1585.947265625, `position_z` = 94.95389556884765625, `orientation` = 2.443508863449096679, `wander_distance` = 15 WHERE (`guid` = 14483);
UPDATE `creature` SET `position_x` = -3949.75048828125, `position_y` = -1683.5694580078125, `position_z` = 91.99030303955078125, `orientation` = 0.787908792495727539 WHERE (`guid` = 14466);
UPDATE `creature` SET `position_x` = -3939.34033203125, `position_y` = -1611.8465576171875, `position_z` = 92.9383087158203125, `orientation` = 5.59519052505493164, `wander_distance` = 3 WHERE (`guid` = 14469);
UPDATE `creature` SET `position_x` = -3929.97998046875, `position_y` = -1644.9207763671875, `position_z` = 91.75000762939453125, `orientation` = 5.94186258316040039, `wander_distance` = 3 WHERE (`guid` = 14467);
UPDATE `creature` SET `position_x` = -3877.010009765625, `position_y` = -1637.673583984375, `position_z` = 91.790618896484375, `orientation` = 3.53634190559387207, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14482);
UPDATE `creature` SET `position_x` = -3896.322021484375, `position_y` = -1638.49658203125, `position_z` = 91.75, `orientation` = 0.890117883682250976, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14852);
UPDATE `creature` SET `position_x` = -3899.80859375, `position_y` = -1590.860107421875, `position_z` = 91.80103302001953125, `orientation` = 3.954757928848266601, `wander_distance` = 3 WHERE (`guid` = 14471);
UPDATE `creature` SET `position_x` = -3949.537841796875, `position_y` = -1579.2098388671875, `position_z` = 95.29972076416015625, `orientation` = 1.745146751403808593, `wander_distance` = 15 WHERE (`guid` = 14476);
UPDATE `creature` SET `position_x` = -3948.72998046875, `position_y` = -1750.0577392578125, `position_z` = 93.83647918701171875, `orientation` = 4.40481424331665039 WHERE (`guid` = 14870);
UPDATE `creature` SET `position_x` = -3982.5595703125, `position_y` = -1817.1763916015625, `position_z` = 92.387298583984375, `orientation` = 3.877511024475097656 WHERE (`guid` = 14472);
UPDATE `creature` SET `position_x` = -4000.796875, `position_y` = -1699.2528076171875, `position_z` = 109.85455322265625, `orientation` = 2.459156036376953125, `wander_distance` = 3 WHERE (`guid` = 14475);
UPDATE `creature` SET `position_x` = -4013.983642578125, `position_y` = -1733.058837890625, `position_z` = 100.4260635375976562, `orientation` = 2.17334747314453125, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14464);
UPDATE `creature` SET `position_x` = -4018.21484375, `position_y` = -1883.667724609375, `position_z` = 92.290130615234375, `orientation` = 4.933152198791503906, `wander_distance` = 15 WHERE (`guid` = 14470);

-- Blackthorn Ridge - Razormane Warfrenzy
DELETE FROM `creature_movement` WHERE (`id` = 14911);
UPDATE `creature` SET `position_x` = -3711.147705078125, `position_y` = -1561.383056640625, `position_z` = 91.75787353515625, `orientation` = 5.683600425720214843, `wander_distance` = 3 WHERE (`guid` = 14899);
UPDATE `creature` SET `position_x` = -3705.283935546875, `position_y` = -1636.061279296875, `position_z` = 93.87445831298828125, `orientation` = 4.081216812133789062 WHERE (`guid` = 14908);
UPDATE `creature` SET `position_x` = -3717.40576171875, `position_y` = -1651.58251953125, `position_z` = 91.77725982666015625, `orientation` = 1.990363240242004394 WHERE (`guid` = 14902);
UPDATE `creature` SET `position_x` = -3744.18408203125, `position_y` = -1570.5831298828125, `position_z` = 92.81789398193359375, `orientation` = 4.513307571411132812, `wander_distance` = 3 WHERE (`guid` = 14901);
UPDATE `creature` SET `position_x` = -3783.30908203125, `position_y` = -1548.28955078125, `position_z` = 86.74230194091796875, `orientation` = 5.793673038482666015, `wander_distance` = 15 WHERE (`guid` = 14909);
UPDATE `creature` SET `position_x` = -3891.163330078125, `position_y` = -1508.8834228515625, `position_z` = 134.773712158203125, `orientation` = 1.083611488342285156, `wander_distance` = 15 WHERE (`guid` = 14906);
UPDATE `creature` SET `position_x` = -3880.205810546875, `position_y` = -1607.9376220703125, `position_z` = 91.75000762939453125, `orientation` = 6.181790351867675781, `wander_distance` = 3 WHERE (`guid` = 14915);
UPDATE `creature` SET `position_x` = -3864.048583984375, `position_y` = -1645.2213134765625, `position_z` = 91.95745849609375, `orientation` = 5.572035789489746093, `wander_distance` = 3 WHERE (`guid` = 14913);
UPDATE `creature` SET `position_x` = -3915.796875, `position_y` = -1596.6441650390625, `position_z` = 92.6855010986328125, `orientation` = 2.042035102844238281, `wander_distance` = 3 WHERE (`guid` = 14904);
UPDATE `creature` SET `position_x` = -3939.6572265625, `position_y` = -1636.0543212890625, `position_z` = 91.75002288818359375, `orientation` = 3.98622894287109375, `wander_distance` = 3 WHERE (`guid` = 14900);
UPDATE `creature` SET `position_x` = -3846.838134765625, `position_y` = -1615.9185791015625, `position_z` = 94.44873046875, `orientation` = 5.897150993347167968, `wander_distance` = 15 WHERE (`guid` = 14914);
UPDATE `creature` SET `position_x` = -3904.112060546875, `position_y` = -1655.456787109375, `position_z` = 91.83074951171875, `orientation` = 3.273372888565063476, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14907);
UPDATE `creature` SET `position_x` = -3823.3759765625, `position_y` = -1639.760009765625, `position_z` = 91.93326568603515625, `orientation` = 5.501051902770996093 WHERE (`guid` = 14912);
UPDATE `creature` SET `position_x` = -3850.069580078125, `position_y` = -1545.6275634765625, `position_z` = 108.0192947387695312, `orientation` = 2.722713708877563476, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14910);
UPDATE `creature` SET `position_x` = -3845.513916015625, `position_y` = -1516.3941650390625, `position_z` = 110.0340728759765625, `orientation` = 6.234123706817626953, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14911);
UPDATE `creature` SET `position_x` = -3678.7109375, `position_y` = -1583.29150390625, `position_z` = 100.9452590942382812, `orientation` = 1.608775019645690917, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14903);
UPDATE `creature` SET `position_x` = -3720.5439453125, `position_y` = -1594.82080078125, `position_z` = 92.6669921875, `orientation` = 2.216568231582641601, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14905);

-- Blackthorn Ridge - Razormane Stalker 
DELETE FROM `creature_movement` WHERE (`id` IN (14456, 14458, 14459));
UPDATE `creature` SET `position_x` = -3739.767333984375, `position_y` = -1616.7410888671875, `position_z` = 93.49802398681640625, `orientation` = 3.741856575012207031 WHERE (`guid` = 14461);
UPDATE `creature` SET `position_x` = -3953.618896484375, `position_y` = -1846.1832275390625, `position_z` = 91.8077850341796875, `orientation` = 4.625122547149658203, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14447);
UPDATE `creature` SET `position_x` = -3914.016845703125, `position_y` = -1848.60595703125, `position_z` = 92.34610748291015625, `orientation` = 1.706279993057250976, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14457);
UPDATE `creature` SET `position_x` = -4019.349853515625, `position_y` = -1782.73095703125, `position_z` = 95.48525238037109375, `orientation` = 5.099140167236328125, `wander_distance` = 0, `movement_type` = 2 WHERE (`guid` = 14459);
UPDATE `creature` SET `position_x` = -3967.78564453125, `position_y` = -1847.4989013671875, `position_z` = 92.08513641357421875, `orientation` = 4.328416347503662109, `wander_distance` = 0, `movement_type` = 2 WHERE (`guid` = 14463);
UPDATE `creature` SET `position_x` = -3707.479248046875, `position_y` = -1625.7177734375, `position_z` = 93.5980682373046875, `orientation` = 1.884955525398254394, `wander_distance` = 0, `movement_type` = 2 WHERE (`guid` = 14462);
UPDATE `creature` SET `position_x` = -3987.1494140625, `position_y` = -1700.7276611328125, `position_z` = 101.2779083251953125, `orientation` = 4.140810012817382812, `wander_distance` = 0, `movement_type` = 2 WHERE (`guid` = 14450);
UPDATE `creature` SET `position_x` = -3914.80078125, `position_y` = -1686.4130859375, `position_z` = 93.79752349853515625, `orientation` = 3.014932632446289062, `movement_type` = 1, `wander_distance` = 3 WHERE (`guid` = 14458);
UPDATE `creature` SET `position_x` = -3881.443115234375, `position_y` = -1683.9642333984375, `position_z` = 92.446044921875, `orientation` = 3.704319715499877929, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14460);
UPDATE `creature` SET `position_x` = -3964.18701171875, `position_y` = -1726.6461181640625, `position_z` = 91.75, `orientation` = 0.685016036033630371, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14456);
UPDATE `creature` SET `position_x` = -3996.2666015625, `position_y` = -1753.4185791015625, `position_z` = 96.37256622314453125, `orientation` = 0.609398365020751953, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14449);
UPDATE `creature` SET `position_x` = -4015.509521484375, `position_y` = -1772.7977294921875, `position_z` = 96.6458740234375, `orientation` = 4.318390846252441406, `wander_distance` = 3, `movement_type` = 1 WHERE (`guid` = 14454);
UPDATE `creature` SET `position_x` = -3983.107666015625, `position_y` = -1784.988525390625, `position_z` = 91.75, `orientation` = 1.76606154441833496, `movement_type` = 1 WHERE (`guid` = 14451);
UPDATE `creature` SET `position_x` = -4016.32763671875, `position_y` = -1816.6165771484375, `position_z` = 93.98346710205078125, `orientation` = 3.474052190780639648, `movement_type` = 1 WHERE (`guid` = 14453);
UPDATE `creature` SET `position_x` = -4048.19580078125, `position_y` = -1850.2257080078125, `position_z` = 93.72255706787109375, `orientation` = 0.870968461036682128, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14448);
UPDATE `creature` SET `position_x` = -4015.97216796875, `position_y` = -1848.4598388671875, `position_z` = 92.07452392578125, `orientation` = 1.128053545951843261, `movement_type` = 1 WHERE (`guid` = 14455);
UPDATE `creature` SET `position_x` = -3949.8046875, `position_y` = -1815.7564697265625, `position_z` = 94.009063720703125, `orientation` = 3.414394617080688476, `wander_distance` = 15, `movement_type` = 1 WHERE (`guid` = 14452);

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14459, 1, -3998.294189453125, -1768.3206787109375, 92.48551177978515625, 100, 0, 0),
(14459, 2, -3985.19140625, -1755.57080078125, 93.90323638916015625, 100, 0, 0),
(14459, 3, -3968.66357421875, -1735.9847412109375, 92.62003326416015625, 100, 0, 0),
(14459, 4, -3947.14013671875, -1711.923828125, 91.79166412353515625, 100, 0, 0),
(14459, 5, -3941.966552734375, -1684.6060791015625, 92.03311920166015625, 100, 0, 0),
(14459, 6, -3924.58642578125, -1669.921875, 92.3057708740234375, 100, 0, 0),
(14459, 7, -3890.572021484375, -1654.6845703125, 91.79166412353515625, 100, 0, 0),
(14459, 8, -3871.137939453125, -1646.505615234375, 91.79166412353515625, 100, 0, 0),
(14459, 9, -3890.572021484375, -1654.6845703125, 91.79166412353515625, 100, 0, 0),
(14459, 10, -3924.58642578125, -1669.921875, 92.3057708740234375, 100, 0, 0),
(14459, 11, -3941.966552734375, -1684.6060791015625, 92.03311920166015625, 100, 0, 0),
(14459, 12, -3947.14013671875, -1711.923828125, 91.79166412353515625, 100, 0, 0),
(14459, 13, -3968.66357421875, -1735.9847412109375, 92.62003326416015625, 100, 0, 0),
(14459, 14, -3985.19140625, -1755.57080078125, 93.90323638916015625, 100, 0, 0),
(14459, 15, -3998.294189453125, -1768.3206787109375, 92.48551177978515625, 100, 0, 0),
(14459, 16, -4019.147216796875, -1783.228515625, 95.38814544677734375, 100, 0, 0);

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14463, 1, -3966.581298828125, -1817.1708984375, 93.36280059814453125, 100, 0, 0),
(14463, 2, -3971.7353515625, -1768.50830078125, 92.21231842041015625, 100, 0, 0),
(14463, 3, -3963.580322265625, -1750.2469482421875, 93.47452545166015625, 100, 0, 0),
(14463, 4, -3941.563720703125, -1736.299072265625, 92.29166412353515625, 100, 0, 0),
(14463, 5, -3910.04345703125, -1715.5157470703125, 93.07190704345703125, 100, 0, 0),
(14463, 6, -3894.415771484375, -1695.89501953125, 93.79166412353515625, 100, 0, 0),
(14463, 7, -3925.331298828125, -1668.5599365234375, 92.1937103271484375, 100, 0, 0),
(14463, 8, -3943.249267578125, -1637.40966796875, 91.79166412353515625, 100, 0, 0),
(14463, 9, -3941.50390625, -1616.904052734375, 92.78653717041015625, 100, 0, 0),
(14463, 10, -3937.6728515625, -1598.9700927734375, 93.9994354248046875, 100, 0, 0),
(14463, 11, -3924.12939453125, -1581.828369140625, 94.62467193603515625, 100, 0, 0),
(14463, 12, -3897.2109375, -1583.3812255859375, 91.79166412353515625, 100, 0, 0),
(14463, 13, -3873.07373046875, -1589.1622314453125, 92.21012115478515625, 100, 0, 0),
(14463, 14, -3836.016845703125, -1593.613037109375, 94.797088623046875, 100, 0, 0),
(14463, 15, -3790.6064453125, -1591.5621337890625, 93.4691619873046875, 100, 0, 0),
(14463, 16, -3747.341064453125, -1595.3931884765625, 94.11844635009765625, 100, 0, 0),
(14463, 17, -3715.487548828125, -1616.977294921875, 91.864105224609375, 100, 0, 0),
(14463, 18, -3747.341064453125, -1595.3931884765625, 94.11844635009765625, 100, 0, 0),
(14463, 19, -3790.6064453125, -1591.5621337890625, 93.4691619873046875, 100, 0, 0),
(14463, 20, -3836.016845703125, -1593.613037109375, 94.797088623046875, 100, 0, 0),
(14463, 21, -3873.07373046875, -1589.1622314453125, 92.21012115478515625, 100, 0, 0),
(14463, 22, -3897.2109375, -1583.3812255859375, 91.79166412353515625, 100, 0, 0),
(14463, 23, -3924.12939453125, -1581.828369140625, 94.62467193603515625, 100, 0, 0),
(14463, 24, -3937.6728515625, -1598.9700927734375, 93.9994354248046875, 100, 0, 0),
(14463, 25, -3941.50390625, -1616.904052734375, 92.78653717041015625, 100, 0, 0),
(14463, 26, -3943.249267578125, -1637.40966796875, 91.79166412353515625, 100, 0, 0),
(14463, 27, -3925.331298828125, -1668.5599365234375, 92.1937103271484375, 100, 0, 0),
(14463, 28, -3894.415771484375, -1695.89501953125, 93.79166412353515625, 100, 0, 0),
(14463, 29, -3910.04345703125, -1715.5157470703125, 93.07190704345703125, 100, 0, 0),
(14463, 30, -3941.563720703125, -1736.299072265625, 92.29166412353515625, 100, 0, 0),
(14463, 31, -3963.580322265625, -1750.2469482421875, 93.47452545166015625, 100, 0, 0),
(14463, 32, -3971.7353515625, -1768.50830078125, 92.21231842041015625, 100, 0, 0),
(14463, 33, -3966.581298828125, -1817.1708984375, 93.36280059814453125, 100, 0, 0),
(14463, 34, -3966.739990234375, -1848.2486572265625, 91.9879608154296875, 100, 0, 0);

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14462, 1, -3746.592041015625, -1620.11767578125, 92.81510162353515625, 100, 0, 0),
(14462, 2, -3771.6884765625, -1604.8638916015625, 93.52066802978515625, 100, 0, 0),
(14462, 3, -3811.658935546875, -1617.60400390625, 92.25308990478515625, 100, 0, 0),
(14462, 4, -3854.255615234375, -1623.04541015625, 93.690765380859375, 100, 0, 0),
(14462, 5, -3876.948486328125, -1646.83203125, 91.79166412353515625, 100, 0, 0),
(14462, 6, -3908.81591796875, -1667.0164794921875, 92.9232025146484375, 100, 0, 0),
(14462, 7, -3937.747802734375, -1674.614013671875, 91.79166412353515625, 100, 0, 0),
(14462, 8, -3957.114501953125, -1697.3070068359375, 91.79166412353515625, 100, 0, 0),
(14462, 9, -3968.3984375, -1722.902099609375, 91.79166412353515625, 100, 0, 0),
(14462, 10, -3994.439208984375, -1748.53369140625, 96.32340240478515625, 100, 0, 0),
(14462, 11, -3998.74658203125, -1766.65283203125, 93.05850982666015625, 100, 0, 0),
(14462, 12, -4016.666748046875, -1783.1439208984375, 95.69600677490234375, 100, 0, 0),
(14462, 13, -4034.07861328125, -1791.6168212890625, 93.64420318603515625, 100, 0, 0),
(14462, 14, -4048.76123046875, -1813.3311767578125, 94.58575439453125, 100, 0, 0),
(14462, 15, -4043.8525390625, -1837.8311767578125, 95.0143280029296875, 100, 0, 0),
(14462, 16, -4025.904052734375, -1875.193603515625, 91.79166412353515625, 100, 0, 0),
(14462, 17, -4005.89013671875, -1874.3975830078125, 92.01261138916015625, 100, 0, 0),
(14462, 18, -3988.811279296875, -1846.7237548828125, 93.7472381591796875, 100, 0, 0),
(14462, 19, -3959.00341796875, -1832.449462890625, 92.47901153564453125, 100, 0, 0),
(14462, 20, -3942.1015625, -1808.982666015625, 92.92237091064453125, 100, 0, 0),
(14462, 21, -3933.892333984375, -1774.31396484375, 92.56143951416015625, 100, 0, 0),
(14462, 22, -3927.954833984375, -1744.516845703125, 93.35520172119140625, 100, 0, 0),
(14462, 23, -3903.489501953125, -1736.5184326171875, 92.09934234619140625, 100, 0, 0),
(14462, 24, -3904.11376953125, -1699.411865234375, 94.0687103271484375, 100, 0, 0),
(14462, 25, -3898.48046875, -1678.0689697265625, 93.17179107666015625, 100, 0, 0),
(14462, 26, -3896.466064453125, -1647.417724609375, 91.79166412353515625, 100, 0, 0),
(14462, 27, -3874.388916015625, -1658.662109375, 91.52945709228515625, 100, 0, 0),
(14462, 28, -3863.10595703125, -1610.615478515625, 93.930511474609375, 100, 0, 0),
(14462, 29, -3842.54345703125, -1584.190185546875, 94.952850341796875, 100, 0, 0),
(14462, 30, -3834.811767578125, -1551.8248291015625, 101.6061782836914062, 100, 0, 0),
(14462, 31, -3816.94970703125, -1539.9151611328125, 102.3889999389648437, 100, 0, 0),
(14462, 32, -3792.05908203125, -1567.544921875, 91.5909881591796875, 100, 0, 0),
(14462, 33, -3765.852783203125, -1581.6890869140625, 93.10868072509765625, 100, 0, 0),
(14462, 34, -3741.364501953125, -1585.7574462890625, 92.97196197509765625, 100, 0, 0),
(14462, 35, -3719.835205078125, -1601.3856201171875, 92.181976318359375, 100, 0, 0),
(14462, 36, -3741.364501953125, -1585.7574462890625, 92.97196197509765625, 100, 0, 0),
(14462, 37, -3765.852783203125, -1581.6890869140625, 93.10868072509765625, 100, 0, 0),
(14462, 38, -3792.05908203125, -1567.544921875, 91.5909881591796875, 100, 0, 0),
(14462, 39, -3816.94970703125, -1539.9151611328125, 102.3889999389648437, 100, 0, 0),
(14462, 40, -3834.811767578125, -1551.8248291015625, 101.6061782836914062, 100, 0, 0),
(14462, 41, -3842.54345703125, -1584.190185546875, 94.952850341796875, 100, 0, 0),
(14462, 42, -3863.10595703125, -1610.615478515625, 93.930511474609375, 100, 0, 0),
(14462, 43, -3874.388916015625, -1658.662109375, 91.52945709228515625, 100, 0, 0),
(14462, 44, -3896.466064453125, -1647.417724609375, 91.79166412353515625, 100, 0, 0),
(14462, 45, -3898.48046875, -1678.0689697265625, 93.17179107666015625, 100, 0, 0),
(14462, 46, -3904.11376953125, -1699.411865234375, 94.0687103271484375, 100, 0, 0),
(14462, 47, -3903.489501953125, -1736.5184326171875, 92.09934234619140625, 100, 0, 0),
(14462, 48, -3927.954833984375, -1744.516845703125, 93.35520172119140625, 100, 0, 0),
(14462, 49, -3933.892333984375, -1774.31396484375, 92.56143951416015625, 100, 0, 0),
(14462, 50, -3942.1015625, -1808.982666015625, 92.92237091064453125, 100, 0, 0),
(14462, 51, -3959.00341796875, -1832.449462890625, 92.47901153564453125, 100, 0, 0),
(14462, 52, -3988.811279296875, -1846.7237548828125, 93.7472381591796875, 100, 0, 0),
(14462, 53, -4005.89013671875, -1874.3975830078125, 92.01261138916015625, 100, 0, 0),
(14462, 54, -4025.904052734375, -1875.193603515625, 91.79166412353515625, 100, 0, 0),
(14462, 55, -4043.8525390625, -1837.8311767578125, 95.0143280029296875, 100, 0, 0),
(14462, 56, -4048.76123046875, -1813.3311767578125, 94.58575439453125, 100, 0, 0),
(14462, 57, -4034.07861328125, -1791.6168212890625, 93.64420318603515625, 100, 0, 0),
(14462, 58, -4016.666748046875, -1783.1439208984375, 95.69600677490234375, 100, 0, 0),
(14462, 59, -3998.74658203125, -1766.65283203125, 93.05850982666015625, 100, 0, 0),
(14462, 60, -3994.439208984375, -1748.53369140625, 96.32340240478515625, 100, 0, 0),
(14462, 61, -3968.3984375, -1722.902099609375, 91.79166412353515625, 100, 0, 0),
(14462, 62, -3957.114501953125, -1697.3070068359375, 91.79166412353515625, 100, 0, 0),
(14462, 63, -3937.747802734375, -1674.614013671875, 91.79166412353515625, 100, 0, 0),
(14462, 64, -3908.81591796875, -1667.0164794921875, 92.9232025146484375, 100, 0, 0),
(14462, 65, -3876.948486328125, -1646.83203125, 91.79166412353515625, 100, 0, 0),
(14462, 66, -3854.255615234375, -1623.04541015625, 93.690765380859375, 100, 0, 0),
(14462, 67, -3811.658935546875, -1617.60400390625, 92.25308990478515625, 100, 0, 0),
(14462, 68, -3771.6884765625, -1604.8638916015625, 93.52066802978515625, 100, 0, 0),
(14462, 69, -3746.592041015625, -1620.11767578125, 92.81510162353515625, 100, 0, 0),
(14462, 70, -3708.046142578125, -1624.884521484375, 93.223968505859375, 100, 0, 0);

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14450, 1, -3991.114990234375, -1722.455078125, 94.63809967041015625, 100, 0, 0),
(14450, 2, -3991.162841796875, -1739.0048828125, 93.76627349853515625, 100, 0, 0),
(14450, 3, -3978.96533203125, -1759.072021484375, 92.25333404541015625, 100, 0, 0),
(14450, 4, -3981.11669921875, -1771.773193359375, 91.79166412353515625, 100, 0, 0),
(14450, 5, -3961.44970703125, -1798.943603515625, 91.79166412353515625, 100, 0, 0),
(14450, 6, -3960.98046875, -1822.943359375, 93.66724395751953125, 100, 0, 0),
(14450, 7, -3961.8212890625, -1839.3780517578125, 92.04770660400390625, 100, 0, 0),
(14450, 8, -3987.704345703125, -1848.51953125, 93.3592987060546875, 100, 0, 0),
(14450, 9, -4004.0517578125, -1854.6500244140625, 91.7916717529296875, 100, 0, 0),
(14450, 10, -4010.03173828125, -1876.521240234375, 92.03678131103515625, 100, 0, 0),
(14450, 11, -4004.0517578125, -1854.6500244140625, 91.7916717529296875, 100, 0, 0),
(14450, 12, -3987.704345703125, -1848.51953125, 93.3592987060546875, 100, 0, 0),
(14450, 13, -3961.8212890625, -1839.3780517578125, 92.04770660400390625, 100, 0, 0),
(14450, 14, -3960.954833984375, -1823.0679931640625, 93.71143341064453125, 100, 0, 0),
(14450, 15, -3961.44970703125, -1798.943603515625, 91.79166412353515625, 100, 0, 0),
(14450, 16, -3981.11669921875, -1771.773193359375, 91.79166412353515625, 100, 0, 0),
(14450, 17, -3978.96533203125, -1759.072021484375, 92.25333404541015625, 100, 0, 0),
(14450, 18, -3991.162841796875, -1739.0048828125, 93.76627349853515625, 100, 0, 0),
(14450, 19, -3991.114990234375, -1722.455078125, 94.63809967041015625, 100, 0, 0),
(14450, 20, -3988.694091796875, -1703.1265869140625, 102.1695938110351562, 100, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `health_percent`, `mana_percent`, `movement_type`, `wander_distance`, `patch_max`) VALUES
(14490, 3457, 1, -3971.21142578125, -1694.1512451171875, 92.91718292236328125, 5.393429279327392578, 275, 275, 100, 0, 1, 3, 10),
(14522, 3457, 1, -3988.124267578125, -1715.4732666015625, 97.33461761474609375, 2.168816566467285156, 275, 275, 100, 0, 1, 3, 10),
(14538, 3457, 1, -4040.241455078125, -1790.84765625, 93.35214996337890625, 4.834561824798583984, 275, 275, 100, 0, 1, 3, 10),
(14539, 3457, 1, -4049.8359375, -1914.0797119140625, 92.91652679443359375, 0.489519417285919189, 275, 275, 100, 0, 1, 3, 10),
(14540, 3457, 1, -3971.19921875, -1859.3646240234375, 92.62744140625, 5.244793891906738281, 275, 275, 100, 0, 1, 3, 10),
(14543, 3457, 1, -3997.637939453125, -1876.1453857421875, 92.88404083251953125, 1.698674798011779785, 275, 275, 100, 0, 1, 3, 10);

-- Noboru the Cudgel Waypoints (credit cmangos)
UPDATE `creature` SET `position_x` = -10141.78125, `position_y` = -3501.775146484375, `position_z` = 23.06176376342773437, `orientation` = 3.31115579605102539, `wander_distance` = 0, `movement_type` = 0 WHERE `guid` = 43589;
UPDATE `creature` SET `position_x` = -10146.423828125, `position_y` = -3505.00439453125, `position_z` = 23.02414512634277343, `orientation` = 2.316309928894042968, `wander_distance` = 0, `movement_type` = 0 WHERE `guid` = 43590;
UPDATE `creature` SET `position_x` = -10146.3828125, `position_y` = -3500.4365234375, `position_z` = 23.08516883850097656, `orientation` = 3.328068971633911132, `movement_type` = 2 WHERE `guid` = 43588;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(5477, 1, -10199.28125, -3489.0244140625, 22.89615440368652343, 100, 0, 0),
(5477, 2, -10208.9814453125, -3470.27783203125, 23.36289024353027343, 100, 0, 0),
(5477, 3, -10218.23828125, -3447.069580078125, 22.50715446472167968, 100, 0, 0),
(5477, 4, -10217.212890625, -3422.0703125, 20.87409400939941406, 100, 0, 0),
(5477, 5, -10212.0126953125, -3382.2548828125, 23.25324440002441406, 100, 0, 0),
(5477, 6, -10210.7939453125, -3339.044677734375, 24.30500602722167968, 100, 0, 0),
(5477, 7, -10208.2080078125, -3308.25341796875, 22.02155876159667968, 100, 0, 0),
(5477, 8, -10212.1845703125, -3288.988525390625, 20.03130912780761718, 100, 0, 0),
(5477, 9, -10179.041015625, -3269.541015625, 22.29747200012207031, 100, 0, 0),
(5477, 10, -10151.513671875, -3240.291259765625, 20.44405174255371093, 100, 0, 0),
(5477, 11, -10135.18359375, -3221.2890625, 22.11031723022460937, 100, 0, 0),
(5477, 12, -10111.1806640625, -3191.95947265625, 20.99517822265625, 100, 0, 0),
(5477, 13, -10116.873046875, -3159.724853515625, 23.36187744140625, 100, 0, 0),
(5477, 14, -10152.5146484375, -3146.046142578125, 20.62872314453125, 100, 0, 0),
(5477, 15, -10168.91015625, -3113.720703125, 22.32606887817382812, 100, 0, 0),
(5477, 16, -10202.677734375, -3103.907470703125, 24.04048919677734375, 100, 0, 0),
(5477, 17, -10240.646484375, -3097.669189453125, 21.9894256591796875, 100, 0, 0),
(5477, 18, -10282.701171875, -3092.743896484375, 23.1742401123046875, 100, 0, 0),
(5477, 19, -10309.5048828125, -3074.629150390625, 23.08895301818847656, 100, 0, 0),
(5477, 20, -10331.9814453125, -3065.276123046875, 23.26966094970703125, 100, 0, 0),
(5477, 21, -10319.2578125, -3044.580810546875, 22.30823516845703125, 100, 0, 0),
(5477, 22, -10300.271484375, -3007.030029296875, 21.12286567687988281, 100, 0, 0),
(5477, 23, -10294.0673828125, -2991.93359375, 22.43688011169433593, 100, 0, 0),
(5477, 24, -10272.6298828125, -2989.186767578125, 22.01354026794433593, 100, 0, 0),
(5477, 25, -10239.630859375, -2988.478515625, 22.00403594970703125, 100, 0, 0),
(5477, 26, -10219.9150390625, -2974.809814453125, 19.83499908447265625, 100, 0, 0),
(5477, 27, -10189.126953125, -2962.115478515625, 22.09839057922363281, 100, 0, 0),
(5477, 28, -10178.8720703125, -2963.053955078125, 23.43799018859863281, 100, 0, 0),
(5477, 29, -10189.126953125, -2962.115478515625, 22.09839057922363281, 100, 0, 0),
(5477, 30, -10219.9150390625, -2974.809814453125, 19.83499908447265625, 100, 0, 0),
(5477, 31, -10239.5234375, -2988.482666015625, 22.01819610595703125, 100, 0, 0),
(5477, 32, -10272.6298828125, -2989.186767578125, 22.01354026794433593, 100, 0, 0),
(5477, 33, -10294.0673828125, -2991.93359375, 22.43688011169433593, 100, 0, 0),
(5477, 34, -10300.271484375, -3007.030029296875, 21.12286567687988281, 100, 0, 0),
(5477, 35, -10319.2578125, -3044.580810546875, 22.30823516845703125, 100, 0, 0),
(5477, 36, -10331.9814453125, -3065.276123046875, 23.26966094970703125, 100, 0, 0),
(5477, 37, -10309.5048828125, -3074.629150390625, 23.08895301818847656, 100, 0, 0),
(5477, 38, -10282.701171875, -3092.743896484375, 23.1742401123046875, 100, 0, 0),
(5477, 39, -10240.646484375, -3097.669189453125, 21.9894256591796875, 100, 0, 0),
(5477, 40, -10202.677734375, -3103.907470703125, 24.04048919677734375, 100, 0, 0),
(5477, 41, -10168.91015625, -3113.720703125, 22.32606887817382812, 100, 0, 0),
(5477, 42, -10152.5146484375, -3146.046142578125, 20.62872314453125, 100, 0, 0),
(5477, 43, -10116.873046875, -3159.724853515625, 23.36187744140625, 100, 0, 0),
(5477, 44, -10111.1806640625, -3191.95947265625, 20.99517822265625, 100, 0, 0),
(5477, 45, -10135.18359375, -3221.2890625, 22.11031723022460937, 100, 0, 0),
(5477, 46, -10151.513671875, -3240.291259765625, 20.44405174255371093, 100, 0, 0),
(5477, 47, -10179.041015625, -3269.541015625, 22.29747200012207031, 100, 0, 0),
(5477, 48, -10212.1845703125, -3288.988525390625, 20.03130912780761718, 100, 0, 0),
(5477, 49, -10208.2080078125, -3308.25341796875, 22.02155876159667968, 100, 0, 0),
(5477, 50, -10210.7939453125, -3339.044677734375, 24.30500602722167968, 100, 0, 0),
(5477, 51, -10212.0126953125, -3382.2548828125, 23.25324440002441406, 100, 0, 0),
(5477, 52, -10217.236328125, -3422.067138671875, 20.74958229064941406, 100, 0, 0),
(5477, 53, -10218.26171875, -3447.06640625, 22.42780876159667968, 100, 0, 0),
(5477, 54, -10208.9814453125, -3470.27783203125, 23.36289024353027343, 100, 0, 0),
(5477, 55, -10199.28125, -3489.0244140625, 22.89615440368652343, 100, 0, 0),
(5477, 56, -10174.763671875, -3505.798583984375, 23.74078178405761718, 100, 0, 0);
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(43588, 43589, 4, 2.35619, 11),
(43588, 43590, 4, 3.92699, 11);
                                                
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 5 WHERE `guid` = 20299;
                                                
-- Kodo Hide Bag is a Leatherworking Quest
UPDATE `quest_template` SET `RequiredSkill` = 165, `RequiredSkillValue` = 1, `PrevQuestId` = 0 WHERE `entry` = 769;

-- Gordok Courtyard Key should not drop from trash mobs                                            
DELETE FROM `creature_loot_template` WHERE `item` = 18266;

-- Add correct Items to Vendor Ranik
UPDATE `npc_vendor` SET `item` = 6275 WHERE `entry` = 3499 AND `item` = 2675;

-- Fix Ridge Huntress Stuck Underground
UPDATE `creature` SET `position_x` = -6662.364258, `position_y` = -3489.209961, `position_z`= 256.418640 WHERE `guid` = 6915;

-- Officer's Door inside Champions' Hall.
UPDATE `gameobject_template` SET `flags`=32 WHERE `entry`=176575;
UPDATE `gameobject` SET `state`=1, `animprogress`=100 WHERE `id`=176575;

-- Officer's Door in Stormwind City.
DELETE FROM `gameobject` WHERE `guid`=30699;
UPDATE `gameobject` SET `state`=1, `patch_min`=0, `patch_max`=10 WHERE `guid`=26262;
DELETE FROM `gameobject_template` WHERE `entry`=176576;
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (176576, 0, 0, 4413, 'Officer\'s Door', 0, 48, 1, 0, 0, 196608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (176576, 2, 0, 4413, 'Officer\'s Door', 0, 32, 1, 0, 0, 196608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

-- Officer's Door inside Hall of Legends.
UPDATE `gameobject_template` SET `data0`=0, `data2`=196608 WHERE `entry`=176566;
UPDATE `gameobject` SET `state`=1, `animprogress`=100 WHERE `id`=176566;

-- Officer's Door in Orgrimmar.
DELETE FROM `gameobject` WHERE `guid`=31661;
UPDATE `gameobject` SET `position_x`=1634.87, `position_y`=-4247.86, `position_z`=55.8397, `orientation`=4.19752, `rotation2`=-0.863835, `rotation3`=0.503774, `state`=1, `patch_min`=0, `patch_max`=10 WHERE `guid`=31660;
DELETE FROM `gameobject_template` WHERE `entry`=176562;
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (176562, 0, 0, 4412, 'Officer\'s Door', 0, 48, 1, 0, 0, 196608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (176562, 2, 0, 4412, 'Officer\'s Door', 0, 32, 1, 0, 0, 196608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

-- Brave Ironhorn 3212 (credit cmangos)
DELETE FROM `creature_movement` WHERE `id` IN (25222);
DELETE FROM `creature_movement_template` WHERE `entry` = 3212;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(3212,1,-2298.2,-351.438,-9.42489,100,0,0),
(3212,2,-2291.71,-343.486,-9.42489,100,0,0),
(3212,3,-2282.4,-330.866,-9.42489,100,0,0),
(3212,4,-2268.44,-310.453,-9.42489,100,45000,0),
(3212,5,-2281.84,-330.136,-9.42489,100,0,0),
(3212,6,-2291.55,-343.159,-9.42489,100,0,0),
(3212,7,-2304.42,-358.541,-9.29993,100,60000,0);

-- Brave Strongbash 3215 (credit cmangos)
UPDATE `creature` SET `position_x` = -2231.419434, `position_y` = -440.354370, `position_z` = -9.072980, `wander_distance` = 10, `movement_type` = 1 WHERE `guid` = 25468;

-- Brave Dawneagle 3217 (credit cmangos)
UPDATE `creature` SET `position_x` = -2346.944336, `position_y` = -569.264160, `position_z` = -5.403835, `wander_distance` = 10, `movement_type` = 1 WHERE `guid` = 25768;

-- Brave Swiftwind 3218 (credit cmangos)
UPDATE `creature` SET `position_x` = -2230.241943, `position_y` = -493.677399, `position_z` = -7.003939, `wander_distance` = 10, `movement_type` = 1 WHERE `guid` = 25797;

-- Brave Rockhorn 3221 (credit cmangos)
UPDATE `creature` SET `position_x` = -2420.237061, `position_y` = -535.265320, `position_z` = -8.944574, `wander_distance` = 10, `movement_type` = 1 WHERE `guid` = 25946;

-- Brave Rainchaser 3223 (credit cmangos)
UPDATE `creature` SET `position_x` = -2428.320557, `position_y` = -426.269196, `position_z` = -3.226686, `wander_distance` = 15, `movement_type` = 1 WHERE `guid` = 25996;

-- Brave Leaping Deer 3219 (credit cmangos)
DELETE FROM `creature_movement` WHERE `id` IN (25829);
DELETE FROM `creature_movement_template` WHERE `entry` = 3219;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(3219,1,-2272.73,-568.658,-8.95156,100,0,0),
(3219,2,-2259.37,-559.312,-9.22062,100,0,0),
(3219,3,-2240.58,-547.992,-9.68616,100,0,0),
(3219,4,-2226.31,-537.873,-9.55282,100,0,0),
(3219,5,-2212.15,-527.607,-9.50613,100,0,0),
(3219,6,-2200.57,-519.734,-9.36321,100,0,0),
(3219,7,-2189.11,-511.698,-9.41977,100,0,0),
(3219,8,-2178.02,-503.16,-9.4245,100,0,0),
(3219,9,-2162.45,-489.092,-9.31665,100,0,0),
(3219,10,-2148.87,-476.906,-9.18732,100,0,0),
(3219,11,-2137.1,-464.155,-9.40511,100,0,0),
(3219,12,-2127.31,-454.562,-9.33309,100,0,0),
(3219,13,-2113.38,-450.415,-8.93407,100,0,0),
(3219,14,-2126.06,-453.998,-9.32824,100,0,0),
(3219,15,-2136.26,-463.148,-9.39692,100,0,0),
(3219,16,-2148.01,-476.05,-9.214,100,0,0),
(3219,17,-2161.52,-488.36,-9.28535,100,0,0),
(3219,18,-2176.82,-502.179,-9.42166,100,0,0),
(3219,19,-2187.83,-510.835,-9.42139,100,0,0),
(3219,20,-2199.65,-519.008,-9.36565,100,0,0),
(3219,21,-2210.84,-526.624,-9.47771,100,0,0),
(3219,22,-2224.29,-536.375,-9.52534,100,0,0),
(3219,23,-2238.99,-546.799,-9.67003,100,0,0),
(3219,24,-2258.44,-558.824,-9.29044,100,0,0),
(3219,25,-2271.85,-568.12,-8.9458,100,0,0),
(3219,26,-2280.07,-576.787,-9.1016,100,0,0),
(3219,27,-2287.31,-585.167,-9.2441,100,0,0),
(3219,28,-2279.6,-576.683,-9.1001,100,0,0);

-- Brave Darksky 3220 (credit cmangos)
DELETE FROM `creature_movement` WHERE `id` IN (25849);
DELETE FROM `creature_movement_template` WHERE `entry` = 3220;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
(3220,1,-2145.25,-423.961,-4.73679,100,0,0,0),
(3220,2,-2138.01,-430.979,-6.61955,100,0,0,0),
(3220,3,-2124.24,-434.329,-8.21678,100,0,0,0),
(3220,4,-2112.64,-432.811,-7.75092,100,0,0,0),
(3220,5,-2103.88,-425.69,-6.33626,100,0,0,0),
(3220,6,-2100.36,-421.59,-5.33525,100,0,0,0),
(3220,7,-2092.45,-409.603,-8.61398,100,0,0,0),
(3220,8,-2082.15,-395.164,-10.1276,100,0,0,0),
(3220,9,-2070.78,-379.774,-10.142,100,0,0,0),
(3220,10,-2060.26,-365.842,-8.69267,100,0,0,0),
(3220,11,-2052.33,-355.33,-5.32804,100,0,0,0),
(3220,12,-2047.17,-346.573,-6.44673,100,0,0,0),
(3220,13,-2037.19,-331.33,-8.29043,0.962816,60000,0,0),
(3220,14,-2046.5,-345.848,-6.55182,100,0,0,0),
(3220,15,-2051.8,-354.856,-5.34343,100,0,0,0),
(3220,16,-2059.73,-365.244,-8.59291,100,0,0,0),
(3220,17,-2070.31,-379.249,-10.1046,100,0,0,0),
(3220,18,-2081.43,-394.128,-10.1875,100,0,0,0),
(3220,19,-2091.91,-408.781,-8.74285,100,0,0,0),
(3220,20,-2100.29,-421.368,-5.32932,100,0,0,0),
(3220,21,-2102.79,-424.611,-5.39383,100,0,0,0),
(3220,22,-2111.1,-431.819,-7.53913,100,0,0,0),
(3220,23,-2123.01,-434.328,-8.21845,100,0,0,0),
(3220,24,-2137.24,-431.42,-6.79462,100,0,0,0),
(3220,25,-2144.59,-424.52,-4.8653,100,0,0,0),
(3220,26,-2148.51,-416.498,-3.65111,100,15000,5,0);

-- Brave Wildrunner 3222 (credit cmangos)
DELETE FROM `creature_movement` WHERE `id` IN (25971);
DELETE FROM `creature_movement_template` WHERE `entry` = 3222;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(3222,1,-2362.1,-390.164,-6.42207,100,0,0),
(3222,2,-2375.46,-388.484,-4.36099,100,0,0),
(3222,3,-2362.69,-390.051,-6.32043,100,0,0),
(3222,4,-2346.92,-401.052,-8.76384,100,0,0),
(3222,5,-2354.09,-411.151,-9.62591,100,0,0),
(3222,6,-2367.23,-422.885,-9.41758,100,0,0),
(3222,7,-2382.75,-434.843,-8.85514,100,0,0),
(3222,8,-2368.13,-423.745,-9.40204,100,0,0),
(3222,9,-2354.89,-412.086,-9.65188,100,0,0),
(3222,10,-2346.79,-401.761,-8.82241,100,0,0),
(3222,11,-2357.01,-393.213,-7.4745,100,0,0),
(3222,12,-2361.89,-390.492,-6.47299,100,0,0),
(3222,13,-2374.99,-388.569,-4.39082,100,0,0),
(3222,14,-2362.33,-390.291,-6.39084,100,0,0),
(3222,15,-2346.76,-394.591,-8.23082,100,0,0),
(3222,16,-2324.54,-396.704,-8.10889,100,0,0),
(3222,17,-2315.63,-393.945,-8.63139,100,0,0),
(3222,18,-2310.55,-386.913,-9.11332,100,0,0),
(3222,19,-2305.12,-377.337,-9.22376,100,0,0),
(3222,20,-2294.72,-375.317,-9.27485,100,0,0),
(3222,21,-2286.61,-375.294,-9.40442,100,0,0),
(3222,22,-2273.96,-383.353,-9.42395,100,0,0),
(3222,23,-2264.92,-389.313,-9.42395,100,0,0),
(3222,24,-2250.44,-387.983,-9.42395,100,0,0),
(3222,25,-2237.12,-385.581,-9.42395,100,0,0),
(3222,26,-2220.76,-386.094,-9.41871,100,0,0),
(3222,27,-2205.99,-388.292,-8.06188,100,0,0),
(3222,28,-2196.4,-391.052,-6.18634,100,0,0),
(3222,29,-2178.99,-392.042,-3.76443,100,0,0),
(3222,30,-2196.46,-396.049,-5.84742,100,0,0),
(3222,31,-2211,-400.197,-8.04214,100,0,0),
(3222,32,-2226.7,-419.667,-9.3831,100,0,0),
(3222,33,-2240.58,-436.043,-9.42391,100,0,0),
(3222,34,-2250.57,-446.375,-9.36871,100,0,0),
(3222,35,-2259.71,-455.322,-8.10143,100,0,0),
(3222,36,-2264.55,-458.615,-8.05276,100,0,0),
(3222,37,-2270.51,-458.245,-7.09582,100,0,0),
(3222,38,-2278.78,-455.2,-5.8183,100,0,0),
(3222,39,-2287.57,-451.09,-5.00688,100,0,0),
(3222,40,-2297.79,-446.529,-5.43833,100,0,0),
(3222,41,-2307.09,-442.195,-5.43833,100,0,0),
(3222,42,-2311.76,-430.689,-5.43833,100,0,0),
(3222,43,-2314.42,-421.159,-5.00785,100,0,0),
(3222,44,-2317.55,-410.02,-6.92146,100,0,0),
(3222,45,-2320.52,-401.265,-8.36848,100,0,0),
(3222,46,-2317.5,-384.084,-8.68469,100,0,0),
(3222,47,-2313.86,-361.247,-9.42375,100,0,0),
(3222,48,-2318.75,-349.606,-9.33739,100,0,0),
(3222,49,-2326.33,-340.258,-9.37897,100,0,0),
(3222,50,-2331.81,-328.02,-8.9977,100,0,0),
(3222,51,-2336.67,-317.216,-9.3216,100,0,0),
(3222,52,-2332.24,-327.504,-8.97723,100,0,0),
(3222,53,-2327.05,-339.495,-9.37647,100,0,0),
(3222,54,-2319.39,-349.119,-9.32185,100,0,0),
(3222,55,-2314.3,-360.069,-9.42418,100,0,0),
(3222,56,-2317.28,-383.543,-8.73534,100,0,0),
(3222,57,-2320.61,-401.061,-8.36308,100,0,0),
(3222,58,-2317.91,-409.313,-7.00568,100,0,0),
(3222,59,-2314.79,-420.547,-5.13457,100,0,0),
(3222,60,-2312.16,-429.307,-5.43833,100,0,0),
(3222,61,-2307.55,-441.624,-5.43833,100,0,0),
(3222,62,-2299.13,-445.991,-5.43833,100,0,0),
(3222,63,-2287.65,-450.94,-5.00741,100,0,0),
(3222,64,-2279.23,-455.174,-5.73992,100,0,0),
(3222,65,-2271.56,-458.118,-6.98679,100,0,0),
(3222,66,-2265.37,-458.805,-8.05597,100,0,0),
(3222,67,-2260.42,-455.823,-8.07678,100,0,0),
(3222,68,-2251.49,-447.223,-9.28688,100,0,0),
(3222,69,-2241.41,-436.973,-9.42448,100,0,0),
(3222,70,-2227.31,-420.418,-9.3886,100,0,0),
(3222,71,-2211.36,-400.907,-8.07511,100,0,0),
(3222,72,-2196.92,-395.961,-5.9352,100,0,0),
(3222,73,-2178.88,-392.144,-3.76367,100,0,0),
(3222,74,-2194.74,-391.121,-5.85785,100,0,0),
(3222,75,-2219.08,-386.393,-9.35368,100,0,0),
(3222,76,-2236.59,-385.575,-9.42354,100,0,0),
(3222,77,-2248.19,-387.537,-9.42354,100,0,0),
(3222,78,-2264.4,-389.364,-9.42354,100,0,0),
(3222,79,-2273.3,-383.892,-9.42354,100,0,0),
(3222,80,-2285.88,-375.369,-9.4112,100,0,0),
(3222,81,-2294.18,-374.99,-9.29083,100,0,0),
(3222,82,-2304.23,-376.537,-9.22788,100,0,0),
(3222,83,-2310.61,-387.123,-9.10346,100,0,0),
(3222,84,-2315.59,-393.766,-8.63748,100,0,0),
(3222,85,-2323.53,-396.452,-8.12964,100,0,0),
(3222,86,-2329.52,-396.651,-8.07738,100,0,0),
(3222,87,-2351.43,-393.596,-8.11827,100,0,0);

-- Brave Cloudmane 3224 (credit cmangos)
DELETE FROM `creature_movement` WHERE `id` IN (26053);
DELETE FROM `creature_movement_template` WHERE `entry` = 3224;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
(3224,1,-2260.23,-299.509,-9.34905,100,0,0,0),
(3224,2,-2261.29,-302.85,-9.29993,100,0,0,0),
(3224,3,-2260.51,-306.049,-9.29993,100,0,0,0),
(3224,4,-2257.75,-312.749,-9.29993,100,5000,5,0),
(3224,5,-2265.13,-312.055,-9.42604,100,0,0,0),
(3224,6,-2272.79,-315.722,-9.42604,100,5000,5,0),
(3224,7,-2270.73,-308.69,-9.42604,100,0,0,0),
(3224,8,-2274.7,-300.973,-9.42604,100,5000,5,0),
(3224,9,-2270.95,-301.636,-9.29993,100,0,0,0),
(3224,10,-2267.42,-302.304,-9.29993,100,0,0,0),
(3224,11,-2263.55,-300.676,-9.29993,100,0,0,0),
(3224,12,-2259.32,-296.491,-9.34905,100,5000,5,0);

-- Explosive Sheep 2675 (credit cmangos)
UPDATE `creature_template` SET `auras`='4051 8279' WHERE  `entry`=2675;

-- Naga Explorer 1907 (credit cmangos)
INSERT INTO `creature` (`guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `movement_type`, `patch_max`) VALUES
(2090, 1907, -13669.1, 616.477, 7.57179, 3.58152, 300, 300, 5, 100, 1, 10),
(2093, 1907, -13701, 633.343, 7.3798, 3.06592, 300, 300, 5, 100, 1, 10),
(2554, 1907, -13705.4, 574.627, 18.7638, 4.46864, 300, 300, 5, 100, 1, 10),
(180, 1907, -13783.5, 645.277, 14.8763, 5.95696, 300, 300, 5, 100, 1, 10);
UPDATE `creature` SET `position_x` = -13780.404297, `position_y` = 498.528076, `position_z` = 69.540359, `wander_distance` = 5, `movement_type` = 1 WHERE `guid` = 1966;

-- Tethis 730 (credit cmangos)
INSERT INTO `creature` (`guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `movement_type`, `patch_max`) VALUES
(2588, 730, -12978.6, 411.841, 21.7456, 3.43503, 420, 600, 15, 100, 1, 10),
(565, 730, -13017.2, 193.101, 22.7814, 1.45268, 420, 600, 15, 100, 1, 10);
UPDATE `creature` SET `wander_distance` = 20, `movement_type` = 1 WHERE `id` = 730;
INSERT INTO `pool_creature_template` (`id`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(730, 125, 0, 'Tethis (730)', 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(125, 1, 'Tethis (730)');

-- Southsea Cannoneer Should Not Drop Lvl 20 Items
UPDATE `creature_loot_template` SET `item` = 30041, `mincountOrRef` = -30041 WHERE `entry` = 3382 AND `item` = 30040 AND `groupid` = 0;

-- Farmer Ray Should Not Drop Lvl 30+ Items
DELETE FROM `creature_loot_template` WHERE  `item`= 4421 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 4424 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 6149 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 1645 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 3928 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 4419 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 4422 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 4599 AND `entry`= 232;
DELETE FROM `creature_loot_template` WHERE  `item`= 30048 AND `entry`= 232;

-- Fix Base Mana For Druids
UPDATE `player_classlevelstats` SET `basemana` = 50, `basehp` = 34 WHERE `class` = 11 AND `level` = 1;

-- Bloodfen Scytheclaw Skinning Template
UPDATE `creature_template` SET `skinning_loot_id` = 4343 WHERE `entry` = 4355;

-- Deatheye Skinning Template
UPDATE `creature_template` SET `skinning_loot_id` = 8302 WHERE `entry` = 8302;
INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `patch_max`) VALUES
(8302, 4304, 85, 1, 1, 1, 10),
(8302, 8170, 15, 1, 1, 1, 10);

-- Correct Faction for Firecrackers
UPDATE `gameobject_template` SET `faction` = 114 WHERE `entry` IN (180763, 180764, 180871);

-- Tanaris Winter Veil Tree
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(138, 178428, 1, -7182.83, -3917.6, 24.0838, 0.209439, 0, 0, 0.104528, 0.994522, 180, 180, 100, 1, 0, 0, 0, 10),
(161, 178429, 1, -7183.6, -3917.66, 24.6085, 0.296705, 0, 0, 0.147809, 0.989016, 180, 180, 100, 1, 0, 0, 0, 10),
(178, 178430, 1, -7185.27, -3918.21, 24.1332, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 0, 10),
(205, 178431, 1, -7183.5, -3916.42, 24.9472, 0.087266, 0, 0, 0.0436192, 0.999048, 180, 180, 100, 1, 0, 0, 0, 10),
(209, 178431, 1, -7184.26, -3918.91, 23.6283, 4.86947, 0, 0, -0.649447, 0.760406, 180, 180, 100, 1, 0, 0, 0, 10),
(227, 178432, 1, -7182.84, -3916.78, 24.2755, 0.244346, 0, 0, 0.121869, 0.992546, 180, 180, 100, 1, 0, 0, 0, 10),
(240, 178432, 1, -7184.59, -3917.37, 24.1482, 1.46608, 0, 0, 0.66913, 0.743145 , 180, 180, 100, 1, 0, 0, 0, 10),
(244, 178432, 1, -7183.69, -3918.27, 23.7908, 0.506145, 0, 0, 0.25038, 0.968148, 180, 180, 100, 1, 0, 0, 0, 10),
(298, 178433, 1, -7184.36, -3918.86, 24.0966, 4.79966, 0, 0, -0.67559, 0.737278, 180, 180, 100, 1, 0, 0, 0, 10),
(313, 178667, 1, -7184.51, -3918.14, 24.4141, 0.942477, 0, 0, 0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 0, 10);

-- Tanaris Mistletoe
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(334, 180844, 1, -7161.29, -3846.01, 16.2651, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Auberdine Mistletoe
(344, 180844, 1, 6407.84, 518.982, 21.3728, 0.698131, 0, 0, 0.34202, 0.939693, 180, 180, 100, 1, 0, 0, 6, 10),

-- Aerie Peak Mistletoe
(371, 180844, 0, 397.858, -2094.07, 139.418, 4.7822, 0, 0, -0.681998, 0.731354, 180, 180, 100, 1, 0, 0, 6, 10),

-- Menethil Harbour Mistletoe
(467, 180844, 0, -3805.32, -826.125, 15.1539, 6.19592, 0, 0, -0.0436192, 0.999048, 180, 180, 100, 1, 0, 0, 6, 10),

-- Loch Modan Mistletoe
(468, 180844, 0, -5381.93, -2966.99, 327.787, 5.39307, 0, 0, -0.43051, 0.902586, 180, 180, 100, 1, 0, 0, 6, 10),

-- Stonard Mistletoe
(487, 180844, 0, -10489.9, -3249.67, 26.9997, 5.21854, 0, 0, -0.507538, 0.861629, 180, 180, 100, 1, 0, 0, 6, 10),

-- Hammerfall Mistletoe
(541, 180844, 0, -922.002, -3529.65, 81.2248, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Revantusk Village Mistletoe
(560, 180844, 0, -630.094, -4576, 17.1913, 0.261798, 0, 0, 0.130526, 0.991445, 180, 180, 100, 1, 0, 0, 6, 10),

-- The Sepulcher Mistletoe
(564, 180844, 0, 507.755, 1639.02, 132.205, 0.0698117, 0, 0, 0.0348988, 0.999391, 180, 180, 100, 1, 0, 0, 6, 10),

-- Grom Gol Base Camp Mistletoe
(576, 180844, 0, -12428.3, 212.661, 10.7339, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Darnassus Mistletoe
(584, 180844, 1, 10129.5, 2218.1, 1336.3, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Astranaar Mistletoe
(608, 180844, 1, 2755.18, -419.486, 125.07, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Splintertree Post Mistletoe
(627, 180844, 1, 2337.47, -2578.87, 110.433, 2.47837, 0, 0, 0.945518, 0.325568, 180, 180, 100, 1, 0, 0, 6, 10),

-- Everlook Mistletoe
(753, 180844, 1, 6690.82, -4679.31, 727.253, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Ratchet Mistletoe
(756, 180844, 1, -1045.8, -3666.32, 28.8748, 4.95674, 0, 0, -0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 6, 10),

-- Camp Taurajo Mistletoe
(792, 180844, 1, -2364.96, -1978.73, 104.281, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Theramore Mistletoe
(809, 180844, 1, -3620.3, -4461.65, 19.7844, 0.575957, 0, 0, 0.284015, 0.95882, 180, 180, 100, 1, 0, 0, 6, 10),

-- Shadowprey Village Mistletoe
(810, 180844, 1, -1587.05, 3158.42, 51.9753, 5.74214, 0, 0, -0.267238, 0.963631, 180, 180, 100, 1, 0, 0, 6, 10),

-- Nijels Point Mistletoe
(849, 180844, 1, 247.596, 1260.14, 206.021, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Sun Rock Retreat Mistletoe
(864, 180844, 1, 909.268, 915.652, 113.815, 0.85521, 0, 0, 0.414693, 0.909962, 180, 180, 100, 1, 0, 0, 6, 10),

-- Freewind Post Mistletoe
(911, 180844, 1, -5462.75, -2454.01, 96.5328, 5.60251, 0, 0, -0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 6, 10),

-- Camp Mojache Mistletoe
(912, 180844, 1, -4442.31, 251.874, 46.6908, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Feathermoon Stronghold Mistletoe
(936, 180844, 1, -4350.53, 3288.4, 28.2028, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Cenarion Hold Mistletoe
(951, 180844, 1, -6854.17, 736.686, 53.7043, 2.23402, 0, 0, 0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 6, 10),

-- Add Some Missing Ironforge Entrance Winter Veil Objects 
(962, 178556, 0, -5021.14, -834.256, 524.032, 2.25147, 0, 0, 0.902585, 0.430512, 180, 180, 100, 1, 0, 0, 0, 10);

INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES
(138, 2),
(161, 2),
(178, 2),
(205, 2),
(209, 2),
(227, 2),
(240, 2),
(244, 2),
(298, 2),
(313, 2),
(334, 2),
(344, 2),
(371, 2),
(467, 2),
(468, 2),
(487, 2),
(541, 2),
(560, 2),
(564, 2),
(576, 2),
(584, 2),
(608, 2),
(627, 2),
(753, 2),
(756, 2),
(792, 2),
(809, 2),
(810, 2),
(849, 2),
(864, 2),
(911, 2),
(912, 2),
(936, 2),
(951, 2),
(962, 2);

-- Tanaris Winter Reveler Correct Position
UPDATE `creature` SET `position_x` = -7160.19, `position_y` = -3845.04, `position_z` = 8.8656, `orientation` = 2.89725 WHERE `guid` = 90180;

-- Auberdine Winter Reveler Correct Position
UPDATE `creature` SET `position_x` = 6406.53, `position_y` = 519.009, `position_z` = 8.73281, `orientation` = 6.07375 WHERE `guid` = 90187;
UPDATE `creature` SET `orientation` = 2.84489 WHERE `guid` = 90188;

-- Booty Bay Winter Reveler Correct Position
UPDATE `creature` SET `position_x` = -14460.8, `position_y` = 492.998, `position_z` = 15.208, `orientation` = 3.92699 WHERE `guid` = 89380;

-- Correct Scale for Tauren Female Winter Reveler
UPDATE `creature_template` SET `display_scale1` = 1.25 WHERE `entry` = 15789;

-- Correct Scale for Tauren Male Winter Reveler
UPDATE `creature_template` SET `display_scale1` = 1.35 WHERE `entry` = 15793;

-- Greatfather Winter's Helper Should Yell
UPDATE `broadcast_text` SET `chat_type`=1 WHERE `entry`=11430;
UPDATE `creature_ai_scripts` SET `datalong`=0 WHERE `datalong`=1 && `dataint`=11430;

-- Quest 6962 Is Not Repeatable
UPDATE `quest_template` SET `SpecialFlags` = 0 WHERE `entry` = 6962;

-- Falling underground - Fixes (credit cmangos)
UPDATE `creature` SET `position_x` = -6690.331543, `position_y` = -2988.697021, `position_z` = 248.367706, `wander_distance` = 7, `movement_type` = 1 WHERE `guid` = 6910;
UPDATE `creature` SET `position_x` = -6629.925293, `position_y` = -3554.510498, `position_z` = 254.083786, `wander_distance` = 7, movement_type = 1 WHERE `guid` = 6926;
UPDATE `creature` SET `position_x` = 51.213818, `position_y` = 1539.047974, `position_z` = 107.961784, `wander_distance` = 7, `movement_type` = 1 WHERE `guid` = 27980;
UPDATE `creature` SET `position_x` = 393.519775, `position_y` = -623.946899, `position_z` = 162.409653, `wander_distance` = 5, `movement_type` = 1 WHERE `guid` = 17345;
UPDATE `creature` SET `position_x` = -3649.268, `position_y` = -727.9708, `position_z` = 10.7234, `orientation` = 5.907869, `wander_distance` = 0, `movement_type` = 0 WHERE `guid` = 9530;

-- Grand Foreman Puzik should not drop Cache of Zanzils Altered Mixture
DELETE FROM `creature_loot_template` WHERE `entry` = 7288 AND `item` = 8073;

-- Touch of Zanzil Should Not Be Applied When Accepting 2479
UPDATE `quest_template` SET `SrcSpell`= 0 WHERE  `entry` = 2479;

-- Hammerfall Troll Attack Event (credit cmangos)
INSERT INTO `creature` (`guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `patch_max`) VALUES
(140697, 2553, -1233.3, -3533.72, 46.0859, 5.80098, 120, 300, 0, 100, 100, 2, 10),
(140696, 2552, -1229.85, -3535.1, 46.3087, 5.918, 120, 120, 0, 100, 0, 0, 10),
(140695, 2552, -1230.75, -3533.46, 46.0261, 5.83082, 120, 120, 0, 100, 0, 0, 10),
(140694, 2552, -1232.1, -3535.9, 46.4729, 5.6706, 120, 120, 0, 100, 0, 0, 10),
(140693, 2556, -1234.76, -3536.47, 46.5823, 5.929, 120, 120, 0, 100, 0, 0, 10);

INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(140697, 140696, 4, 4.71, 11),
(140697, 140695, 4, 6.25244, 11),
(140697, 140694, 4, 3.14, 11),
(140697, 140693, 4, 1.57, 11);

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(140697, 1, -1233.3, -3533.72, 46.0859, 5.80098, 1000, 3180901),
(140697, 2, -1233.3, -3533.72, 46.0859, 5.80098, 0, 0),
(140697, 3, -1233.3, -3533.72, 46.0859, 5.80098, 0, 0),
(140697, 4, -1162.87, -3563.07, 50.5074, 0.0411459, 0, 0),
(140697, 5, -1032.97, -3550.54, 55.9796, 6.22908, 0, 0);

-- Enable Eventai for Klaven Mortwake
UPDATE `creature_template` SET `ai_name` = 'EventAI' WHERE `entry` = 7053;

-- Touch of Zanzil Should Not Be Applied When Accepting 2607
UPDATE `quest_template` SET `SrcSpell` = 0 WHERE `entry` = 2607;

-- Add Quest Start Script for 2359
INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (2359, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3264, 0, 0, 0, 0, 0, 0, 0, 0, 'Klaven\'s Tower: Agent Kearnen - Talk');
UPDATE `quest_template` SET `StartScript` = 2359 WHERE `entry` = 2359;

-- Add Traps to Buccaneers Strongboxes
-- Update Spawntimes For Existing Objects
UPDATE `gameobject` SET `spawntimesecsmin` = 2, `spawntimesecsmax` = 2 WHERE `guid` IN (15683, 15145, 15702, 15705, 55913, 55911);
UPDATE `gameobject` SET `animprogress` = 100 WHERE `guid` IN (55913, 55911);

-- Buccaneers Strongbox Pool 1
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(978, 123331, 1, -1452.1, -3966.4, 7.56134, -3.07178, 0, 0, 0.999391, -0.034899, 2, 2, 100, 1, 0, 0, 0, 10),
(1209, 123332, 1, -1452.1, -3966.4, 7.56134, -3.07178, 0, 0, 0.999391, -0.034899, 2, 2, 100, 1, 0, 0, 0, 10),
(1219, 123333, 1, -1452.1, -3966.4, 7.56134, -3.07178, 0, 0, 0.999391, -0.034899, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(126, 1, 'Buccaneer\'s Strongbox Pool 1');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15121, 126, 0, 'Buccaneer\'s Strongbox Pool 1', 10),
(978, 126, 0, 'Buccaneer\'s Strongbox Pool 1', 10),
(1209, 126, 0, 'Buccaneer\'s Strongbox Pool 1', 10),
(1219, 126, 0, 'Buccaneer\'s Strongbox Pool 1', 10);

-- Buccaneers Strongbox Pool 2
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1231, 123331, 1, -1453.02, -3969.75, 7.56026, 2.49582, 0, 0, 0.948324, 0.317305, 2, 2, 100, 1, 0, 0, 0, 10),
(1243, 123332, 1, -1453.02, -3969.75, 7.56026, 2.49582, 0, 0, 0.948324, 0.317305, 2, 2, 100, 1, 0, 0, 0, 10),
(1246, 123333, 1, -1453.02, -3969.75, 7.56026, 2.49582, 0, 0, 0.948324, 0.317305, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(127, 1, 'Buccaneer\'s Strongbox Pool 2');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15122, 127, 0, 'Buccaneer\'s Strongbox Pool 2', 10),
(1231, 127, 0, 'Buccaneer\'s Strongbox Pool 2', 10),
(1243, 127, 0, 'Buccaneer\'s Strongbox Pool 2', 10),
(1246, 127, 0, 'Buccaneer\'s Strongbox Pool 2', 10);

-- Buccaneers Strongbox Pool 3
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1249, 123330, 1, -1454.38, -3971.26, 7.5598, 2.14675, 0, 0, 0.878817, 0.477159, 2, 2, 100, 1, 0, 0, 0, 10),
(1250, 123331, 1, -1454.38, -3971.26, 7.5598, 2.14675, 0, 0, 0.878817, 0.477159, 2, 2, 100, 1, 0, 0, 0, 10),
(1261, 123332, 1, -1454.38, -3971.26, 7.5598, 2.14675, 0, 0, 0.878817, 0.477159, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(128, 1, 'Buccaneer\'s Strongbox Pool 3');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15702, 128, 0, 'Buccaneer\'s Strongbox Pool 3', 10),
(1249, 128, 0, 'Buccaneer\'s Strongbox Pool 3', 10),
(1250, 128, 0, 'Buccaneer\'s Strongbox Pool 3', 10),
(1261, 128, 0, 'Buccaneer\'s Strongbox Pool 3', 10);

-- Buccaneers Strongbox Pool 4
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1298, 123331, 1, -1456.44, -3971.63, 7.56249, 1.8326, 0, 0, 0.793353, 0.608761, 2, 2, 100, 1, 0, 0, 0, 10),
(1299, 123332, 1, -1456.44, -3971.63, 7.56249, 1.8326, 0, 0, 0.793353, 0.608761, 2, 2, 100, 1, 0, 0, 0, 10),
(1300, 123333, 1, -1456.44, -3971.63, 7.56249, 1.8326, 0, 0, 0.793353, 0.608761, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(129, 1, 'Buccaneer\'s Strongbox Pool 4');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15119, 129, 0, 'Buccaneer\'s Strongbox Pool 4', 10),
(1298, 129, 0, 'Buccaneer\'s Strongbox Pool 4', 10),
(1299, 129, 0, 'Buccaneer\'s Strongbox Pool 4', 10),
(1300, 129, 0, 'Buccaneer\'s Strongbox Pool 4', 10);

-- Buccaneers Strongbox Pool 5
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1301, 123333, 1, -1458.06, -3972.06, 8.26139, 1.39626, 0, 0, 0.642788, 0.766044, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(130, 1, 'Buccaneer\'s Strongbox Pool 5');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15125, 130, 0, 'Buccaneer\'s Strongbox Pool 5', 10),
(15683, 130, 0, 'Buccaneer\'s Strongbox Pool 5', 10),
(55911, 130, 0, 'Buccaneer\'s Strongbox Pool 5', 10),
(1301, 130, 0, 'Buccaneer\'s Strongbox Pool 5', 10);

-- Buccaneers Strongbox Pool 6
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1302, 123331, 1, -1461.56, -3970.03, 7.56018, 0.750492, 0, 0, 0.366501, 0.930418, 2, 2, 100, 1, 0, 0, 0, 10),
(1303, 123332, 1, -1461.56, -3970.03, 7.56018, 0.750492, 0, 0, 0.366501, 0.930418, 2, 2, 100, 1, 0, 0, 0, 10),
(1304, 123333, 1, -1461.56, -3970.03, 7.56018, 0.750492, 0, 0, 0.366501, 0.930418, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(131, 1, 'Buccaneer\'s Strongbox Pool 6');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15120, 131, 0, 'Buccaneer\'s Strongbox Pool 6', 10),
(1302, 131, 0, 'Buccaneer\'s Strongbox Pool 6', 10),
(1303, 131, 0, 'Buccaneer\'s Strongbox Pool 6', 10),
(1304, 131, 0, 'Buccaneer\'s Strongbox Pool 6', 10);

-- Buccaneers Strongbox Pool 7
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1305, 123330, 1, -1463, -3968.46, 7.56007, 0.069813, 0, 0, 0.034899, 0.999391, 2, 2, 100, 1, 0, 0, 0, 10),
(1306, 123332, 1, -1463, -3968.46, 7.56007, 0.069813, 0, 0, 0.034899, 0.999391, 2, 2, 100, 1, 0, 0, 0, 10),
(1307, 123333, 1, -1463, -3968.46, 7.56007, 0.069813, 0, 0, 0.034899, 0.999391, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(132, 1, 'Buccaneer\'s Strongbox Pool 7');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15145, 132, 0, 'Buccaneer\'s Strongbox Pool 7', 10),
(1305, 132, 0, 'Buccaneer\'s Strongbox Pool 7', 10),
(1306, 132, 0, 'Buccaneer\'s Strongbox Pool 7', 10),
(1307, 132, 0, 'Buccaneer\'s Strongbox Pool 7', 10);

-- Buccaneers Strongbox Pool 8
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1308, 123331, 1, -1462.45, -3966.9, 7.56138, -0.017453, 0, 0, 0.008727, -0.999962, 2, 2, 100, 1, 0, 0, 0, 10),
(1309, 123332, 1, -1462.45, -3966.9, 7.56138, -0.017453, 0, 0, 0.008727, -0.999962, 2, 2, 100, 1, 0, 0, 0, 10),
(1310, 123333, 1, -1462.45, -3966.9, 7.56138, -0.017453, 0, 0, 0.008727, -0.999962, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(133, 1, 'Buccaneer\'s Strongbox Pool 8');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(15123, 133, 0, 'Buccaneer\'s Strongbox Pool 8', 10),
(1308, 133, 0, 'Buccaneer\'s Strongbox Pool 8', 10),
(1309, 133, 0, 'Buccaneer\'s Strongbox Pool 8', 10),
(1310, 133, 0, 'Buccaneer\'s Strongbox Pool 8', 10);

-- Add Rat Bomb Traps
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1312, 123355, 1, -1452.1, -3966.4, 7.56134, -3.07178, 0, 0, 0.999391, -0.034899, 2, 2, 100, 1, 0, 0, 0, 10),
(1417, 123355, 1, -1453.02, -3969.75, 7.56026, 2.49582, 0, 0, 0.948324, 0.317305, 2, 2, 100, 1, 0, 0, 0, 10),
(1432, 123355, 1, -1456.44, -3971.63, 7.56249, 1.8326, 0, 0, 0.793353, 0.608761, 2, 2, 100, 1, 0, 0, 0, 10),
(1438, 123355, 1, -1458.06, -3972.06, 8.26139, 1.39626, 0, 0, 0.642788, 0.766044, 2, 2, 100, 1, 0, 0, 0, 10),
(1451, 123355, 1, -1461.56, -3970.03, 7.56018, 0.750492, 0, 0, 0.366501, 0.930418, 2, 2, 100, 1, 0, 0, 0, 10),
(1474, 123355, 1, -1463, -3968.46, 7.56007, 0.069813, 0, 0, 0.034899, 0.999391, 2, 2, 100, 1, 0, 0, 0, 10),
(1494, 123355, 1, -1462.45, -3966.9, 7.56138, -0.017453, 0, 0, 0.008727, -0.999962, 2, 2, 100, 1, 0, 0, 0, 10);

-- Add Frost Hold Traps
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1502, 123334, 1, -1452.1, -3966.4, 7.56134, -3.07178, 0, 0, 0.999391, -0.034899, 2, 2, 100, 1, 0, 0, 0, 10),
(1507, 123334, 1, -1453.02, -3969.75, 7.56026, 2.49582, 0, 0, 0.948324, 0.317305, 2, 2, 100, 1, 0, 0, 0, 10),
(1515, 123334, 1, -1454.38, -3971.26, 7.5598, 2.14675, 0, 0, 0.878817, 0.477159, 2, 2, 100, 1, 0, 0, 0, 10),
(1523, 123334, 1, -1456.44, -3971.63, 7.56249, 1.8326, 0, 0, 0.793353, 0.608761, 2, 2, 100, 1, 0, 0, 0, 10),
(1529, 123334, 1, -1461.56, -3970.03, 7.56018, 0.750492, 0, 0, 0.366501, 0.930418, 2, 2, 100, 1, 0, 0, 0, 10),
(1534, 123334, 1, -1463, -3968.46, 7.56007, 0.069813, 0, 0, 0.034899, 0.999391, 2, 2, 100, 1, 0, 0, 0, 10),
(1311, 123334, 1, -1462.45, -3966.9, 7.56138, -0.017453, 0, 0, 0.008727, -0.999962, 2, 2, 100, 1, 0, 0, 0, 10);

-- Add Traps to Practice Lockboxes
-- Update Spawntimes For Existing Objects
UPDATE `gameobject` SET `spawntimesecsmin` = 2, `spawntimesecsmax` = 2 WHERE `guid` IN (20511, 20453, 20504, 20434, 31118, 31117, 31119);

-- Practice Strongbox Pool 1
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1553, 178244, 0, -9232.72, -2705.1, 89.086, 0.890118, 0, 0, 0.430511, 0.902585, 2, 2, 100, 1, 0, 0, 0, 10),
(1614, 178245, 0, -9232.72, -2705.1, 89.086, 0.890118, 0, 0, 0.430511, 0.902585, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(134, 1, 'Practice Strongbox Pool 1');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(20504, 134, 0, 'Practice Strongbox Pool 1', 10),
(1553, 134, 0, 'Practice Strongbox Pool 1', 10),
(1614, 134, 0, 'Practice Strongbox Pool 1', 10);

-- Practice Strongbox Pool 2
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1843, 178244, 0, -9233.62, -2701.74, 89.086, -0.331612, 0, 0, 0.165048, -0.986286, 2, 2, 100, 1, 0, 0, 0, 10),
(1875, 178245, 0, -9233.62, -2701.74, 89.086, -0.331612, 0, 0, 0.165048, -0.986286, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(135, 1, 'Practice Strongbox Pool 2');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(20434, 135, 0, 'Practice Strongbox Pool 2', 10),
(1843, 135, 0, 'Practice Strongbox Pool 2', 10),
(1875, 135, 0, 'Practice Strongbox Pool 2', 10);

-- Practice Strongbox Pool 3
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1876, 178245, 0, -9227.89, -2696.93, 89.086, -0.872665, 0, 0, 0.422618, -0.906308, 2, 2, 100, 1, 0, 0, 0, 10),
(1877, 178246, 0, -9227.89, -2696.93, 89.086, -0.872665, 0, 0, 0.422618, -0.906308, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(136, 1, 'Practice Strongbox Pool 3');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(31118, 136, 0, 'Practice Strongbox Pool 3', 10),
(1876, 136, 0, 'Practice Strongbox Pool 3', 10),
(1877, 136, 0, 'Practice Strongbox Pool 3', 10);

-- Practice Strongbox Pool 4
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1878, 178245, 0, -9231.58, -2698.62, 89.086, -0.750491, 0, 0, 0.366501, -0.930418, 2, 2, 100, 1, 0, 0, 0, 10),
(1879, 178246, 0, -9231.58, -2698.62, 89.086, -0.750491, 0, 0, 0.366501, -0.930418, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(137, 1, 'Practice Strongbox Pool 4');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(31117, 137, 0, 'Practice Strongbox Pool 4', 10),
(1878, 137, 0, 'Practice Strongbox Pool 4', 10),
(1879, 137, 0, 'Practice Strongbox Pool 4', 10);

-- Practice Strongbox Pool 5
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1880, 178245, 0, -9225.42, -2694.12, 89.086, -1.16937, 0, 0, 0.551937, -0.833886, 2, 2, 100, 1, 0, 0, 0, 10),
(1881, 178246, 0, -9225.42, -2694.12, 89.086, -1.16937, 0, 0, 0.551937, -0.833886, 2, 2, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(138, 1, 'Practice Strongbox Pool 5');
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `patch_max`) VALUES
(31119, 138, 0, 'Practice Strongbox Pool 5', 10),
(1880, 138, 0, 'Practice Strongbox Pool 5', 10),
(1881, 138, 0, 'Practice Strongbox Pool 5', 10);

-- Add Frost Hold Traps
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(1882, 123334, 0, -9227.89, -2696.93, 89.086, -0.872665, 0, 0, 0.422618, -0.906308, 2, 2, 100, 1, 0, 0, 0, 10),
(1883, 123334, 0, -9231.58, -2698.62, 89.086, -0.750491, 0, 0, 0.366501, -0.930418, 2, 2, 100, 1, 0, 0, 0, 10),
(1884, 123334, 0, -9225.42, -2694.12, 89.086, -1.16937, 0, 0, 0.551937, -0.833886, 2, 2, 100, 1, 0, 0, 0, 10);

-- Greatfather Winters Helpers Should only spawn on the 25th
DELETE FROM `game_event_creature` WHERE `guid` IN (62028, 62029);
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES
(62029, 21),
(62028, 21);

-- Correct Gossip Menu For Itharius (credit cmangos)
-- Add Gossip Menu For When Player Does Not Have Chained Essence of Eranikus
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(1341, 1973);
-- Add Condition To Check If Player Has Chained Essence of Eranikus
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (1341, 2, 10455, 1, 0, 0, 0);
-- Add Condition To Gossip Menu And Gossip Menu Option
UPDATE `gossip_menu` SET `condition_id` = 1341 WHERE `entry` = 1341 AND `text_id` = 1995;
UPDATE `gossip_menu_option` SET `condition_id` = 1341 WHERE `menu_id` = 1341 AND `id` = 0;
-- Add missing Gossip Menu Option
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_broadcast_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `box_broadcast_text`, `condition_id`) VALUES
(1341, 1, 0, 'What\'s an elf like you doing inside a cave like this?', 4471, 1, 1, 1363, 0, 0, 0, 0, NULL, 0, 0);
-- Add missing Gossip Menu
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(1363, 1996);
-- SET Correct Gossip Menu For Option 1341
UPDATE `gossip_menu_option` SET `action_menu_id` = 1366 WHERE `menu_id` = 1341 AND `id`=0;
-- Add misiing Gossip Menu
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(1366, 1997);
-- Update Gossip Menu Option With Correct Gossip Menu
UPDATE `gossip_menu_option` SET `menu_id` = 1366 WHERE `menu_id` = 16033;
-- Remove Incorrect Gossip Menu
DELETE FROM `gossip_menu` WHERE `entry` = 16033;

-- Add Missing Abilities to Zekkis (credit cmangos)
INSERT INTO `creature_spells` (`entry`, `name`, `spellId_1`, `probability_1`, `castTarget_1`, `targetParam1_1`, `targetParam2_1`, `castFlags_1`, `delayInitialMin_1`, `delayInitialMax_1`, `delayRepeatMin_1`, `delayRepeatMax_1`, `scriptId_1`, `spellId_2`, `probability_2`, `castTarget_2`, `targetParam1_2`, `targetParam2_2`, `castFlags_2`, `delayInitialMin_2`, `delayInitialMax_2`, `delayRepeatMin_2`, `delayRepeatMax_2`, `scriptId_2`, `spellId_3`, `probability_3`, `castTarget_3`, `targetParam1_3`, `targetParam2_3`, `castFlags_3`, `delayInitialMin_3`, `delayInitialMax_3`, `delayRepeatMin_3`, `delayRepeatMax_3`, `scriptId_3`, `spellId_4`, `probability_4`, `castTarget_4`, `targetParam1_4`, `targetParam2_4`, `castFlags_4`, `delayInitialMin_4`, `delayInitialMax_4`, `delayRepeatMin_4`, `delayRepeatMax_4`, `scriptId_4`, `spellId_5`, `probability_5`, `castTarget_5`, `targetParam1_5`, `targetParam2_5`, `castFlags_5`, `delayInitialMin_5`, `delayInitialMax_5`, `delayRepeatMin_5`, `delayRepeatMax_5`, `scriptId_5`, `spellId_6`, `probability_6`, `castTarget_6`, `targetParam1_6`, `targetParam2_6`, `castFlags_6`, `delayInitialMin_6`, `delayInitialMax_6`, `delayRepeatMin_6`, `delayRepeatMax_6`, `scriptId_6`, `spellId_7`, `probability_7`, `castTarget_7`, `targetParam1_7`, `targetParam2_7`, `castFlags_7`, `delayInitialMin_7`, `delayInitialMax_7`, `delayRepeatMin_7`, `delayRepeatMax_7`, `scriptId_7`, `spellId_8`, `probability_8`, `castTarget_8`, `targetParam1_8`, `targetParam2_8`, `castFlags_8`, `delayInitialMin_8`, `delayInitialMax_8`, `delayRepeatMin_8`, `delayRepeatMax_8`, `scriptId_8`) VALUES (54000, 'Temple of Atal\'Hakkar - Zekkis', 8282, 100, 1, 0, 0, 0, 0, 5, 60, 60, 0, 7102, 100, 1, 0, 0, 0, 5, 10, 120, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
UPDATE `creature_template` SET `speed_walk` = 2.5, `base_attack_time` = 2000, `spell_id2` = 0, `spell_id1` = 0, `spell_list_id` = 54000, `script_name`= '' WHERE `entry`=5400 AND `patch`=0;

-- Add Gossip Menus to Malyfous Darkhammer (credit trinity core)
-- Add Correct Gossip Menus
INSERT INTO `gossip_menu` (`entry`, `text_id`, `condition_id`) VALUES
(2991, 3674, 0),
(2992, 3675, 0),
(2993, 3676, 0);
-- Add Condition Quest 5047 Must Be Completed
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (2984, 8, 5047, 0, 0, 0, 0);
-- Add Missing Gossip Menu Options
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_broadcast_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `box_broadcast_text`, `condition_id`) VALUES
(2984, 0, 0, 'Tell me about the hide.', 6129, 1, 1, 2991, 0, 0, 0, 0, '', 0, 2984),
(2991, 0, 0, 'What are the chances of obtaining such a hide?', 6131, 1, 1, 2992, 0, 0, 0, 0, '', 0, 0),
(2992, 0, 0, 'So let us pretend I get this hide, what else would you need and what could you actually make?', 6133, 1, 1, 2993, 0, 0, 0, 0, '', 0, 0),
(2993, 0, 0, 'Ok!', 6135, 1, 1, -1, 0, 2993, 0, 0, '', 0, 0);
-- Add Gossip Script
INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (2993, 0, 35, 0, 0, 0, 0, 175927, 5, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Malyfous Darkhammer - Set Orientation');
INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (2993, 2, 1, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Malyfous Darkhammer - Emote');
INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (2993, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6139, 0, 0, 0, 0, 0, 0, 0, 0, 'Malyfous Darkhammer - Talk');
INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (2993, 5, 35, 1, 0, 0, 0, 175927, 5, 11, 0, 0, 0, 0, 0, 0, 0, 0, 3.12414, 0, 'Malyfous Darkhammer - Set Orientation');

-- Malyfous's Catalogue (credit trinity core)
-- Add Correct Gossip Menus
INSERT INTO `gossip_menu` (`entry`, `text_id`, `condition_id`) VALUES
(2986,3695,0),
(2987,3696,0),
(2988,3697,0),
(2989,3699,0),
(2990,3698,0);
-- Add Missing Gossip Menu Options
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_broadcast_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `box_broadcast_text`, `condition_id`) VALUES
(2985, 0, 0, 'Chapter on Frayed Abomination Stitchings.', 6145, 1, 1, 2986, 0, 0, 0, 0, '', 0, 2984),
(2985, 1, 0, 'Chapter on Enchanted Scarlet Thread.', 6146, 1, 1, 2987, 0, 0, 0, 0, '', 0, 2984),
(2985, 2, 0, 'Chapter on Frostwhisper\'s Embalming Fluid.', 6147, 1, 1, 2988, 0, 0, 0, 0, '', 0, 2984),
(2985, 3, 0, 'Chapter on Arcane Crystals and Arcanite.', 6151, 1, 1, 2989, 0, 0, 0, 0, '', 0, 2984),
(2985, 4, 0, 'Chapter on Skin of Shadow.', 6161, 1, 1, 2990, 0, 0, 0, 0, '', 0, 2984);
-- Add Missing NPC Text
INSERT INTO `npc_text` (`ID`, `BroadcastTextID0`, `Probability0`, `BroadcastTextID1`, `Probability1`, `BroadcastTextID2`, `Probability2`, `BroadcastTextID3`, `Probability3`, `BroadcastTextID4`, `Probability4`, `BroadcastTextID5`, `Probability5`, `BroadcastTextID6`, `Probability6`, `BroadcastTextID7`, `Probability7`) VALUES
(3695, 6163, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3696, 6164, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3697, 6165, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3698, 6166, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3699, 6167, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- Add Scripts to Gameobjects Used in Quest Samophlange Part 2 (credit trinity core)
INSERT INTO `gameobject_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (15722, 0, 10, 3284, 180000, 0, 0, 0, 0, 0, 0, 0, 407201, -1, 2, 826.776, -2674.53, 91.6667, 5.53466, 0, 'Main Control Valve - Summon Creature');
INSERT INTO `gameobject_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (15722, 0, 10, 3285, 180000, 0, 0, 0, 0, 0, 0, 0, 407201, -1, 2, 824.479, -2678.73, 91.6667, 6.04909, 0, 'Main Control Valve - Summon Creature');
INSERT INTO `gameobject_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (15730, 0, 10, 3285, 180000, 0, 0, 0, 0, 0, 0, 0, 407201, -1, 2, 843.523, -2669.85, 91.6668, 4.39584, 0, 'Regulator Valve - Summon Creature');
INSERT INTO `generic_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (407201, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4704, 0, 0, 0, 0, 0, 0, 0, 0, 'Venture Co. Peon and Drudger - Talk');

-- Update Lunar Festival Elder Spawns
UPDATE `creature` SET position_x = 514.754, position_y = 1560.97, position_z = 130.145, orientation = 4.39823 WHERE `id` = 15561;
UPDATE `creature` SET position_x = -8761.99, position_y = 1092.71, position_z = 94.8771, orientation = 5.13127 WHERE `id` = 15562;
UPDATE `creature` SET position_x = 1633.3, position_y = 233.931, position_z = 62.6749, orientation = 0.401426 WHERE `id` = 15564;
UPDATE `creature` SET position_x = -9413.27, position_y = 154.286, position_z = 57.1548, orientation = 2.14675 WHERE `id` = 15565;
UPDATE `creature` SET position_x = 2237.86, position_y = -5340.41, position_z = 84.7113, orientation = 1.13446 WHERE `id` = 15566;
UPDATE `creature` SET position_x = 2215.43, position_y = 237.536, position_z = 34.7272, orientation = 1.69297 WHERE `id` = 15568;
UPDATE `creature` SET position_x = -5571.58, position_y = -503.608, position_z = 403.093, orientation = 1.91986 WHERE `id` = 15569;
UPDATE `creature` SET position_x = 6746.22, position_y = -4679.31, position_z = 725.611, orientation = 1.5708 WHERE `id` = 15574;
UPDATE `creature` SET position_x = -2103.06, position_y = -438.984, position_z = -7.22764, orientation = 1.44862 WHERE `id` = 15575;
UPDATE `creature` SET position_x = -14327.7, position_y = 458.502, position_z = 8.04239, orientation = 2.6529 WHERE `id` = 15576;
UPDATE `creature` SET position_x = 1957.36, position_y = -4257.51, position_z = 31.384, orientation = 1.23918 WHERE `id` = 15579;
UPDATE `creature` SET position_x = -1012.62, position_y = -245.095, position_z = 159.361, orientation = 0.244346 WHERE `id` = 15580;
UPDATE `creature` SET position_x = -869.85, position_y = -3725.6, position_z = 24.4655, orientation = 4.62512 WHERE `id` = 15582;
UPDATE `creature` SET position_x = -5435.71, position_y = -2431.92, position_z = 89.3615, orientation = 5.42797 WHERE `id` = 15584;
UPDATE `creature` SET position_x = 1853.99, position_y = -3721.45, position_z = 162.308, orientation = 1.27409 WHERE `id` = 15592;
UPDATE `creature` SET position_x = -460.237, position_y = -2586.04, position_z = 99.476, orientation = 5.13127 WHERE `id` = 15597;
UPDATE `creature` SET position_x = 10137.4, position_y = 2583.92, position_z = 1325.58, orientation = 4.38078 WHERE `id` = 15598;
UPDATE `creature` SET position_x = 1995.88, position_y = -2420.17, position_z = 59.3823, orientation = 2.72271 WHERE `id` = 15602;
UPDATE `creature` SET position_x = 6466.88, position_y = -4265.45, position_z = 663.761, orientation = 0.767945 WHERE `id` = 15606;
UPDATE `creature` SET position_x = -4659.2, position_y = -944.427, position_z = 500.461, orientation = 4.24115 WHERE `id` = 15871;

-- Add missing loot to Xandivious' Demon Bag.
UPDATE `gameobject_template` SET `patch`=7 WHERE `entry`=180671;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (17516, 21145, -100, 0, 1, 1, 0, 7, 10);

-- Add missing gameobject Demon Summoning Torch.
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `script_name`) VALUES (180672, 5, 4095, 'Demon Summoning Torch', 1, 0, 1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

-- Events list for Xandivious
DELETE FROM `creature_ai_events` WHERE `creature_id`=15623;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES (1562301, 15623, 0, 2, 0, 100, 0, 50, 1, 0, 0, 1562301, 0, 0, 'Xandivious - Enrage at 50% HP');
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES (1562302, 15623, 0, 6, 0, 100, 0, 0, 0, 0, 0, 1562302, 0, 0, 'Xandivious - Summon Xandivious\' Demon Bag on Death');
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES (1562303, 15623, 0, 11, 0, 100, 0, 0, 0, 0, 0, 1562303, 0, 0, 'Xandivious - Say Text on Spawn');
DELETE FROM `creature_ai_scripts` WHERE `id`=1562301;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (1562301, 0, 15, 8599, 2, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Xandivious - Cast Spell Enrage');
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (1562301, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2384, 0, 0, 0, 0, 0, 0, 0, 0, 'Xandivious - Say Text');
DELETE FROM `creature_ai_scripts` WHERE `id`=1562302;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (1562302, 0, 15, 25791, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Xandivious - Cast Spell Xandivious\' Demon Bag');
DELETE FROM `creature_ai_scripts` WHERE `id`=1562303;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (1562303, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11268, 0, 0, 0, 0, 0, 0, 0, 0, 'Xandivious - Say Text');
REPLACE INTO `creature_spells` (`entry`, `name`, `spellId_1`, `probability_1`, `castTarget_1`, `targetParam1_1`, `targetParam2_1`, `castFlags_1`, `delayInitialMin_1`, `delayInitialMax_1`, `delayRepeatMin_1`, `delayRepeatMax_1`, `scriptId_1`, `spellId_2`, `probability_2`, `castTarget_2`, `targetParam1_2`, `targetParam2_2`, `castFlags_2`, `delayInitialMin_2`, `delayInitialMax_2`, `delayRepeatMin_2`, `delayRepeatMax_2`, `scriptId_2`, `spellId_3`, `probability_3`, `castTarget_3`, `targetParam1_3`, `targetParam2_3`, `castFlags_3`, `delayInitialMin_3`, `delayInitialMax_3`, `delayRepeatMin_3`, `delayRepeatMax_3`, `scriptId_3`, `spellId_4`, `probability_4`, `castTarget_4`, `targetParam1_4`, `targetParam2_4`, `castFlags_4`, `delayInitialMin_4`, `delayInitialMax_4`, `delayRepeatMin_4`, `delayRepeatMax_4`, `scriptId_4`, `spellId_5`, `probability_5`, `castTarget_5`, `targetParam1_5`, `targetParam2_5`, `castFlags_5`, `delayInitialMin_5`, `delayInitialMax_5`, `delayRepeatMin_5`, `delayRepeatMax_5`, `scriptId_5`, `spellId_6`, `probability_6`, `castTarget_6`, `targetParam1_6`, `targetParam2_6`, `castFlags_6`, `delayInitialMin_6`, `delayInitialMax_6`, `delayRepeatMin_6`, `delayRepeatMax_6`, `scriptId_6`, `spellId_7`, `probability_7`, `castTarget_7`, `targetParam1_7`, `targetParam2_7`, `castFlags_7`, `delayInitialMin_7`, `delayInitialMax_7`, `delayRepeatMin_7`, `delayRepeatMax_7`, `scriptId_7`, `spellId_8`, `probability_8`, `castTarget_8`, `targetParam1_8`, `targetParam2_8`, `castFlags_8`, `delayInitialMin_8`, `delayInitialMax_8`, `delayRepeatMin_8`, `delayRepeatMax_8`, `scriptId_8`) VALUES (156230, 'Winterspring - Xandivious', 11980, 100, 1, 0, 0, 32, 3, 3, 15, 15, 0, 11639, 100, 1, 0, 0, 32, 5, 5, 15, 15, 0, 16046, 100, 1, 0, 0, 64, 7, 7, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
UPDATE `broadcast_text` SET `chat_type`=1 WHERE `entry`=11268;
DELETE FROM `creature_loot_template` WHERE `entry`=15623;
UPDATE `creature_template` SET `loot_id`=0, `spell_list_id`=156230, `ai_name`='EventAI', `script_name`='' WHERE `entry`=15623;


-- End of migration.
END IF;
END??
delimiter ; 
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;