diff options
| author | ModoX <moardox@gmail.com> | 2022-02-07 22:49:21 +0100 |
|---|---|---|
| committer | ModoX <moardox@gmail.com> | 2022-02-07 22:49:21 +0100 |
| commit | 42428a08986d7e6dc41a2c3c9ac9b78929cd8bd0 (patch) | |
| tree | 6bae45b7490aa7c993ed1bfe1849855e797cf002 | |
| parent | 66509502f4a5065d74cb3da501558f7eff6ea1ec (diff) | |
DB/Spawns: Added accidently deleted spawn of Captain Garrick
* was deleted in https://github.com/TrinityCore/TrinityCore/commit/c4fedd10ab2f5dba3eed57bdba0d6c46c67614a2
* originally added in https://github.com/TrinityCore/TrinityCore/commit/53429375c7dfee2e8e0bda09a7dba66c67d787f3
| -rw-r--r-- | sql/updates/world/master/2022_02_07_03_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_07_03_world.sql b/sql/updates/world/master/2022_02_07_03_world.sql new file mode 100644 index 00000000000..55ec138552f --- /dev/null +++ b/sql/updates/world/master/2022_02_07_03_world.sql @@ -0,0 +1,5 @@ +-- +SET @CGUID := 1050589; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+1; +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`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 156280, 2261, 10424, 10639, '0', 14350, 0, 0, 0, 37.83321762084960937, -1.40558588504791259, 12.40759944915771484, 3.31911778450012207, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 41079); -- Captain Garrick (Area: -Unknown- - Difficulty: 0) |