diff options
| author | Killyana <morphone1@gmail.com> | 2018-02-24 15:01:13 +0100 |
|---|---|---|
| committer | tkrokli <tkrokli@gmail.com> | 2018-02-24 15:01:50 +0100 |
| commit | 4c791ec376fdf5c7717a6249604502ec15656902 (patch) | |
| tree | d36c3cbb354774546c7f5afa13f36795c64f8e2f | |
| parent | 16b5f39de6295c541b7fb400aa8d63e8ba08b233 (diff) | |
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
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_24_00_world_335.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_24_01_world_335.sql | 2 |
2 files changed, 3 insertions, 1 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_24_00_world_335.sql b/sql/updates/world/3.3.5/2018_02_24_00_world_335.sql index 6d4ce16a205..9d87518b782 100644 --- a/sql/updates/world/3.3.5/2018_02_24_00_world_335.sql +++ b/sql/updates/world/3.3.5/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'"), diff --git a/sql/updates/world/3.3.5/2018_02_24_01_world_335.sql b/sql/updates/world/3.3.5/2018_02_24_01_world_335.sql new file mode 100644 index 00000000000..fb853ff5a20 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_24_01_world_335.sql @@ -0,0 +1,2 @@ +-- Apothecary Keever's test subjects (Caged Human Male, Squirrel, Rabbit, Toad, Sheep) +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (5736,5739,5741,5742,5743); |