diff options
| -rw-r--r-- | sql/updates/world/2014_07_23_01_world_misc.sql | 129 |
1 files changed, 129 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_23_01_world_misc.sql b/sql/updates/world/2014_07_23_01_world_misc.sql new file mode 100644 index 00000000000..35d4a26d30c --- /dev/null +++ b/sql/updates/world/2014_07_23_01_world_misc.sql @@ -0,0 +1,129 @@ +DELETE FROM `waypoints` WHERE `entry`IN(5697,36217); +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(5697, 1, 1660.239, 357.8071, -60.50915, 'Theresa'), +(5697, 2, 1667.285, 351.934, -60.65938, 'Theresa'), +(5697, 3, 1671.285, 349.184, -60.65938, 'Theresa'), +(5697, 4, 1673.035, 347.684, -60.65938, 'Theresa'), +(5697, 5, 1677.349, 344.461, -60.36777, 'Theresa'), +(5697, 6, 1678.349, 343.711, -60.36777, 'Theresa'), +(5697, 7, 1687.099, 337.711, -60.36777, 'Theresa'), +(5697, 8, 1696.237, 335.3875, -60.27203, 'Theresa'), +(5697, 9, 1698.237, 334.8875, -60.27203, 'Theresa'), +(5697, 10, 1698.737, 334.3875, -60.27203, 'Theresa'), +(5697, 11, 1699.125, 334.0252, -60.18984, 'Theresa'), +(5697, 12, 1703.875, 327.2752, -55.18984, 'Theresa'), +(5697, 13, 1707.573, 325.8514, -55.09002, 'Theresa'), +(5697, 14, 1708.073, 326.3514, -55.09002, 'Theresa'), +(5697, 15, 1708.343, 326.3065, -55.10049, 'Theresa'), +(5697, 16, 1713.843, 330.0565, -52.35049, 'Theresa'), +(5697, 17, 1717.343, 332.3065, -49.60049, 'Theresa'), +(5697, 18, 1719.343, 333.5565, -49.10049, 'Theresa'), +(5697, 19, 1720.593, 334.5565, -49.10049, 'Theresa'), +(5697, 20, 1721.343, 335.0565, -48.85049, 'Theresa'), +(5697, 21, 1721.395, 335.242, -49.0298, 'Theresa'), +(5697, 22, 1723.395, 336.742, -49.0298, 'Theresa'), +(5697, 23, 1725.145, 338.242, -49.5298, 'Theresa'), +(5697, 24, 1728.645, 340.742, -52.2798, 'Theresa'), +(5697, 25, 1733.645, 344.992, -55.0298, 'Theresa'), +(5697, 26, 1738.039, 343.7055, -55.17478, 'Theresa'), +(5697, 27, 1738.289, 343.4555, -55.17478, 'Theresa'), +(5697, 28, 1738.487, 343.1309, -55.18909, 'Theresa'), +(5697, 29, 1742.487, 337.6309, -59.43909, 'Theresa'), +(5697, 30, 1742.987, 337.1309, -60.18909, 'Theresa'), +(5697, 31, 1743.298, 336.912, -60.19115, 'Theresa'), +(5697, 32, 1745.298, 335.412, -60.19115, 'Theresa'), +(5697, 33, 1751.572, 336.5025, -60.3616, 'Theresa'), +(5697, 34, 1753.072, 336.7525, -60.3616, 'Theresa'), +(5697, 35, 1755.322, 337.0025, -61.8616, 'Theresa'), +(5697, 36, 1757.322, 337.5025, -61.8616, 'Theresa'), +(5697, 37, 1759.572, 338.5025, -61.8616, 'Theresa'), +(5697, 38, 1759.866, 338.7348, -62.05041, 'Theresa'), +(5697, 39, 1765.366, 341.4848, -62.05041, 'Theresa'), +(5697, 40, 1769.366, 343.7348, -62.05041, 'Theresa'), +(5697, 41, 1778.866, 347.9848, -62.05041, 'Theresa'), +(5697, 42, 1780.616, 350.7348, -62.30041, 'Theresa'), +(5697, 43, 1780.713, 350.9941, -61.98751, 'Theresa'), +(5697, 44, 1784.713, 356.7441, -61.98751, 'Theresa'), +(5697, 45, 1789.213, 363.4941, -59.98751, 'Theresa'), +(5697, 46, 1790.213, 365.2441, -59.98751, 'Theresa'), +(5697, 47, 1791.963, 367.7441, -59.98751, 'Theresa'), +(5697, 48, 1792.291, 372.9213, -59.93742, 'Theresa'), +(5697, 49, 1792.541, 375.4213, -59.93742, 'Theresa'), +(5697, 50, 1792.015, 377.6637, -59.68606, 'Theresa'), +(5697, 51, 1791.515, 378.9137, -59.68606, 'Theresa'), +(5697, 52, 1788.515, 386.6637, -56.93606, 'Theresa'), +(5697, 53, 1786.015, 392.9137, -56.93606, 'Theresa'), +(5697, 54, 1785.422, 394.1371, -56.9608, 'Theresa'), -- Event +(5697, 55, 1785.592, 393.9244, -56.93671, 'Theresa'), +(5697, 56, 1788.842, 387.1744, -56.93671, 'Theresa'), +(5697, 57, 1792.092, 379.1744, -59.68671, 'Theresa'), +(5697, 58, 1792.291, 378.9213, -59.93742, 'Theresa'), +(5697, 59, 1792.541, 378.1713, -59.93742, 'Theresa'), +(5697, 60, 1792.541, 375.4213, -59.93742, 'Theresa'), +(5697, 61, 1792.291, 372.9213, -59.93742, 'Theresa'), +(5697, 62, 1791.963, 367.7441, -59.98751, 'Theresa'), +(5697, 63, 1790.213, 365.2441, -59.98751, 'Theresa'), +(5697, 64, 1789.213, 363.4941, -59.98751, 'Theresa'), +(5697, 65, 1784.713, 356.7441, -61.98751, 'Theresa'), +(5697, 66, 1780.713, 350.9941, -61.98751, 'Theresa'), +(5697, 67, 1780.616, 350.7348, -62.30041, 'Theresa'), +(5697, 68, 1778.866, 347.9848, -62.05041, 'Theresa'), +(5697, 69, 1769.366, 343.7348, -62.05041, 'Theresa'), +(5697, 70, 1765.366, 341.4848, -62.05041, 'Theresa'), +(5697, 71, 1759.866, 338.7348, -62.05041, 'Theresa'), +(5697, 72, 1759.572, 338.5025, -61.8616, 'Theresa'), +(5697, 73, 1757.322, 337.5025, -61.8616, 'Theresa'), +(5697, 74, 1755.322, 337.0025, -61.8616, 'Theresa'), +(5697, 75, 1753.072, 336.7525, -60.3616, 'Theresa'), +(5697, 76, 1751.572, 336.5025, -60.3616, 'Theresa'), +(5697, 77, 1745.298, 335.412, -60.19115, 'Theresa'), +(5697, 78, 1743.298, 336.912, -60.19115, 'Theresa'), +(5697, 79, 1742.987, 337.1309, -60.18909, 'Theresa'), +(5697, 80, 1742.487, 337.6309, -59.43909, 'Theresa'), +(5697, 81, 1738.487, 343.1309, -55.18909, 'Theresa'), +(5697, 82, 1738.289, 343.4555, -55.17478, 'Theresa'), +(5697, 83, 1738.039, 343.7055, -55.17478, 'Theresa'), +(5697, 84, 1733.645, 344.992, -55.0298, 'Theresa'), +(5697, 85, 1728.645, 340.742, -52.2798, 'Theresa'), +(5697, 86, 1725.145, 338.242, -49.5298, 'Theresa'), +(5697, 87, 1723.395, 336.742, -49.0298, 'Theresa'), +(5697, 88, 1721.395, 335.242, -49.0298, 'Theresa'), +(5697, 89, 1721.343, 335.0565, -48.85049, 'Theresa'), +(5697, 90, 1720.593, 334.5565, -49.10049, 'Theresa'), +(5697, 91, 1719.343, 333.5565, -49.10049, 'Theresa'), +(5697, 92, 1717.343, 332.3065, -49.60049, 'Theresa'), +(5697, 93, 1713.843, 330.0565, -52.35049, 'Theresa'), +(5697, 94, 1708.343, 326.3065, -55.10049, 'Theresa'), +(5697, 95, 1708.073, 326.3514, -55.09002, 'Theresa'), +(5697, 96, 1707.573, 325.8514, -55.09002, 'Theresa'), +(5697, 97, 1703.875, 327.2752, -55.18984, 'Theresa'), +(5697, 98, 1699.125, 334.0252, -60.18984, 'Theresa'), +(5697, 99, 1698.737, 334.3875, -60.27203, 'Theresa'), +(5697, 100, 1698.237, 334.8875, -60.27203, 'Theresa'), +(5697, 101, 1696.237, 335.3875, -60.27203, 'Theresa'), +(5697, 102, 1687.099, 337.711, -60.36777, 'Theresa'), +(5697, 103, 1678.349, 343.711, -60.36777, 'Theresa'), +(5697, 104, 1677.349, 344.461, -60.36777, 'Theresa'), +(5697, 105, 1673.035, 347.684, -60.65938, 'Theresa'), +(5697, 106, 1671.285, 349.184, -60.65938, 'Theresa'), +(5697, 107, 1667.285, 351.934, -60.65938, 'Theresa'), +(5697, 108, 1660.239, 357.8071, -60.50915, 'Theresa'), +(5697, 109, 1655.74, 367.394, -60.7665, 'Theresa'), -- end +(36217, 1, 1437.886, 402.0313, -85.00998, 'Overseer Kraggosh'), +(36217, 2, 1436.636, 399.0313, -85.00998, 'Overseer Kraggosh'), +(36217, 3, 1432.636, 396.2813, -85.00998, 'Overseer Kraggosh'), +(36217, 4, 1429.136, 399.2813, -85.00998, 'Overseer Kraggosh'), +(36217, 5, 1438.026, 403.8299, -85.26257, 'Overseer Kraggosh'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=569600 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(569600, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Gerard Abernathy - Script - Say Line 0'), +(569600, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 5, 2, 0, 0, 0, 0, 0, 19, 5697, 0, 0, 0, 0, 0, 0, 'Gerard Abernathy - Play Emote Oneshot Bow on Teresa'), +(569600, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 5697, 0, 0, 0, 0, 0, 0, 'Gerard Abernathy - Script - Set Data Theresa'), +(569600, 9, 3, 0, 0, 0, 100, 0, 20000, 20000, 0, 0, 1, 2, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Gerard Abernathy - Script - Say Line 2'), +(569600, 9, 4, 0, 0, 0, 100, 0, 9000, 9000, 0, 0, 1, 0, 3000, 0, 0, 0, 0, 19, 5699, 0, 0, 0, 0, 0, 0, 'Gerard Abernathy - Script - Say Line 0'), +(569600, 9, 5, 0, 0, 0, 100, 0, 9000, 9000, 0, 0, 1, 3, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Gerard Abernathy - Script - Say Line 3'), +(569600, 9, 6, 0, 0, 0, 100, 0, 9000, 9000, 0, 0, 1, 0, 3000, 0, 0, 0, 0, 19, 5698, 0, 0, 0, 0, 0, 0, 'Gerard Abernathy - Script - Say Line 0'); + +UPDATE `smart_scripts` SET `event_param1`=54 WHERE `entryorguid`=5697 AND `source_type`=0 AND `id`=2 AND `link`=3; +UPDATE `smart_scripts` SET `event_param1`=109 WHERE `entryorguid`=5697 AND `source_type`=0 AND `id`=7 AND `link`=8; |