View Single Post
  #8  
Old 10-13-2007, 02:01 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

There's no bug.

If the skeletons are the same 'id' (and most common skeletons within a zone are) then they will have the same lootdrop_tables. The best way to randomise their drops is to specify 25% of them to get the loot . Run the query, then rerun it again several times. In this way, if you run it 4 times, the skeleton will have 4 different items , and randomly drop 1-4 based on chance.

My workflow -
I often specify 25% and a %chance of 25% per execution. Rerun 4 times to generate 4 random items. When npc dies, it will drop the item based on the % chance alone. you *will* get between 1-4 items per drop.

The % of all NPC to get the lootdrop input is simply a % of the npc's within the level range. If there are 4000 npc's level 1-10 in game , then *about* 1000 of them should get a random loot per run.


Also, if the npc's are within the same npc_id, then their drops will always be the same, but like I said above, rerun the program 4 times to generate a wider range of loot drops. It helps, but still limited to 4 possible items. You can rerun as many times as you wish.


GeorgeS




GeorgeS

__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote