From cdc38e207018889dec4fa6dd1304e7dfeb8936f8 Mon Sep 17 00:00:00 2001 From: Naddley Date: Sun, 13 Nov 2022 00:17:56 +0100 Subject: DB/Misc: Fix sql error 662d32d673913e7a827a1049c77ebf47e477ac96 followup --- sql/updates/world/master/2022_11_12_25_world.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sql/updates/world/master/2022_11_12_25_world.sql b/sql/updates/world/master/2022_11_12_25_world.sql index 260487bce30..3f4eb5aff45 100644 --- a/sql/updates/world/master/2022_11_12_25_world.sql +++ b/sql/updates/world/master/2022_11_12_25_world.sql @@ -111,11 +111,11 @@ DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` IN (31346400, 31346401); UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 29152; 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, 34, 0, 100, 0, 2, 1, 0, 0, 71, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Take off all equipped items'), (@ENTRY, 0, 1, 0, 34, 0, 100, 0, 2, 1, 0, 0, 80, 31346400, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Start timed action list id #31346400 (update out of combat) // -inline'), -(31346400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 71, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Take off all equipped items'),, 0, 0, 0, 34, 0, 100, 0, 2, 1, 0, 0, 71, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Take off all equipped items'), -(31346400, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set stand state to KNEEL'), -(31346400, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 83610, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Cast spell 83610 on Self'), -(31346400, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Remove stand state KNEEL'), +(31346400, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set stand state to KNEEL'), +(31346400, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 83610, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Cast spell 83610 on Self'), +(31346400, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Remove stand state KNEEL'), (@ENTRY, 0, 2, 0, 34, 0, 100, 0, 2, 11, 0, 0, 80, 31346401, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 11 - Self: Start timed action list id #31346401 (update out of combat) // -inline'), (31346401, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set stand state to KNEEL'), (31346401, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 28, 83610, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Remove aura due to spell 83610'), -- cgit v1.2.3