aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-02-10 18:15:05 +0200
committerShauren <shauren.trinity@gmail.com>2022-03-06 20:49:34 +0100
commit3ff5c50db469203d70af368922e1dccde98b10ba (patch)
tree0ed917fafbd7acd02275894324b8d6a070f65fad
parent4929bf6d933f8e37a6472b377bfb85130ddb5915 (diff)
DB/Loot: Conditions for Unfired Plate Gauntlets
Closes #26059 (cherry picked from commit fde8ee1398007c0ec1f409b96d0a26c31b235f6c)
-rw-r--r--sql/updates/world/master/2022_03_06_43_world_2021_02_10_01_world.sql6
1 files changed, 6 insertions, 0 deletions
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;