Activate Defiant Drops

[vkrr]

you'd have to compare the loottable assigned to the mob to any other mob with the assigned loot table.
Someone who knows more about SQL than I would have to help you out, though.

Theorycrafting:
Compare loottable assigned to any mob with all other mobs who have the same loottable
if any of them are lower than X, don't add it, otherwise, add it.

maybe something like this for starters (assuming these are the right table and column names)

select * from lootdrop INNER JOIN npc_types on lootdrop.id = npc_types.lootdrop_id;
select lootdrop .*,npc_types .*  from lootdrop ,npc_types  where  lootdrop.id = npc_types.lootdrop_id;

[Shiny151]

I'm not versed well enough to figure this one out; I'm only slightly dangerous with sql. Perhaps you and werebat can put your heads together and figure this one out. Seems like you're on the right path though.

Originally Posted by vkrr

you'd have to compare the loottable assigned to the mob to any other mob with the assigned loot table.
Someone who knows more about SQL than I would have to help you out, though.

Theorycrafting:
Compare loottable assigned to any mob with all other mobs who have the same loottable
if any of them are lower than X, don't add it, otherwise, add it.

maybe something like this for starters (assuming these are the right table and column names)

select * from lootdrop INNER JOIN npc_types on lootdrop.id = npc_types.lootdrop_id;
select lootdrop .*,npc_types .*  from lootdrop ,npc_types  where  lootdrop.id = npc_types.lootdrop_id;

[MisifuWiki]

For to me any of the scrips posted in this thread works for me at peqdb 2506 , anyone can make defiant works ??

[MisifuWiki]

I try differents scripts and finally i got one wich work with db rev2506 /Cheers !!!! Then i will share with you all.


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;

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

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

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

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

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

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

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


And this is all folks !!!

[warkid]

what do i edit to increase drop rate? the 10 or something els?

[Furniture]

just thought i should add that while that query will remove defiant drops, theres many more pieces of defiant type gear that still drops, as well as augments, tradeskill items, etc.

Just a warning for those looking to get rid of all out of era stuff like defiant out of their database

[dagulus2]

shouldent this be 'SET peq.lootdrop_entries.probability = 0' rather than 'SET peq.loottable_entries.probability = 0' ?

[sorvani]

Depends. If the defiant is always on its own loot drop you can. Otherwise setting the specific entry to zero makes just that item in the loot drop not get rolled.

[werebat]

This sql will remove all defiant from lootdrops. It also includes the combatant and adept stuff which is pretty much defiant for other slots.

delete from lootdrop_entries
where item_id in (select id from items where name regexp '(Crude|Simple|Rough|Ornate|Flawed|Intricate|Elabo rate|Elegant)( Defiant| Combatant| Adept)');

[Bohbo]

With some of the new DB Fields / Updates the code doesn't match the column count. For anyone having trouble try this structure.

See the 2 highlighted values. This will match up the column count.

insert into lootdrop_entries select 100001, id, 1, 1, 2, 0, 0, 127, 1 from items where name like 'Crude Defiant%' and nodrop = 1;