Hey recently I was messing around on my sql and seen a way how to have custom loot from npc's. This is very handy if you want a custom instance. Onto the tut!
First:
If you want to have a custom boss/npc, go to WoW Vendetta - Wage Your War | WoW-V.com and create an account,
then at the top click mob/npc. Insert the sql code into your sql when your done. If you want the boss to
have custom loot, create a custom item the same way.
Second:
Go into your SQL database, and go under World -> Loot_creatures. Create a new entry. For index put a couple of random numbers(not important), for entry id,
put the id you would use to spawn the boss, so if you created an npc with the entry # 99889, then the entry id would be 99889. The item id is the same thing,
it is what you would enter to spawn it ingame(.char additem ####). Percent and heroic percent chance are the chances of it dropping in an instance of that difficulty.
So if you wanted it to drop 90%, put 90, not 0.9. Min/ Max count are the amount(s) to be dropped. Leave ffa loot at 0.
Third:
Restart you server, enjoy!