diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_01_12_11_world.sql | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_01_12_11_world.sql b/sql/updates/world/3.3.5/2019_01_12_11_world.sql new file mode 100644 index 00000000000..b02f30f6716 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_01_12_11_world.sql @@ -0,0 +1,42 @@ +-- Wrath Speaker +DELETE FROM `creature` WHERE `guid` IN (77846, 77847, 77848, 77849); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(77846, 22195, 530, 1, 1, 0, 0, 2809.144, 7028.737, 370.1192, 5.2640550, 300, 10, 0, 5744, 3155, 1), +(77847, 22195, 530, 1, 1, 0, 0, 2951.050, 7042.642, 368.8290, 0.6083948, 300, 0, 0, 5744, 3155, 2), +(77848, 22195, 530, 1, 1, 0, 0, 2967.950, 6890.847, 370.4887, 4.6027830, 300, 0, 0, 5744, 3155, 2), +(77849, 22195, 530, 1, 1, 0, 0, 3005.345, 6799.072, 373.6648, 1.4287640, 300, 0, 0, 5744, 3155, 2); + +DELETE FROM `creature_addon` WHERE `guid` IN (77846, 77847, 77848, 77849); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(77846, 0, 0, 0, 0, ""), +(77847, 778470, 0, 0, 0, ""), +(77848, 778480, 0, 0, 0, ""), +(77849, 778490, 0, 0, 0, ""); + +DELETE FROM `waypoint_data` WHERE `id` IN (778470,778480,778490); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`, `action_chance`) VALUES +(778470, 1, 2975.211, 7059.475, 367.0825, 0, 0, 100), +(778470, 2, 2988.456, 7052.621, 369.1406, 0, 0, 100), +(778470, 3, 2970.003, 7061.874, 369.9319, 0, 0, 100), +(778470, 4, 2959.972, 7082.811, 368.6384, 0, 0, 100), +(778470, 5, 2959.031, 7090.068, 364.4005, 0, 0, 100), +(778470, 6, 2937.706, 7083.439, 363.8671, 0, 0, 100), +(778470, 7, 2943.229, 7070.313, 370.5299, 0, 0, 100), +(778470, 8, 2945.689, 7043.885, 368.4086, 0, 0, 100), +(778470, 9, 2939.260, 7034.117, 367.3447, 0, 0, 100), +(778480, 1, 2965.214, 6865.952, 370.0455, 0, 0, 100), +(778480, 2, 2961.003, 6840.708, 370.1313, 0, 0, 100), +(778480, 3, 2964.531, 6820.890, 369.2407, 0, 0, 100), +(778480, 4, 2962.245, 6799.692, 366.7432, 0, 0, 100), +(778480, 5, 2964.531, 6820.890, 369.2407, 0, 0, 100), +(778480, 6, 2961.003, 6840.708, 370.1313, 0, 0, 100), +(778480, 7, 2965.214, 6865.952, 370.0455, 0, 0, 100), +(778480, 8, 2968.895, 6893.699, 370.4094, 0, 0, 100), +(778490, 1, 3010.420, 6834.429, 369.9110, 0, 0, 100), +(778490, 2, 3009.010, 6869.215, 370.3058, 0, 0, 100), +(778490, 3, 3019.349, 6882.292, 370.7339, 0, 0, 100), +(778490, 4, 3012.913, 6898.837, 369.5817, 0, 0, 100), +(778490, 5, 3019.349, 6882.292, 370.7339, 0, 0, 100), +(778490, 6, 3009.010, 6869.215, 370.3058, 0, 0, 100), +(778490, 7, 3010.420, 6834.429, 369.9110, 0, 0, 100), +(778490, 8, 3006.181, 6800.649, 373.9317, 0, 0, 100); |