diff options
Diffstat (limited to 'sql')
6 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/2011_05_28_02_world_areatrigger_scripts.sql b/sql/updates/world/2011_05_28_02_world_areatrigger_scripts.sql new file mode 100644 index 00000000000..579386a8b4b --- /dev/null +++ b/sql/updates/world/2011_05_28_02_world_areatrigger_scripts.sql @@ -0,0 +1,3 @@ +DELETE FROM `areatrigger_scripts` WHERE `entry`=5867; +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(5867, 'at_baltharus_plateau'); diff --git a/sql/updates/world/2011_05_28_02_world_creature_template.sql b/sql/updates/world/2011_05_28_02_world_creature_template.sql new file mode 100644 index 00000000000..4f21dced22b --- /dev/null +++ b/sql/updates/world/2011_05_28_02_world_creature_template.sql @@ -0,0 +1,3 @@ +UPDATE `creature_template` SET `npcflag`=0,`ScriptName`= 'npc_xerestrasza' WHERE `entry`=40429; +UPDATE `creature_template` SET `mindmg`=497,`maxdmg`=676,`attackpower`=795,`dmg_multiplier`=35,`ScriptName`= 'boss_baltharus_the_warborn' WHERE `entry`=39751; +UPDATE `creature_template` SET `exp`=2,`mindmg`=497,`maxdmg`=676,`attackpower`=795,`dmg_multiplier`=70 WHERE `entry`=39920; diff --git a/sql/updates/world/2011_05_28_02_world_creature_text.sql b/sql/updates/world/2011_05_28_02_world_creature_text.sql new file mode 100644 index 00000000000..8db0b085d27 --- /dev/null +++ b/sql/updates/world/2011_05_28_02_world_creature_text.sql @@ -0,0 +1,17 @@ +DELETE FROM `creature_text` WHERE `entry` IN (39751,40429); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(39751,0,0, 'Your power wanes, ancient one.... Soon you will join your friends.',14,0,100,0,0,17525, 'Baltharus the Warborn'), +(39751,1,0, 'Ah, the entertainment has arrived.',14,0,100,0,0,17520, 'Baltharus the Warborn'), +(39751,2,0, 'Baltharus leaves no survivors!',14,0,100,0,0,17521, 'Baltharus the Warborn'), +(39751,2,1, 'This world has enough heroes.',14,0,100,0,0,17522, 'Baltharus the Warborn'), +(39751,3,0, 'Twice the pain and half the fun.',14,0,100,0,0,17524, 'Baltharus the Warborn'), +(39751,4,1, 'I... didn''t see that coming....',14,0,100,0,0,17523, 'Baltharus the Warborn'), +(40429,0,0, 'Thank you! I could not have held out for much longer.... A terrible thing has happened here.',14,0,100,5,0,17491, 'Sanctum Guardian Xerestrasza'), +(40429,1,0, 'We believed the Sanctum was well-fortified, but we were not prepared for the nature of this assault.',12,0,100,1,0,17492, 'Sanctum Guardian Xerestrasza'), +(40429,2,0, 'The Black dragonkin materialized from thin air, and set upon us before we could react.',12,0,100,1,0,17493, 'Sanctum Guardian Xerestrasza'), +(40429,3,0, 'We did not stand a chance. As my brethren perished around me, I managed to retreat here and bar the entrance.',12,0,100,1,0,17494, 'Sanctum Guardian Xerestrasza'), +(40429,4,0, 'They slaughtered us with cold efficiency, but the true focus of their interest seemed to be the eggs kept here in the Sanctum.',12,0,100,1,0,17495, 'Sanctum Guardian Xerestrasza'), +(40429,5,0, 'The commander of the forces on the ground here is a cruel brute named Zarithrian, but I fear there are greater powers at work.',12,0,100,1,0,17496, 'Sanctum Guardian Xerestrasza'), +(40429,6,0, 'In their initial assault, I caught a glimpse of their true leader, a fearsome full-grown twilight dragon.',12,0,100,1,0,17497, 'Sanctum Guardian Xerestrasza'), +(40429,7,0, 'I know not the extent of their plans, heroes, but I know this: They cannot be allowed to succeed!',12,0,100,5,0,17498, 'Sanctum Guardian Xerestrasza'), +(40429,8,0, 'Help! I am trapped within this tree! I require aid!',14,0,100,5,0,17490, 'Sanctum Guardian Xerestrasza'); diff --git a/sql/updates/world/2011_05_28_02_world_instance_template.sql b/sql/updates/world/2011_05_28_02_world_instance_template.sql new file mode 100644 index 00000000000..ef6d6d31084 --- /dev/null +++ b/sql/updates/world/2011_05_28_02_world_instance_template.sql @@ -0,0 +1 @@ +UPDATE `instance_template` SET `script`= 'instance_ruby_sanctum' WHERE `map`=724;
\ No newline at end of file diff --git a/sql/updates/world/2011_05_28_02_world_sai.sql b/sql/updates/world/2011_05_28_02_world_sai.sql new file mode 100644 index 00000000000..88a816636d4 --- /dev/null +++ b/sql/updates/world/2011_05_28_02_world_sai.sql @@ -0,0 +1,9 @@ +-- Smart AI for Baltarhus the Warborn Clone +SET @ENTRY := 39899; -- NPC entry +SET @SPELL1 := 40504; -- Cleave +SET @SPELL2 := 75125; -- Blade Tempest +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +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,0,0,100,0,5000,10000,24000,24000,11,@SPELL1,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Baltarhus the Warborn Clone - Combat - Cast Cleave on victim'), +(@ENTRY,0,1,0,0,0,100,0,18000,25000,24000,26000,11,@SPELL2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Baltarhus the Warborn Clone - Cast Blade Tempest on self'); diff --git a/sql/updates/world/2011_05_28_02_world_spell_script_names.sql b/sql/updates/world/2011_05_28_02_world_spell_script_names.sql new file mode 100644 index 00000000000..d2236aa4c6b --- /dev/null +++ b/sql/updates/world/2011_05_28_02_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_baltharus_enervating_brand'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(74502, 'spell_baltharus_enervating_brand'); |