diff options
| author | offl <offl@users.noreply.github.com> | 2021-07-25 03:01:49 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-11 19:39:00 +0100 |
| commit | aedaef66d933cd34efc11055fc3cfc486c324957 (patch) | |
| tree | d10484432e72919f7625fec2ba1ebf6ad7b193a2 | |
| parent | b420ef8ea9118cbb4967daab9df81a50f4e2ddf0 (diff) | |
DB/SAI: Prepare SMART_ACTION_WP_START to remove reactState param pt 3
Ref #26728
(cherry picked from commit 831d2b8cd77ac0afcb62ecd78eacb401019fbd91)
| -rw-r--r-- | sql/updates/world/master/2022_03_11_27_world_2021_07_25_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_11_27_world_2021_07_25_00_world.sql b/sql/updates/world/master/2022_03_11_27_world_2021_07_25_00_world.sql new file mode 100644 index 00000000000..2e708155c81 --- /dev/null +++ b/sql/updates/world/master/2022_03_11_27_world_2021_07_25_00_world.sql @@ -0,0 +1,8 @@ +-- Random, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (-74951,-74950,-74949,-74948,-74524,-74523,-74522,23364,23380,25986,26237,26310,26677) AND `source_type` = 0 AND `action_type` = 53; +-- Random, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (17809,17810,17811,17812,23975,25220,25458) AND `source_type` = 0 AND `action_type` = 53; +-- Action lists, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (279000,285200,285201,298300,405900,442900,442902,461800,472000,825600,911701,929800,929802,929803,1435400,1435401,1435402,1446900,1450000,1612801,1768200,1968500,2080200,2141100,2303800,2304202,2336500,2428400,2431500,2440500,2463900,2473500,3456500,3780100,3833400,3833500,3833700,3833800) AND `source_type` = 9 AND `action_type` = 53; +-- Action lists, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (143300,369501,399500,508800,566600,811501,857900,1710901,1710905,1722600,1722601,1783101,2389900,2741100) AND `source_type` = 9 AND `action_type` = 53; |