sql-mods.txt

# Disable Creeping Sludge's Noxious Cloud (150 aoe dps).
DELETE FROM `creature_ai_scripts` WHERE creature_id = 12222 LIMIT 1;
# Disable Creeping Sludge's Poison Shock (200 aoe dps).
# None of these seem to work.
UPDATE `creature_template_addon` SET `auras`=NULL WHERE  `entry`=12222 LIMIT 1;
UPDATE `creature_template` SET `AIName`=NULL WHERE  `entry`=12222 LIMIT 1;
INSERT INTO `spell_template` (`id`, `comments`) VALUES (22638, 'Poison Shock Aura - nerfed');

# Fix quest 'Deadwood of the North'
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (15395, 8461);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (15395, 8461);

# Improve Morrowgrain drop rate.
UPDATE `item_loot_template` SET `ChanceOrQuestChance`=100, `groupid`=0 WHERE `item`=11040;

# Improve Chillwind Horn drop rate.
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `item`=12444;

# Fix Firestar's Libram quests.
# Previously, they were set to autocomplete, making it impossible to get the items from the Dark Coffer.
UPDATE `quest_template` SET `Method`=2 WHERE `entry`=4463 LIMIT 1;
UPDATE `quest_template` SET `Method`=2 WHERE `entry`=4481 LIMIT 1;
UPDATE `quest_template` SET `Method`=2 WHERE `entry`=4482 LIMIT 1;
UPDATE `quest_template` SET `Method`=2 WHERE `entry`=4483 LIMIT 1;
UPDATE `quest_template` SET `Method`=2 WHERE `entry`=4484 LIMIT 1;