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