aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-10-11 16:41:42 +0200
committerKillyana <morphone1@gmail.com>2018-10-11 16:41:42 +0200
commit60add3df21e96fba2f87d42e2756d5de4f5f1f5b (patch)
treee67692ffa73f3e0939e02af4999ba574ad85e439
parente2bfbf2e5183bb04846c3439d925d644b2638a08 (diff)
DB/Creature: Namdo Bizzfizzle
-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);