aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-07-25 04:06:13 +0300
committeroffl <offl@users.noreply.github.com>2021-07-25 04:06:13 +0300
commit418e73896125ed9cbc0b95e71adb30e43476260f (patch)
tree09a92ca62f6184e4ed716997fe8f4dd32c5b766e
parent831d2b8cd77ac0afcb62ecd78eacb401019fbd91 (diff)
DB/SAI: Prepare SMART_ACTION_WP_START to remove reactState param pt 4
Ref #26728
-rw-r--r--sql/updates/world/3.3.5/2021_07_25_01_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_07_25_01_world.sql b/sql/updates/world/3.3.5/2021_07_25_01_world.sql
new file mode 100644
index 00000000000..e74c7440888
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_07_25_01_world.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `source_type` = 0 AND `action_type` = 53 AND `action_param6` = 2 AND `entryorguid` IN ( -200011,-127350,-127349,-126160,-113456,-113455,-113454,-113453,-111228,-111227,-111226,-111225,-111187,-111186,-111185,-110298,-106201,-106200,-96556,-95560,-82823,-78837,-71999,-71998,-71997,-68314,-68313,-68312,-68311,-66988,-63374,-63373,-42910,-14428,-12819,-11747,412,467,1379,1421,1511,1514,1516,2060,2061,2062,2063,2064,2065,2066,2067,2068,2435,2700,3584,4962,4973,5413,5662,5697,5878,6013,6013,6031,6169,6182,6909,7053,7273,7997,8890,8891,8912,9056,9537,10944,11016,11625,11713,11714,11862,12204,12205,14321,14323,14372,15420,15449,15620,15629,15629,15629,15656,15958,16655,16666,16667,16671,16678,16708,16727,16757,17204,17495,17519,17520,17528,18063,18076,18088,18089,18146,18154,18180,18248,18297,18475,18547,18903,18945,18947,18948,18949,18950,18965,18970,18971,18972,18986,19142,19456,19604,19616,19666,19747,20763,21309,21315,21315,21397,21400,21409,21410,21633,21701,21837,22113,22458,22989,22990,23734,23741,23741,25167,25237,25237,25244,25244,25244,25244,25244,25244,25244,25244,25244,25244,25244,25244,25274,25453,25625,25629,25644,25803,26287,26379,26666,27002,28897,28897,29001,29626,29801,30017,30023,30152,31701,31701,31832,31832,36217);
+UPDATE `smart_scripts` SET `action_param6` = 3 WHERE `source_type` = 9 AND `action_type` = 53 AND `action_param6` = 2 AND `entryorguid` IN (73800,73803,73804,130901,197800,276800,276802,319100,369200,398400,488000,498300,518400,518401,539100,564400,617600,617601,617602,705200,758300,776400,778400,780600,780700,889100,889101,915700,959800,1042700,1064600,1094600,1097700,1097800,1185600,1285800,1435403,1463500,1463501,1463502,1463503,1463504,1463505,1463506,1463507,1463508,1463509,1544000,1629500,1699300,1707600,1707700,1711900,1712300,1737900,1739100,1739200,1739300,1787700,1796900,1807500,1871300,1876000,1895600,1941200,1955600,1958900,1964700,1967100,1967103,1967111,2012900,2044800,2081200,2086400,2086500,2237700,2242400,2309300,2318800,2318801,2318802,2318803,2343400,2356600,2386400,2473700,2520800,2533500,2539700,2539800,2539900,2545100,2545101,2545102,2545103,2545104,2545105,2545106,2545107,2545108,2550400,2558900,2584900,2628700,2658200,2658201,2681400,2681404,3123500,3173701,3183301,3257601,3257700,3257800,3257900,3258000);