diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2021-10-14 13:08:38 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-14 13:08:38 +0200 |
| commit | 0e197eef58a1375e5a3ed9b99ac743f3d6e8e681 (patch) | |
| tree | 3853a2290f86e5c6f0293871e1d83c37280d90d6 | |
| parent | cd9d2b0e9b29879dbb57602887a14028d5c58996 (diff) | |
DB/Creature: Arcanist Ithanas
closes #27060 by osleyder85
| -rw-r--r-- | sql/updates/world/master/2021_10_14_01_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_14_01_world.sql b/sql/updates/world/master/2021_10_14_01_world.sql new file mode 100644 index 00000000000..e14e34ecef7 --- /dev/null +++ b/sql/updates/world/master/2021_10_14_01_world.sql @@ -0,0 +1,12 @@ +-- Arcanist Ithanas (Area: Sunstrider Isle - Difficulty: 0) +UPDATE `creature_template` SET `minlevel`=20, `maxlevel`=20, `RangeAttackTime`=0, `VerifiedBuild`=40120 WHERE `entry`=15296; + +UPDATE `creature_template_model` SET `VerifiedBuild`=40120 WHERE `CreatureID`=15296 AND `Idx`=0; + +UPDATE `creature_model_info` SET `VerifiedBuild`=40120 WHERE `DisplayID`=15532; + +UPDATE `creature` SET `zoneId`=6455, `areaId`=3431, `spawntimesecs`=120, `curhealth`=522, `curmana`=1202, `VerifiedBuild`=40120 WHERE `guid`=55054; + +DELETE FROM `creature_addon` WHERE `guid`=55054; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES +(55054, 0, 0, 0, 1, 0, 0, 0, 0, ''); -- Arcanist Ithanas |