aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-03-09 14:06:51 +0100
committerKillyana <morphone1@gmail.com>2018-03-09 14:06:51 +0100
commit2f04591dae5aad85ca1074bc3a7d88baa20f7c7c (patch)
treee98af10f1713f7a51cc54ddba0a30f7669a702e1
parent4d84ae2736c793807e650dc0c5cdc5158ed6d454 (diff)
DB/Condition: Fix conditions for spells used by Sjonnir The Ironshaper to summon npcs
-rw-r--r--sql/updates/world/3.3.5/2018_03_09_00_world.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_03_09_00_world.sql b/sql/updates/world/3.3.5/2018_03_09_00_world.sql
new file mode 100644
index 00000000000..254201d45d0
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_03_09_00_world.sql
@@ -0,0 +1,15 @@
+--
+DELETE FROM `conditions` WHERE `SourceEntry` IN (50790,50791,50802,50803,50825,50826) AND `SourceTypeOrReferenceId`=13;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13, 1, 50790, 0, 0, 31, 0, 3, 22515, 0, 0, 0, 0, "", ""),
+(13, 1, 50791, 0, 0, 31, 0, 3, 22515, 0, 0, 0, 0, "", ""),
+(13, 2, 50790, 0, 0, 31, 0, 5, 192163, 0, 0, 0, 0, "", ""),
+(13, 2, 50791, 0, 0, 31, 0, 5, 192164, 0, 0, 0, 0, "", ""),
+(13, 1, 50802, 0, 0, 31, 0, 3, 22515, 0, 0, 0, 0, "", ""),
+(13, 1, 50803, 0, 0, 31, 0, 3, 22515, 0, 0, 0, 0, "", ""),
+(13, 2, 50802, 0, 0, 31, 0, 5, 192163, 0, 0, 0, 0, "", ""),
+(13, 2, 50803, 0, 0, 31, 0, 5, 192164, 0, 0, 0, 0, "", ""),
+(13, 1, 50825, 0, 0, 31, 0, 3, 22515, 0, 0, 0, 0, "", ""),
+(13, 1, 50826, 0, 0, 31, 0, 3, 22515, 0, 0, 0, 0, "", ""),
+(13, 2, 50825, 0, 0, 31, 0, 5, 192163, 0, 0, 0, 0, "", ""),
+(13, 2, 50826, 0, 0, 31, 0, 5, 192164, 0, 0, 0, 0, "", "");