Files
moonwell-core-vanilla/sql/migrations/20220624163458_world.sql
2023-02-20 01:22:12 +02:00

166 lines
18 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`='20220624163458');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20220624163458');
-- Add your query below.
-- Misc
UPDATE `gameobject_template` SET `faction` = 14 WHERE `entry` IN (180249, 180250, 180401);
UPDATE `gameobject_template` SET `faction` = 114 WHERE `entry` IN (180402, 180404);
UPDATE `creature_template` SET `script_name`='' WHERE `entry` IN (14875, 15069, 15080);
UPDATE `creature` SET `spawn_flags` = 1 WHERE `guid` IN (391, 385, 723, 436);
UPDATE `quest_template` SET `CompleteScript` = 8183 WHERE `entry` = 8183;
DELETE FROM `script_waypoint` WHERE `entry` = 14875;
UPDATE `broadcast_text` SET `chat_type` = 1 WHERE `entry` = 10612;
-- GameObjects spawned during script.
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `state`, `animprogress`, `spawn_flags`) VALUES
(99908, 180404, 0, -11831.6, 1331.36, 1.85519, 5.74214, 0, 0, -0.267238, 0.963631, -1, -1, 1, 100, 1),
(99909, 180404, 0, -11817.8, 1324.95, 1.47568, 6.05629, 0, 0, -0.113203, 0.993572, -1, -1, 1, 100, 1),
(99910, 180404, 0, -11801.3, 1335.25, 1.33491, 0.261798, 0, 0, 0.130526, 0.991445, -1, -1, 1, 100, 1),
(99911, 180404, 0, -11835.1, 1349.48, 2.13036, 3.01941, 0, 0, 0.998135, 0.0610518, -1, -1, 1, 100, 1),
(99912, 180402, 0, -11818.4, 1344.86, 4.26675, 0, 0, 0, 0, 1, -1, -1, 1, 100, 1),
(99913, 180249, 0, -11818.3, 1345.13, 8.0145, 1.32645, 0, 0, 0.615661, 0.788011, -1, -1, 1, 100, 1),
(99914, 180250, 0, -11818.3, 1345.13, 8.0145, 1.32645, 0, 0, 0.615661, 0.788011, -1, -1, 1, 100, 1),
(99915, 180401, 0, -11818.3, 1345.13, 8.0145, 1.32645, 0, 0, 0.615661, 0.788011, -1, -1, 1, 100, 1),
(99916, 180391, 0, -11866.5, 1299.45, 2.09667, 0.209439, 0, 0, 0.104528, 0.994522, -1, -1, 1, 100, 1),
(99917, 180391, 0, -11800.3, 1233.46, -0.576672, 3.6652, 0, 0, -0.965925, 0.258821, -1, -1, 1, 100, 1),
(99918, 180391, 0, -11866.7, 1233.16, 3.90082, 2.11185, 0, 0, 0.870356, 0.492424, -1, -1, 1, 100, 1),
(99919, 180391, 0, -14474.6, 456.099, 30.455, 2.61799, 0, 0, 0.965925, 0.258821, -1, -1, 1, 100, 1),
(99920, 180391, 0, -14456.5, 419.375, 25.0717, 3.56047, 0, 0, -0.978148, 0.207912, -1, -1, 1, 100, 1),
(99921, 180391, 0, -14452.6, 468.902, 15.2266, 4.55531, 0, 0, -0.760406, 0.649449, -1, -1, 1, 100, 1),
(100001, 180391, 0, -14445.8, 492.904, 37.0182, 4.76475, 0, 0, -0.688354, 0.725374, -1, -1, 1, 100, 1),
(100002, 180391, 0, -14436, 440.761, 15.9439, 4.06662, 0, 0, -0.894934, 0.446199, -1, -1, 1, 100, 1),
(100003, 180391, 0, -14428, 521.74, 4.98022, 3.22886, 0, 0, -0.999048, 0.0436193, -1, -1, 1, 100, 1),
(100004, 180391, 0, -14390.2, 415.434, 22.7543, 1.0472, 0, 0, 0.5, 0.866025, -1, -1, 1, 100, 1),
(100005, 180391, 0, -14358.1, 377.618, 23.4272, 2.53072, 0, 0, 0.953716, 0.300708, -1, -1, 1, 100, 1),
(100006, 180391, 0, -14320.2, 443.482, 22.934, 4.69494, 0, 0, -0.71325, 0.70091, -1, -1, 1, 100, 1),
(100007, 180391, 0, -14298.3, 526.593, 8.76179, 0.820303, 0, 0, 0.398748, 0.91706, -1, -1, 1, 100, 1),
(100008, 180391, 0, -11800.3, 1299.85, -0.53611, 4.11898, 0, 0, -0.882947, 0.469473, -1, -1, 1, 100, 1);
-- Generic script for Creature Servant of the Hand
DELETE FROM `generic_scripts` WHERE `id`=1508001;
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
(1508001, 0, 15, 17321, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Spirit Spawn-in'),
(1508001, 17, 15, 24217, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Heart of Hakkar, Ritual Cast Visual'),
(1508001, 49, 15, 24221, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Teleport Spawn-out');
-- Generic script for Creature Servant of the Hand
DELETE FROM `generic_scripts` WHERE `id`=1508002;
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
(1508002, 0, 15, 17321, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Spirit Spawn-in'),
(1508002, 17, 15, 24217, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Heart of Hakkar, Ritual Cast Visual'),
(1508002, 48, 15, 24221, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Teleport Spawn-out');
-- Generic script for Creature Servant of the Hand
DELETE FROM `generic_scripts` WHERE `id`=1508003;
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
(1508003, 0, 15, 17321, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Spirit Spawn-in'),
(1508003, 17, 15, 24217, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Heart of Hakkar, Ritual Cast Visual'),
(1508003, 49, 15, 24221, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Teleport Spawn-out');
-- Generic script for Creature Servant of the Hand
DELETE FROM `generic_scripts` WHERE `id`=1508004;
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
(1508004, 0, 15, 17321, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Spirit Spawn-in'),
(1508004, 17, 15, 24217, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Heart of Hakkar, Ritual Cast Visual'),
(1508004, 48, 15, 24221, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Servant of the Hand - Cast Spell Quest - Teleport Spawn-out');
-- Main script
DELETE FROM `quest_end_scripts` WHERE `id`=8183;
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
(8183, 0, 0, 4, 147, 3, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Remove Npc Flags'),
(8183, 0, 0, 4, 147, 1, 2, 0, 385, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand - Remove Npc Flags'),
(8183, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Emote'),
(8183, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10473, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Say Text'),
(8183, 0, 0, 4, 147, 1, 2, 0, 723, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand - Remove Npc Flags'),
(8183, 2, 0, 3, 0, 2445, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11823.4, 1250.01, 2.62618, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 4, 0, 9, 99909, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Servant of the Hand Summoning Circle'),
(8183, 4, 0, 9, 99908, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Servant of the Hand Summoning Circle'),
(8183, 4, 0, 9, 99911, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Servant of the Hand Summoning Circle'),
(8183, 4, 0, 9, 99910, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Servant of the Hand Summoning Circle'),
(8183, 4, 0, 3, 0, 2393, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11828.4, 1260.1, 1.75118, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 5, 0, 3, 0, 3797, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11836.6, 1280.52, 1.88022, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 7, 0, 3, 0, 2554, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11837.8, 1291.05, 1.39231, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 8, 0, 10, 15080, 60000, 0, 0, 0, 0, 0, 0, 2, 1508004, -1, 1, -11831.7, 1331.29, 1.93852, 0.942478, 0, 'The Heart of Hakkar: Summon Creature Servant of the Hand'),
(8183, 8, 0, 10, 15080, 60000, 0, 0, 0, 0, 0, 0, 2, 1508003, -1, 1, -11817.9, 1325.02, 1.55901, 1.51844, 0, 'The Heart of Hakkar: Summon Creature Servant of the Hand'),
(8183, 8, 0, 10, 15080, 60000, 0, 0, 0, 0, 0, 0, 2, 1508002, -1, 1, -11801.4, 1335.38, 1.36269, 2.61799, 0, 'The Heart of Hakkar: Summon Creature Servant of the Hand'),
(8183, 8, 0, 10, 15080, 60000, 0, 0, 0, 0, 0, 0, 2, 1508001, -1, 1, -11835.2, 1349.36, 2.11011, 6.05629, 0, 'The Heart of Hakkar: Summon Creature Servant of the Hand'),
(8183, 9, 0, 3, 0, 2768, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11833.9, 1301.87, 0.84901, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 11, 0, 3, 0, 4010, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11825.8, 1323.78, 0.491301, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 17, 0, 15, 24214, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Cast Spell Heart of Hakkar - Molthor chucks the heart'),
(8183, 20, 0, 10, 15069, 28000, 0, 0, 0, 0, 0, 0, 2, 0, -1, 1, -11818.3, 1345.13, 8.0145, 1.32645, 0, 'The Heart of Hakkar: Summon Creature Heart of Hakkar'),
(8183, 20, 0, 9, 99912, 26, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Object'),
(8183, 21, 0, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.25664, 0, 'The Heart of Hakkar: Molthor - Set Orientation'),
(8183, 21, 0, 1, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Emote OneShotShot'),
(8183, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10474, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Say Text'),
(8183, 25, 0, 28, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Set Stand State to UNIT_STAND_STATE_KNEEL'),
(8183, 26, 0, 9, 99915, 31, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Portal Sound'),
(8183, 26, 0, 9, 99913, 31, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Air Rift'),
(8183, 26, 0, 9, 99914, 31, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Fire Rift'),
(8183, 26, 0, 15, 24202, 0, 0, 0, 15069, 30, 8, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar - Cast Spell Create Heart of Hakkar Rift'),
(8183, 26, 0, 15, 24203, 0, 0, 0, 15069, 30, 8, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar - Cast Spell Heart of Hakkar Banning'),
(8183, 42, 0, 10, 15073, 8000, 0, 0, 0, 0, 0, 0, 2, 0, -1, 1, -11818.3, 1345.13, 8.09784, 1.32645, 0, 'The Heart of Hakkar: Summon Creature Pat\'s Hellfire Guy'),
(8183, 42, 0, 15, 24215, 0, 0, 0, 15069, 30, 8, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar - Cast Spell Create Heart of Hakkar Explosion'),
(8183, 45, 0, 15, 24207, 0, 0, 0, 15073, 30, 8, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Pat\'s Hellfire Guy - Cast Spell Hellfire Cast Visual'),
(8183, 45, 0, 15, 24204, 0, 0, 0, 15069, 30, 8, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar - Cast Spell Heart of Hakkar Implode'),
(8183, 45, 0, 16, 7059, 2, 0, 0, 15069, 30, 8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar - Play Sound AvatarofHakkarDeath'),
(8183, 46, 0, 4, 147, 1, 1, 0, 723, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand - Add Npc Flags'),
(8183, 46, 0, 4, 147, 1, 1, 0, 385, 0, 9, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand - Add Npc Flags'),
(8183, 49, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10537, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Say Text'),
(8183, 49, 0, 1, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Emote OneShotShot'),
(8183, 49, 0, 0, 0, 0, 0, 0, 436, 0, 9, 2, 10612, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Zandalarian Emissary - Say Text'),
(8183, 50, 0, 9, 99921, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 99920, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100008, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100005, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100006, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100007, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100003, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100002, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100004, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 100001, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 99917, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 99916, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 99918, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 50, 0, 9, 99919, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Respawn GameObject Heart of Hakkar Spell Emitter'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100003, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100004, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100006, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100007, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100008, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100002, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100001, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 99920, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 99919, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 99918, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 99917, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 99916, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 51, 0, 15, 24425, 0, 0, 0, 100005, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Heart of Hakkar Spell Emitter - Cast Spell'),
(8183, 53, 80, 80, 2, 0, 0, 0, 99911, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand Summoning Circle - Set Go State to GO_STATE_ACTIVE_ALTERNATIVE'),
(8183, 53, 80, 80, 2, 0, 0, 0, 99910, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand Summoning Circle - Set Go State to GO_STATE_ACTIVE_ALTERNATIVE'),
(8183, 53, 80, 80, 2, 0, 0, 0, 99909, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand Summoning Circle - Set Go State to GO_STATE_ACTIVE_ALTERNATIVE'),
(8183, 53, 80, 80, 2, 0, 0, 0, 99908, 0, 12, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Servant of the Hand Summoning Circle - Set Go State to GO_STATE_ACTIVE_ALTERNATIVE'),
(8183, 54, 0, 3, 0, 3060, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11834.3, 1301.17, 0.815517, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 55, 0, 28, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Set Stand State to UNIT_STAND_STATE_STAND'),
(8183, 57, 0, 3, 0, 2028, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11838.1, 1289.74, 1.58054, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 58, 0, 3, 0, 3967, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11829.8, 1264.85, 1.62618, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 62, 0, 3, 0, 3061, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11818.5, 1249.37, 2.59151, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 65, 0, 3, 0, 1790, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11812.3, 1260.91, 5.99856, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 66, 0, 3, 0, 1163, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, -11812.3, 1260.91, 5.99856, 0, 0, 'The Heart of Hakkar: Molthor - Move'),
(8183, 68, 0, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.27606, 0, 'The Heart of Hakkar: Molthor - Set Orientation'),
(8183, 70, 0, 4, 147, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Heart of Hakkar: Molthor - Add Npc Flags');
-- End of migration.
END IF;
END??
delimiter ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;