EQEmulator Forums - Incream defiant drop rate

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Incream defiant drop rate (https://www.eqemulator.org/forums/showthread.php?t=37493)

warkid

11-08-2013 07:03 PM

Incream defiant drop rate

how would i increase drop rate for Defiant gear? i found stuff about increasing al drops but thats not what i want

rencro

11-09-2013 02:31 PM

Are you getting defiant to drop at all?

whats this query come back with?

Code:

SELECT i.Name, i.id, ld.lootdrop_id, ld.chance, lt.droplimit

FROM lootdrop_entries ld 

INNER JOIN items i ON i.id=ld.item_id 

INNER JOIN loottable_entries lt ON ld.lootdrop_id=lt.lootdrop_id 

WHERE i.Name like '%defiant%' and ld.chance = 0;

I assume some 44000 hits or so?

warkid

11-10-2013 01:47 PM

it list chance at 0 and droplimit as 1

rencro

11-10-2013 03:48 PM

Not sure whats going on with the 40000ish with chance 0, too lazy to look deeply into it, but there are some 5000ish hits with chance != 0.. Lets up these..

Code:

UPDATE lootdrop_entries ld  

INNER JOIN items i ON i.id=ld.item_id 

INNER JOIN loottable_entries lt ON ld.lootdrop_id=lt.lootdrop_id 

SET ld.chance = ld.chance * 4

WHERE i.Name like '%defiant%' and ld.chance > 0 and ld.chance < 25;

That would increase the currently dropping Defiant gear by 4.

Hmm, wonder whats up with all those chance 0's?

warkid

11-11-2013 05:34 PM

when i try and run tha command... cmd dose not accept it .....
here is command i ran under cmd... to make defiant fropable

insert into lootdrop values (200002, 'Crude Defiant');
insert into lootdrop_entries select 200002, id, 1, 1, 3, 0, 0, 127, 1 from items where name like 'Crude Defiant%' and nodrop = 1;
insert into loottable_entries select distinct loottable_id, 200002, 1, 1, 0, 10 from npc_types where loottable_id > 0 and level between 1 and 4;

All times are GMT -4. The time now is 07:00 AM.