From d77a9588097c52e426ec70a762bfef05924471da Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Sat, 15 Oct 2016 00:09:30 +0200 Subject: Creature/AI: prevent Kologarn's arms from attacking. --- sql/updates/world/3.3.5/2016_10_14_06_world.sql | 20 ++++++++++++++++++++ sql/updates/world/3.3.5/2016_10_14_07_world.sql | 2 ++ sql/updates/world/3.3.5/9955_22_52_world.sql | 20 -------------------- 3 files changed, 22 insertions(+), 20 deletions(-) create mode 100644 sql/updates/world/3.3.5/2016_10_14_06_world.sql create mode 100644 sql/updates/world/3.3.5/2016_10_14_07_world.sql delete mode 100644 sql/updates/world/3.3.5/9955_22_52_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_10_14_06_world.sql b/sql/updates/world/3.3.5/2016_10_14_06_world.sql new file mode 100644 index 00000000000..f42a57a5a5c --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_14_06_world.sql @@ -0,0 +1,20 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_gormok_ride_player','spell_gormok_jump_to_hand','spell_gormok_snobolled'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(66245,'spell_gormok_ride_player'), +(66342,'spell_gormok_jump_to_hand'), +(66406,'spell_gormok_snobolled'); + +DELETE FROM `disables` WHERE `sourceType`=0 AND `entry`=66636; +INSERT INTO `disables` (`sourceType`, `entry`, `flags`, `params_0`, `params_1`, `comment`) VALUES +(0, 66636, 64, 0, 0, 'Disable LoS for Spell Rising Anger'); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=34796; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(34796, 46598, 0, 0); + +DELETE FROM `vehicle_template_accessory` WHERE `entry`=34796 AND `accessory_entry`=34800; +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(34796,34800,0,0,'Snobold Vassal', 5,0), +(34796,34800,1,0,'Snobold Vassal', 5,0), +(34796,34800,2,0,'Snobold Vassal', 5,0), +(34796,34800,3,0,'Snobold Vassal', 5,0); diff --git a/sql/updates/world/3.3.5/2016_10_14_07_world.sql b/sql/updates/world/3.3.5/2016_10_14_07_world.sql new file mode 100644 index 00000000000..8b9364acf80 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_14_07_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `AIName`="PassiveAI" WHERE `entry` IN (32933,32934); diff --git a/sql/updates/world/3.3.5/9955_22_52_world.sql b/sql/updates/world/3.3.5/9955_22_52_world.sql deleted file mode 100644 index f42a57a5a5c..00000000000 --- a/sql/updates/world/3.3.5/9955_22_52_world.sql +++ /dev/null @@ -1,20 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_gormok_ride_player','spell_gormok_jump_to_hand','spell_gormok_snobolled'); -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(66245,'spell_gormok_ride_player'), -(66342,'spell_gormok_jump_to_hand'), -(66406,'spell_gormok_snobolled'); - -DELETE FROM `disables` WHERE `sourceType`=0 AND `entry`=66636; -INSERT INTO `disables` (`sourceType`, `entry`, `flags`, `params_0`, `params_1`, `comment`) VALUES -(0, 66636, 64, 0, 0, 'Disable LoS for Spell Rising Anger'); - -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=34796; -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES -(34796, 46598, 0, 0); - -DELETE FROM `vehicle_template_accessory` WHERE `entry`=34796 AND `accessory_entry`=34800; -INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES -(34796,34800,0,0,'Snobold Vassal', 5,0), -(34796,34800,1,0,'Snobold Vassal', 5,0), -(34796,34800,2,0,'Snobold Vassal', 5,0), -(34796,34800,3,0,'Snobold Vassal', 5,0); -- cgit v1.2.3