diff options
| author | offl <offl@users.noreply.github.com> | 2020-07-02 23:22:21 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-21 16:18:13 +0100 |
| commit | f036d2e21e5c94248100f72f7c45b256e226833f (patch) | |
| tree | b75bbe5f60b6833fd046df7bcc4c8ba322f3572c | |
| parent | dde859cb21c9f00ffc351efe7df887a56641effb (diff) | |
DB/SAI: Update target types in recently added areatrigger scripts to avoid use of unstable guid target types
Closes #24853
(cherry picked from commit 738baf110ed38d3f2a9faaff6a2215e8cf34b4df)
| -rw-r--r-- | sql/updates/world/master/2022_01_21_03_world_2020_07_01_03_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_21_03_world_2020_07_01_03_world.sql b/sql/updates/world/master/2022_01_21_03_world_2020_07_01_03_world.sql new file mode 100644 index 00000000000..f2647802191 --- /dev/null +++ b/sql/updates/world/master/2022_01_21_03_world_2020_07_01_03_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `smart_scripts` SET `target_type` = 19, `target_param1` = 11152, `target_param2` = 0 WHERE `entryorguid` IN (2246,2248,2250,2252,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637) AND `source_type` = 2 AND `id` = 0; +UPDATE `smart_scripts` SET `target_type` = 19, `target_param1` = 7917, `target_param2` = 0 WHERE `entryorguid` = 1125 AND `source_type` = 2 AND `id` IN (1,2); +UPDATE `smart_scripts` SET `target_type` = 19, `target_param1` = 20242, `target_param2` = 0 WHERE `entryorguid` = 4495 AND `source_type` = 2 AND `id` IN (1,2); +UPDATE `smart_scripts` SET `target_type` = 19, `target_param1` = 19227, `target_param2` = 0 WHERE `entryorguid` = 4389 AND `source_type` = 2 AND `id` IN (1,2); + +UPDATE `smart_scripts` SET `comment` = "Areatrigger (Lower City) - On Trigger - Store Targetlist" WHERE `entryorguid` = 4389 AND `source_type` = 2 AND `id` = 0; +UPDATE `smart_scripts` SET `comment` = "Areatrigger (Lower City) - On Link - Send Target 1 (Griftah)" WHERE `entryorguid` = 4389 AND `source_type` = 2 AND `id` = 1; +UPDATE `smart_scripts` SET `comment` = "Areatrigger (Lower City) - On Link - Set Data 0 1 (Griftah)" WHERE `entryorguid` = 4389 AND `source_type` = 2 AND `id` = 2; |