From 738baf110ed38d3f2a9faaff6a2215e8cf34b4df Mon Sep 17 00:00:00 2001 From: offl Date: Thu, 2 Jul 2020 23:22:21 +0200 Subject: DB/SAI: Update target types in recently added areatrigger scripts to avoid use of unstable guid target types Closes #24853 --- sql/updates/world/3.3.5/2020_07_01_03_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_07_01_03_world.sql diff --git a/sql/updates/world/3.3.5/2020_07_01_03_world.sql b/sql/updates/world/3.3.5/2020_07_01_03_world.sql new file mode 100644 index 00000000000..f2647802191 --- /dev/null +++ b/sql/updates/world/3.3.5/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; -- cgit v1.2.3