I'm pretty sure I understand all of this conversation and it's right in line with what I figured out on my own, but I must be missing something because I can't seem to get my new loot to drop. My goal was this: Get all the mobs that are supposed to drop the "ornate defiant scepter" (item ID: 50557) to drop it.
I started by trying to get Hill Giants in Rathe Mts to drop it 100% of the time, just so I could see it drop and then I'd back the % off to about 5. Here's what I did:
1. Add an entry into lootdrop_entries. the previous high value was 90495 so I made mine 90496:
insert into lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES (90496, 50557, 1, 0, 100);
[Aside: does 'equip_item' mean the hill giant would have it equipped as his weapon?]
2. figure out that hill giants in rathe mts all use the same loot table (1839):
SELECT npc_types.id,npc_types.name,npc_types.loottable_id
FROM npc_types JOIN spawnentry ON npc_types.id=spawnentry.npcID
JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID
JOIN zone ON spawn2.zone = zone.short_name
where npc_types.name='a_hill_giant' and short_name='rathemtn';
3. Add a new entry into that loot table for my new loot drop, giving it a 100% chance of dropping:
insert into loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES (1839, 90496, 1, 100);
That seems pretty straight-forward to me, but none of my hill giants have dropped a scepter. What did I do wrong?
|