DB/SAI: Remove params of SMART_EVENT_RESPAWN (SMART_SCRIPT_RESPAWN_CONDITION)

(cherry picked from commit 0c3d11c71a056acdd392ddc219185444f63b6372)

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_12_30_world_2021_08_16_01_world.sql b/sql/updates/world/master/2022_03_12_30_world_2021_08_16_01_world.sql
new file mode 100644
index 00000000000..2d90af21ede
--- /dev/null
+++ b/sql/updates/world/master/2022_03_12_30_world_2021_08_16_01_world.sql
@@ -0,0 +1,9 @@
+-- Not even needed, set as typo and uses no type but only map param
+UPDATE `smart_scripts` SET `event_param2` = 0 WHERE `entryorguid` = 23941 AND `source_type` = 0 AND `id` = 0;
+-- They all are spawned in same map and type is again 0, it's not even called
+-- Even if intention was to reset faction to default, it will never work like that
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 23678 AND `source_type` = 0 AND `id` = 0;
+-- This should be handled differently, instead of changing default faction in template and changing it back in script for all creatures
+-- except one summoned(not even implemented), faction should be changed only in script of summoned creature
+UPDATE `creature_template` SET `faction` = 17 WHERE `entry` = 1706;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 1706 AND `source_type` = 0 AND `id` = 3;