aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-02-14 18:34:42 +0100
committerShauren <shauren.trinity@gmail.com>2021-06-21 00:06:41 +0200
commitc4bdaaede6b44e0732572ef81546d63be06dbcc4 (patch)
tree84c5c7f07bdbc8bcd0ec6bbe07a52dc968c861f5 /sql
parente9ddf644b0c9075e637089601d70eb8adcf5654a (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 (cherry picked from commit 3135aaea9d6ef268d769e2a51d78c8d62bc692dd)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_06_20_10_world_2018_02_14_08_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_20_10_world_2018_02_14_08_world.sql b/sql/updates/world/master/2021_06_20_10_world_2018_02_14_08_world.sql
new file mode 100644
index 00000000000..f5d3bf5b3ab
--- /dev/null
+++ b/sql/updates/world/master/2021_06_20_10_world_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;