If your having problems with your loot that drops for normal instances and heroics then look here how to fix, or you want to add new loot for non heroic and heroic instances then see below.
For Arcemu this is what you do.
Make sure your mysql is running:
Then using Navicat/SQLyog/Heidsql open your database and look for the loot_creatures table.
Should look like this:
So say you have made a new instance in say The Nexus. For normal loot you would set the percentchance to whatever percent you wanted but keep the heroicpercentchance at 0. This means that in heroic mode there is a 0% chance it will drop which is what we want.
But if you have custom items or non custom items that you only want to drop in heroic mode and not normal then you set the percentchance to 0 and the heroicpercentchance to whatever you want the % to be of it dropping.
When adding items just change the index to higher than the last number there.
Have the entry id higher than the last entry id
Have the itemid the id of the item you want to drop.
Percentchance just explained above
Heroicpercentchance explained above
Mincount is the minimum of the item to drop
Maxcount is the maximum of the item to drop
ffa_loot is free for all loot such as coins or junk items
Image of a custom item added to drop 50% in only heroic instances:
Hope it helped
Thanks
~2d~