Files
moonwell-core-vanilla/sql/migrations/20250721160556_world.sql

301 lines
22 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`='20250721160556');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250721160556');
-- Add your query below.
-- Minor Manifestation of Water
UPDATE `creature_template` SET `auras` = '8203', `movement_type` = 2 WHERE `entry` = 5895;
DELETE FROM `creature_movement_template` WHERE `entry` = 5895;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
(5895, 1, 417.04, 1822.66, 12.61, 1.483, 300000, 0, 0, 0),
(5895, 2, 417.04, 1822.66, 12.61, 1.483, 0, 0, 589500, 0),
(5895, 3, 421.879, 1840.35, 12.0528, 100, 0, 0, 0, 0),
(5895, 4, 431.016, 1847.81, 11.6124, 100, 0, 0, 0, 0),
(5895, 5, 454.363, 1883.92, 5.44203, 100, 0, 0, 0, 0),
(5895, 6, 459.398, 1923.79, -10.2403, 100, 1000, 0, 4, 0);
DELETE FROM `creature_movement_scripts` WHERE `id` = 589500;
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
(589500, 0, 0, 4, 147, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Minor Manifestation of Water - Modify Flags');
-- Corrupt Water Spirit
UPDATE `creature` SET `spawntimesecsmin` = 450, `spawntimesecsmax` = 450 WHERE `id` = 5897;
-- Water Spirit
UPDATE `creature_template` SET `faction` = 35, `auras` = '8203', `ai_name` = 'EventAI' WHERE `entry` = 6748;
DELETE FROM `creature_ai_events` WHERE `creature_id`=6748;
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
(674801, 6748, 0, 1, 0, 100, 1, 0, 1000, 1000, 1000, 674801, 0, 0, 'Water Spirit - Set Orientation - OOC');
DELETE FROM `creature_ai_scripts` WHERE `id`=674801;
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
(674801, 0, 0, 35, 0, 0, 0, 0, 20, 0, 25, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Water Spirit - Set Orientation');
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `id5`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(10997, 6748, 0, 0, 0, 0, 0, 392.31, 1847.33, 12.36, 6.068, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(10998, 6748, 0, 0, 0, 0, 0, 439.28, 1837.3, 12.42, 2.934, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(10999, 6748, 0, 0, 0, 0, 0, 431.41, 1849.24, 11.39, 3.516, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11001, 6748, 0, 0, 0, 0, 0, 404.85, 1863.62, 11.2, 5.135, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11002, 6748, 0, 0, 0, 0, 0, 418.96, 1854.28, 10.97, 4.339, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11003, 6748, 0, 0, 0, 0, 0, 393.13, 1860.64, 11.22, 5.577, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11004, 6748, 0, 0, 0, 0, 0, 405.81, 1843.58, 12.54, 6.161, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11005, 6748, 0, 0, 0, 0, 0, 400.15, 1827.5, 10.46, 0.813, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11006, 6748, 0, 0, 0, 0, 0, 424.45, 1818.22, 10.46, 1.964, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11007, 6748, 0, 0, 0, 0, 0, 424.75, 1840.46, 12.25, 2.945, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11008, 6748, 0, 0, 0, 0, 0, 413.2, 1831.29, 10.46, 1.468, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10),
(11009, 6748, 0, 0, 0, 0, 0, 434.02, 1862.14, 10.89, 3.925, 10, 10, 0, 100, 100, 2, 2, 0, 0, 10);
DELETE FROM `creature_movement` WHERE `id` IN (10997, 10998, 10999, 11001, 11002, 11003, 11004, 11005, 11006, 11007, 11008, 11009);
INSERT INTO `creature_movement` (`id`, `path_id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(10997, 0, 1, 392.31, 1847.33, 12.36, 6.068, 300000, 0),
(10997, 0, 2, 392.31, 1847.33, 12.36, 6.068, 3000, 0),
(10997, 0, 3, 406.45312, 1853.0293, 11.4607525, 100, 0, 0),
(10997, 0, 4, 426.0931, 1853.4049, 11.238218, 100, 0, 0),
(10997, 0, 5, 439.47028, 1859.5836, 10.419017, 100, 0, 0),
(10997, 0, 6, 452.2871, 1873.2698, 8.482309, 100, 0, 0),
(10997, 0, 7, 469.80817, 1890.7695, 1.4991376, 100, 1000, 674800),
(10998, 0, 1, 439.28, 1837.30, 12.42, 2.934, 300000, 0),
(10998, 0, 2, 439.28, 1837.30, 12.42, 2.934, 5000, 0),
(10998, 0, 3, 439.02524, 1844.5131, 11.919017, 100, 0, 0),
(10998, 0, 4, 439.42584, 1860.4017, 10.526927, 100, 0, 0),
(10998, 0, 5, 443.2843, 1880.2444, 5.9984226, 100, 0, 0),
(10998, 0, 6, 442.6797, 1877.0859, 6.942026, 100, 1000, 674800),
(10999, 0, 1, 431.41, 1849.24, 11.39, 3.516, 300000, 0),
(10999, 0, 2, 431.41, 1849.24, 11.39, 3.516, 5000, 0),
(10999, 0, 3, 438.10107, 1862.1263, 10.4462385, 100, 0, 0),
(10999, 0, 4, 445.3859, 1866.9548, 9.960947, 100, 0, 0),
(10999, 0, 5, 449.72852, 1879.206, 6.567026, 100, 0, 0),
(10999, 0, 6, 446.74728, 1892.3281, 1.0941257, 100, 0, 0),
(10999, 0, 7, 443.83682, 1903.1873, -5.6569366, 100, 1000, 674800),
(11001, 0, 1, 404.85, 1863.62, 11.20, 5.135, 300000, 0),
(11001, 0, 2, 404.85, 1863.62, 11.20, 5.135, 500, 0),
(11001, 0, 3, 410.91525, 1860.8453, 10.843443, 100, 0, 0),
(11001, 0, 4, 427.12457, 1856.0109, 10.926939, 100, 0, 0),
(11001, 0, 5, 437.1794, 1860.1814, 10.519969, 100, 0, 0),
(11001, 0, 6, 457.08438, 1888.1526, 4.269785, 100, 0, 0),
(11001, 0, 7, 464.85547, 1909.8047, -5.720413, 100, 1000, 674800),
(11002, 0, 1, 418.96, 1854.28, 10.97, 4.339, 300000, 0),
(11002, 0, 2, 418.96, 1854.28, 10.97, 4.339, 3000, 0),
(11002, 0, 3, 430.84006, 1853.1951, 11.028135, 100, 0, 0),
(11002, 0, 4, 437.45844, 1860.4113, 10.4864, 100, 0, 0),
(11002, 0, 5, 444.05286, 1873.4497, 8.562632, 100, 0, 0),
(11002, 0, 6, 448.75015, 1888.2692, 3.3022556, 100, 0, 0),
(11002, 0, 7, 457.16418, 1900.19, -1.3889923, 100, 1000, 674800),
(11003, 0, 1, 393.13, 1860.64, 11.22, 5.577, 300000, 0),
(11003, 0, 2, 393.13, 1860.64, 11.22, 5.577, 5000, 0),
(11003, 0, 3, 407.33914, 1859.3123, 11.392515, 100, 0, 0),
(11003, 0, 4, 429.232, 1856.2153, 10.9607525, 100, 0, 0),
(11003, 0, 5, 443.2384, 1870.1517, 9.710215, 100, 0, 0),
(11003, 0, 6, 463.67264, 1896.4757, 0.32032204, 100, 1000, 674800),
(11004, 0, 1, 405.81, 1843.58, 12.54, 6.161, 300000, 0),
(11004, 0, 2, 405.81, 1843.58, 12.54, 6.161, 10000, 0),
(11004, 0, 3, 425.22348, 1816.2814, 10.487756, 100, 0, 0),
(11004, 0, 4, 430.78104, 1820.6372, 10.487756, 100, 0, 0),
(11004, 0, 5, 439.31754, 1825.1202, 12.664169, 100, 0, 0),
(11004, 0, 6, 441.66635, 1835.1333, 12.419017, 100, 0, 0),
(11004, 0, 7, 444.533, 1842.4141, 12.521068, 100, 0, 0),
(11004, 0, 8, 449.82465, 1849.613, 11.037059, 100, 0, 0),
(11004, 0, 9, 446.33344, 1861.1415, 10.195994, 100, 0, 0),
(11004, 0, 10, 469.31055, 1891.5924, 1.3225019, 100, 1000, 674800),
(11005, 0, 1, 400.15, 1827.50, 10.46, 0.813, 300000, 0),
(11005, 0, 2, 400.15, 1827.50, 10.46, 0.813, 10000, 0),
(11005, 0, 3, 428.5726, 1819.7274, 10.487756, 100, 0, 0),
(11005, 0, 4, 427.20813, 1827.1571, 10.487756, 100, 0, 0),
(11005, 0, 5, 432.24295, 1836.5192, 12.405577, 100, 0, 0),
(11005, 0, 6, 438.77335, 1843.1816, 12.084422, 100, 0, 0),
(11005, 0, 7, 436.4252, 1853.4467, 10.884349, 100, 0, 0),
(11005, 0, 8, 434.67307, 1868.783, 10.27186, 100, 0, 0),
(11005, 0, 9, 439.33084, 1876.4147, 8.145517, 100, 0, 0),
(11005, 0, 10, 444.48453, 1893.4553, 0.009897232, 100, 0, 0),
(11005, 0, 11, 440.0733, 1901.166, -5.9965363, 100, 1000, 674800),
(11006, 0, 1, 424.45, 1818.22, 10.46, 1.964, 300000, 0),
(11006, 0, 2, 424.45, 1818.22, 10.46, 1.964, 11000, 0),
(11006, 0, 3, 428.00943, 1825.4735, 10.487756, 100, 0, 0),
(11006, 0, 4, 425.67725, 1830.5055, 10.480554, 100, 0, 0),
(11006, 0, 5, 428.95306, 1840.714, 12.4607525, 100, 0, 0),
(11006, 0, 6, 436.45667, 1845.7812, 11.806468, 100, 0, 0),
(11006, 0, 7, 437.6485, 1854.5172, 10.588695, 100, 0, 0),
(11006, 0, 8, 449.22168, 1880.1298, 6.3767185, 100, 0, 0),
(11006, 0, 9, 448.36328, 1878.207, 6.817026, 100, 1000, 674800),
(11007, 0, 1, 424.75, 1840.46, 12.25, 2.945, 300000, 0),
(11007, 0, 2, 424.75, 1840.46, 12.25, 2.945, 11000, 0),
(11007, 0, 3, 435.19205, 1825.6515, 12.399033, 100, 0, 0),
(11007, 0, 4, 442.65442, 1836.267, 12.600047, 100, 0, 0),
(11007, 0, 5, 445.90778, 1853.7994, 10.150584, 100, 0, 0),
(11007, 0, 6, 445.82993, 1865.9453, 10.130931, 100, 0, 0),
(11007, 0, 7, 458.66364, 1884.7913, 5.2171726, 100, 0, 0),
(11007, 0, 8, 470.88943, 1897.9523, -1.1516192, 100, 1000, 674800),
(11008, 0, 1, 413.20, 1831.29, 10.46, 1.468, 300000, 0),
(11008, 0, 2, 413.20, 1831.29, 10.46, 1.468, 11000, 0),
(11008, 0, 3, 428.40353, 1829.527, 10.391686, 100, 0, 0),
(11008, 0, 4, 432.89297, 1843.0895, 12.342833, 100, 0, 0),
(11008, 0, 5, 430.71457, 1858.4186, 10.9607525, 100, 0, 0),
(11008, 0, 6, 439.50668, 1870.2897, 9.891489, 100, 0, 0),
(11008, 0, 7, 451.3856, 1891.964, 2.2780857, 100, 0, 0),
(11008, 0, 8, 451.89758, 1899.8502, -1.6959133, 100, 1000, 674800),
(11009, 0, 1, 434.02, 1862.14, 10.89, 3.925, 300000, 0),
(11009, 0, 2, 434.02, 1862.14, 10.89, 3.925, 3000, 0),
(11009, 0, 3, 454.813, 1891.4397, 2.8512058, 100, 1000, 674800);
DELETE FROM `creature_movement_scripts` WHERE `id`= 674800;
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
(674800, 0, 0, 41, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Water Spirit - Remove Creature');
-- Corrupt Minor Manifestation of Water
UPDATE `creature` SET `position_x`= 418.87442, `position_y` = 1831.7448, `position_z` = 10.740808, `orientation` = 1.29154360294342, `movement_type` = 2 WHERE `guid` = 84707;
DELETE FROM `creature_movement_template` WHERE `entry` = 5894;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
(5894, 1, 418.874, 1831.74, 10.7408, 1.29154, 15000, 0, 0, 0),
(5894, 2, 411.101, 1830.18, 10.4878, 100, 0, 0, 0, 0),
(5894, 3, 405.481, 1825.35, 10.4878, 100, 0, 0, 0, 0),
(5894, 4, 405.215, 1819.34, 10.4343, 100, 0, 0, 0, 0),
(5894, 5, 413.839, 1811.1, 10.6594, 100, 0, 0, 0, 0),
(5894, 6, 422.242, 1812.21, 10.6679, 100, 0, 0, 0, 0),
(5894, 7, 426.716, 1816.27, 10.4878, 100, 0, 0, 0, 0),
(5894, 8, 429.111, 1821.22, 10.4878, 100, 0, 0, 0, 0),
(5894, 9, 427.671, 1827.4, 10.4878, 100, 0, 0, 0, 0),
(5894, 10, 420.717, 1832, 10.7591, 100, 1000, 0, 0, 0),
(5894, 11, 418.874, 1831.74, 10.7408, 100, 1000, 0, 0, 0),
(5894, 12, 418.874, 1831.74, 10.7408, 1.29154, 47000, 0, 0, 0),
(5894, 13, 425.767, 1830.2, 10.6121, 100, 0, 0, 0, 0),
(5894, 14, 428.906, 1822.9, 10.4878, 100, 0, 0, 0, 0),
(5894, 15, 426.916, 1815.86, 10.4878, 100, 0, 0, 0, 0),
(5894, 16, 420.529, 1811.66, 11.1522, 100, 0, 0, 0, 0),
(5894, 17, 411.956, 1812.03, 11.1035, 100, 0, 0, 0, 0),
(5894, 18, 405.622, 1817.44, 10.1745, 100, 0, 0, 0, 0),
(5894, 19, 404.275, 1823.17, 10.4878, 100, 0, 0, 0, 0),
(5894, 20, 407.255, 1828.5, 10.4878, 100, 0, 0, 0, 0),
(5894, 21, 412.924, 1831.53, 10.4878, 100, 0, 0, 0, 0),
(5894, 22, 417.869, 1833.24, 10.5609, 100, 0, 0, 0, 0),
(5894, 23, 418.874, 1831.74, 10.7408, 100, 0, 0, 0, 0),
(5894, 24, 418.874, 1831.74, 10.7408, 1.29154, 2000, 0, 0, 0),
(5894, 25, 417.949, 1841.03, 11.7537, 100, 0, 0, 0, 0),
(5894, 26, 412.838, 1840.49, 12.2891, 100, 0, 0, 0, 0),
(5894, 27, 406.217, 1836.33, 12.8358, 100, 0, 0, 0, 0),
(5894, 28, 394.713, 1846.76, 12.2286, 100, 0, 0, 0, 0),
(5894, 29, 399.557, 1860.32, 11.4649, 100, 0, 0, 0, 0),
(5894, 30, 410.529, 1863.6, 10.5587, 100, 0, 0, 0, 0),
(5894, 31, 420.337, 1853.75, 11.2009, 100, 0, 0, 0, 0),
(5894, 32, 429.426, 1847.49, 11.689, 100, 0, 0, 0, 0),
(5894, 33, 440.584, 1847.81, 11.27, 100, 0, 0, 0, 0),
(5894, 34, 443.787, 1843, 12.2899, 100, 0, 0, 0, 0),
(5894, 35, 440.005, 1835.25, 12.419, 100, 0, 0, 0, 0),
(5894, 36, 433.309, 1829.94, 12.1319, 100, 0, 0, 0, 0),
(5894, 37, 428.294, 1837.99, 12.4147, 100, 0, 0, 0, 0),
(5894, 38, 421.721, 1840.7, 12.1011, 100, 0, 0, 0, 0),
(5894, 39, 418.874, 1831.74, 10.7408, 100, 0, 0, 0, 0),
(5894, 40, 418.874, 1831.74, 10.7408, 1.29154, 25000, 0, 0, 0);
-- Quest 100 Start Script
DELETE FROM `quest_start_scripts` WHERE `id` = 100;
INSERT INTO `quest_start_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
(100, 0, 0, 31, 5895, 20, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Terminate Script'),
(100, 0, 1, 39, 100, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Start Script');
DELETE FROM `generic_scripts` WHERE `id` = 100;
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
(100, 0, 1, 68, 5897, 2, 5897, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Corrupt Water Spirit - Start Script For All'),
(100, 1, 0, 9, 15176, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Gameobject'),
(100, 12, 0, 9, 15175, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Gameobject'),
(100, 15, 0, 10, 5895, 360000, 0, 0, 0, 0, 0, 0, 4, 0, -1, 1, 417.04, 1822.66, 12.61, 1.483, 0, 'Call of Water: Summon Minor Manifestation of Water'),
(100, 19, 1, 91, 10997, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 19, 1, 91, 10998, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 19, 1, 91, 10999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 20, 1, 91, 11001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 20, 1, 91, 11002, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 22, 1, 91, 11003, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 22, 1, 91, 11004, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 22, 1, 91, 11005, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 24, 1, 91, 11006, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 24, 1, 91, 11007, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 25, 1, 91, 11008, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit'),
(100, 25, 1, 91, 11009, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Respawn Water Spirit');
-- Quest 96 Start Script
UPDATE `quest_template` SET `StartScript` = 96 WHERE `entry` = 96;
DELETE FROM `quest_start_scripts` WHERE `id` = 96;
INSERT INTO `quest_start_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
(96, 12, 0, 60, 2, 2, 0, 0, 0, 0, 0, 0, 0, 5895, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Minor Manifestation of Water -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11006, 0, 11, 2, 11006, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11008, 0, 11, 2, 11008, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 10997, 0, 11, 2, 10997, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 10998, 0, 11, 2, 10998, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 10999, 0, 11, 2, 10999, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11001, 0, 11, 2, 11001, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11002, 0, 11, 2, 11002, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11003, 0, 11, 2, 11003, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11004, 0, 11, 2, 11004, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11005, 0, 11, 2, 11005, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11009, 0, 11, 2, 11009, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints'),
(96, 13, 0, 60, 1, 2, 0, 0, 11007, 0, 11, 2, 11007, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Water Spirit -Start Waypoints');
-- Quest 1103 End Script
UPDATE `quest_template` SET `PrevQuestId` = 220 WHERE `entry` = 972;
UPDATE `quest_template` SET `PrevQuestId` = 63 WHERE `entry` = 1103;
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`, `conditionId`, `inverseEffectMask`, `build_min`, `build_max`) VALUES
(9735, 0, 101750, 0, 0, 0, 5875);
DELETE FROM `quest_end_scripts` WHERE `id`=1103;
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
(1103, 0, 0, 28, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Set Standstate'),
(1103, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3069, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Talk'),
(1103, 3, 0, 60, 3, 0, 0, 0, 0, 0, 0, 0, 0, 7007, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Start Waypoints');
DELETE FROM `creature_movement_special` WHERE `id` = 7007;
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
(7007, 1, 431.493, 1869.76, 10.9623, 100, 6000, 0, 700700, 0),
(7007, 2, 433.69, 1865.99, 10.5627, 100, 0, 0, 0, 0),
(7007, 3, 435.59, 1863.4, 10.6, 100, 0, 0, 0, 0),
(7007, 4, 419.184, 1849.87, 11.6537, 100, 0, 0, 0, 0),
(7007, 5, 419.108, 1845.34, 11.9373, 100, 15000, 0, 700701, 0),
(7007, 6, 418.881, 1834.54, 10.5858, 100, 0, 0, 0, 0),
(7007, 7, 416.736, 1827.01, 11.6469, 100, 16000, 0, 700702, 0),
(7007, 8, 424.093, 1833.23, 9.8055, 100, 0, 0, 0, 0),
(7007, 9, 435.794, 1853.76, 10.9224, 100, 0, 0, 0, 0),
(7007, 10, 434.792, 1868.7, 10.2297, 100, 0, 0, 0, 0),
(7007, 11, 430.836, 1880.7, 15.1794, 100, 0, 0, 0, 0),
(7007, 12, 430.385, 1881.86, 15.4235, 100, 0, 0, 0, 0),
(7007, 13, 430.385, 1881.86, 15.4235, 5.131, 4000, 0, 700703, 0);
DELETE FROM `creature_movement_scripts` WHERE `id`=700700;
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
(700700, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3070, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Talk'),
(700700, 3, 0, 35, 0, 0, 0, 0, 10, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Set Orientation'),
(700700, 3, 1, 15, 9735, 0, 0, 0, 10, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Cast Spell');
DELETE FROM `creature_movement_scripts` WHERE `id`=700701;
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
(700701, 0, 0, 35, 0, 0, 0, 0, 10, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Set Orientation'),
(700701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3071, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Talk'),
(700701, 2, 0, 1, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Emote'),
(700701, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3072, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Talk'),
(700701, 6, 0, 39, 100, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Start Script');
DELETE FROM `creature_movement_scripts` WHERE `id`=700702;
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
(700702, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3073, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Talk');
DELETE FROM `creature_movement_scripts` WHERE `id`=700703;
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
(700703, 0, 0, 28, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Call of Water: Tiev Mordune - Set Standstate');
-- Misc
UPDATE `quest_template` SET `OfferRewardText` = 'The wind approaches you quickly from the horizon; the earth is steady beneath your feet; and your spirit is already warmed by fire--I would say it is time for you to learn about the purity of water.$B$BYour path has led you this far, and your spirit will give you the strength to carry on even further. But the first step is yours to take.' WHERE `entry` = 2986;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
(3066, 2986),
(3173, 2985);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;