From 3ff5c50db469203d70af368922e1dccde98b10ba Mon Sep 17 00:00:00 2001 From: offl Date: Wed, 10 Feb 2021 18:15:05 +0200 Subject: DB/Loot: Conditions for Unfired Plate Gauntlets Closes #26059 (cherry picked from commit fde8ee1398007c0ec1f409b96d0a26c31b235f6c) --- .../world/master/2022_03_06_43_world_2021_02_10_01_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2022_03_06_43_world_2021_02_10_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2022_03_06_43_world_2021_02_10_01_world.sql b/sql/updates/world/master/2022_03_06_43_world_2021_02_10_01_world.sql new file mode 100644 index 00000000000..4dd12bfdb1e --- /dev/null +++ b/sql/updates/world/master/2022_03_06_43_world_2021_02_10_01_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 4 AND `SourceGroup` = 13574 AND `SourceEntry` = 12812; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(4,13574,12812,0,0,7,0,164,275,0,0,0,0,"","Group 0: Item 'Unfired Plate Gauntlets' can be looted if player does have Blacksmithing with skill level 275"); + +UPDATE `gameobject_loot_template` SET `QuestRequired` = 0 WHERE `Item` = 12812 AND `Reference` = 0; -- cgit v1.2.3