aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2020_08_21_05_world_335.sql27
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_08_21_05_world_335.sql b/sql/updates/world/3.3.5/2020_08_21_05_world_335.sql
new file mode 100644
index 00000000000..1a20316476b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_21_05_world_335.sql
@@ -0,0 +1,27 @@
+--
+UPDATE `creature_model_info` SET `DisplayID_Other_Gender` = 0 WHERE `DisplayID` = 2582;
+UPDATE `creature_equip_template` SET `ItemID1` = 4560, `VerifiedBuild` = 0 WHERE `CreatureID` = 14221 AND `ID` = 1;
+UPDATE `creature` SET `position_x` = 717.6572, `position_y` = -846.4034, `position_z` = 160.7536, `orientation` = 3.351032 WHERE `id` = 14221;
+DELETE FROM `waypoint_data` WHERE `id` = 867560;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES
+(867560,1,710.176,-847.23,158.978,0,0),
+(867560,2,700.134,-853.063,158.516,0,0),
+(867560,3,684.42,-847.68,158.498,0,0),
+(867560,4,666.937,-858.739,158.498,0,0),
+(867560,5,663.885,-866.644,158.499,0,0),
+(867560,6,662.637,-879.389,158.291,0,0),
+(867560,7,659.842,-884.845,158.617,0,0),
+(867560,8,666.729,-899.79,164.624,0,0),
+(867560,9,669.022,-904.201,164.414,0,0),
+(867560,10,667.229,-921.961,164.414,0,0),
+(867560,11,666.778,-939.546,164.85,0,0),
+(867560,12,673.587,-950.274,164.35,0,0),
+(867560,13,684.347,-959.261,164.35,0,0),
+(867560,14,698.708,-966.321,164.653,0,0),
+(867560,15,708.321,-976.576,165.562,0,30000),
+(867560,16,700.121,-957.096,164.68,0,0),
+(867560,17,715.224,-933.369,164.344,0,0),
+(867560,18,716.543,-899.917,166.366,0,0),
+(867560,19,715.204,-866.595,161.66,0,0),
+(867560,20,717.657,-846.403,160.754,0,0),
+(867560,21,717.657,-846.403,160.754,3.35103,30000);