aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-05-21 21:32:43 +0200
committerKillyana <morphone1@gmail.com>2019-05-21 21:32:43 +0200
commit8b6d2ecaac71e09db8ff233f7635c5f18674d05a (patch)
tree6b6a367f9a3da53be74bf536094a804c7984cc07
parent94c331a427f9af84f9f69c66f1353dc391c271de (diff)
DB/Creature: Event Generator Old Hillsbrad
-rw-r--r--sql/updates/world/3.3.5/2019_05_21_04_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_05_21_04_world.sql b/sql/updates/world/3.3.5/2019_05_21_04_world.sql
new file mode 100644
index 00000000000..08703b2f69f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_05_21_04_world.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (105360,105429) AND `id`=20391;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(105360, 20391, 560, 0, 0, 3, 1, 0, 0, 1736.54, 1073.2, 6.96295, 2.18166, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(105429, 20391, 560, 0, 0, 3, 1, 0, 0, 1815.18, 1035.5, 11.1722, 3.94444, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0);