diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_09_01_world.sql | 132 |
1 files changed, 132 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_09_01_world.sql b/sql/updates/world/3.3.5/2019_07_09_01_world.sql new file mode 100644 index 00000000000..a5bbcf280c9 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_07_09_01_world.sql @@ -0,0 +1,132 @@ +-- +DELETE FROM `creature_addon` WHERE `guid`=66689; +UPDATE `creature_template_addon` SET `path_id`=185270 WHERE `entry`=18527; +UPDATE `creature` SET `position_x`=9503.076, `position_y`=-7266.791, `position_z`=14.35056, `orientation`=2.990923 WHERE `guid`=66689; + +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=18527; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18527 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 1852700 AND 1852705 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`, `event_param5`, `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 +(18527, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 60000, 160000, 0, 88, 1852700, 1852705, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Conjurer Tyren - OOC - Call Random Actionlist"), +(1852700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 12051, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Conjurer Tyren - On Script - Cast Spell 'Evocation'"), +(1852701, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 11544, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Conjurer Tyren - On Script - Cast Spell 'Yellow Rose Firework'"), +(1852702, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 32475, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Conjurer Tyren - On Script - Cast Spell 'Hellfire Visual (DND)'"), +(1852703, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 11542, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Conjurer Tyren - On Script - Cast Spell 'Red Streaks Firework'"), +(1852704, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 30161, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Conjurer Tyren - On Script - Cast Spell 'Purple Firework'"), +(1852705, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 11540, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Conjurer Tyren - On Script - Cast Spell 'Blue Firework'"); + +DELETE FROM `waypoint_data` WHERE `id`=666890; +DELETE FROM `waypoint_data` WHERE `id`=185270; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(185270, 1, 9525.83, -7264.368, 14.29412, 0), +(185270, 2, 9555.74, -7264.021, 14.24792, 0), +(185270, 3, 9565.372, -7262.795, 14.27687, 0), +(185270, 4, 9571.793, -7261.719, 14.30366, 0), +(185270, 5, 9579.403, -7262.639, 14.27172, 0), +(185270, 6, 9583.036, -7263.716, 14.238, 0), +(185270, 7, 9593.344, -7264.484, 14.2086, 0), +(185270, 8, 9601.985, -7267.124, 13.86666, 0), +(185270, 9, 9607.529, -7267.409, 13.86902, 0), +(185270, 10, 9622.397, -7267.357, 13.86774, 0), +(185270, 11, 9634.858, -7267.739, 13.87062, 0), +(185270, 12, 9646.49, -7267.261, 13.86557, 0), +(185270, 13, 9653.177, -7264.745, 14.20316, 0), +(185270, 14, 9659.288, -7260.724, 14.25711, 0), +(185270, 15, 9661.345, -7260.638, 14.24835, 160000), +(185270, 16, 9664.87, -7253.128, 14.26376, 0), +(185270, 17, 9667.089, -7247.808, 14.2601, 0), +(185270, 18, 9671.11, -7242.395, 13.93584, 0), +(185270, 19, 9674.306, -7237.416, 13.96349, 0), +(185270, 20, 9673.825, -7233.556, 14.20105, 0), +(185270, 21, 9671.942, -7231.321, 14.30227, 0), +(185270, 22, 9669.491, -7231.277, 14.3052, 0), +(185270, 23, 9665.034, -7231.147, 14.30523, 0), +(185270, 24, 9660.11, -7230.576, 14.63309, 0), +(185270, 25, 9657.628, -7229.685, 14.94244, 0), +(185270, 26, 9655.798, -7227.885, 15.28191, 0), +(185270, 27, 9655.33, -7225.428, 15.62823, 0), +(185270, 28, 9655.853, -7221.955, 15.63705, 0), +(185270, 29, 9662.243, -7216.792, 14.30528, 0), +(185270, 30, 9666.57, -7216.749, 14.30529, 0), +(185270, 31, 9671.489, -7216.527, 14.3053, 0), +(185270, 32, 9674.929, -7213.607, 14.30419, 0), +(185270, 33, 9676.145, -7209.757, 13.98104, 0), +(185270, 34, 9674.326, -7203.975, 13.96977, 0), +(185270, 35, 9669.352, -7201.253, 14.31973, 0), +(185270, 36, 9663.998, -7200.293, 14.32058, 0), +(185270, 37, 9664.278, -7198.672, 14.3207, 160000), +(185270, 38, 9655.878, -7192.329, 14.32253, 0), +(185270, 39, 9648.602, -7190.215, 14.32354, 0), +(185270, 40, 9641.105, -7187.674, 14.32352, 0), +(185270, 41, 9633.334, -7184.746, 14.31826, 0), +(185270, 42, 9626.474, -7182.906, 14.31192, 0), +(185270, 43, 9621.006, -7182.036, 14.30669, 0), +(185270, 44, 9614.548, -7181.054, 14.29494, 0), +(185270, 45, 9605.972, -7177.758, 14.28037, 0), +(185270, 46, 9601.303, -7174.567, 14.27075, 0), +(185270, 47, 9596.593, -7167.143, 14.26718, 0), +(185270, 48, 9592.958, -7161.62, 14.2672, 0), +(185270, 49, 9588.81, -7154.42, 14.26773, 0), +(185270, 50, 9584.6, -7148.086, 14.25677, 0), +(185270, 51, 9580.141, -7142.188, 14.25466, 0), +(185270, 52, 9577.233, -7135.599, 14.25943, 0), +(185270, 53, 9579.829, -7136.315, 14.26142, 160000), +(185270, 54, 9582.844, -7125.709, 14.33732, 0), +(185270, 55, 9586.646, -7121.539, 14.37463, 0), +(185270, 56, 9591.073, -7119.295, 14.39802, 0), +(185270, 57, 9600.336, -7115.224, 14.45064, 0), +(185270, 58, 9606.748, -7113.093, 14.44458, 0), +(185270, 59, 9617.806, -7110.341, 14.38485, 0), +(185270, 60, 9624.748, -7106.712, 14.36993, 0), +(185270, 61, 9630.475, -7102.962, 14.36568, 0), +(185270, 62, 9637.075, -7099.869, 14.34035, 0), +(185270, 63, 9640.724, -7099.007, 14.31583, 0), +(185270, 64, 9647.447, -7098.322, 14.27178, 0), +(185270, 65, 9654.606, -7098.396, 14.31958, 0), +(185270, 66, 9661.563, -7101.602, 14.32034, 0), +(185270, 67, 9664.166, -7107.86, 14.3234, 0), +(185270, 68, 9664.803, -7115.409, 14.32384, 0), +(185270, 69, 9670.005, -7120.562, 14.32511, 0), +(185270, 70, 9672.925, -7119.867, 14.325, 160000), +(185270, 71, 9683.609, -7114.696, 14.32453, 0), +(185270, 72, 9689.89, -7121.827, 14.32379, 0), +(185270, 73, 9692.474, -7125.519, 14.32378, 0), +(185270, 74, 9697.283, -7133.035, 14.32398, 0), +(185270, 75, 9701.83, -7143.789, 13.92369, 0), +(185270, 76, 9704.126, -7157.538, 13.91884, 0), +(185270, 77, 9701.934, -7170.944, 13.91428, 0), +(185270, 78, 9697.442, -7175.639, 13.91493, 0), +(185270, 79, 9693.155, -7178.723, 13.91556, 0), +(185270, 80, 9688.754, -7184.653, 13.93028, 0), +(185270, 81, 9684.507, -7193.309, 13.94777, 0), +(185270, 82, 9680.572, -7202.682, 13.96665, 0), +(185270, 83, 9675.43, -7212.983, 14.30399, 0), +(185270, 84, 9673.156, -7215.233, 14.3048, 0), +(185270, 85, 9668.141, -7216.213, 14.30531, 0), +(185270, 86, 9663.368, -7216.781, 14.30528, 0), +(185270, 87, 9656.968, -7217.948, 14.96112, 0), +(185270, 88, 9655.109, -7219.812, 15.62181, 0), +(185270, 89, 9655.357, -7224.03, 15.63319, 0), +(185270, 90, 9659.113, -7231.174, 14.63404, 0), +(185270, 91, 9668.264, -7231.758, 14.30523, 0), +(185270, 92, 9674.341, -7233.996, 14.21699, 0), +(185270, 93, 9677.061, -7237.09, 14.04281, 0), +(185270, 94, 9682.192, -7242.183, 14.00031, 0), +(185270, 95, 9688.502, -7246.363, 14.25585, 0), +(185270, 96, 9687.255, -7247.573, 14.27575, 160000), +(185270, 97, 9689.044, -7255.803, 14.26559, 0), +(185270, 98, 9689.769, -7260.857, 14.26465, 0), +(185270, 99, 9688.377, -7266.877, 14.29548, 0), +(185270, 100, 9686.974, -7272.359, 14.343, 0), +(185270, 101, 9681.692, -7277.843, 14.08473, 0), +(185270, 102, 9672.991, -7282.88, 14.05452, 0), +(185270, 103, 9659.612, -7282.505, 14.01126, 0), +(185270, 104, 9647.426, -7282.733, 14.01161, 0), +(185270, 105, 9623.108, -7282.724, 14.00799, 0), +(185270, 106, 9577.864, -7282.284, 14.00856, 0), +(185270, 107, 9533.067, -7282.263, 14.01119, 0), +(185270, 108, 9524.143, -7278.108, 13.97925, 0), +(185270, 109, 9520.332, -7274.874, 13.9996, 0), +(185270, 110, 9516.705, -7271.591, 14.01897, 0), +(185270, 111, 9509.566, -7267.776, 14.34473, 0), +(185270, 112, 9503.076, -7266.791, 14.35056, 160000); |