diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2014-06-28 03:34:47 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2014-06-28 03:34:47 +0200 |
| commit | 5ffce750df90cd715627a2daf80e8a106b0316ab (patch) | |
| tree | 2ef6e4008367fa296042a667ff828c069f3c03eb /sql | |
| parent | 745833ccbc09660209ec2c48db3d020c07ff22c2 (diff) | |
DB/Misc: Missing Graveyard in Zone 44
Closes #9724
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_06_28_00_world_misc.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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) |