diff options
| -rw-r--r-- | sql/updates/world/2011_10_01_05_world_sai.sql | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_01_05_world_sai.sql b/sql/updates/world/2011_10_01_05_world_sai.sql new file mode 100644 index 00000000000..a6380f6c991 --- /dev/null +++ b/sql/updates/world/2011_10_01_05_world_sai.sql @@ -0,0 +1,51 @@ +UPDATE `creature_template` SET `unit_flags`=32768,`equipment_id`=53 WHERE `entry`=24062; -- Wildervar Miner +UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=24178; -- Shatterhorn + +UPDATE `creature_model_info` SET `bounding_radius`=1.25,`combat_reach`=4.375,`gender`=0 WHERE `modelid`=22486; -- Shatterhorn + +DELETE FROM `creature_template_addon` WHERE `entry` IN (24062,24178); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(24062,0,1,257,0, NULL), -- Wildervar Miner +(24178,0,3,1,0, '6606'); -- Shatterhorn, Self Visual - Sleep Until Cancelled (DND) +DELETE FROM `creature_addon` WHERE `guid` IN (120419,120422,106573); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(120419,0,0,0,0,1,''), -- Wildervar Miner, talk +(120422,0,0,0,0,1,''); -- Wildervar Miner, talk + +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY; + +-- The ram meat spell may only be used if player is inside the mine +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=43209; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(17,0,43209,0,23,4534,0,0,64,'','Place Ram Meat can only be used in Wildervar Mine'); + +-- Insert missing spell_target_position for Place Ram Meat spell +DELETE FROM `spell_target_position` WHERE `id`=43209; +INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES +(43209,571,2636.288086,-5050.891113,295.537445,5.374982); + +-- Shatterhorn SAI +SET @ENTRY := 24178; +SET @SPELL_GROUND_SMASH := 12734; -- Ground Smash +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Shatterhorn - On Aggro - Say Line 0'), +(@ENTRY,0,1,0,0,0,100,0,3000,5000,12000,13000,11,@SPELL_GROUND_SMASH,1,0,0,0,0,2,0,0,0,0,0,0,0,'Shatterhorn - In Combat - Cast Ground Smash'), +(@ENTRY,0,2,0,6,0,100,0,0,0,0,0,41,8000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Shatterhorn - Force Despawn 8 Seconds After Death'), +(@ENTRY,0,3,0,8,0,0,0,43209,0,0,0,19,0x300,1,0,0,0,0,1,0,0,0,0,0,0,0,'Shatterhorn - On Place Meat spellhit remove unit flags'), +(@ENTRY,0,4,0,8,0,0,0,43209,0,0,0,28,6606,1,0,0,0,0,1,0,0,0,0,0,0,0,'Shatterhorn - On Place Meat spellhit remove sleep aura'), +(@ENTRY,0,5,0,8,0,0,0,43209,0,0,0,91,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Shatterhorn - On Place Meat spellhit remove byte1 3'); + +-- Text +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@ENTRY,0,0,'%s wakes up from the smell of fresh meat!',16,0,100,15,0,0,'Shatterhorn on aggro line and roar at same time'); + +/* Target is null, can't use event_scripts +-- Event send by Place Ram Meat spell +DELETE FROM `event_scripts` WHERE `id`=15739; +INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES +(15739, 2, 14, 6606, 0, 0, 0, 0, 0, 0), +(15739, 3, 5, 0x6+0x35, 0x300, 0, 0, 0, 0, 0); +*/ |