diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-28 15:18:14 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-06 19:20:15 +0100 |
| commit | 561781a475fe203b9106773f446feb3d9f7a7a2a (patch) | |
| tree | 8a59758ec93fa253aa33d308b9786d82451c0f92 | |
| parent | 378aac374dcceb58fdf2d82cdaa5f4b4dcaf7713 (diff) | |
DB/SAI: Fix targets for group quests
Closes #24706
(cherry picked from commit 77ae76852bbdf27dea37cf386787060db4b31a0b)
| -rw-r--r-- | sql/updates/world/master/2022_01_06_31_world_2020_05_28_01_world.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_06_31_world_2020_05_28_01_world.sql b/sql/updates/world/master/2022_01_06_31_world_2020_05_28_01_world.sql new file mode 100644 index 00000000000..180d7a3dd74 --- /dev/null +++ b/sql/updates/world/master/2022_01_06_31_world_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); |