aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-02-14 18:34:42 +0100
committerKillyana <morphone1@gmail.com>2018-02-14 18:34:42 +0100
commit3135aaea9d6ef268d769e2a51d78c8d62bc692dd (patch)
tree2e4ab58b004b86baa5da22d9e7884ddddcc3f53b
parent4101bc287d5ec51d5991b9158583cf576c4841bf (diff)
DB/SAI: Update SAI that was using threat list target on aggro
target_type 2, 3, 4, 5, 6 musn't be used with the event 4
-rw-r--r--sql/updates/world/3.3.5/2018_02_14_08_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_14_08_world.sql b/sql/updates/world/3.3.5/2018_02_14_08_world.sql
new file mode 100644
index 00000000000..f5d3bf5b3ab
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_02_14_08_world.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `smart_scripts` SET `target_type`=7 WHERE `event_type` IN (4) AND `target_type`=2;
+UPDATE `smart_scripts` SET `target_type`=16 WHERE `event_type` IN (4) AND `target_type`=5;
+UPDATE `smart_scripts` SET `event_type`=0 WHERE `entryorguid`=18701 AND `source_type`=0 AND `id`=1;