Files
moonwell-core-vanilla/sql/migrations/20231226052448_world.sql
2023-12-26 07:25:47 +02:00

1214 lines
88 KiB
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`='20231226052448');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20231226052448');
-- Add your query below.
-- Defias Dockworker 6927 Convert to Creature Group
UPDATE `creature` SET `position_x` = -9961.2, `position_y` = -153.40921, `position_z` = 21.847925, `movement_type` = 0 WHERE `guid` IN (84587, 80730, 80732);
DELETE FROM `creature_movement` WHERE `id` IN (84587, 80730, 80732);
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(84587, 84587, 0, 6.25244, 11),
(84587, 80730, 3, 3.14, 11),
(84587, 80732, 6, 3.14, 11);
UPDATE `creature` SET `movement_type` = 2 WHERE `guid` = 84587;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(84587, 1, -9961.2, -153.40921, 21.847925, 100, 1000, 0),
(84587, 2, -9956.517, -159.12874, 22.818628, 100, 0, 0),
(84587, 3, -9951.445, -163.15524, 24.69314, 100, 0, 0),
(84587, 4, -9946.228, -165.53757, 27.017359, 100, 0, 0),
(84587, 5, -9944.468, -163.84106, 27.131617, 100, 0, 0),
(84587, 6, -9944.139, -153.49643, 25.133081, 100, 0, 0),
(84587, 7, -9943.608, -147.81813, 25.008081, 100, 0, 0),
(84587, 8, -9936.224, -135.3706, 25.780787, 100, 0, 0),
(84587, 9, -9929.365, -131.3284, 25.417545, 100, 0, 0),
(84587, 10, -9928.282, -121.96587, 25.139225, 100, 0, 0),
(84587, 11, -9935.369, -114.50511, 25.765055, 100, 0, 0),
(84587, 12, -9945.132, -113.93359, 25.394205, 100, 0, 0),
(84587, 13, -9956.19, -116.17986, 25.25944, 100, 0, 0),
(84587, 14, -9965.036, -125.75975, 25.56315, 100, 0, 0),
(84587, 15, -9966.419, -130.92566, 24.818033, 100, 0, 0),
(84587, 16, -9967.337, -137.82283, 24.607573, 100, 0, 0),
(84587, 17, -9965.224, -140.53967, 24.583359, 100, 1000, 0),
(84587, 18, -9967.337, -137.82283, 24.607573, 100, 0, 0),
(84587, 19, -9966.419, -130.92566, 24.818033, 100, 0, 0),
(84587, 20, -9965.036, -125.75975, 25.56315, 100, 0, 0),
(84587, 21, -9956.19, -116.17986, 25.25944, 100, 0, 0),
(84587, 22, -9945.132, -113.93359, 25.394205, 100, 0, 0),
(84587, 23, -9935.369, -114.50511, 25.765055, 100, 0, 0),
(84587, 24, -9928.282, -121.96587, 25.139225, 100, 0, 0),
(84587, 25, -9929.365, -131.3284, 25.417545, 100, 0, 0),
(84587, 26, -9936.224, -135.3706, 25.780787, 100, 0, 0),
(84587, 27, -9943.608, -147.81813, 25.008081, 100, 0, 0),
(84587, 28, -9944.139, -153.49643, 25.133081, 100, 0, 0),
(84587, 29, -9944.468, -163.84106, 27.131617, 100, 0, 0),
(84587, 30, -9946.228, -165.53757, 27.017359, 100, 0, 0),
(84587, 31, -9951.445, -163.15524, 24.69314, 100, 0, 0),
(84587, 32, -9956.517, -159.12874, 22.818628, 100, 0, 0);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Add Events to Barov Servants
UPDATE `creature_template` SET `ai_name` = 'EventAI' WHERE `entry` IN (11636, 11637);
-- Events list for Servant of Alexi Barov
DELETE FROM `creature_ai_events` WHERE `creature_id`=11637;
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
(1163701, 11637, 0, 4, 0, 20, 2, 0, 0, 0, 0, 1163601, 1163602, 0, 'Servant of Alexi Barov - Talk On Aggro');
-- Events list for Servant of Weldon Barov
DELETE FROM `creature_ai_events` WHERE `creature_id`=11636;
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
(1163601, 11636, 0, 4, 0, 20, 2, 0, 0, 0, 0, 1163601, 1163602, 0, 'Servant of Weldon Barov - Talk On Aggro');
DELETE FROM `creature_ai_scripts` WHERE `id`=1163601;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(1163601, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7150, 7151, 7152, 7153, 0, 0, 0, 0, 0, 'Servant of Alexi\Weldon Barov - Talk');
DELETE FROM `creature_ai_scripts` WHERE `id`=1163602;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(1163602, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7154, 7153, 7152, 7151, 0, 0, 0, 0, 0, 'Servant of Alexi\Weldon Barov - Talk');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Convert Klaven Mortwake to Stealth Alert
DELETE FROM `creature_ai_events` WHERE `creature_id`=7053;
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
(705301, 7053, 0, 35, 0, 100, 1, 10000, 10000, 0, 0, 705301, 0, 0, 'Klaven Mortwake - Say on Stealth Alert');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/*
World of Warcraft Client Patch 1.7.0 (2005-09-13)
- Dark Iron mineral nodes will now sometimes appear in the Burning
Steppes and Searing Gorge.
*/
-- Set Correct Patch For Dark Iron Deposit
UPDATE `gameobject` SET `patch_min` = 5 WHERE `id` = 165658 && `map` IN (0, 1);
UPDATE `pool_gameobject` SET `patch_min` = 5 WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 165658 && `map` IN (0, 1));
-- These spawns are pooled, and pool chance must always add up to 100%, so this means we must use equal chance instead of explicit chance for one of the other gameobjects in the pool.
-- Mithril
UPDATE `pool_gameobject` SET `chance`=0 WHERE `guid` IN (27334, 29734, 29735, 29736, 29737, 29738, 29739, 29740, 29741, 29742, 29743, 29744, 29745, 29746, 29747, 29748, 29749, 29750, 29751, 29752, 29753, 29754, 29755, 29756, 29757, 29758, 29759, 29760, 29761, 29762, 38345, 38346, 38347, 38348, 38349, 38350, 38351, 38352, 38353, 38354, 38355, 38356, 38357, 38358, 38359, 38360, 38361, 38362, 38363, 38364, 38365, 38366, 38367, 38368, 38369, 38370, 38371, 38372, 38373, 38374, 38375, 38376, 38377, 38378, 38379, 38380, 38381, 38382, 38383, 38384, 38385, 38386, 38387, 38388, 38389, 38390, 38391, 38392, 38393, 38394, 38395, 38396, 38397, 38398, 38399, 38400, 38401, 38402, 38403, 38404, 38405, 38406, 38407, 38408, 38409, 38410, 38411, 38412, 38413, 38414, 38415, 38416, 38417, 38418, 38419, 38420, 38421, 38422, 38423, 38424, 38425, 38426, 38427, 38428, 38429, 38430, 38431, 38432, 38433, 38434, 38435, 38436, 38437, 38438, 38439, 38440, 38441, 38442, 38443, 38444, 200012, 200016, 200025, 200026);
-- Truesilver
UPDATE `pool_gameobject` SET `chance`=0 WHERE `guid` IN (31180, 31181, 31182, 31183, 31184, 31186, 31187, 31188, 31189, 31190, 31191, 31192, 31193, 31194, 31195, 31196, 31197, 31198, 31199, 31200, 31201, 31202, 31203, 31204, 31205, 31207, 31208, 31209, 31210, 31211, 31212, 31213, 31214, 31215, 32994, 32995, 32996, 32997, 32998, 32999, 33001, 33003, 33004, 33005, 33006, 33007, 33008, 33009, 33010, 33011, 33012, 33013, 33014, 33015, 33016, 33017, 33018, 33019, 220446, 220447);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Mining Node Position
UPDATE `gameobject` SET `position_x`=26.0743, `position_y`=-1906.15, `position_z`=84.0589, `orientation`=4.69494 WHERE `guid`=34711;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Update Cook Ghilm Script
DELETE FROM `creature_movement_scripts` WHERE `id`=135501;
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `priority`, `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
(135501, 3, 0, 82, 10837, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cook Ghilm - Load Gameobject'),
(135501, 3, 0, 1, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cook Ghilm - Emote'),
(135501, 4, 0, 19, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cook Ghilm - Set Equipment'),
(135501, 7, 0, 41, 0, 0, 0, 0, 10837, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cook Ghilm - Remove Object');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Stranglethorn Tigress and Shadowmaw Panther Share Spawns
UPDATE `creature` SET `id` = 684, `id2` = 772 WHERE `id` IN (684, 772);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Align Guard Respawntime
UPDATE `creature` SET `spawntimesecsmin` = 300, `spawntimesecsmax` = 300 WHERE `id` IN (
68, -- Stormwind City Guard
727, -- Ironforge Mountaineer
1423, -- Stormwind Guard
1976, -- Stormwind City Patroller
3084, -- Bluffwatcher
3212, -- Brave Ironhorn
3215, -- Brave Strongbash
3217, -- Brave Dawneagle
3218, -- Brave Swiftwind
3219, -- Brave Leaping Deer
3220, -- Brave Darksky
3221, -- Brave Rockhorn
3222, -- Brave Wildrunner
3223, -- Brave Rainchaser
3224, -- Brave Cloudmane
3296, -- Orgrimmar Grunt
5595, -- Ironforge Guard
5624, -- Undercity Guardian
12996, -- Mounted Ironforge Mountaineer
13076); -- Dun Morogh Mountaineer
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
UPDATE `creature` SET `wander_distance`=5 WHERE `guid`=4185;
DELETE FROM `creature_movement_template` WHERE `entry` = 468;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Ancient of War Does Not Have Gossip
UPDATE `creature_template` SET `npc_flags` = 0 WHERE `entry`=3469;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Update Some Creature Group Angles
UPDATE `creature_groups` SET `angle` = 3.12 WHERE `member_guid` IN (42898, 60006, 287, 153);
UPDATE `creature_groups` SET `angle` = 3.12 WHERE `member_guid` = 3477;
UPDATE `creature_groups` SET `angle` = 3.23 WHERE `member_guid` = 3560;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Add Script For Quest Frostmaw
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `state`, `animprogress`) VALUES
(3114, 19875, 0, 263.424, -268.076, 145.521, 4.34587, 0, 0, -0.824126, 0.566406, -180, -180, 1, 100),
(3115, 965, 0, 263.262, -267.665, 145.024, 4.57276, 0, 0, -0.754709, 0.656059, -180, -180, 1, 100);
DELETE FROM `event_scripts` WHERE `id`=727;
INSERT INTO `event_scripts` (`id`, `delay`, `priority`, `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
(727, 0, 0, 10, 4504, 0, 1, 0, 0, 0, 0, 0, 8, 0, -1, 7, 234.227, -239.227, 141.325, 2.84489, 0, 'Frostmaw: Summon Creature Frostmaw'),
(727, 0, 0, 9, 3114, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Frostmaw: Respawn GameObject Fresh Lion Carcass'),
(727, 0, 0, 9, 3115, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Frostmaw: Respawn GameObject Black Smoke - scale 2');
DELETE FROM `creature_movement_template` WHERE `entry` = 4504;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(4504, 1, 221.10156, -254.34375, 145.13052, 100, 0, 0),
(4504, 2, 221.40279, -262.92282, 145.25552, 100, 0, 0),
(4504, 3, 229.7501, -267.23904, 145.87318, 100, 7000, 0),
(4504, 4, 241.35802, -267.15924, 144.7831, 100, 0, 0),
(4504, 5, 247.68039, -266.39713, 144.98044, 100, 0, 0),
(4504, 6, 261.16113, -267.38702, 144.8716, 100, 7000, 450401),
(4504, 7, 248.05843, -267.17468, 145.08376, 100, 0, 0),
(4504, 8, 242.37035, -266.9359, 144.5908, 100, 0, 0),
(4504, 9, 237.8304, -267.07703, 145.80971, 100, 0, 0),
(4504, 10, 229.01921, -267.1084, 145.80151, 100, 0, 0),
(4504, 11, 222.44646, -260.98682, 145.13052, 100, 0, 0),
(4504, 12, 222.2341, -253.12283, 144.81778, 100, 0, 0),
(4504, 13, 230.49452, -242.26663, 142.41824, 100, 3000, 450402);
DELETE FROM `creature_movement_scripts` WHERE `id`=450401;
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `priority`, `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
(450401, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1464, 0, 0, 0, 0, 0, 0, 0, 0, 'Frostmaw - Talk'),
(450401, 5, 0, 81, 3114, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Frostmaw - Despawn Object'),
(450401, 5, 0, 81, 3115, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Frostmaw - Despawn Object');
DELETE FROM `creature_movement_scripts` WHERE `id`=450402;
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `priority`, `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
(450402, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1465, 0, 0, 0, 0, 0, 0, 0, 0, 'Frostmaw - Talk'),
(450402, 2, 0, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Frostmaw - Despawn');
UPDATE `creature_template` SET `movement_type` = 2 WHERE `entry` = 4504;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Holy Spring Does Not Require Quest To Loot
UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance` = 100 WHERE `entry` = 938 AND `item` = 737;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Set Correct Target For Script
DELETE FROM `creature_ai_scripts` WHERE `id`=852401;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(852401, 0, 0, 15, 16567, 39, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cursed Mage - Cast Spell Tainted Mind');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Set Southshore Guard Default Movement to Wander
UPDATE `creature_template` SET `movement_type` = 1 WHERE `entry` = 2386;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct High Executor Darthalia Spawn Position
UPDATE `creature` SET `position_x`= -33.3555, `position_y`= -927.892, `position_z`= 54.5261, `orientation`= 1.54421 WHERE `guid` = 15542;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Add Roland Geardabbler Aura
UPDATE `creature_template` SET `auras` = '12508' WHERE `entry`=8394 AND `patch`=0;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Add Mai'Zoth Aura
UPDATE `creature_template` SET `auras` = '12544' WHERE `entry`=818 AND `patch`=0;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Pool Alien Egg
UPDATE `gameobject` SET `spawntimesecsmin` = 10, `spawntimesecsmax` = 10 WHERE `id` = 175565;
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(3585, 1, 'Thousand Needles - Alien Egg', 0, 10);
INSERT INTO `pool_gameobject_template` (`id`, `pool_entry`, `chance`, `description`, `patch_min`, `patch_max`) VALUES
(175565, 3585, 0, 'Thousand Needles - Alien Egg', 0, 10);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Patch Min
UPDATE `pool_template` SET `patch_min`= 0 WHERE `entry` IN (21603, 21604);
UPDATE `pool_gameobject_template` SET `patch_min`= 0 WHERE `pool_entry` IN (21603, 21604);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Creatures Should Wander
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 2 WHERE `guid` IN (6782, 6784, 6787, 6790, 6797, 6794);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Remove Custom Object
DELETE FROM `gameobject` WHERE `guid` = 42899;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Some Waypoints (credit cmangos)
-- Nikova Raskol 1721
DELETE FROM `creature_movement` WHERE `id` = 79770;
UPDATE `creature` SET `position_x` = -8733.151, `position_y` = 394.31458, `position_z` = 98.35401, `orientation` = 2.86234 WHERE `id` = 1721;
DELETE FROM `creature_movement_template` WHERE `entry` = 1721;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(1721, 1 , -8733.151, 394.31458, 98.35401, 2.86234, 150000, 0),
(1721, 2 , -8734.93, 405.106, 97.8717, 100, 0, 0),
(1721, 3 , -8725.77, 417.125, 97.7309, 100, 0, 0),
(1721, 4 , -8719.993, 438.32822, 97.38104, 100, 0, 0),
(1721, 5 , -8715.713, 453.567, 97.223045, 100, 0, 0),
(1721, 6 , -8681.3125, 485.25836, 96.80815, 100, 0, 0),
(1721, 7 , -8666.829, 497.89432, 100.59907, 100, 0, 0),
(1721, 8 , -8652.376, 486.10168, 102.306854, 100, 0, 0),
(1721, 9 , -8636.195, 465.46332, 102.354004, 100, 0, 0),
(1721, 10, -8632.351, 456.59332, 102.292595, 100, 0, 0),
(1721, 11, -8638.788, 450.0242, 102.47641, 1.6406097, 150000, 0),
(1721, 12, -8633.501, 442.80057, 102.32132, 100, 0, 0),
(1721, 13, -8640.329, 437.12598, 101.77766, 100, 0, 0),
(1721, 14, -8646.861, 427.44424, 101.507576, 100, 0, 0),
(1721, 15, -8655.466, 420.30447, 102.31269, 100, 0, 0),
(1721, 16, -8665.616, 411.49307, 103.124855, 100, 0, 0),
(1721, 17, -8670.606, 403.65277, 103.36292, 100, 0, 0),
(1721, 18, -8680.942, 400.98178, 102.935486, 100, 0, 0),
(1721, 19, -8687.236, 395.86807, 102.108986, 100, 0, 0),
(1721, 20, -8693.097, 396.71255, 101.587204, 100, 0, 0),
(1721, 21, -8696.334, 391.15247, 102.407005, 3.508112, 150000, 0),
(1721, 22, -8698.372, 401.56934, 101.02059, 100, 0, 0),
(1721, 23, -8717.303, 406.84973, 98.10654, 100, 0, 0),
(1721, 24, -8724.674, 406.65234, 97.80793, 100, 0, 0);
-- Thomas Miller 3518
-- path corrected - had some points missing or custom made
DELETE FROM `creature_movement` WHERE `id` = 79723;
UPDATE `creature` SET `position_x` = -8831.716, `position_y` = 543.03986, `position_z` = 96.87623 WHERE `id` = 3518;
DELETE FROM `creature_movement_template` WHERE `entry` = 3518;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(3518, 1 , -8831.716, 543.03986, 96.87623, 100, 3000, 0),
(3518, 2 , -8824.937, 553.64734, 95.23644 , 100, 0, 0),
(3518, 3 , -8816.558, 562.692, 94.15401 , 100, 0, 0),
(3518, 4 , -8812.594, 575.2082, 94.89822, 100, 0, 0),
(3518, 5 , -8798.608, 587.61664, 97.43818 , 100, 0, 0),
(3518, 6 , -8788.722, 593.3572, 97.64036, 100, 0, 0),
(3518, 7 , -8776.456, 603.8965, 97.37932, 100, 0, 0),
(3518, 8 , -8762.598, 617.44586, 99.08215 , 100, 0, 0),
(3518, 9 , -8758.275, 627.52496, 101.945015, 100, 0, 0),
(3518, 10, -8759.411, 641.9355, 103.61436 , 100, 0, 0),
(3518, 11, -8770.62, 661.28796, 103.70394 , 100, 0, 0),
(3518, 12, -8779.22, 672.5389, 103.11453, 100, 0, 0),
(3518, 13, -8787.312, 680.3848, 102.35647 , 100, 0, 0),
(3518, 14, -8804.321, 683.7612, 100.726585, 100, 0, 0),
(3518, 15, -8815.349, 680.6345, 98.42479, 100, 0, 0),
(3518, 16, -8831.333, 674.36786, 98.42116 , 100, 0, 0),
(3518, 17, -8844.647, 666.4365, 97.73251, 100, 0, 0),
(3518, 18, -8853.126, 657.96735, 96.82975 , 100, 0, 0),
(3518, 19, -8848.778, 647.818, 96.52911 , 100, 0, 0),
(3518, 20, -8842.514, 637.99854, 95.320206, 100, 0, 0),
(3518, 21, -8834.657, 634.1927, 94.384514 , 100, 0, 0),
(3518, 22, -8823.594, 639.3086, 94.391815 , 100, 0, 0),
(3518, 23, -8818.339, 641.126, 94.354004, 100, 0, 0),
(3518, 24, -8811.451, 634.4778, 94.354004 , 100, 0, 0),
(3518, 25, -8813.913, 625.36554, 94.15325 , 100, 0, 0),
(3518, 26, -8827.415, 620.4255, 94.33926, 100, 0, 0),
(3518, 27, -8836.966, 613.5763, 93.262215 , 100, 0, 0),
(3518, 28, -8845.903, 602.001, 92.78646 , 100, 0, 0),
(3518, 29, -8854.596, 591.41406, 92.982 , 100, 0, 0),
(3518, 30, -8863.754, 582.47644, 93.56701 , 100, 0, 0),
(3518, 31, -8875.346, 571.9302, 93.48887, 100, 0, 0),
(3518, 32, -8883.425, 571.9704, 92.85839, 100, 0, 0),
(3518, 33, -8888.318, 578.2813, 92.8863 , 100, 0, 0),
(3518, 34, -8889.5, 585.4183, 93.43408 , 100, 0, 0),
(3518, 35, -8880.202, 592.32275, 93.37659 , 100, 0, 0),
(3518, 36, -8867.2295, 598.0203, 92.40573 , 100, 0, 0),
(3518, 37, -8849.395, 608.0734, 92.51413, 100, 0, 0),
(3518, 38, -8835.409, 618.3853, 93.27875, 100, 0, 0),
(3518, 39, -8828.214, 620.0535, 94.319084 , 100, 0, 0),
(3518, 40, -8819.852, 613.14777, 95.27985 , 100, 0, 0),
(3518, 41, -8809.6455, 603.60876, 96.39362, 100, 0, 0),
(3518, 42, -8806.867, 593.1512, 97.364456 , 100, 0, 0),
(3518, 43, -8815.863, 581.43365, 95.57355 , 100, 0, 0),
(3518, 44, -8821.164, 571.0665, 94.37265, 100, 0, 0),
(3518, 45, -8830.861, 559.04755, 94.95533 , 100, 0, 0),
(3518, 46, -8834.466, 549.53735, 96.44727 , 100, 0, 0);
-- Officer Jaxon 14423
-- path corrected
DELETE FROM `creature_movement` WHERE `id` = 79818;
UPDATE `creature` SET `position_x` = -8835.849, `position_y` = 543.1174, `position_z` = 97.05621 WHERE `id` = 14423;
DELETE FROM `creature_movement_template` WHERE `entry` = 14423;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14423, 1, -8835.849, 543.1174, 97.05621, 100, 0, 0),
(14423, 2, -8818.347, 560.51434, 94.520195, 100, 0, 0),
(14423, 3, -8812.764, 570.36664, 94.27222, 100, 0, 0),
(14423, 4, -8808.098, 576.9897, 95.35623, 100, 0, 0),
(14423, 5, -8788.984, 592.1376, 97.60096, 100, 0, 0),
(14423, 6, -8772.828, 605.4169, 97.22266, 100, 0, 0),
(14423, 7, -8769.656, 606.08704, 97.06241, 100, 0, 0),
(14423, 8, -8743.524, 579.3958, 97.68507, 100, 0, 0),
(14423, 9, -8736.395, 575.75323, 97.46956, 100, 0, 0),
(14423, 10 , -8731.595, 578.7232, 97.569214, 100, 0, 0),
(14423, 11 , -8721.105, 589.80945, 98.70483, 100, 0, 0),
(14423, 12 , -8716.723, 592.7718, 98.71562, 100, 0, 0),
(14423, 13 , -8710.64, 595.3354, 98.82091, 100, 0, 0),
(14423, 14 , -8707.837, 600.4015, 99.04902, 100, 0, 0),
(14423, 15 , -8706.04, 621.844, 100.6301, 100, 0, 0),
(14423, 16 , -8707.136, 635.97766, 100.33522, 100, 0, 0),
(14423, 17 , -8714.38, 657.8422, 99.1828, 100, 0, 0),
(14423, 18 , -8726.181, 679.58325, 98.754, 100, 0, 0),
(14423, 19 , -8731.577, 691.1555, 98.786606, 100, 0, 0),
(14423, 20 , -8741.34, 706.4121, 98.75399, 100, 0, 0),
(14423, 21 , -8741.346, 712.86865, 98.64099, 100, 0, 0),
(14423, 22 , -8732.024, 720.8717, 101.77593, 100, 0, 0),
(14423, 23 , -8717.243, 732.2366, 98.15399, 100, 0, 0),
(14423, 24 , -8699.213, 718.9027, 97.30005, 100, 0, 0),
(14423, 25 , -8695.856, 718.0643, 97.216225, 100, 0, 0),
(14423, 26 , -8662.411, 743.59424, 96.90535, 100, 5000, 0),
(14423, 27 , -8658.026, 743.83685, 96.7404, 100, 0, 0),
(14423, 28 , -8640.762, 740.77295, 96.754, 100, 0, 0),
(14423, 29 , -8635.552, 741.5513, 97.06899, 100, 0, 0),
(14423, 30 , -8614.239, 758.03345, 96.775826, 100, 0, 0),
(14423, 31 , -8614.618, 761.8731, 96.782036, 100, 0, 0),
(14423, 32 , -8632.216, 783.48956, 96.754, 100, 0, 0),
(14423, 33 , -8635.4375, 784.1659, 96.75399, 100, 0, 0),
(14423, 34 , -8656.627, 767.5417, 97.16683, 100, 0, 0),
(14423, 35 , -8656.929, 763.6135, 96.754, 100, 0, 0),
(14423, 36 , -8663.05, 745.1423, 96.83425, 100, 0, 0),
(14423, 37 , -8682.5625, 729.8788, 97.19358, 100, 0, 0),
(14423, 38 , -8697.906, 717.0097, 97.184715, 100, 0, 0),
(14423, 39 , -8700.944, 717.45276, 97.247086, 100, 0, 0),
(14423, 40 , -8714.825, 731.938, 97.9968, 100, 0, 0),
(14423, 41 , -8719.364, 732.74634, 98.44594, 100, 0, 0),
(14423, 42 , -8732.694, 722.76404, 101.69060, 100, 0, 0),
(14423, 43 , -8743.116, 714.8106, 98.387695, 100, 0, 0),
(14423, 44 , -8747.028, 714.84534, 97.985664, 100, 0, 0),
(14423, 45 , -8756.39, 726.35, 98.26425, 100, 0, 0),
(14423, 46 , -8763.958, 733.9565, 98.894646, 100, 0, 0),
(14423, 47 , -8776.364, 740.62286, 99.85111, 100, 0, 0),
(14423, 48 , -8791.9, 744.8109, 98.46442, 100, 0, 0),
(14423, 49 , -8802.408, 743.47595, 97.75399, 100, 0, 0),
(14423, 50 , -8813.773, 738.3633, 98.159935, 100, 0, 0),
(14423, 51 , -8828.805, 729.5161, 98.43811, 100, 0, 0),
(14423, 52 , -8841.403, 722.7214, 97.401886, 100, 0, 0),
(14423, 53 , -8842.708, 718.64844, 97.51971, 100, 0, 0),
(14423, 54 , -8826.645, 683.35724, 97.2486, 100, 0, 0),
(14423, 55 , -8827.101, 677.3289, 97.66306, 100, 0, 0),
(14423, 56 , -8840.831, 668.8012, 97.997955, 100, 0, 0),
(14423, 57 , -8852.247, 660.8422, 97.148384, 100, 0, 0),
(14423, 58 , -8865.671, 651.91254, 96.35991, 100, 0, 0),
(14423, 59 , -8876.904, 645.0913, 96.17128, 100, 0, 0),
(14423, 60 , -8888.976, 638.1713, 99.55399, 100, 0, 0),
(14423, 61 , -8899.427, 632.6978, 99.55399, 100, 0, 0),
(14423, 62 , -8909.794, 628.06274, 99.55399, 100, 6000, 0),
(14423, 63 , -8923.3125, 629.1903, 99.55399, 100, 0, 0),
(14423, 64 , -8925.838, 628.58215, 99.554, 100, 0, 0),
(14423, 65 , -8930.134, 625.66364, 99.553986, 100, 0, 0),
(14423, 66 , -8930.966, 623.2076, 99.628334, 100, 0, 0),
(14423, 67 , -8923.769, 610.96277, 99.554, 100, 0, 0),
(14423, 68 , -8919.345, 611.08984, 99.55399, 100, 0, 0),
(14423, 69 , -8915.428, 613.3201, 99.554, 100, 0, 0),
(14423, 70 , -8908.395, 625.8867, 99.55399, 100, 0, 0),
(14423, 71 , -8906.335, 627.2471, 99.55399, 100, 0, 0),
(14423, 72 , -8890.132, 637.0877, 99.90722, 100, 0, 0),
(14423, 73 , -8876.437, 643.2713, 96.29825, 100, 0, 0),
(14423, 74 , -8860.858, 642.2024, 96.33926, 100, 0, 0),
(14423, 75 , -8852.24, 643.3288, 96.56118, 100, 0, 0),
(14423, 76 , -8847.913, 641.9933, 96.37936, 100, 0, 0),
(14423, 77 , -8839.461, 624.4588, 93.743034, 100, 0, 0),
(14423, 78 , -8839.58, 619.7258, 93.07439, 100, 0, 0),
(14423, 79 , -8841.623, 615.4827, 92.954, 100, 0, 0),
(14423, 80 , -8870.555, 595.22906, 92.610054, 100, 0, 0),
(14423, 81 , -8884.704, 584.25714, 93.19327, 100, 0, 0),
(14423, 82 , -8887.59, 577.5536, 92.88254, 100, 0, 0),
(14423, 83 , -8886.7705, 573.9427, 92.81689, 100, 0, 0),
(14423, 84 , -8883.764, 571.6493, 92.818565, 100, 0, 0),
(14423, 85 , -8876.726, 573.4393, 93.1993, 100, 0, 0),
(14423, 86 , -8862.226, 585.3546, 93.18828, 100, 0, 0),
(14423, 87 , -8838.603, 611.6338, 93.13657, 100, 0, 0),
(14423, 88 , -8830.998, 619.3348, 93.91167, 100, 0, 0),
(14423, 89 , -8826.625, 619.0254, 94.484795, 100, 0, 0),
(14423, 90 , -8810.239, 604.8376, 96.15262, 100, 0, 0),
(14423, 91 , -8808.071, 599.38696, 96.85791, 100, 0, 0),
(14423, 92 , -8810.741, 586.7192, 96.686806, 100, 0, 0),
(14423, 93 , -8826.246, 563.833, 94.38658, 100, 0, 0),
(14423, 94 , -8836.717, 545.1619, 96.86916, 100, 0, 0),
(14423, 95 , -8848.263, 526.5596, 106.16259, 100, 0, 0),
(14423, 96 , -8852.016, 527.30664, 106.15399, 100, 0, 0),
(14423, 97 , -8853.239, 534.3621, 105.954, 100, 0, 0),
(14423, 98 , -8855.577, 537.7486, 106.14462, 100, 0, 0),
(14423, 99 , -8864.929, 534.4644, 106.73442, 100, 0, 0),
(14423, 100, -8866.474, 530.0012, 107.093216, 100, 0, 0),
(14423, 101, -8856.673, 514.6363, 109.37261, 100, 0, 0),
(14423, 102, -8842.954, 494.74283, 109.754, 100, 0, 0),
(14423, 103, -8834.646, 484.44086, 109.75400, 100, 0, 0),
(14423, 104, -8833.602, 480.35483, 109.75400, 100, 0, 0),
(14423, 105, -8838.841, 481.5585, 109.754005, 100, 0, 0),
(14423, 106, -8844.973, 493.54514, 109.754, 100, 0, 0),
(14423, 107, -8855.75, 509.68088, 109.754005, 100, 0, 0),
(14423, 108, -8868.258, 530.4019, 106.97846, 100, 0, 0),
(14423, 109, -8866.882, 534.6631, 106.65699, 100, 0, 0),
(14423, 110, -8856.083, 538.7447, 106.04074, 100, 0, 0),
(14423, 111, -8853.478, 528.61993, 106.070145, 100, 0, 0),
(14423, 112, -8849.387, 524.78156, 106.186676, 100, 0, 0);
-- Officer Brady 14439
-- path corrected
DELETE FROM `creature_movement` WHERE `id` = 79768;
UPDATE `creature` SET `position_x` = -8601.638, `position_y` = 523.6507, `position_z` = 106.63933 WHERE `id` = 14439;
DELETE FROM `creature_movement_template` WHERE `entry` = 14439;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14439, 1, -8601.638, 523.6507, 106.63933, 100, 5000, 0),
(14439, 2, -8581.546, 539.69574, 102.266045, 100, 0, 0),
(14439, 3, -8575.862, 539.07605, 102.03139, 100, 0, 0),
(14439, 4, -8563.927, 528.2599, 101.19023, 100, 0, 0),
(14439, 5, -8545.241, 504.38858, 98.61761, 100, 0, 0),
(14439, 6, -8541.685, 504.4677, 98.75399, 100, 0, 0),
(14439, 7, -8514.327, 525.6356, 98.354004, 100, 0, 0),
(14439, 8, -8485.2295, 553.8302, 97.770065, 100, 0, 0),
(14439, 9, -8463.388, 571.3037, 95.95916, 100, 0, 0),
(14439, 10, -8446.622, 580.2648, 94.52985, 100, 0, 0),
(14439, 11, -8443.085, 580.16766, 94.495346, 100, 0, 0),
(14439, 12, -8436.027, 574.83234, 94.52548, 100, 0, 0),
(14439, 13, -8426.326, 569.79895, 93.59884, 100, 0, 0),
(14439, 14, -8413.44, 569.19977, 92.472206, 100, 0, 0),
(14439, 15, -8406.945, 571.6961, 91.67245, 100, 0, 0),
(14439, 16, -8390.114, 582.91095, 91.47244, 100, 0, 0),
(14439, 17, -8387.141, 587.1458, 91.841576, 100, 0, 0),
(14439, 18, -8384.841, 596.20184, 93.043465, 100, 0, 0),
(14439, 19, -8387.144, 608.99445, 94.47244, 100, 0, 0),
(14439, 20, -8386.659, 616.2249, 95.34915, 100, 0, 0),
(14439, 21, -8383.278, 631.36255, 94.88296, 100, 0, 0),
(14439, 22, -8383.281, 637.25195, 94.76593, 100, 0, 0),
(14439, 23, -8389.605, 654.75226, 94.929665, 100, 0, 0),
(14439, 24, -8397.433, 666.32074, 95.07245, 100, 0, 0),
(14439, 25, -8404.393, 672.2673, 95.07245, 100, 0, 0),
(14439, 26, -8411.867, 672.3292, 95.00038, 100, 0, 0),
(14439, 27, -8424.925, 665.08606, 94.27243, 100, 0, 0),
(14439, 28, -8439.999, 655.98676, 92.971954, 100, 0, 0),
(14439, 29, -8443.912, 656.62335, 93.24204, 100, 0, 0),
(14439, 30, -8457.47, 674.0869, 97.094086, 100, 0, 0),
(14439, 31, -8470.097, 688.96515, 99.79605, 100, 0, 0),
(14439, 32, -8473.718, 688.8735, 99.825134, 100, 0, 0),
(14439, 33, -8487.623, 676.3581, 100.7908, 100, 0, 0),
(14439, 34, -8505.957, 655.3216, 100.61463, 100, 0, 0),
(14439, 35, -8510.778, 655.6416, 100.49313, 100, 0, 0),
(14439, 36, -8520.38, 670.751, 102.80517, 100, 0, 0),
(14439, 37, -8534.158, 683.94714, 97.862404, 100, 0, 0),
(14439, 38, -8539.977, 686.23254, 97.754, 100, 0, 0),
(14439, 39, -8548.569, 683.8376, 97.354004, 100, 0, 0),
(14439, 40, -8571.158, 666.95355, 97.173935, 100, 0, 0),
(14439, 41, -8594.918, 658.57477, 98.33257, 100, 0, 0),
(14439, 42, -8612.844, 654.1473, 98.82604, 100, 0, 0),
(14439, 43, -8632.7705, 655.2765, 100.654625, 100, 0, 0),
(14439, 44, -8649.738, 659.1952, 101.0557, 100, 0, 0),
(14439, 45, -8660.059, 665.005, 100.647, 100, 0, 0),
(14439, 46, -8671.601, 681.9389, 99.05992, 100, 0, 0),
(14439, 47, -8696.091, 711.7486, 97.1978, 100, 0, 0),
(14439, 48, -8712.865, 730.7987, 97.92129, 100, 0, 0),
(14439, 49, -8717.392, 730.96027, 98.31952, 100, 0, 0),
(14439, 50, -8728.78, 721.7431, 101.630295, 100, 0, 0),
(14439, 51, -8741.077, 710.851, 98.75803, 100, 0, 0),
(14439, 52, -8741.721, 705.45416, 98.75399, 100, 0, 0),
(14439, 53, -8738.794, 701.3393, 98.754, 100, 0, 0),
(14439, 54, -8740.221, 697.0274, 98.95223, 100, 0, 0),
(14439, 55, -8770.687, 673.35767, 102.959305, 100, 0, 0),
(14439, 56, -8776.231, 671.7561, 103.1594, 100, 0, 0),
(14439, 57, -8786.678, 678.2949, 102.67048, 100, 0, 0),
(14439, 58, -8789.155, 678.1131, 102.46095, 100, 0, 0),
(14439, 59, -8792.827, 674.55066, 101.764534, 100, 0, 0),
(14439, 60, -8795.769, 665.7567, 99.55677, 100, 0, 0),
(14439, 61, -8800.489, 651.89575, 94.70415, 100, 0, 0),
(14439, 62, -8803.677, 650.1126, 94.649124, 100, 0, 0),
(14439, 63, -8816.515, 643.13165, 94.354004, 100, 0, 0),
(14439, 64, -8829.733, 636.3333, 94.34265, 100, 0, 0),
(14439, 65, -8835.547, 636.18, 94.64197, 100, 0, 0),
(14439, 66, -8846.8545, 647.9088, 96.562965, 100, 0, 0),
(14439, 67, -8856.071, 654.5511, 96.43227, 100, 0, 0),
(14439, 68, -8861.03, 655.1785, 96.45397, 100, 0, 0),
(14439, 69, -8866.372, 651.38116, 96.297714, 100, 0, 0),
(14439, 70, -8884.347, 641.22296, 99.4233, 100, 0, 0),
(14439, 71, -8890.692, 637.1547, 99.8204, 100, 0, 0),
(14439, 72, -8906.768, 629.0008, 99.55399, 100, 0, 0),
(14439, 73, -8909.354, 625.2092, 99.55399, 100, 0, 0),
(14439, 74, -8911.279, 620.55646, 99.55399, 100, 0, 0),
(14439, 75, -8913.617, 614.4619, 99.55399, 100, 0, 0),
(14439, 76, -8921.304, 609.9665, 99.553986, 100, 0, 0),
(14439, 77, -8930.665, 623.9537, 99.63321, 100, 0, 0),
(14439, 78, -8929.692, 625.934, 99.553986, 100, 0, 0),
(14439, 79, -8923.158, 629.34064, 99.55399, 100, 0, 0),
(14439, 80, -8912.935, 627.77594, 99.55399, 100, 0, 0),
(14439, 81, -8906.326, 628.42816, 99.55399, 100, 0, 0),
(14439, 82, -8891.953, 636.0993, 99.55399, 100, 5000, 0),
(14439, 83, -8880.388, 642.80945, 97.86962, 100, 0, 0),
(14439, 84, -8866.74, 643.21515, 96.108, 100, 0, 0),
(14439, 85, -8857.599, 642.42804, 96.35401, 100, 0, 0),
(14439, 86, -8851.031, 643.18274, 96.40751, 100, 0, 0),
(14439, 87, -8841.356, 634.33606, 94.87717, 100, 0, 0),
(14439, 88, -8818.9375, 613.9858, 95.33711, 100, 0, 0),
(14439, 89, -8797.172, 592.83624, 97.59489, 100, 0, 0),
(14439, 90, -8793.838, 591.6427, 97.66595, 100, 0, 0),
(14439, 91, -8772.587, 606.4388, 97.19474, 100, 0, 0),
(14439, 92, -8768.8, 606.7465, 97.07879, 100, 0, 0),
(14439, 93, -8740.778, 578.358, 97.65093, 100, 0, 0),
(14439, 94, -8739.849, 573.6635, 97.479866, 100, 0, 0),
(14439, 95, -8742.695, 568.91644, 97.877884, 100, 0, 0),
(14439, 96, -8745.282, 561.0124, 97.6453, 100, 0, 0),
(14439, 97, -8743.528, 554.8785, 98.55012, 100, 0, 0),
(14439, 98, -8731.185, 540.56525, 101.23076, 100, 0, 0),
(14439, 99, -8715.927, 521.71313, 97.46964, 100, 0, 0),
(14439, 100, -8718.485, 516.16925, 96.796684, 100, 0, 0),
(14439, 101, -8719.92, 510.41788, 96.58051, 100, 0, 0),
(14439, 102, -8706.45, 492.0687, 95.754, 100, 0, 0),
(14439, 103, -8696.674, 476.42502, 95.35401, 100, 0, 0),
(14439, 104, -8697.08, 472.32367, 95.76096, 100, 0, 0),
(14439, 105, -8712.461, 456.7931, 96.97515, 100, 0, 0),
(14439, 106, -8721.935, 437.2447, 97.505424, 100, 0, 0),
(14439, 107, -8724.592, 422.58865, 97.90321, 100, 0, 0),
(14439, 108, -8725.233, 412.21182, 97.72274, 100, 0, 0),
(14439, 109, -8723.628, 408.02072, 97.82699, 100, 0, 0),
(14439, 110, -8719.919, 405.9682, 97.81381, 100, 0, 0),
(14439, 111, -8713.227, 404.88998, 98.48217, 100, 0, 0),
(14439, 112, -8691.036, 399.28354, 101.87355, 100, 0, 0),
(14439, 113, -8684.052, 399.10904, 102.17337, 100, 0, 0),
(14439, 114, -8673.338, 406.66763, 103.560715, 100, 0, 0),
(14439, 115, -8659.548, 416.714, 102.703674, 100, 0, 0),
(14439, 116, -8643.841, 434.49725, 101.354004, 100, 0, 0),
(14439, 117, -8637.046, 445.28604, 102.29749, 100, 0, 0),
(14439, 118, -8633.903, 454.77972, 102.22414, 100, 0, 0),
(14439, 119, -8634.247, 457.57434, 102.18744, 100, 0, 0),
(14439, 120, -8642.854, 476.16907, 102.55399, 100, 0, 0),
(14439, 121, -8641.72, 479.74405, 102.55401, 100, 0, 0),
(14439, 122, -8614.536, 501.1686, 103.175896, 100, 0, 0),
(14439, 123, -8610.833, 510.68784, 103.80662, 100, 0, 0),
(14439, 124, -8608.197, 516.80945, 104.47012, 100, 0, 0);
-- Officer Pomeroy 14438
-- path corrected
DELETE FROM `creature_movement` WHERE `id` = 90484;
UPDATE `creature` SET `position_x` = -8826.6045, `position_y` = 681.38184, `position_z` = 97.28126 WHERE `id` = 14438;
DELETE FROM `creature_movement_template` WHERE `entry` = 14438;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(14438, 1, -8826.6045, 681.38184, 97.28126, 100, 5000, 0),
(14438, 2, -8842.063, 714.4598, 97.55399, 100, 0, 0),
(14438, 3, -8853.691, 737.02234, 100.78476, 100, 0, 0),
(14438, 4, -8869.02, 758.17505, 97.28695, 100, 0, 0),
(14438, 5, -8873.345, 758.4512, 96.61947, 100, 0, 0),
(14438, 6, -8880.728, 756.8039, 96.24257, 100, 0, 0),
(14438, 7, -8900.08, 779.33575, 89.73537, 100, 0, 0),
(14438, 8, -8908.083, 787.47943, 88.064926, 100, 0, 0),
(14438, 9, -8911.849, 788.13385, 87.49192, 100, 0, 0),
(14438, 10 , -8928.932, 775.021, 87.86979, 100, 0, 0),
(14438, 11 , -8939.538, 771.4059, 89.48743, 100, 0, 0),
(14438, 12 , -8962.231, 771.539, 94.13737, 100, 0, 0),
(14438, 13 , -8969.38, 773.04, 95.491196, 100, 0, 0),
(14438, 14 , -8982.435, 787.9675, 99.143845, 100, 0, 0),
(14438, 15 , -8988.74, 796.0562, 101.41231, 100, 0, 0),
(14438, 16 , -8994.252, 817.9813, 104.24161, 100, 0, 0),
(14438, 17 , -8992.901, 827.8486, 105.245514, 100, 5000, 0),
(14438, 18 , -8991.418, 831.4787, 105.51857, 100, 0, 0),
(14438, 19 , -8987.735, 838.6429, 105.8535, 100, 0, 0),
(14438, 20 , -8981.061, 844.9807, 105.78623, 100, 0, 0),
(14438, 21 , -8976.74, 854.08765, 105.943665, 100, 0, 0),
(14438, 22 , -8975.687, 875.33624, 106.722664, 100, 0, 0),
(14438, 23 , -8977.0205, 879.33563, 106.60473, 100, 0, 0),
(14438, 24 , -8983.05, 886.4566, 106.0557, 100, 0, 0),
(14438, 25 , -9002.962, 900.2066, 105.73605, 100, 0, 0),
(14438, 26 , -9006.293, 904.16595, 105.93901, 100, 0, 0),
(14438, 27 , -9016.06, 923.40845, 107.788734, 100, 0, 0),
(14438, 28 , -9016.432, 928.2142, 108.12979, 100, 0, 0),
(14438, 29 , -9005.371, 954.27234, 110.55287, 100, 0, 0),
(14438, 30 , -9000.655, 957.66907, 112.133026, 100, 0, 0),
(14438, 31 , -8988.076, 960.3045, 115.30632, 100, 0, 0),
(14438, 32 , -8961.927, 955.78107, 117.632065, 100, 0, 0),
(14438, 33 , -8953.663, 955.3211, 117.170044, 100, 0, 0),
(14438, 34 , -8920.106, 946.71765, 117.502, 100, 0, 0),
(14438, 35 , -8916.348, 943.68774, 117.32009, 100, 0, 0),
(14438, 36 , -8902.853, 923.7333, 114.53584, 100, 0, 0),
(14438, 37 , -8896.755, 914.3192, 111.26516, 100, 0, 0),
(14438, 38 , -8892.268, 913.3867, 110.75214, 100, 0, 0),
(14438, 39 , -8876.938, 921.7949, 107.52044, 100, 0, 0),
(14438, 40 , -8855.174, 931.5497, 102.02101, 100, 0, 0),
(14438, 41 , -8849.411, 931.1022, 102.71485, 100, 0, 0),
(14438, 42 , -8835.05, 940.1454, 105.36824, 100, 0, 0),
(14438, 43 , -8819.731, 951.83875, 100.95979, 100, 0, 0),
(14438, 44 , -8815.408, 951.99457, 100.958, 100, 0, 0),
(14438, 45 , -8805.506, 944.2154, 101.35402, 100, 0, 0),
(14438, 46 , -8801.645, 943.8826, 101.33978, 100, 0, 0),
(14438, 47 , -8774.448, 965.0911, 100.55399, 100, 0, 0),
(14438, 48 , -8741.579, 994.1904, 97.12727, 100, 0, 0),
(14438, 49 , -8736.561, 1002.4335, 96.02398, 100, 0, 0),
(14438, 50 , -8734.741, 1029.0597, 94.18169, 100, 0, 0),
(14438, 51 , -8739.745, 1057.9086, 89.916534, 100, 0, 0),
(14438, 52 , -8743.805, 1061.6417, 90.154, 100, 0, 0),
(14438, 53 , -8767.127, 1065.1029, 90.95401, 100, 0, 0),
(14438, 54 , -8774.271, 1068.6871, 90.80249, 100, 0, 0),
(14438, 55 , -8796.405, 1092.5201, 90.8025, 100, 0, 0),
(14438, 56 , -8797.778, 1100.0641, 90.8025, 100, 0, 0),
(14438, 57 , -8794.471, 1129.7848, 90.80248, 100, 0, 0),
(14438, 58 , -8782.961, 1143.3358, 90.80249, 100, 0, 0),
(14438, 59 , -8748.739, 1147.6006, 90.40249, 100, 0, 0),
(14438, 60 , -8733.698, 1142.6151, 90.40249, 100, 0, 0),
(14438, 61 , -8718.343, 1123.0289, 90.80249, 100, 0, 0),
(14438, 62 , -8718.974, 1096.3301, 90.46272, 100, 0, 0),
(14438, 63 , -8724.44, 1080.1276, 90.80249, 100, 0, 0),
(14438, 64 , -8736.404, 1072.752, 90.713524, 100, 0, 0),
(14438, 65 , -8738.63, 1069.1337, 90.55558, 100, 0, 0),
(14438, 66 , -8728.967, 1030.7166, 93.86056, 100, 0, 0),
(14438, 67 , -8730.614, 993.82605, 96.23467, 100, 0, 0),
(14438, 68 , -8736.167, 956.74915, 100.315636, 100, 0, 0),
(14438, 69 , -8736.422, 948.7537, 101.27374, 100, 0, 0),
(14438, 70 , -8734.122, 942.94196, 101.07282, 100, 0, 0),
(14438, 71 , -8712.0625, 915.35547, 101.35400, 100, 0, 0),
(14438, 72 , -8712.734, 911.00323, 101.354004, 100, 0, 0),
(14438, 73 , -8731.607, 894.3013, 101.00582, 100, 0, 0),
(14438, 74 , -8733.229, 890.0532, 101.37273, 100, 0, 0),
(14438, 75 , -8725.045, 877.95807, 102.75375, 100, 0, 0),
(14438, 76 , -8712.339, 860.64136, 97.451584, 100, 0, 0),
(14438, 77 , -8713.042, 852.7908, 96.953995, 100, 0, 0),
(14438, 78 , -8723.935, 837.57025, 96.154, 100, 0, 0),
(14438, 79 , -8727.033, 823.617, 97.09409, 100, 0, 0),
(14438, 80 , -8725.302, 811.90326, 97.24609, 100, 0, 0),
(14438, 81 , -8722.625, 807.19257, 97.44662, 100, 0, 0),
(14438, 82 , -8718.096, 792.9386, 97.23787, 100, 0, 0),
(14438, 83 , -8722.994, 780.9759, 98.14472, 100, 0, 0),
(14438, 84 , -8729.802, 771.00183, 98.13611, 100, 0, 0),
(14438, 85 , -8731.231, 765.0807, 98.21273, 100, 0, 0),
(14438, 86 , -8727.691, 755.94196, 98.30679, 100, 0, 0),
(14438, 87 , -8716.1875, 738.75885, 97.959816, 100, 0, 0),
(14438, 88 , -8716.432, 734.7947, 97.80666, 100, 0, 0),
(14438, 89 , -8730.757, 724.1091, 101.566315, 100, 0, 0),
(14438, 90 , -8741.676, 711.95276, 98.63757, 100, 0, 0),
(14438, 91 , -8743.053, 707.6099, 98.52741, 100, 0, 0),
(14438, 92 , -8738.356, 701.60657, 98.754, 100, 0, 0),
(14438, 93 , -8739.159, 697.4417, 98.87494, 100, 0, 0),
(14438, 94 , -8772.889, 672.07, 103.154, 100, 0, 0),
(14438, 95 , -8777.839, 671.7857, 103.15387, 100, 0, 0),
(14438, 96 , -8789.471, 681.72363, 101.99133, 100, 0, 0),
(14438, 97 , -8800.104, 684.8838, 101.27393, 100, 0, 0),
(14438, 98 , -8804.825, 684.38684, 100.78233, 100, 0, 0),
(14438, 99 , -8832.582, 673.52954, 98.35401, 100, 0, 0),
(14438, 100, -8854.741, 658.60895, 96.79449, 100, 0, 0),
(14438, 101, -8873.732, 646.583, 96.09485, 100, 0, 0),
(14438, 102, -8887.442, 638.54376, 99.55399, 100, 0, 0),
(14438, 103, -8898.564, 632.5816, 99.55399, 100, 0, 0),
(14438, 104, -8909.45, 626.0978, 99.55399, 100, 0, 0),
(14438, 105, -8910.427, 623.763, 99.55399, 100, 0, 0),
(14438, 106, -8915.915, 613.1712, 99.554, 100, 0, 0),
(14438, 107, -8922.533, 609.69055, 99.554, 100, 0, 0),
(14438, 108, -8925.138, 610.2278, 99.554, 100, 0, 0),
(14438, 109, -8931.703, 623.3658, 99.62185, 100, 0, 0),
(14438, 110, -8930.488, 625.82227, 99.553986, 100, 0, 0),
(14438, 111, -8922.257, 630.2243, 99.55399, 100, 0, 0),
(14438, 112, -8919.293, 630.1833, 99.553986, 100, 0, 0),
(14438, 113, -8911.858, 627.912, 99.55399, 100, 0, 0),
(14438, 114, -8906.694, 628.94806, 99.55399, 100, 0, 0),
(14438, 115, -8886.024, 639.9803, 99.55399, 100, 0, 0),
(14438, 116, -8875.899, 645.8838, 96.14633, 100, 0, 0),
(14438, 117, -8852.701, 660.43933, 97.03088, 100, 0, 0),
(14438, 118, -8827.224, 677.1314, 97.70704, 100, 0, 0);
-- Erich Lohan 3627
-- path corrected
DELETE FROM `creature_movement_scripts` WHERE `id` IN ( 9044502, 9044504, 9044507, 9044512, 9044517, 9044521, 9044526, 9044530, 9044535, 9044539, 9044543, 9044547, 9044552, 9044557, 9044561);
-- Events list for Erich Lohan
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
(362701, 3627, 0, 1, 0, 100, 3, 1000, 30000, 60000, 120000, 362701, 362702, 0, 'Erich Lohan - Talk - OOC');
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(362701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1192, 1193, 1194, 1195, 0, 0, 0, 0, 0, 'Erich Lohan - Talk - OOC'),
(362702, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1196, 1197, 1198, 1199, 0, 0, 0, 0, 0, 'Erich Lohan - Talk - OOC');
UPDATE `creature_template` SET `ai_name` = 'EventAI' WHERE `entry` = 3627;
DELETE FROM `creature_movement` WHERE `id` = 90445;
UPDATE `creature` SET `position_x` = -9034.635, `position_y` = 873.8468, `position_z` = 110.45542 WHERE `guid` = 90445;
DELETE FROM `creature_movement_template` WHERE entry = 3627;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(3627, 1 , -9034.635, 873.8468, 110.45542, 100, 0, 0),
(3627, 2 , -9035.321, 861.9573, 107.154, 100, 0, 0),
(3627, 3 , -9034.322, 850.70685, 107.154, 100, 0, 0),
(3627, 4 , -9029.455, 838.80646, 107.15399, 100, 0, 0),
(3627, 5 , -9024.216, 832.8253, 105.754005, 100, 0, 0),
(3627, 6 , -9015.763, 824.17285, 105.553986, 100, 0, 0),
(3627, 7 , -9009.887, 824.89044, 105.45737, 100, 0, 0),
(3627, 8 , -9003.698, 831.9128, 106.09863, 100, 0, 0),
(3627, 9 , -8996.925, 835.7118, 105.89727, 100, 0, 0),
(3627, 10, -8989.419, 836.58997, 105.86534, 100, 0, 0),
(3627, 11, -8981.592, 844.1351, 105.820435, 100, 0, 0),
(3627, 12, -8975.935, 855.59845, 106.035545, 100, 0, 0),
(3627, 13, -8965.941, 861.0381, 106.12975, 100, 0, 0),
(3627, 14, -8953.057, 862.613, 104.917076, 100, 0, 0),
(3627, 15, -8938.807, 860.5985, 102.82739, 100, 0, 0),
(3627, 16, -8926.196, 858.409, 99.511894, 100, 0, 0),
(3627, 17, -8915.191, 852.04144, 96.84531, 100, 0, 0),
(3627, 18, -8907.254, 842.3125, 95.751564, 100, 0, 0),
(3627, 19, -8899.501, 830.12036, 93.38386, 100, 0, 0),
(3627, 20, -8898.51, 814.8087, 89.55783, 100, 0, 0),
(3627, 21, -8900.932, 798.8295, 87.58461, 100, 0, 0),
(3627, 22, -8910.074, 791.3167, 87.43847, 100, 0, 0),
(3627, 23, -8919.713, 783.53015, 87.55399, 100, 0, 0),
(3627, 24, -8926.364, 776.04004, 87.37037, 100, 0, 0),
(3627, 25, -8938.711, 771.2658, 89.29464, 100, 0, 0),
(3627, 26, -8955.9375, 770.7839, 92.95392, 100, 0, 0),
(3627, 27, -8967.881, 773.459, 95.29695, 100, 0, 0),
(3627, 28, -8974.038, 780.0628, 96.830635, 100, 0, 0),
(3627, 29, -8984.748, 789.0114, 99.593796, 100, 0, 0),
(3627, 30, -8988.526, 796.8366, 101.55564, 100, 0, 0),
(3627, 31, -8991.243, 807.8743, 103.65796, 100, 0, 0),
(3627, 32, -8994.158, 821.1847, 104.61137, 100, 0, 0),
(3627, 33, -8993.103, 830.43097, 105.49524, 100, 0, 0),
(3627, 34, -8988.234, 838.76794, 105.830765, 100, 0, 0),
(3627, 35, -8981.39, 845.93054, 105.69717, 100, 0, 0),
(3627, 36, -8975.966, 856.02454, 106.047874, 100, 0, 0),
(3627, 37, -8975.371, 869.4717, 106.822136, 100, 0, 0),
(3627, 38, -8976.599, 878.00903, 106.61893, 100, 0, 0),
(3627, 39, -8984.586, 888.0883, 105.74467, 100, 0, 0),
(3627, 40, -8994.966, 896.75665, 105.62777, 100, 0, 0),
(3627, 41, -9004.082, 902.9594, 105.85836, 100, 0, 0),
(3627, 42, -9012.935, 918.2857, 107.09058, 100, 0, 0),
(3627, 43, -9013.746, 934.3277, 108.432205, 100, 0, 0),
(3627, 44, -9008.433, 946.70825, 109.30699, 100, 0, 0),
(3627, 45, -9005.583, 953.9983, 110.48592, 100, 0, 0),
(3627, 46, -8996.755, 958.68243, 113.1283, 100, 0, 0),
(3627, 47, -8984.302, 960.6096, 115.732765, 100, 0, 0),
(3627, 48, -8974.652, 958.9971, 116.92094, 100, 0, 0),
(3627, 49, -8959.526, 956.1835, 117.53096, 100, 0, 0),
(3627, 50, -8946.355, 955.13165, 116.94782, 100, 0, 0),
(3627, 51, -8931.708, 949.62445, 117.34928, 100, 0, 0),
(3627, 52, -8920.861, 949.9142, 117.362656, 100, 0, 0),
(3627, 53, -8913.316, 939.4435, 116.99974, 100, 0, 0),
(3627, 54, -8901.914, 921.08594, 113.86572, 100, 0, 0),
(3627, 55, -8889.96, 900.97235, 107.442894, 100, 0, 0),
(3627, 56, -8888.45, 891.4626, 103.9027, 100, 0, 0),
(3627, 57, -8892.7, 874.5964, 99.52523, 100, 0, 0),
(3627, 58, -8899.321, 861.36035, 96.3868, 100, 0, 0),
(3627, 59, -8907.177, 849.31134, 96.34712, 100, 0, 0),
(3627, 60, -8915.933, 851.704, 96.932594, 100, 0, 0),
(3627, 61, -8926.026, 858.4897, 99.47577, 100, 0, 0),
(3627, 62, -8938.801, 860.7874, 102.8409, 100, 0, 0),
(3627, 63, -8953.069, 862.7512, 104.92075, 100, 0, 0),
(3627, 64, -8966.061, 861.0922, 106.138145, 100, 0, 0),
(3627, 65, -8976.133, 855.7526, 106.058304, 100, 0, 0),
(3627, 66, -8981.173, 845.29376, 105.75669, 100, 0, 0),
(3627, 67, -8989.85, 837.08203, 105.85746, 100, 0, 0),
(3627, 68, -8997.29, 835.3158, 105.9672, 100, 0, 0),
(3627, 69, -9003.969, 831.63586, 106.08048, 100, 0, 0),
(3627, 70, -9009.577, 825.371, 105.47429, 100, 0, 0),
(3627, 71, -9015.882, 824.13556, 105.553986, 100, 0, 0),
(3627, 72, -9024.274, 832.87933, 105.754005, 100, 0, 0),
(3627, 73, -9029.402, 838.9516, 107.15399, 100, 0, 0),
(3627, 74, -9034.356, 850.774, 107.154, 100, 0, 0),
(3627, 75, -9035.346, 861.90265, 107.154, 100, 0, 0),
(3627, 76, -9034.61, 874.1747, 110.45368, 100, 0, 0),
(3627, 77, -9030.81, 883.0651, 110.44071, 100, 1000, 0);
-- Stormwind City Patroller 1976
-- 2 guards at Valley of Heroes
UPDATE `creature` SET `position_x` = -8926.496, `position_y` = 547.9117, `position_z` = 94.36078 WHERE `guid` = 79675;
UPDATE `creature` SET `position_x` = -8921.255, `position_y` = 541.5815, `position_z` = 94.345055 WHERE `guid` = 79670;
-- waypoints
DELETE FROM `creature_movement` WHERE `id` IN (79675,79670);
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
-- 79675
(79675, 1 , -8926.496, 547.9117, 94.36078 , 100, 0, 0),
(79675, 2 , -8912.502, 560.546, 93.694756 , 100, 0, 0),
(79675, 3 , -8904.495, 566.9569, 93.143295, 100, 0, 0),
(79675, 4 , -8898.334, 572.24176, 92.81866, 100, 0, 0),
(79675, 5 , -8896.334, 569.8383, 92.76499 , 100, 0, 0),
(79675, 6 , -8910.702, 557.90906, 93.57455, 100, 0, 0),
(79675, 7 , -8928.997, 544.5078, 94.39267 , 100, 0, 0),
(79675, 8 , -8927.138, 534.4533, 94.67518 , 100, 0, 0),
(79675, 9 , -8915.321, 517.5744, 93.954 , 100, 0, 0),
(79675, 10, -8916.1455, 501.6403, 93.95401, 100, 0, 0),
(79675, 11, -8934.112, 502.02863, 93.954 , 100, 0, 0),
(79675, 12, -8940.811, 511.40945, 96.03233, 100, 0, 0),
(79675, 13, -8947.672, 515.8253, 96.66118 , 100, 0, 0),
(79675, 14, -8961.026, 516.0897, 96.75399 , 100, 0, 0),
(79675, 15, -8960.283, 529.70825, 96.601 , 100, 0, 0),
(79675, 16, -8974.147, 544.01447, 94.13085, 100, 0, 0),
(79675, 17, -8981.909, 554.18823, 94.10508, 100, 0, 0),
(79675, 18, -8970.087, 564.66046, 93.954 , 100, 0, 0),
(79675, 19, -8960.388, 571.90063, 93.95401, 100, 0, 0),
(79675, 20, -8953.924, 570.0947, 93.89443 , 100, 0, 0),
(79675, 21, -8943.239, 558.2567, 93.95401 , 100, 0, 0),
(79675, 22, -8932.935, 546.86414, 94.4136 , 100, 0, 0),
-- 79670
(79670, 1 , -8921.255, 541.5815, 94.345055, 100, 0, 0),
(79670, 2 , -8908.754, 551.8247, 93.764854, 100, 0, 0),
(79670, 3 , -8893.195, 563.9041, 92.846146, 100, 0, 0),
(79670, 4 , -8895.691, 566.93414, 92.76838, 100, 0, 0),
(79670, 5 , -8910.966, 554.7331, 93.72926 , 100, 0, 0),
(79670, 6 , -8923.191, 544.4699, 94.34877 , 100, 0, 0),
(79670, 7 , -8934.748, 543.7842, 94.43737 , 100, 0, 0),
(79670, 8 , -8946.599, 558.0619, 93.95401 , 100, 0, 0),
(79670, 9 , -8966.307, 561.7617, 93.954 , 100, 0, 0),
(79670, 10, -8967.722, 542.7493, 94.28108 , 100, 0, 0),
(79670, 11, -8956.603, 532.3937, 96.62912 , 100, 0, 0),
(79670, 12, -8961.372, 518.6285, 96.75399 , 100, 0, 0),
(79670, 13, -8947.429, 510.66342, 96.41146, 100, 0, 0),
(79670, 14, -8935.815, 494.46545, 94.050964, 100, 0, 0),
(79670, 15, -8926.802, 490.17264, 93.954 , 100, 0, 0),
(79670, 16, -8918.674, 495.736, 93.95402 , 100, 0, 0),
(79670, 17, -8912.285, 501.35205, 93.954 , 100, 0, 0),
(79670, 18, -8908.821, 507.93185, 93.954 , 100, 0, 0),
(79670, 19, -8909.695, 514.50336, 93.954 , 100, 0, 0),
(79670, 20, -8912.723, 523.9491, 93.954 , 100, 0, 0),
(79670, 21, -8923.787, 536.1689, 94.77347, 100, 0, 0);
-- Ironforge Mountaineer 727
-- custom made path corrected
DELETE FROM `creature_movement` WHERE `id` = 146;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(146,1 ,-5247.748,-515.876,386.3603,100,30000,0),
(146,2 ,-5244.334,-523.7012,387.8603,100,0,0),
(146,3 ,-5243.176,-543.9634,395.2614,100,0,0),
(146,4 ,-5242.821,-564.1043,402.5114,100,0,0),
(146,5 ,-5239.889,-571.1794,405.0498,100,0,0),
(146,6 ,-5232.076,-573.5452,405.4427,100,0,0),
(146,7 ,-5227.861,-572.004,404.6927,100,0,0),
(146,8 ,-5226.727,-562.0967,408.5633,100,0,0),
(146,9 ,-5226.727,-562.0967,408.5633,2.199115,60000,0),
(146,10,-5227.023,-570.0957,405.3177,100,0,0),
(146,11,-5237.249,-572.7875,405.4248,100,0,0),
(146,12,-5242.318,-566.8207,403.5498,100,0,0),
(146,13,-5242.512,-533.8203,391.5114,100,0,0);
-- Felix Whindlebolt 8416
UPDATE `creature` SET `wander_distance` = 7, `movement_type` = 1 WHERE `id` = 8416;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Increase Droprate of Samophlange Manual Page
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -20 WHERE `entry`=3283 AND `item`=11148 AND `groupid`=0 AND `patch_min`=0 AND `patch_max`=10;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -20 WHERE `entry`=3286 AND `item`=11148 AND `groupid`=0 AND `patch_min`=0 AND `patch_max`=10;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Quest Complete Text For Dawn's Gambit (credit cmangos)
UPDATE `quest_template` SET `OfferRewardText` = "You did it! Vectus is defeated! And Dawn's Gambit... did it work?$B$BHm... maybe my device wasn't the success I had hoped, but I'm glad you were able to handle things anyway. Well done, $N!$B$BThe Argent Dawn, and the good people of Azeroth, are in your debt." WHERE `entry` = 4771;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Update Stormwind Guards
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 1 WHERE `guid` = 79840;
DELETE FROM `creature` WHERE `guid` IN (189, 190);
DELETE FROM `game_event_creature_data` WHERE `guid` IN (189, 190);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Remove Duplicate Gameobjects
DELETE FROM `gameobject` WHERE `guid` IN (SELECT `guid` FROM `pool_gameobject` WHERE `pool_entry` = 1319);
DELETE FROM `pool_gameobject` WHERE `pool_entry` = 1319;
DELETE FROM `pool_template` WHERE `entry` = 1319;
UPDATE `gameobject` SET `spawntimesecsmin` = 300, `spawntimesecsmax` = 300 WHERE `guid`=2223;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Remove Creature in Wrong Place
DELETE FROM `creature` WHERE `guid` = 5608;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Add Script For Suspicious Hoofprints
UPDATE `quest_template` SET `CompleteScript` = 1284 WHERE `entry`=1284;
DELETE FROM `quest_end_scripts` WHERE `id`=1284;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `priority`, `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
(1284, 0, 0, 1, 1, 0, 0, 0, 4944, 30, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Captain Garran Vimes - Emote OneShotTalk'),
(1284, 0, 0, 0, 0, 0, 0, 0, 4944, 30, 8, 2, 1753, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Captain Garran Vimes - Say Text'),
(1284, 1, 0, 10, 5088, 30297, 0, 0, 0, 0, 0, 0, 0, 0, -1, 1, -3715.15, -4523.85, 25.917, 4.76475, 0, 'Suspicious Hoofprints: Summon Creature Falgran Hastil'),
(1284, 3, 0, 3, 0, 3162, 1, 2, 5088, 50, 8, 2, 0, 0, 0, 0, -3714.11, -4531.68, 25.8337, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Move'),
(1284, 5, 0, 3, 0, 3864, 1, 2, 5088, 50, 8, 2, 0, 0, 0, 0, -3714.36, -4537.47, 25.8337, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Move'),
(1284, 6, 0, 3, 0, 4620, 1, 2, 5088, 50, 8, 2, 0, 0, 0, 0, -3717.07, -4542.72, 25.8337, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Move'),
(1284, 6, 0, 0, 0, 0, 0, 0, 4948, 30, 8, 2, 1754, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Adjutant Tesoran - Say Text'),
(1284, 6, 0, 1, 1, 0, 0, 0, 4948, 30, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Adjutant Tesoran - Emote OneShotTalk'),
(1284, 10, 0, 3, 0, 4548, 1, 2, 5088, 50, 8, 2, 0, 0, 0, 0, -3724.38, -4545.64, 25.8337, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Move'),
(1284, 14, 0, 35, 1, 0, 0, 0, 5088, 50, 8, 2, 0, 0, 0, 0, 0, 0, 0, 3.92117, 0, 'Suspicious Hoofprints: Falgran Hastil - Set Orientation'),
(1284, 16, 0, 1, 16, 0, 0, 0, 5088, 50, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Emote OneShotKneel'),
(1284, 19, 0, 1, 1, 0, 0, 0, 5088, 50, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Emote OneShotTalk'),
(1284, 19, 0, 0, 0, 0, 0, 0, 5088, 50, 8, 2, 1752, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Say Text'),
(1284, 23, 0, 1, 66, 0, 0, 0, 5088, 50, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Emote OneShotSalute'),
(1284, 24, 0, 25, 1, 0, 0, 0, 5088, 50, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Run'),
(1284, 26, 0, 60, 2, 0, 0, 0, 5088, 50, 8, 2, 0, 5088, 0, 0, 0, 0, 0, 0, 0, 'Suspicious Hoofprints: Falgran Hastil - Start Waypoints');
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
(5088, 1, -3717.860107, -4542.540039, 26.083700, 100, 0, 0, 0),
(5088, 2, -3714.360107, -4539.790039, 26.083700, 100, 0, 0, 0),
(5088, 3, -3712.860107, -4535.540039, 26.083700, 100, 0, 0, 0),
(5088, 4, -3714.110107, -4528.790039, 26.083700, 100, 0, 0, 0),
(5088, 5, -3714.360107, -4527.790039, 26.083700, 100, 0, 0, 0),
(5088, 6, -3714.610107, -4526.540039, 26.083700, 100, 0, 0, 0),
(5088, 7, -3714.830078, -4524.939941, 25.833700, 100, 0, 0, 0);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Backstab Spell for Defias Pathstalker 121 (credit cmangos)
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
(1210, 'Westfall - Defias Pathstalker', 7159, 65, 1, 0, 0, 0, 1, 7, 4, 4, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Add Eliza Spawn Text and Spawn Position
DELETE FROM `creature_ai_scripts` WHERE `id`=31403;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 111, 0, 0, 0, 0, 0, 0, 0, 0, 'Eliza - Say Text');
DELETE FROM `creature_ai_scripts` WHERE `id`=31413;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(31413, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 'Eliza - Say on Spawn');
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
(31413, 314, 0, 11, 0, 100, 0, 0, 0, 0, 0, 31413, 0, 0, 'Eliza - Say on Spawn');
DELETE FROM `quest_end_scripts` WHERE `id`=254;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `priority`, `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
(254, 1, 0, 10, 314, 3000000, 0, 0, 0, 0, 0, 0, 8, 0, -1, 1, -10270, 53.9225, 41.8903, 6.15428, 0, 'Digging Through the Dirt: Summon Creature');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Some Creature Loot (Credit TrinityCore)
DELETE FROM `creature_loot_template` WHERE `entry` IN (11374);
UPDATE `creature_template` SET `loot_id` = 0, `skinning_loot_id` = 0 WHERE `entry` IN (11374);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Events list for Dustbelcher Mystic
UPDATE `creature_template` SET `ai_name` = 'EventAI' WHERE `entry` = 2907;
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
(290701, 2907, 0, 4, 0, 10, 0, 0, 0, 0, 0, 290701, 0, 0, 'Dustbelcher Mystic - Talk on Aggro');
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(290701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1925, 1926, 0, 0, 0, 0, 0, 0, 0, 'Dustbelcher Mystic - Talk');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Events list for Blackrock Scout
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
(406402, 4064, 0, 4, 0, 10, 0, 0, 0, 0, 0, 406402, 0, 0, 'Blackrock Scout - Talk on Aggro');
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(406402, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1874, 1875, 0, 0, 0, 0, 0, 0, 0, 'Blackrock Scout - Talk');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct respawn time
-- Tethis 420 600
-- King Bangalash 420 600
-- Bhag'thera 420 600
-- Mai'Zoth 1800 1800
UPDATE `creature` SET `spawntimesecsmin` = 240, `spawntimesecsmax` = 360 WHERE `id` IN (730,731,728,818);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Injured Stockades Guard
INSERT INTO `creature_addon` (`guid`, `mount_display_id`, `stand_state`, `auras`) VALUES
(79581, 0, 1, NULL);
UPDATE `creature_template` SET `script_name`='' WHERE `entry`=4996 AND `patch`=0;
UPDATE `creature` SET `position_x` = -8767.58, `position_y` = 819.59, `position_z` = 97.718, `orientation` = 5.00909 WHERE `guid` = 79581;
UPDATE `creature` SET `position_x` = -8764.93, `position_y` = 815.262, `position_z` = 97.718, `orientation` = 0.593412 WHERE `guid` = 79550;
UPDATE `creature` SET `position_x` = -8763.87, `position_y` = 813.766, `position_z` = 97.718, `orientation` = 0.645772 WHERE `guid` = 79580;
UPDATE `creature` SET `position_x` = -8762.81, `position_y` = 812.356, `position_z` = 97.718, `orientation` = 0.715585 WHERE `guid` = 79522;
UPDATE `creature` SET `position_x` = -8757.44, `position_y` = 812.397, `position_z` = 97.718, `orientation` = 2.28638 WHERE `guid` = 79558;
UPDATE `creature` SET `position_x` = -8756.31, `position_y` = 813.461, `position_z` = 97.718, `orientation` = 2.44346 WHERE `guid` = 90457;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Objects Should Not Despawn On Use
UPDATE `gameobject` SET `spawntimesecsmin` = 0, `spawntimesecsmax` = 0 WHERE `id` IN (149481, 149480, 149482, 149483);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Remove Incorrect Creature
DELETE FROM `creature` WHERE `guid` = 23898;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Fix Creature Stuck in Tree
UPDATE `creature` SET `position_x` = 1610.617, position_y = -5611.91, `position_z` = 101.6521, `movement_type` = 1, `wander_distance` = 5 WHERE `guid` = 56554;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Nicky: New creature spell lists. (We should really sync with cmangos ACID)
-- brotalnia: No we should not throw our own data we've worked on for years and blindly replace it with another project's. We should only update things based on sniffs. No sniff = no proof!
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
(18470, 'Western Plaguelands - Foulmane', 3391, 100, 0, 0, 0, 0, 8, 12, 15, 20, 0, 3427, 100, 1, 0, 0, 32, 10, 30, 15, 45, 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);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Dream Bough Creatures Should be Grouped
UPDATE `creature` SET `movement_type` = 0, `wander_distance` = 0 WHERE `guid` IN (51280, 51259, 51237, 51285, 51241, 51262, 51289, 51266, 51245, 51291, 51268, 51247, 51293, 51270, 51249, 51250, 51294, 51271, 51292, 51248, 51269, 51298, 51255, 51276, 51283, 51282, 51239, 51281, 51238, 51260, 51296, 51252, 51273, 51254, 51275, 51297, 51253, 51274, 51278);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51273;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51273, 51252, 4, 2.35619, 11),
(51273, 51296, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51260;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51260, 51281, 4, 2.35619, 11),
(51260, 51238, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51239;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51239, 51283, 4, 2.35619, 11),
(51239, 51282, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51276;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51276, 51255, 4, 2.35619, 11),
(51276, 51298, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51269;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51269, 51248, 4, 2.35619, 11),
(51269, 51292, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51271;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51271, 51294, 4, 2.35619, 11),
(51271, 51250, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51293;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51293, 51270, 4, 2.35619, 11),
(51293, 51249, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51247;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51247, 51268, 4, 2.35619, 11),
(51247, 51291, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51289;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51289, 51266, 4, 2.35619, 11),
(51289, 51245, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51262;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51262, 51241, 4, 2.35619, 11),
(51262, 51285, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51280;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51280, 51259, 4, 2.35619, 11),
(51280, 51237, 4, 3.92699, 11);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51254;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51254, 51275, 4, 2.35619, 11),
(51254, 51297, 4, 3.92699, 11);
UPDATE `creature` SET `position_x` = -3009.146, `position_y` = 2113.024, `position_z` = 30.851 WHERE `guid` IN (51253, 51274, 51278);
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 15 WHERE `guid` = 51253;
INSERT INTO `creature_groups` (`leader_guid`, `member_guid`, `dist`, `angle`, `flags`) VALUES
(51253, 51274, 4, 2.35619, 11),
(51253, 51278, 4, 3.92699, 11);
-- Remove Duplicate Object
DELETE FROM `gameobject` WHERE `guid` = 42329;
DELETE FROM `pool_gameobject` WHERE `guid` = 42329;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Dusty Reliquary Does Not Despawn on Use
UPDATE `gameobject` SET `spawntimesecsmin` = 0, `spawntimesecsmax` = 0 WHERE `guid` = 49372;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Rock Stalker and Stonelash Flayer Share Spawns
UPDATE `creature` SET `id` = 11737, `id2` = 11739 WHERE `id` IN (11737, 11739);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Twilight Geolord and Twilight Avengers Share Spawns
UPDATE `creature` SET `id` = 11880, `id2` = 11881 WHERE `id` IN (11880, 11881);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Twilight Avengers and Twilight Overlord Share Spawns
UPDATE `creature` SET `id` = 11880, `id2` = 15213 WHERE `guid` IN (43078, 43079, 43080, 43081, 43082, 43083, 43084, 43085, 43086, 43087, 43088, 43089, 43090, 43091, 43092, 43093, 43094, 43095, 43096, 42954, 42946, 42945, 42987, 42986);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Creatures Should Wander
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 1 WHERE `guid` IN (41059, 41061, 41058, 41039);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Stonelash Scorpid and Sand Skitterer Share Spawns
UPDATE `creature` SET `id` = 11735, `id2` = 11738 WHERE `id` IN (11735, 11738);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Add Script For Hive Ashi Pod
UPDATE `creature_template` SET `spawn_spell_id` = 10389 WHERE `entry` = 13301;
DELETE FROM `creature` WHERE `guid` IN (300179, 300178);
DELETE FROM `creature_groups` WHERE `leader_guid`=300178;
INSERT INTO `gameobject_scripts` (`id`, `delay`, `priority`, `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
(49376, 0, 0, 10, 13301, 180000, 2, 0, 0, 0, 0, 0, 8, 4937601, 0, 1, -7183.78, 439.759, 64.2477, 6.14356, 0, 'Hive Ashi Pod - Summon Creature'),
(49376, 0, 0, 10, 13301, 180000, 2, 0, 0, 0, 0, 0, 8, 4937602, 0, 1, -7176.54, 441.411, 64.1541, 3.45575, 0, 'Hive Ashi Pod - Summon Creature');
INSERT INTO `generic_scripts` (`id`, `delay`, `priority`, `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
(4937601, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8675, 0, 0, 0, 0, 0, 0, 0, 0, 'Hive Ashi Ambusher - Talk');
INSERT INTO `generic_scripts` (`id`, `delay`, `priority`, `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
(4937602, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8676, 0, 0, 0, 0, 0, 0, 0, 0, 'Hive Ashi Ambusher - Talk');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Quests 4508 and 4509 are Alliance / Horde Only
UPDATE `quest_template` SET `RequiredRaces` = 77 WHERE `entry` = 4508;
UPDATE `quest_template` SET `RequiredRaces` = 178 WHERE `entry` = 4509;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Plaguehound Runt and Plaguebat Share Spawns
UPDATE `creature` SET `id` = 8596, `id2` = 8600 WHERE `id` IN (8596, 8600);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Create new pool to hold Small Lockbox spawns in Western Plaguelands.
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(3587, 9, 'Western Plaguelands - Small Lockbox', 0, 10);
INSERT INTO `pool_gameobject_template` (`id`, `pool_entry`, `description`) VALUES
(175802, 3587, 'Western Plaguelands - Small Lockbox');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Create new pool to hold Moontouched Feather spawns in Winterspring
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(3588, 30, 'Winterspring - Moontouched Feather', 0, 10);
INSERT INTO `pool_gameobject_template` (`id`, `pool_entry`, `description`) VALUES
(175407, 3588, 'Winterspring - Moontouched Feather');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Remove Duplicate Object
DELETE FROM `gameobject` WHERE `guid` IN (SELECT `guid` FROM `pool_gameobject` WHERE `pool_entry` = 417);
DELETE FROM `pool_gameobject` WHERE `pool_entry` = 417;
DELETE FROM `pool_pool` WHERE `pool_id` = 417;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Scarlet Mage and Scarlet Knight Share Spawns
UPDATE `creature` SET `id` = 1826, `id2` = 1833 WHERE `id` IN (1826, 1833);
-- Except
UPDATE `creature` SET `id` = 1833, `id2` = 0 WHERE `guid` IN (45381,45377, 47157, 45379);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Correct Skeletal Horror Spell List
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 (2020, 'Duskwood - Skeletal Horror', 7399, 100, 1, 0, 0, 32, 5, 20, 20, 30, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Shared Spawns At The Fungal Vale
UPDATE `creature` SET `id` = 8529, `id2` = 8532, `id3` = 8542, `id4` = 8545 WHERE `guid` IN (92706, 92705, 92517, 92674, 92793, 92513, 92515, 92514, 92672, 92707, 92374, 92324, 92519, 92708, 92521, 91925, 92261, 91928, 92709, 92520, 92380, 92378, 91931, 91930);
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Shared Spawns At Browman Mill / The Noxious Glade
UPDATE `creature` SET `id` = 8528, `id2` = 8529, `id3` = 8532, `id4` = 8542 WHERE `guid` IN (92810, 92809, 92474, 92547, 92654, 92653, 92650, 92651, 92652, 92476, 92562, 92475, 92561, 92777, 92776, 92681, 92677, 92678, 92676, 92675, 92473, 92667, 92666, 92663, 92660, 92683, 92659, 92680, 92679, 92808);
-- Fix db errors after this.
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=47160 AND `id`=1826;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=47889 AND `id`=1826;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92474 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92475 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92547 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92561 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92562 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92651 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92652 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92653 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92654 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92663 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92666 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92676 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92679 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92680 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92681 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=92808 AND `id`=8528;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=42954 AND `id`=11880;
UPDATE `creature` SET `mana_percent`=100 WHERE `guid`=42986 AND `id`=11880;
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Events list for Darrowshire Poltergeist
UPDATE `creature_template` SET `ai_name` = 'EventAI' WHERE `entry` = 11296;
DELETE FROM `creature_ai_events` WHERE `creature_id`=11296;
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
(1129601, 11296, 0, 1, 0, 100, 3, 10000, 30000, 30000, 60000, 1129601, 1129602, 0, 'Darrowshire Poltergeist - Talk - OOC');
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(1129601, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7205, 7206, 7207, 7208, 0, 0, 0, 0, 0, 'Darrowshire Poltergeist - Talk');
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `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
(1129602, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7209, 7210, 7211, 7212, 0, 0, 0, 0, 0, 'Darrowshire Poltergeist - Talk');
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Remove Duplicate Object
DELETE FROM `gameobject` WHERE `guid` = 12043;
-- End of migration.
END IF;
END??
delimiter ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;