aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-02-10 18:15:05 +0200
committeroffl <offl@users.noreply.github.com>2021-02-10 18:15:05 +0200
commitfde8ee1398007c0ec1f409b96d0a26c31b235f6c (patch)
tree10485605cf8ec2bb9404c4c6c9bac16ff5094bae
parentc91c3cb09f6288ba66949a544b81d64099ead3e1 (diff)
DB/Loot: Conditions for Unfired Plate Gauntlets
Closes #26059
-rw-r--r--sql/updates/world/3.3.5/2021_02_10_01_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_02_10_01_world.sql b/sql/updates/world/3.3.5/2021_02_10_01_world.sql
new file mode 100644
index 00000000000..4dd12bfdb1e
--- /dev/null
+++ b/sql/updates/world/3.3.5/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;