diff options
| author | offl <offl@users.noreply.github.com> | 2021-07-26 02:08:42 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-07-26 02:08:42 +0300 |
| commit | 8b2ed153dd7663c0f3b860b58c05f37e8ac9fd3e (patch) | |
| tree | d58479abf4ba7f342556cd074e6f1b4c5f8ed6af | |
| parent | a45eb13e3eabf455f89d7e2a500cabf1ba814339 (diff) | |
DB/SAI: Prepare SMART_ACTION_WP_START to remove reactState param pt 5
Ref #26728
| -rw-r--r-- | sql/updates/world/3.3.5/2021_07_26_00_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_07_26_00_world.sql b/sql/updates/world/3.3.5/2021_07_26_00_world.sql new file mode 100644 index 00000000000..db3041dd45f --- /dev/null +++ b/sql/updates/world/3.3.5/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; |