DB/SAI: Replace the action 70 by 41 to despawn gobs

Years ago the action 70 was used to despawn/respawn gobs but it's no longer the case , it must only be used to respawn gobs with negative respawntime

(cherry picked from commit 428528774e0ee8da623ed7234f9251d808634fa2)

1 files changed, 53 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_01_06_world_2020_04_11_00_world.sql b/sql/updates/world/master/2022_01_01_06_world_2020_04_11_00_world.sql
new file mode 100644
index 00000000000..1fce2128f3b
--- /dev/null
+++ b/sql/updates/world/master/2022_01_01_06_world_2020_04_11_00_world.sql
@@ -0,0 +1,53 @@
+-- 
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185938  AND `source_type`=1 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813700 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18804900 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814700 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814600 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120  WHERE `entryorguid`=375     AND `source_type`=1 AND `id`=0 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814500 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813900 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813500 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813400 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814800 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814900 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815000 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=7200 WHERE `entryorguid`=179485  AND `source_type`=1 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814300 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814400 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815100 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815200 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815300 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815400 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=600  WHERE `entryorguid`=188463  AND `source_type`=1 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=181582  AND `source_type`=1 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592703 AND `source_type`=9 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592702 AND `source_type`=9 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592701 AND `source_type`=9 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592700 AND `source_type`=9 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=60  WHERE `entryorguid`=190590  AND `source_type`=1 AND `id`=0 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185937  AND `source_type`=1 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185936  AND `source_type`=1 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185932  AND `source_type`=1 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120  WHERE `entryorguid`=188464  AND `source_type`=1 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=50   WHERE `entryorguid`=184835  AND `source_type`=1 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=50   WHERE `entryorguid`=184834  AND `source_type`=1 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813800 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=4880 AND `source_type`=0 AND `id`=27 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12244 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12249 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12251 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12252 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12253 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12254 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12255 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=12256 AND `source_type`=0 AND `id`=1 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=17877 AND `source_type`=0 AND `id`=8 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=23364 AND `source_type`=0 AND `id`=3 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=27331 AND `source_type`=0 AND `id`=7 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=37827 AND `source_type`=0 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=1999500 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=2584900 AND `source_type`=9 AND `id`=2 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=2584900 AND `source_type`=9 AND `id`=3 AND `action_type`=70;
+UPDATE `smart_scripts` SET `action_type`=41 WHERE `entryorguid`=2584900 AND `source_type`=9 AND `id`=4 AND `action_type`=70;