aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-12-21 19:06:32 +0100
committerjoschiwald <joschiwald.trinity@gmail.com>2018-04-21 18:46:14 +0200
commita4ab3a7d443b4bb4d2c66661427f8730677c3ce2 (patch)
tree3b1fbe26b1a52e2f479b117155525fa32508b53b
parent1ceb6eca6d37374479cf9ac1018545792235b067 (diff)
DB: Fix some DB errors
Updates #18542 (cherry picked from commit 5b8b779a5cbf68f8b670ea20550ac5fd0656bef8)
-rw-r--r--sql/updates/world/master/2018_04_21_03_world_2016_12_21_00_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_04_21_03_world_2016_12_21_00_world.sql b/sql/updates/world/master/2018_04_21_03_world_2016_12_21_00_world.sql
new file mode 100644
index 00000000000..06759ffd58b
--- /dev/null
+++ b/sql/updates/world/master/2018_04_21_03_world_2016_12_21_00_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`IN (13,17) AND `SourceEntry`=30218;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(17, 0, 30218, 0, 0, 31, 1, 3, 17274, 0, 0, 0, 0, '', 'Fireball only target Temper''s Target');
+
+DELETE FROM `gameobject_addon` WHERE `guid`=30031;