From 126c8aac67a34fec0eabb4e0b4f5bf653642759c Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 14 Oct 2021 13:10:50 +0200 Subject: DB/Creature: Training Dummy closes #27062 by osleyder85 --- sql/updates/world/master/2021_10_14_03_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/master/2021_10_14_03_world.sql (limited to 'sql/updates/world') diff --git a/sql/updates/world/master/2021_10_14_03_world.sql b/sql/updates/world/master/2021_10_14_03_world.sql new file mode 100644 index 00000000000..866329a39a9 --- /dev/null +++ b/sql/updates/world/master/2021_10_14_03_world.sql @@ -0,0 +1,17 @@ +-- Training Dummy (Area: Sunstrider Isle - Difficulty: 0) +UPDATE `creature_template` SET `minlevel`=20, `maxlevel`=20, `VerifiedBuild`=40120 WHERE `entry`=44937; + +UPDATE `creature_template_model` SET `VerifiedBuild`=40120 WHERE `CreatureID`=44937 AND `Idx`=0; + +UPDATE `creature_model_info` SET `VerifiedBuild`=40120 WHERE `DisplayID`=3019; + +UPDATE `creature` SET `zoneId`=6455, `areaId`=3431, `spawntimesecs`=120, `curhealth`=1244, `VerifiedBuild`=40120 WHERE `guid` IN (250887,250888,250889,250890,250891,250892); + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN 250887 AND 250892; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES +(250887, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Training Dummy +(250888, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Training Dummy +(250889, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Training Dummy +(250890, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Training Dummy +(250891, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Training Dummy +(250892, 0, 0, 0, 1, 0, 0, 0, 0, ''); -- Training Dummy -- cgit v1.2.3