diff options
| author | offl <offl@users.noreply.github.com> | 2021-07-24 02:16:10 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-07-24 02:16:10 +0300 |
| commit | ba4f2e5a83629fa6043784781847416b61c8511f (patch) | |
| tree | 8c9629c177fe2822842747a2171de4052ba68939 | |
| parent | caf68840b9bc6a435a59b2fb954c1fe779a27c66 (diff) | |
DB/SAI: Prepare SMART_ACTION_WP_START to remove reactState param pt 2
Ref #26728
| -rw-r--r-- | sql/updates/world/3.3.5/2021_07_24_00_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_07_24_00_world.sql b/sql/updates/world/3.3.5/2021_07_24_00_world.sql new file mode 100644 index 00000000000..35a86cb7290 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_07_24_00_world.sql @@ -0,0 +1,12 @@ +-- Just Summoned, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (7401,7411,14353,21768,24041,24156,25742,26935,27492,27683,27924,28498,32446,34044,36101,36102,37845,37846,37857,38493,38505) AND `source_type` = 0 AND `action_type` = 53; +-- On Quest Finished, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (1269,4709,6826,12997) AND `source_type` = 0 AND `action_type` = 53; +-- On Quest Finished, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (1373,4048,7207,14875) AND `source_type` = 0 AND `action_type` = 53; +-- On Quest Taken, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (6181) AND `source_type` = 0 AND `action_type` = 53; +-- Random, ReactState 0 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (37966,37980,36812,36642,36624,35604,35589,35372,35361,35321,35320,33957,33956,33696,33235,32443,31083,29261,27939,23042,23038,22870,22406,22405,22404,21170,20206,19546,19545,19482,19271,19228,18069,17230,16256,15291,14508,14470,13716,8024,8023,4068,3681,-53790,-23440,-23439,-23438,-23437,-23436,-23433,-23432,-23429,-23426) AND `source_type` = 0 AND `action_type` = 53; +-- Random, ReactState 1 +UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `entryorguid` IN (3694,4721,4972,5088,6497,9453,10610,10803,10805,14909,17242,17955,19543,19544,20071,22820,23282,23283,23284) AND `source_type` = 0 AND `action_type` = 53; |