Multiple Loot drops same mob
 

Hi, I am trying to customize my world and have run into an issue that I'm unsure of. I was able to succesfully change in Kurns Tower zone, exp rate, respawn time, removal of place holder type mobs ect,

The issue is with npcid 97075, now made to be a 100% spawn, and originally had one lootdrop_id in its loottable_entries. In its original lootdrop_entries there were two items, 14757, and 14771, with 50% chance of drop each. I wanted to make sure both items dropped every time.. I edited item 14757 to be 100 on chance in lootdrop_entries and created a new lootdrop_id based on the same loottable_id. And then made 14771 part of the new lootdrop with 100 chance. The problem I had was only 14757 dropped in game..

Here is a summary of my sql, pardon the formatting...

select * from loottable_entries where loottable_id = 5764;

loottable_id lootdrop_id multiplier Probability
5764 10822 1 100
5764 110822 1 100

This shows the new lootdrop created with 100 chance, I assume multiplier comes into effect if there a re multiple items in a lootdrop_entries, so in this case, since both are single drop lootdrops, it does not apply?

select * from lootdrop_entries where lootdrop_id = 10822;

lootdrop_id item_id item_charges equip_item chance
10822 14757 1 1 100

select * from lootdrop_entries where lootdrop_id = 110822;

lootdrop_id item_id item_charges equip_item chance
110822 14771 1 0 100

Anything Im not doing right, or maybe my presentation is not proper for help?

I eventually want to apply this to all zones, and Ill use Avatar of War as an example. I want to be able to have all items drop 100 percent on kill, as above.
AVATAR of WAR

select all from loottable_entries where lootdrop_id = 13024;

loottable_id lootdrop_id multiplier propability
7164 13024 4 100

select * from lootdrop_entries where lootdrop_id = 13024;

lootdrop_id item_id item_charges equip_item chance
13024 25208 1 1 17
13024 25209 1 1 17
13024 25010 1 1 17
13024 25211 1 1 17
13024 25212 1 1 17
13024 25213 1 1 16


Would I need to create new lootdrops for each item or could I make all items 100 chance in this table? I assumed the chance needed to add up to 100, though this adds to 101...

make sure that in lootdrop table your lootdrop id has an entry with a NAME, anything that doesn't have a lootdrop name won't drop

BTW why don't you use George npc editor? makes working with loot very very easy, and you will be able to see if something is wrong with your tables right away.

Okay I made an error when I posted the AVATAR of war stuff as item 25212 is 16%, so it does add up to 100%...

I make all changes in query format and then source them in, so that I can see what changes I've made, and also if I update the database I can re-source my queries to get back my custom content. I assumed Georges did not leave a trail of sql changes behind?

I do use geoge's utils to verify and look up though. In this case when I use George's npc editor and I plug in npcid 97075, it comes up with "Bargrynn" and in the lootdrop window, both lootdrop id's show up, as in the sql above. Also when I click an individual lootdrop in the window, it shows me the item drops, and again, they are same as in the above posted sql dumps..

The only difference is the EQUIPED is yes on the original working drop, and NO on my custom..If that could be the cause..I also made both these items ARTIFACTS..

I am using PEQ database but I felt this was more an emulator question, sorry if im wrong..I'll keep plugging away until I get it right. Thanks for the reply..