aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2018_10_11_04_world_335.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_11_04_world_335.sql b/sql/updates/world/3.3.5/2018_10_11_04_world_335.sql
new file mode 100644
index 00000000000..9510bec1fbc
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_11_04_world_335.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (87023);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
+(87023, 3509, 0, 1, 1, 0, 0, -8838.52, 670.28, 98.0987, 0.553153, 300);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=84028 AND `memberGUID`=87023;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(84028, 87023, 3, 120, 515);