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

Removed this query since it was replaced with a newer one.

You should use pastebin or something instead :3
Some anti viruses dosent like beam & its easier to copy from the web and save it as an SQL

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

With this modification the death knight starts in Stormwind or Orgrimmar just like you would at the end of the starter quests but a small custom quest line has been added to give the death knight all the items and skills that are normally awarded during the entire quest series.

Here is the new quest order listing for this mod:

Warchief's Blessing [Horde] or Where Kings Walk [Alliance]
Death Knight assistance. [new custom quest]
More Death Knight assistance. [new custom quest]
Final Death Knight assistance. [new custom quest]

Included with the mod are the changes that need to be made to the playercreateinfo table for the new death knight starting areas.


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


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