diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-28 15:18:14 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-05-28 15:18:14 +0200 |
| commit | 77ae76852bbdf27dea37cf386787060db4b31a0b (patch) | |
| tree | 65a19b1c7794b439b9a0fb8cc2ed6a1494f444c5 | |
| parent | fef63de7ffa1c49aa41de434181aaad5ebf0ada5 (diff) | |
DB/SAI: Fix targets for group quests
Closes #24706
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_28_01_world.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_28_01_world.sql b/sql/updates/world/3.3.5/2020_05_28_01_world.sql new file mode 100644 index 00000000000..180d7a3dd74 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_05_28_01_world.sql @@ -0,0 +1,37 @@ +-- +UPDATE `smart_scripts` SET `action_param1` = 1, `target_type` = 16 WHERE `entryorguid` = 356800 AND `source_type` = 9 AND `id` = 0; +UPDATE `smart_scripts` SET `target_type` = 12, `target_param1` = 1 WHERE `entryorguid` = 356801 AND `source_type` = 9 AND `id` = 2; +UPDATE `smart_scripts` SET `target_type` = 12, `target_param1` = 1 WHERE `entryorguid` = 3568 AND `source_type` = 0 AND `id` = 2; +UPDATE `smart_scripts` SET `target_type` = 16 WHERE `entryorguid` = 2028100 AND `source_type` = 9 AND `id` = 3; +UPDATE `smart_scripts` SET `target_type` = 16 WHERE `entryorguid` = 2242400 AND `source_type` = 9 AND `id` = 0; + +UPDATE `smart_scripts` SET `target_type` = 16, `target_param1` = 0 WHERE +(`entryorguid` = 1379 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 2768 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 3692 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 3692 AND `source_type` = 0 AND `id` = 3) OR +(`entryorguid` = 4276 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 4484 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 4880 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 4880 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 5644 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 9020 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 9520 AND `source_type` = 0 AND `id` = 10) OR +(`entryorguid` = 9598 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 11711 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 12858 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 15402 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 17877 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 19671 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 22377 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 25335 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 25729 AND `source_type` = 0 AND `id` = 0) OR +(`entryorguid` = 164954 AND `source_type` = 1 AND `id` = 0) OR +(`entryorguid` = 467 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 2713 AND `source_type` = 0 AND `id` = 6) OR +(`entryorguid` = 6090 AND `source_type` = 0 AND `id` = 6) OR +(`entryorguid` = 6182 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 7774 AND `source_type` = 0 AND `id` = 1) OR +(`entryorguid` = 8284 AND `source_type` = 0 AND `id` = 5) OR +(`entryorguid` = 11016 AND `source_type` = 0 AND `id` = 2) OR +(`entryorguid` = 20763 AND `source_type` = 0 AND `id` = 2); |