View Single Post
  #1  
Old 10-26-2009, 06:11 PM
rencro
Hill Giant
 
Join Date: Sep 2008
Location: So. California
Posts: 219
Default 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...
Reply With Quote