aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2018_10_11_03_world_335.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_11_03_world_335.sql b/sql/updates/world/3.3.5/2018_10_11_03_world_335.sql
new file mode 100644
index 00000000000..9870822485d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_11_03_world_335.sql
@@ -0,0 +1,5 @@
+--
+UPDATE `creature_template` SET `npcflag`=128 WHERE `entry`=2683;
+DELETE FROM `creature` WHERE `guid` IN (87022);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
+(87022, 2683, 0, 1, 1, 0, 1, -4923.421, 725.513, 253.102, 0.000000, 300);