mirror of
https://github.com/ZhengPeiRu21/mod-individual-progression
synced 2025-11-29 15:38:19 +08:00
44 lines
3.1 KiB
SQL
44 lines
3.1 KiB
SQL
/*
|
|
Optional but suggested changes. The AQ quests were originally designed for a large group of players to farm items given to a chosen player to turn in.
|
|
This reduces the quest requirements to be more reasonably completable by a solo player or a small group.
|
|
*/
|
|
|
|
-- Increases the Rep for The Hand of the Righteous quest by 40 times, so only about 5 turn-ins are necessary instead of 200.
|
|
-- Feel free to adjust to taste - divide RewardFactionOverride1 by 100 to get the amount of rep that would be awarded
|
|
-- Sql edit example: 5 turn-ins = 800000 rep, 1 turn-in = 4000000 rep
|
|
UPDATE `quest_template` SET `RewardFactionOverride1` = 800000, `RewardFactionOverride2` = 0, `RewardFactionOverride3` = 0, `RewardFactionOverride4` = 0, `RewardFactionOverride5` = 0 WHERE `ID` = 8301;
|
|
UPDATE `quest_template` SET `RewardFactionOverride1` = 800000, `RewardFactionOverride2` = 0, `RewardFactionOverride3` = 0, `RewardFactionOverride4` = 0, `RewardFactionOverride5` = 0 WHERE `ID` = 8302;
|
|
|
|
-- Revert drop rate for Nightmare_corruption to nerfed WotLK drop rate
|
|
UPDATE `creature_loot_template` SET `Chance` = 100 WHERE `Item` = 21146;
|
|
UPDATE `creature_loot_template` SET `Chance` = 100 WHERE `Item` = 21147;
|
|
UPDATE `creature_loot_template` SET `Chance` = 100 WHERE `Item` = 21148;
|
|
|
|
-- Revert Narain's Scrying Goggles to nerfed WotLK drop rate
|
|
DELETE FROM `creature_loot_template` WHERE `Item` = 20951;
|
|
INSERT INTO `creature_loot_template` (`Chance`, `Comment`, `Entry`, `GroupId`, `Item`, `LootMode`, `MaxCount`, `MinCount`, `QuestRequired`, `Reference`) VALUES
|
|
(1, NULL, 11502, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Molten Giant - Narain\'s Scrying Goggles', 11658, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Molten Destroyer - Narain\'s Scrying Goggles', 11659, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Flamewaker - Narain\'s Scrying Goggles', 11661, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Flamewaker Priest - Narain\'s Scrying Goggles', 11662, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Flamewaker Healer - Narain\'s Scrying Goggles', 11663, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Flamewaker Elite - Narain\'s Scrying Goggles', 11664, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Lava Annihilator - Narain\'s Scrying Goggles', 11665, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Firewalker - Narain\'s Scrying Goggles', 11666, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Flameguard - Narain\'s Scrying Goggles', 11667, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Firelord - Narain\'s Scrying Goggles', 11668, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Ancient Core Hound - Narain\'s Scrying Goggles', 11673, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 11982, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 11988, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 12056, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 12057, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Lava Elemental - Narain\'s Scrying Goggles', 12076, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 12098, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Lava Reaver - Narain\'s Scrying Goggles', 12100, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Lava Surger - Narain\'s Scrying Goggles', 12101, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 12118, 0, 20951, 1, 1, 1, 1, 0),
|
|
(100, 'Flamewaker Protector - Narain\'s Scrying Goggles', 12119, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 12259, 0, 20951, 1, 1, 1, 1, 0),
|
|
(1, NULL, 12264, 0, 20951, 1, 1, 1, 1, 0);
|