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

1 files changed, 35 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_04_11_00_world.sql b/sql/updates/world/3.3.5/2020_04_11_00_world.sql
new file mode 100644
index 00000000000..77b4f456b6a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_04_11_00_world.sql
@@ -0,0 +1,35 @@
+-- 
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185938  AND `source_type`=1 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813700 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18804900 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814700 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814600 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120  WHERE `entryorguid`=375     AND `source_type`=1 AND `id`=0;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814500 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813900 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813500 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813400 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814800 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814900 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815000 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=7200 WHERE `entryorguid`=179485  AND `source_type`=1 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814300 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18814400 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815100 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815200 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815300 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18815400 AND `source_type`=9 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=600  WHERE `entryorguid`=188463  AND `source_type`=1 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=181582  AND `source_type`=1 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592703 AND `source_type`=9 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592702 AND `source_type`=9 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592701 AND `source_type`=9 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=18592700 AND `source_type`=9 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=60  WHERE `entryorguid`=190590  AND `source_type`=1 AND `id`=0;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185937  AND `source_type`=1 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185936  AND `source_type`=1 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=300  WHERE `entryorguid`=185932  AND `source_type`=1 AND `id`=2;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=120  WHERE `entryorguid`=188464  AND `source_type`=1 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=50   WHERE `entryorguid`=184835  AND `source_type`=1 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=50   WHERE `entryorguid`=184834  AND `source_type`=1 AND `id`=1;
+UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `action_param2`=100  WHERE `entryorguid`=18813800 AND `source_type`=9 AND `id`=2;