aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWyreth <Wyreth@users.noreply.github.com>2017-11-08 19:18:51 +0100
committerKillyana <morphone1@gmail.com>2017-11-08 19:18:51 +0100
commit13b028934232f4d9c8d72f8041c47c897a69edcf (patch)
tree3fd88198c4b176dc524f6a8c696fac5cab6d3866
parentec6e7b618615be16e675d3c081531e5eaddaa89a (diff)
DB/Conditions: Limit usage of item [Gorth's Torch] to correct areas
Closes #20811
-rw-r--r--sql/updates/world/3.3.5/2017_11_08_14_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_08_14_world.sql b/sql/updates/world/3.3.5/2017_11_08_14_world.sql
new file mode 100644
index 00000000000..8ea6f717f34
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_11_08_14_world.sql
@@ -0,0 +1,7 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=43233;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(17, 0, 43233, 0, 0, 29, 0, 24182, 20, 0, 0, 0, 0, "","Spell Burn Structure requires caster to be within 20 yards of creature Winterskorn Dwelling Credit"),
+(17, 0, 43233, 0, 1, 29, 0, 24183, 20, 0, 0, 0, 0, "","Spell Burn Structure requires caster to be within 20 yards of creature Winterskorn Watchtower Credit"),
+(17, 0, 43233, 0, 2, 29, 0, 24184, 20, 0, 0, 0, 0, "","Spell Burn Structure requires caster to be within 20 yards of creature Winterskorn Barracks Credit"),
+(17, 0, 43233, 0, 3, 29, 0, 24185, 20, 0, 0, 0, 0, "","Spell Burn Structure requires caster to be within 20 yards of creature Winterskorn Bridge Credit");