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

I wanted to share these SQL queries that I use on my server. I learned a few basics of SQL and created nearly all of them myself since I could never find anyone who offered these types of queries. My server only hosts a very small group of personal friends and we mainly PVE and craft. These queries focus mainly on that.

Feel free to use and edit these queries if you find any useful. The queries are structured to make broad adjustments on the DB table in question.

I use these queries on the TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit repack (which is a great repack) and they work great. They should work fine with other mangos based repacks as well.

Check out the details below on what DB tables are effected.

The download link for all the SQL files is at the bottom of this post.


creature_loot_template
-- NPC increase to drop percentage for percentages between 0 and 1

creature_template
-- Money drops for creatures that do not drop money
-- All NPC's give honor points

disenchant_loot_template
-- Increase disenchant min and max resource drop rates

fishing_loot_template
-- Increase fishing min and max resource drop rates

skinning_loot_template
-- Increase skinning min and max resource drop rates

milling_loot_template
-- Increase milling min and max resource drop rates

gameobject_loot_template
-- Increase drop rates on mineral veins and herbs

item.template
-- Soul Shards stack in groups of 50 up to 500 in inventory
-- Adds 4 slots to all bags that originally started with 28 or less
-- Increase all armor by 10%

npc_vendor
-- Remove NPC Vendor time constraints
-- Remove NPC Vendor limits

player_classlevelstats
-- Increase player base HP and Mana levels by 10% for all levels

player_levelstats
-- Increase all player base attributes +1 for all levels

playercreateinfo_item
-- Added 1 Foror's Crate of Endless Resist Gear Storage to all classes.
-- Added 1 Shortsword and 1 Large Round Shield to the Paladin class.

playercreateinfo_spell
-- Added one-Handed Sword skill ability to Human, Dwarf, & Draenei Paladin class.
-- Added one-handed sword skill ability to all Warlocks.
-- Added Regeneration racial bonus to all Priests and Mages. (Except Troll which have this ability already.)
-- Added Expansive Mind racial bonus to all Priests and Mages. (Except Gnome which have this ability already.)
-- Added Regeneration racial bonus to all Rogues. (Except Troll which have this ability already.)
-- Added Endurance racial bonus to all Warriors. (Except Tauren which have this ability already.)
-- Added Endurance racial bonus to all Hunters. (Except Tauren which have this ability already.)
-- Added Regeneration racial bonus to all Hunters. (Except Troll which have this ability already.)
-- Added Heroic Presence racial bonus to all Hunters. (Except Draenei which have this ability already.)
-- Added Expansive Mind racial bonus to all Warlocks. (Except Gnome which have this skill already.)


Filebeam - Beam up that File Scottie!

OR

Mangos DB SQL mods - Pastebin.com