diff options
| author | notwonderful <ratatatata322@gmail.com> | 2025-09-20 12:09:57 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2025-09-20 12:10:04 +0200 |
| commit | 70a1d6ce7d1589fe2154b93ef8fef120aeac5e27 (patch) | |
| tree | 3e34e1e09414a4ef37fba58fb5272fbd809ee2ae | |
| parent | 4f6bc26f03cfb3125d6a44125c1bdc9ba75c0996 (diff) | |
DB/Valdrakken: Added graveyard
Closes #31289
| -rw-r--r-- | sql/updates/world/master/2025_09_20_01_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_09_20_01_world.sql b/sql/updates/world/master/2025_09_20_01_world.sql new file mode 100644 index 00000000000..1a5a38e6736 --- /dev/null +++ b/sql/updates/world/master/2025_09_20_01_world.sql @@ -0,0 +1,17 @@ +SET @CGUID := 10006842; + +SET @GGUID := 100098; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+0; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 6491, 2444, 13862, 0, '0', 0, 0, 0, 0, -104.864593505859375, -1202.48095703125, 847.81988525390625, 1.305020809173583984, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 63163); -- Spirit Healer (Area: 0 - Difficulty: 0) CreateObject1 (Auras: 9036 - Ghost, 10848 - Shroud of Death) + +-- Graveyard +DELETE FROM `graveyard_zone` WHERE `ID` BETWEEN @GGUID+0 AND @GGUID+0; +INSERT INTO `graveyard_zone` (`ID`, `GhostZone`, `Comment`) VALUES +(@GGUID+0, 13862, 'Valdrakken - The Emerald Enclave'); + +DELETE FROM `world_safe_locs` WHERE `ID` BETWEEN @GGUID+0 AND @GGUID+0; +INSERT INTO `world_safe_locs` (`ID`, `MapID`, `LocX`, `LocY`, `LocZ`, `Facing`, `Comment`) VALUES +(@GGUID+0, 2444, -103.73, -1198.4, 847.713, 4.4217214, 'Valdrakken - The Emerald Enclave - GY'); |