diff options
| -rw-r--r-- | sql/updates/world/master/2021_09_26_14_world_2018_05_13_00_world_335.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_09_26_14_world_2018_05_13_00_world_335.sql b/sql/updates/world/master/2021_09_26_14_world_2018_05_13_00_world_335.sql new file mode 100644 index 00000000000..8dd102b657f --- /dev/null +++ b/sql/updates/world/master/2021_09_26_14_world_2018_05_13_00_world_335.sql @@ -0,0 +1,35 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (48255, 75558,88485, 103543,106482, 106483,106486, 106487,107837, 142693,142694, 142695,142696, 142697,142710, 143230,143231, 143232,143263, 143264,143268, 143269,143271, 143272,143273, 143697,143700, 143705,143708, 143713,143715, 143921,144009, 144094,144785, 144789,144792, 144794,144796, 203124); +DELETE FROM `creature_addon` WHERE `guid` IN (48255, 75558,88485, 103543,106482, 106483,106486, 106487,107837, 142693,142694, 142695,142696, 142697,142710, 143230,143231, 143232,143263, 143264,143268, 143269,143271, 143272,143273, 143697,143700, 143705,143708, 143713,143715, 143921,144009, 144094,144785, 144789,144792, 144794,144796, 203124); +DELETE FROM `creature` WHERE `id`=31401 AND `guid` IN (111931, 111932, 111933, 111934, 111935); + +DELETE FROM `waypoint_data` WHERE `id`=1325600; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1325600, 25, -4210.05, 3036.03, 359.272, 0, 0, 1, 0, 100, 0), +(1325600, 24, -4197.81, 3024.34, 366.188, 0, 0, 1, 0, 100, 0), +(1325600, 23, -4166.6, 3015.78, 353.327, 0, 0, 1, 0, 100, 0), +(1325600, 22, -4119.36, 3000.52, 350.383, 0, 0, 1, 0, 100, 0), +(1325600, 21, -4078.06, 3004.44, 346.771, 0, 0, 1, 0, 100, 0), +(1325600, 20, -4047.5, 3033.21, 346.827, 0, 0, 1, 0, 100, 0), +(1325600, 19, -4037.82, 3075.94, 350.938, 0, 0, 1, 0, 100, 0), +(1325600, 18, -4037.22, 3122.49, 345.133, 0, 0, 1, 0, 100, 0), +(1325600, 17, -4020.08, 3150.26, 329.883, 0, 0, 1, 0, 100, 0), +(1325600, 16, -3983.11, 3172.78, 330.133, 0, 0, 1, 0, 100, 0), +(1325600, 15, -3945.8, 3163.18, 338.493, 0, 0, 1, 0, 100, 0), +(1325600, 14, -3906.74, 3138.08, 347.049, 0, 0, 1, 0, 100, 0), +(1325600, 13, -3872.96, 3116.54, 357.438, 0, 0, 1, 0, 100, 0), +(1325600, 12, -3857.7, 3086.13, 367.605, 0, 0, 1, 0, 100, 0), +(1325600, 11, -3866.05, 3043.05, 372.104, 0, 0, 1, 0, 100, 0), +(1325600, 10, -3902.36, 3025, 374.716, 0, 0, 1, 0, 100, 0), +(1325600, 9, -3939.95, 3047.44, 368.138, 0, 0, 1, 0, 100, 0), +(1325600, 8, -3976.81, 3075.32, 357.966, 0, 0, 1, 0, 100, 0), +(1325600, 7, -4015.78, 3101.06, 352.327, 0, 0, 1, 0, 100, 0), +(1325600, 6, -4057.3, 3120.64, 344.022, 0, 0, 1, 0, 100, 0), +(1325600, 5, -4093.99, 3151.9, 340.022, 0, 0, 1, 0, 100, 0), +(1325600, 4, -4133.58, 3148.63, 338.077, 0, 0, 1, 0, 100, 0), +(1325600, 3, -4161.6, 3113.01, 348.633, 0, 0, 1, 0, 100, 0), +(1325600, 2, -4193.34, 3081.12, 359.272, 0, 0, 1, 0, 100, 0), +(1325600, 1, -4214.1, 3060.08, 359.272, 0, 0, 1, 0, 100, 0); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-143921) AND `source_type`=0; +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `SpawnId` IN (48255,106482,106483,106486,106487,107837,111931,111932,111933,111934,111935,142710); |