Incream defiant drop rate

[warkid]

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

[rencro]

Are you getting defiant to drop at all?

whats this query come back with?

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]

it list chance at 0 and droplimit as 1

[rencro]

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..

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]

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;