<commit_before># 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);<commit_msg>SQL: Improve Morrowgrain drop rate.<commit_after># 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;
{'fraction_non_alphanumeric': 0.12058627581612258, 'fraction_numerical': 0.06862091938707528, 'mean_word_length': 6.435643564356436, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '172027', 'n_tokens_mistral': 597, 'n_tokens_neox': 501, 'n_words': 174}