diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2021-10-14 13:07:35 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-14 13:07:35 +0200 |
| commit | cd9d2b0e9b29879dbb57602887a14028d5c58996 (patch) | |
| tree | 10922f340b4d2f912bfdc6398e31ecb7fb6d3f99 | |
| parent | f5460b424aae0f7fd438230b6659971828a3d205 (diff) | |
DB/Creature: Magistrix Erona
closes #27058 by osleyder85
| -rw-r--r-- | sql/updates/world/master/2021_10_14_00_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_14_00_world.sql b/sql/updates/world/master/2021_10_14_00_world.sql new file mode 100644 index 00000000000..10ac60b8ae0 --- /dev/null +++ b/sql/updates/world/master/2021_10_14_00_world.sql @@ -0,0 +1,16 @@ +-- Magistrix Erona (Area: Sunstrider Isle - Difficulty: 0) +UPDATE `creature_template` SET `minlevel`=20, `maxlevel`=20, `RangeAttackTime`=0, `VerifiedBuild`=40120 WHERE `entry`=15278; + +UPDATE `creature_template_model` SET `VerifiedBuild`=40120 WHERE `CreatureID`=15278 AND `Idx`=0; + +UPDATE `creature_model_info` SET `VerifiedBuild`=40120 WHERE `DisplayID`=15516; + +UPDATE `creature` SET `zoneId`=6455, `areaId`=3431, `spawntimesecs`=120, `curhealth`=522, `curmana`=1202, `VerifiedBuild`=40120 WHERE `guid`=54984; + +DELETE FROM `creature_addon` WHERE `guid`=54984; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES +(54984, 0, 0, 0, 1, 0, 0, 0, 0, ''); + +UPDATE `gossip_menu` SET `VerifiedBuild`=40120 WHERE (`MenuId`=11902 AND `TextId`=16703); + +UPDATE `npc_text` SET `VerifiedBuild`=40120 WHERE `ID`=16703; |