about drops

[sandy]

i don't understand well the item drop system
there is the % in loottable_entries
and the % in lootdrop_entries

it seems there is a chance there is 0 item dropped no ?
is the order of the item in lootdrop_entries important ? it seems it's always the 1rst ones in the list that drops the most, even if they have less % than other drops ...

in Everquest, on certain boss monsters, they always drop at least a minimum of items, they can't drop nothing, and they can always drop 2 times the same item like the avatar of war who always drop 3 items, 2 of them are always the same, ( 2 blades of carnage or 2 barbarian masks )
is it possible with eqemu to do the same ?

[Lurker_005]

It has been a while and I'm not looking at the DB so forgive me if I get the two tables backwards, and exactly how you figure the drop percentage...


loottable_entries
ID 1 "common loot" 100%
ID 2 "semi rare items" 50%
ID 3 "rare drops" 10%

Then in loodrop_entries
loottable_ID 1 "cloth armor" 50%
loottable_ID 1 "rusty weapons" 60%
loottable_ID 2 "plate armor" 40%
loottable_ID 2 "finesteal weapons" 70%
loottable_ID 3 "diamond" 100%


so you have three possible groups of items that will drop, in group 1 you always should get something, either cloth armor, or rusty weapons. Group 2 you will only get 50% of the time. Group three only 10% but it will always result in a diamond.

Like I said, I don't remember how you actually figure out the drop rate for each item. Do the % (or chance?) have to add up to 100? I'm not sure... anyhow that is how the tables work together to create different groups of items with different drop rates.

Hope that actually helps get you on the right track.

[Grim]

Hey I was messing with this yesterday, have been figuring out alot while populating Bastion of Thunder.

I had 30 spawns of something called Flame_Guard. For their loot table i had about 10 items.. 3 rare 1semirare like a spectral parchment and 6 junks like brick of ore etc. A probability of 4 was making an item drop about 2 per 30. Probability of 10 was much better about half dropped something all dropped coin.

Now to make the junk drop more often i just edited under lootdrop_entries table the CHANCE colum. Make junk higher % like 15
medium 6% gooddrops 5% and rare 3%.. I've yet to see the rare item i added which is great. And after and hour i saw 3 parchments and 1 good item.

Now as i added about 40 or more spawns that pulled from that loot table the drop rate of ANY item dropped to nothing.. SO i think i have to up the PROBABILITY column under loottable for that loot ID.

Maybe Double it accordingly as i ad spawns to pull from that.


For the named i have about 10 spawns all pulling from a loot id of 12529.. filed under id 12529 I have about 40 items all decent to rare. I wanted them always to drop something since they are more rare on the spawn timer. Seems to work great with a probability of 100 and changing the chance of each item to 10% for decent items and like 6-8% for the better items..

Now when a new DB comes out I'm not going to want it=\ all this work hehe.

[a_Guest03]

You could volunteer to help with the master databases - tcsmyworld could probably use the help.

[Grim]

I'm good at adding spawns and have figured out the loot tables pretty quick. I'd love to help with the database in anyway i can. I'm using TCS which i think is a great DB, and im currently trying to figure out how to add zone lines and zone points... Such as in BoT which i have 50%populated.. The red lighting strands that are there to run into and put you above to next level to continue fighting. Then run through more and zone within BOT to next level up and so forth.

Oh and don't assign spellsID to any npc.. like mages In BOT when mages cast their pets my lagometer went from 67 to perma 6000+ and kept disconneting me and my girlfriend.. so i troubleshooted and figured out that was the problem. WHen they don't have pets it is fine.

Any help on Zonelines and zoning within a zone would be greatly appreciated.. and im glad to share tips and what i've learned as well. I don't know C++ or any other programming lanquage but i've picked up on this Database quickly using mysql control center.

Grim

[Grim]

I'm good at adding spawns and have figured out the loot tables pretty quick. I'd love to help with the database in anyway i can. I'm using TCS which i think is a great DB, and im currently trying to figure out how to add zone lines and zone points... Such as in BoT which i have 50%populated.. The red lighting strands that are there to run into and put you above to next level to continue fighting. Then run through more and zone within BOT to next level up and so forth.

Oh and don't assign spellsID to any npc.. like mages In BOT when mages cast their pets my lagometer went from 67 to perma 6000+ and kept disconneting me and my girlfriend.. so i troubleshooted and figured out that was the problem. WHen they don't have pets it is fine.

Any help on Zonelines and zoning within a zone would be greatly appreciated.. and im glad to share tips and what i've learned as well. I don't know C++ or any other programming lanquage but i've picked up on this Database quickly using mysql control center.

Grim