From fba5a22aa8beae4b7ed37aef624cdb54747a44f8 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 24 Feb 2018 15:01:13 +0100 Subject: DB/Creature: assign SmartAI to Apothecary Keever's test subjects + typo fix - missing row number in one of the DELETE FROM queries in commit 20a0d27b5bcbc2c3a334edef37f6a05e653ca401 Closes #21488 (cherry picked from commit 4c791ec376fdf5c7717a6249604502ec15656902) --- .../world/master/2021_07_01_08_world_2018_02_24_00_world_335.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/world/master/2021_07_01_08_world_2018_02_24_00_world_335.sql b/sql/updates/world/master/2021_07_01_08_world_2018_02_24_00_world_335.sql index 6d4ce16a205..9d87518b782 100644 --- a/sql/updates/world/master/2021_07_01_08_world_2018_02_24_00_world_335.sql +++ b/sql/updates/world/master/2021_07_01_08_world_2018_02_24_00_world_335.sql @@ -5,7 +5,7 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (7980,0,0,0,0,0,100,0,0,0,2000,4000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Deathguard Elite - In Combat - Cast 'Shoot'"); -- Stormwind City Guard -DELETE FROM `smart_scripts` WHERE `entryorguid`=68 AND `source_type`=0 AND `id` IN (1,2,3,4,5,6,7,8,9); +DELETE FROM `smart_scripts` WHERE `entryorguid`=68 AND `source_type`=0 AND `id` IN (1,2,3,4,5,6,7,8,9,10); DELETE FROM `smart_scripts` WHERE `entryorguid` IN (6800,6801,6802,6803,6804) AND `source_type`=9; 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 (68, 0, 1,0,0,0,100,0,0,0,2000,4000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Stormwind City Guard - In Combat - Cast 'Shoot'"), -- cgit v1.2.3