diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_06_04_00_world_creature_loot_template.sql | 9 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_04_00_world_creature_template.sql | 12 |
2 files changed, 21 insertions, 0 deletions
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; |