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...
|