Thread: [SQL] Mangos DB mods - PVE, crafting, and more...

After being disappointed that it was not possible to complete the entire death knight starting quests (due to mangos or DB limitations) I set out to restructure the entire line of quests so that it would be possible for any player (not just one using GM commands) to get to the end and have all the skills/equipment that is available.

To do this I had to remove some quests that would not work and move the rewards from these removed quests to others that were still functional. I also reduced some of the requirements to complete a few of the quests. Some quests will be complete when they are accepted so they can be turned in right away. Some were not modified at all. On average is takes less than an hour to complete the entire series of quests to the end.

I use the query for these changes with TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit repack with the CU_0070 update for it. The query may possibly work fine with other mangos based repacks but I have not tested any of them.

Overall I am satisfied with my efforts so I thought I would share my work in case anyone else may find it useful.


(DOWNLOAD REMOVED - NEEDS TO BE UPDATED FOR CURRENT VERSION OF MANGOS)


Here is the order of the quests from start to end and a brief comment on what was changed:

In Service Of The Lich King
The Emblazoned Runeblade
Runeforging: Preparation For Battle
The Endless Hunger
The Eye Of Acherus
The Might Of The Scourge
Report To Scourge Commander Thalanor
The Scarlet Harvest
If Chaos Drives, Let Suffering Hold The Reins [Reduced to killing 5 Scarlet Crusaders & 5 Citizens of Havenshire - Added rewards from Grand Theft Palomino, Into the Realm of Shadows, Tonight We Dine In Havenshire, Death's Challenge.]
Gothik the Harvester
The Gift That Keeps On Giving [Completed upon accepting.]
An Attack Of Opportunity [Added rewards from Massacre At Light's Point.]
Victory At Death's Breach!
The Will Of The Lich King
The Crypt of Remembrance [Added rewards from The Plaguebringer's Request, Noth's Special Brew.]
Nowhere To Run And Nowhere To Hide [Added rewards from How To Win Friends And Influence Enemies, Lambs To The Slaughter.]
Behind Scarlet Lines
The Path Of The Righteous Crusader [Added rewards from Brothers In Death, Bloody Breakout, A Special Surprise, A Sort Of Homecoming.]
Ambush At The Overlook
A Meeting With Fate
The Scarlet Onslaught Emerges
Scarlet Armies Approach...
The Scarlet Apocalypse
An End To All Things... [Completed upon accepting.]
The Lich King's Command
The Light of Dawn [Completed upon accepting. - Assigned new quest taker.]
Taking Back Acherus [Assigned new quest giver.]
The Battle For The Ebon Hold [Completed upon accepting.]

Code:

UPDATE `pet_levelstats` SET `hp` = *4 WHERE `hp` > '10';
UPDATE `pet_levelstats` SET `armor` = *4 WHERE `armor` > '10';
UPDATE `pet_levelstats` SET `mana` = *4 WHERE `mana` > '10';

Try that Qry