aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-06-23 15:10:39 +0200
committerGitHub <noreply@github.com>2016-06-23 15:10:39 +0200
commitf1aecaddd353c00dea2e4a61ab2b5187e9e43237 (patch)
tree3ccaf45880b153c6654050c3b82a2ebce42b7a08
parentef835b70d80af4a1a2c24abf06464a42935a318b (diff)
DB/Creature: Spawn Una Wildmane
updates #16655
-rw-r--r--sql/updates/world/6.x/2016_06_23_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_06_23_00_world.sql b/sql/updates/world/6.x/2016_06_23_00_world.sql
new file mode 100644
index 00000000000..42f23376051
--- /dev/null
+++ b/sql/updates/world/6.x/2016_06_23_00_world.sql
@@ -0,0 +1,5 @@
+--
+SET @CGUID := 250016;
+DELETE FROM creature WHERE `guid` = @CGUID;
+INSERT INTO creature (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID, 37024, 1, 0, 0, 1, 0, 0, 0, 0, -798.2708, -486.757, -32.19226, 1.623156, 120, 0, 0, 0, 0, 0, 0, 0, 0, 15354);