From f6d7facebfa505213575ca90668f6bedcf3c000e Mon Sep 17 00:00:00 2001 From: offl Date: Mon, 26 Jul 2021 02:08:42 +0300 Subject: DB/SAI: Prepare SMART_ACTION_WP_START to remove reactState param pt 5 Ref #26728 (cherry picked from commit 8b2ed153dd7663c0f3b860b58c05f37e8ac9fd3e) --- .../world/master/2022_03_11_30_world_2021_07_26_00_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2022_03_11_30_world_2021_07_26_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_03_11_30_world_2021_07_26_00_world.sql b/sql/updates/world/master/2022_03_11_30_world_2021_07_26_00_world.sql new file mode 100644 index 00000000000..db3041dd45f --- /dev/null +++ b/sql/updates/world/master/2022_03_11_30_world_2021_07_26_00_world.sql @@ -0,0 +1,6 @@ +-- Random, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (-129426,-129425,-129424,-129423,-129422,-129421,-129420,-129419,-129418,-114325,-114324,-84616,-84615,-84614,-84606,-84605,-84603,28665,28710,32682,28182,28391) AND `source_type` = 0 AND `action_type` = 53; +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (3795200,3784600,3712000,3685607,3536802,3410200,3348001,3348000,3347701,3347700,3346701,3346700,3346501,3346500,3346201,3346200,3345901,3345900,3272001,3272000,3143700,3143701,3143702,3123800,3108300,3048700,3047700,3013400,2894800,2884101,2884100,2866500,2849801,2819201,2801601,2748001,2745500,2740900,2662600,2546000,2491600,2367800,2131601,2131600) AND `source_type` = 9 AND `action_type` = 53; +-- Random, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (-10999,-10998,23782) AND `source_type` = 0 AND `action_type` = 53; +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (2021800,2021801,2021802,2021803,2021804,2021805,2043900,2043901,2118800,2732800,2732801,2732802,2830800,2964300) AND `source_type` = 9 AND `action_type` = 53; -- cgit v1.2.3