diff options
| author | mdX7 <mdX7@users.noreply.github.com> | 2021-01-29 18:11:00 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-06 18:26:33 +0100 |
| commit | b7e332fa9b11e570d1861a973b8108f9eb52f0be (patch) | |
| tree | 27d5123d000da9b3c6e4de4b79c40a9885361ca8 | |
| parent | 6d70762840b1affeda95aee93ccc58a27ca87567 (diff) | |
DB/Creature: Add missing spirit healer
Closes #25955
(cherry picked from commit acb3999bb8bc289461e9fccad04e3e4a6fd2fddb)
| -rw-r--r-- | sql/updates/world/master/2022_03_06_12_world_2021_01_29_04_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_06_12_world_2021_01_29_04_world.sql b/sql/updates/world/master/2022_03_06_12_world_2021_01_29_04_world.sql new file mode 100644 index 00000000000..457ac40809c --- /dev/null +++ b/sql/updates/world/master/2022_03_06_12_world_2021_01_29_04_world.sql @@ -0,0 +1,6 @@ +-- +-- ALTER TABLE `creature` MODIFY `VerifiedBuild` int(11) DEFAULT '0'; + +DELETE FROM `creature` WHERE `guid` = 43740 AND `id` = 6491; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES +(43740, 6491, 571, '0', 0, 0, 0, 2002.7415771484375, 5938.0986328125, 37.18986129760742187, 5.934119224548339843, 300, 0, 0, 37176); |