From bdc75eb856cd07f11caafcc9eb533d76f7d7e3a8 Mon Sep 17 00:00:00 2001 From: kaelima Date: Sat, 4 Jun 2011 14:41:45 +0200 Subject: Ruby Sanctum: - Scripted General Zarithrian - Flame walls will now open after killing saviana and baltharus - Fixed savianas timers - Fixed some typos (baltarhus -> baltharus) --- .../world/2011_06_04_00_world_creature_loot_template.sql | 9 +++++++++ sql/updates/world/2011_06_04_00_world_creature_template.sql | 12 ++++++++++++ 2 files changed, 21 insertions(+) create mode 100644 sql/updates/world/2011_06_04_00_world_creature_loot_template.sql create mode 100644 sql/updates/world/2011_06_04_00_world_creature_template.sql (limited to 'sql') diff --git a/sql/updates/world/2011_06_04_00_world_creature_loot_template.sql b/sql/updates/world/2011_06_04_00_world_creature_loot_template.sql new file mode 100644 index 00000000000..ff72ecd3454 --- /dev/null +++ b/sql/updates/world/2011_06_04_00_world_creature_loot_template.sql @@ -0,0 +1,9 @@ +SET @ENTRY := 39946; +UPDATE `creature_template` SET `lootid`=@ENTRY WHERE `entry`=39746; +UPDATE `creature_template` SET `lootid`=@ENTRY+1 WHERE `entry`=39751; +UPDATE `creature_template` SET `lootid`=@ENTRY+2 WHERE `entry`=39747; +DELETE FROM `creature_loot_template` WHERE `entry` BETWEEN @ENTRY AND @ENTRY+2; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@ENTRY,49426,100,1,0,1,1), +(@ENTRY+1,49426,100,1,0,1,1), +(@ENTRY+2,49426,100,1,0,1,1); diff --git a/sql/updates/world/2011_06_04_00_world_creature_template.sql b/sql/updates/world/2011_06_04_00_world_creature_template.sql new file mode 100644 index 00000000000..1155ac4b7e3 --- /dev/null +++ b/sql/updates/world/2011_06_04_00_world_creature_template.sql @@ -0,0 +1,12 @@ +DELETE FROM `creature_text` WHERE `entry`=39746; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(39746,0,0, 'Alexstrasza has chosen capable allies.... A pity that I must END YOU!',14,0,100,0,0,17512, 'Baltharus the Warborn'), +(39746,1,0, 'You thought you stood a chance?',14,0,50,0,0,17513, 'General Zarithrian'), +(39746,1,1, 'It''s for the best.',14,0,50,0,0,17514, 'General Zarithrian'), +(39746,2,0, 'Turn them to ash, minions!',14,0,100,0,0,17516, 'General Zarithrian'), +(39746,3,0, 'HALION! I...',14,0,100,0,0,17515, 'General Zarithrian'); + +UPDATE `creature_template` SET `ScriptName`= 'npc_baltharus_the_warborn_clone' WHERE `ScriptName`= 'npc_baltarhus_the_warborn_clone'; +UPDATE `creature_template` SET `InhabitType`=3 WHERE `entry`=39794; +UPDATE `creature_template` SET `ScriptName`= 'boss_general_zarithrian' WHERE `entry`=39746; +UPDATE `creature_template` SET `ScriptName`= 'npc_onyx_flamecaller' WHERE `entry`=39814; -- cgit v1.2.3