From 0c3d11c71a056acdd392ddc219185444f63b6372 Mon Sep 17 00:00:00 2001 From: offl Date: Mon, 16 Aug 2021 23:00:31 +0300 Subject: DB/SAI: Remove params of SMART_EVENT_RESPAWN (SMART_SCRIPT_RESPAWN_CONDITION) --- sql/updates/world/3.3.5/2021_08_16_01_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2021_08_16_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2021_08_16_01_world.sql b/sql/updates/world/3.3.5/2021_08_16_01_world.sql new file mode 100644 index 00000000000..2d90af21ede --- /dev/null +++ b/sql/updates/world/3.3.5/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; -- cgit v1.2.3