PDA

View Full Version : Lootdrop table question


ionhsmith
09-27-2014, 11:21 PM
So i have been playing on my server testing it out a while now and noticed that really none of the defiant gears drops so i looked in the lootdrop_entry and typed in 50123 which is a flawed defiant BP and it has chance set to 0 and disabled chance set at 2.326 on lootdrop_id (this is one example) ... what do these two mean and how do i get the stuff to start dropping ?

KLS
09-27-2014, 11:42 PM
Disabled chance just is a place holder for chance cause there's no other way to disable a slot without deleting it except to set it's chance to drop to 0.

If you want to re-enable those drops you need to set the chance equal to what's in disabled chance for the appropriate drops.

ionhsmith
09-27-2014, 11:49 PM
ok so if chance is set to 0 then the stuff will never drop? how do i check which mobs will drop it? Thanksfor the response by the way

KLS
09-28-2014, 02:52 AM
npc_types have an entry 'loottable_id' which points to a loottable
loottable_entries with the matching loottable_id point to lootdrop_id
lootdrop_entries are what you're at right now and contain references to items

So you sort of need to go backwards given the lootdrop_id you have you need to find all the loottables that point to it. Then you need to go backwards from there and find each npc_type that points to that loottable.

scrubtasticx
09-28-2014, 03:34 PM
the easiest way to add defiant gear drops to your server (and i JUST did this yesterday for my hotzones) is use george's tools he has a npc loot editor it works wonders and it will also give you a great handle on where things are in the database also so you can edit them from navicat/hiedi in the future.

Uleat
09-28-2014, 05:19 PM
There's a post around here with a script that enables defiant drops.

I don't know if it would meet your expectations (or still work for that matter)..but, it might give you an idea of what you need.


EDIT: Here's the link: http://www.eqemulator.org/forums/showthread.php?t=33764&highlight=defiant

ionhsmith
09-28-2014, 07:36 PM
hmm is most all loot disabled when you start a server? And thanks Uleat I used that script and it changed my tables but not sure its working yet been playing several hours and still no drops. something i dont get though... for example in loottable_entries an ikaav miragenist has a loottable id of 13966 with a lootdrop id of 20169 with probability 100 and then there is another 13966 with a lootdrop id of 200007 with probability of 10 which is from the defiant activation.... it always drops the other stuff but not the defiant gear so does that 100 mean its 100% of the time and I need to adjust it?