From d7de84b0277699fa12776864906e393f414aee08 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 6 Nov 2017 18:55:02 +0100 Subject: DB/Creature: Fix levels for multiple creatures By Malcrom --- sql/updates/world/3.3.5/2017_11_06_01_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_11_06_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_11_06_01_world.sql b/sql/updates/world/3.3.5/2017_11_06_01_world.sql new file mode 100644 index 00000000000..66090b1158b --- /dev/null +++ b/sql/updates/world/3.3.5/2017_11_06_01_world.sql @@ -0,0 +1,13 @@ +-- Auchenai Crypts +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry` IN (20299); -- Auchenai Monk (1) +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20315); -- Raging Skeleton (1) +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20300); -- Auchenai Necromancer (1) + +-- Shadow Labyrinth +UPDATE `creature_template` SET `exp`=0 WHERE `entry` IN (18797); -- Tortured Skeleton +UPDATE `creature_template` SET `minlevel`=70,`maxlevel`=71 WHERE `entry` IN (20641); -- Cabal Deathsworn (1) +UPDATE `creature_template` SET `maxlevel`=70 WHERE `entry` IN (20638); -- Cabal Acolyte (1) +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry` IN (20645); -- Cabal Ritualist (1) + +-- Fix Stats error +UPDATE `creature_classlevelstats` SET `basehp0`=3635 WHERE `level`=66 AND `class` IN (1,4); -- cgit v1.2.3