diff options
| -rw-r--r-- | sql/updates/world/2012_07_14_01_world_creature_loot_template.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/sql/updates/world/2012_07_14_01_world_creature_loot_template.sql b/sql/updates/world/2012_07_14_01_world_creature_loot_template.sql new file mode 100644 index 00000000000..1b9c4f4448c --- /dev/null +++ b/sql/updates/world/2012_07_14_01_world_creature_loot_template.sql @@ -0,0 +1,33 @@ +-- Hellboar shit always drops +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`= -100 WHERE `item`=23270; + +-- update Al'ar loot +SET @gear := 34053; +SET @talon := 34377; +SET @Alar := 19514; + +DELETE FROM `creature_loot_template` WHERE `entry`=@Alar; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@Alar,29434,100,1,0,2,2), -- Badge of Justice 2x +(@Alar,1,100,1,0,-@gear,3), -- 3x Gear Reference +(@Alar,2,10,1,0,-34052,1), -- Pattern Reference +(@Alar,3,2,1,0,-34052,1); -- extra Pattern Reference (small chance) + +DELETE FROM `reference_loot_template` WHERE `entry` IN (@gear,@talon); +INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +-- Gear Reference: +(@gear,29918,0,1,1,1,1), -- Mindstorm Wristbands +(@gear,29920,0,1,1,1,1), -- Phoenix-Ring of Rebirth +(@gear,29921,0,1,1,1,1), -- Fire Crest Breastplate +(@gear,29922,0,1,1,1,1), -- Band of Al'ar +(@gear,29923,0,1,1,1,1), -- Talisman of the Sun King +(@gear,29924,0,1,1,1,1), -- Netherbane +(@gear,29925,0,1,1,1,1), -- Phoenix-Wing Cloak +(@gear,29947,0,1,1,1,1), -- Gloves of the Searing Grip +(@gear,29948,0,1,1,1,1), -- Claw of the Phoenix +(@gear,29949,0,1,1,1,1), -- Arcanite Steam-Pistol +(@gear,30447,0,1,1,1,1), -- Tome of Fiery Redemption +(@gear,1,0,1,1,-@talon,1), -- Talonoption +-- either of the claws is selected +(@talon,30448,0,1,1,1,1), -- Talon of Al'ar +(@talon,32944,0,1,1,1,1); -- Talon of the Phoenix |