aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2020-04-26 22:08:07 +0200
committerShauren <shauren.trinity@gmail.com>2022-01-01 21:41:43 +0100
commit62d8f057136dd9051b808bcb96b7e54b58cbb796 (patch)
tree5f317c3be45486b7b6fdd0bd6ff2539109968bff /sql
parentcc894867584c45d156456ba3364a6a3014a2a68a (diff)
DB/SAI: Update some SAI to use the correct action type to despawn gameobjects instead the old unexpected result of action 70
(cherry picked from commit 22af72b149a57d922933ccf24a28f8c28d09cc03)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_01_01_35_world_2020_04_26_01_world.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_35_world_2020_04_26_01_world.sql b/sql/updates/world/master/2022_01_01_35_world_2020_04_26_01_world.sql
new file mode 100644
index 00000000000..6386cf46d74
--- /dev/null
+++ b/sql/updates/world/master/2022_01_01_35_world_2020_04_26_01_world.sql
@@ -0,0 +1,15 @@
+--
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300, `target_type`=20 WHERE `entryorguid`=37827 AND `source_type`= 0 AND `id`= 2 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12256 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12255 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12254 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12253 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12252 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12251 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12249 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=12244 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300, `target_type`=20 WHERE `entryorguid`=1999500 AND `source_type`=9 AND `id`= 2 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=43200, `target_type`=20 WHERE `entryorguid`=1433800 AND `source_type`= 9 AND `id`= 2 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=27331 AND `source_type`= 0 AND `id`= 7 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=17877 AND `source_type`= 0 AND `id`= 8 AND `action_type` IN (41,70);
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120, `target_type`=20 WHERE `entryorguid`=10717 AND `source_type`= 0 AND `id`= 1 AND `action_type` IN (41,70);