From a7fa9f28db87403ce2c19d86364bfe93b6c96aa4 Mon Sep 17 00:00:00 2001 From: jackpoz Date: Thu, 17 Jun 2021 19:51:19 +0200 Subject: DB/Creature: Convert 27353 to spawn summons with 1 action instead of 30 linked actions Thanks @Jinnai for the sql update. Close #26605 --- sql/updates/world/3.3.5/2021_06_17_00_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2021_06_17_00_world.sql (limited to 'sql/updates/world') diff --git a/sql/updates/world/3.3.5/2021_06_17_00_world.sql b/sql/updates/world/3.3.5/2021_06_17_00_world.sql new file mode 100644 index 00000000000..4ba2dc64718 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_06_17_00_world.sql @@ -0,0 +1,6 @@ +-- +SET @ENTRY := 27353; +DELETE FROM smart_scripts WHERE entryOrGuid = 27353 AND source_type = 0; +UPDATE creature_template SET AIName="SmartAI" WHERE entry= @ENTRY; +INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, COMMENT) VALUES +(@ENTRY, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 12, 27352, 2, 40000, 0, 0, 30, 1, 0, 0, 0, 0, 0, 0, 0, "On respawn - Self: Summon 30 creatures Levine Family Termite (27352) at Self's position, moved by offset (0, 0, 0, 0) as summon type timed or corpse despawn (2) with duration 40 seconds"); -- cgit v1.2.3