diff options
| author | offl <offl@users.noreply.github.com> | 2021-07-21 20:05:01 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-11 19:07:06 +0100 |
| commit | 1b22d75019e983e18e2319ce36a57ab5f17e6752 (patch) | |
| tree | e50cb50668893846967e0e51834971cffe2d5bfb | |
| parent | d44d1f63096ef4e9c7e6b86639dcb45d707d8e34 (diff) | |
DB/SAI: Prepare SMART_ACTION_WP_START to remove reactState param pt 1
Ref #26728
(cherry picked from commit b1e099228e379da152d4f2122e8cd71feb8d1ff7)
| -rw-r--r-- | sql/updates/world/master/2022_03_11_24_world_2021_07_21_02_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_11_24_world_2021_07_21_02_world.sql b/sql/updates/world/master/2022_03_11_24_world_2021_07_21_02_world.sql new file mode 100644 index 00000000000..ea18cdb27a2 --- /dev/null +++ b/sql/updates/world/master/2022_03_11_24_world_2021_07_21_02_world.sql @@ -0,0 +1,8 @@ +-- Reset, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (794,11282,11283,14850,14857,14873,14874,14908,19447,19776,23600,23616,23843,28864,29144) AND `source_type` = 0 AND `action_type` = 53; +-- Reset, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (-67155,3848,5042,16551,16611,16626,16643,16693,16742,16856,17015,17219,17246,17512,19455,19569,19667,20551,25289,27141,27299,27301,27316,40416) AND `source_type` = 0 AND `action_type` = 53; +-- Spawn, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (18191,21182,21291,22401,22402,22403,28682,28705,32421,32424,32426,32509,32668,32669,33589,33788,33854,38191) AND `source_type` = 0 AND `action_type` = 53; +-- Spawn, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (-109655,-109654,-109653,-109652,-98043,-98042,225,3695,17592,18237,18294,19055,21117,23995,25239,25477,25730,26599,26600,26634,26817,27842) AND `source_type` = 0 AND `action_type` = 53; |