From 5ffce750df90cd715627a2daf80e8a106b0316ab Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 28 Jun 2014 03:34:47 +0200 Subject: DB/Misc: Missing Graveyard in Zone 44 Closes #9724 --- sql/updates/world/2014_06_28_00_world_misc.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2014_06_28_00_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_06_28_00_world_misc.sql b/sql/updates/world/2014_06_28_00_world_misc.sql new file mode 100644 index 00000000000..a960642b8fb --- /dev/null +++ b/sql/updates/world/2014_06_28_00_world_misc.sql @@ -0,0 +1,7 @@ +-- +SET @CGUID:= 43496; +DELETE FROM `game_graveyard_zone` WHERE `id`=2; +INSERT INTO `game_graveyard_zone` (`id`, `ghost_zone`, `faction`) VALUES (2, 44, 469); + +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`) VALUES +(@CGUID, 6491, 0, 1, 1, -9190.865, -2308.829, 89.63705, 4.13643, 120, 0, 0); -- 6491 (Area: 44) -- cgit v1.2.3