You can add and remove loot from any npc in your database. If you are new then the simplest way would be to use the npc_loot editor. It can be found here:
http://www.georgestools.eqemulator.n...qEmu_Files.zip
If you want to learn how it actually works then you can create everything manually. The following example uses custom id's so using it on your database WILL NOT work.
loottable & lootdrop example:
Code:
delete from lootdrop where id = 750022;
INSERT INTO `lootdrop` (`id`, `name`) VALUES (750022, 'Ashengate_Normal');
delete from loottable where id = 750022;
INSERT INTO `loottable` (`id`, `name`, `mincash`, `maxcash`, `avgcoin`) VALUES (750022, 'Ashengate_Normal', 100000, 300000, 0);
delete from loottable_entries where loottable_id = 750022;
INSERT INTO `loottable_entries` (`loottable_id`, `lootdrop_id`, `multiplier`, `probability`) VALUES (750022, 750022, 1, 7);
INSERT INTO `loottable_entries` (`loottable_id`, `lootdrop_id`, `multiplier`, `probability`) VALUES (750022, 750023, 1, 5);
delete from lootdrop_entries where lootdrop_id = 750022;delete from lootdrop_entries where lootdrop_id = 750023;
INSERT INTO `lootdrop_entries` (`lootdrop_id`, `item_id`, `item_charges`, `equip_item`, `chance`) VALUES (750022, 219834, 1, 0, 50);
INSERT INTO `lootdrop_entries` (`lootdrop_id`, `item_id`, `item_charges`, `equip_item`, `chance`) VALUES (750022, 219835, 1, 0, 50);
INSERT INTO `lootdrop_entries` (`lootdrop_id`, `item_id`, `item_charges`, `equip_item`, `chance`) VALUES (750023, 219616, 1, 0, 5);
After creating the above you will need to assign the loottable_id to the npc you want the loot to drop from. In this case inserting loottable_id 750022 into an npc's loottable_id field would cause that npc to drop the specified items.