Okay, this Guide is showing how you make a Custom (Already made?) Vendor, mob or NPC, drop a Custom (Already made?) Item. It starts with opening up HeidiSQL/Navicat/SQLyog.
1) Click 'Connect'
2) Find the Database Ascent (Or whatever yours is called) and find "Creatureloot"
3) Under Creatureloot, go to Data and click the black + (Insert Record)
4) There should be 8 Columns listed like so:
Code:
Entryid
Itemid
Percentchance
Heroicpercentchance
Mincount
Maxcount
ffa_loot
5) Index: Leave this at 0, it auto increases
6) Entryid: The Entry ID of the NPC/Mob/Vendor you want the Item to drop off.
7) Itemid: The Entry ID of the Item you want to drop off the NPC/Mob/Vendor.
Percentchance: The Percentage that the Item has of dropping (Note: If your Server droprate is increased, it may cause Items to drop at a higher chance)
9) Heroicpercentchance: The Percent chance the Item has of dropping on the Heroic setting (Usually set as 0)
10) Mincount: The minimum amount of the specific Items that drop (If set as 2, then 2 Items will drop min)
11) Maxcount: The maxiumum amount of the specific Items that drop (If set as 2, then 2 Items will drop max)
12) ffa_loot: Keep this at 0, unimportant (?)
13) Click 'Save' or 'Post Edit'
14) Restart your Server
15) The Item will now successfully drop off the NPC/Mob/Vendor!!
Okay, hope this helps
NOTE*: This Guide is for ArcEmu/Ascent and is working for 2.4x Servers. I do not take any fault if a Server that is not 2.4x has a crash or shutdowns because of this Guide. Use at your own risk (I doubt it could crash/shutdown a Server, but if it does, I do not take fault)