Activate Defiant Drops

[CruelCahal]

For anyone still looking for a working Defiant Loottable, try this, it should all be good.

#add defiant drops
insert into lootdrop values (300000, 'Crude Defiant');
insert into lootdrop_entries select 300000, id, 1, 1, 2, 0, 127, 1 from items where name like 'Crude Defiant%' and nodrop = 1; 
insert into loottable_entries select distinct loottable_id, 300000, 1, 4, 1, 0 from npc_types where loottable_id > 0 and level between 0 and 4;

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

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

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

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

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

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

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

You can, of course, change the loottable ID to values other than 300000-300007 or any other value you would prefer to change but this will get you set up for the drops.

[Warkral]

Originally Posted by CruelCahal

For anyone still looking for a working Defiant Loottable, try this, it should all be good.

#add defiant drops
insert into lootdrop values (300000, 'Crude Defiant');
insert into lootdrop_entries select 300000, id, 1, 1, 2, 0, 127, 1 from items where name like 'Crude Defiant%' and nodrop = 1; 
insert into loottable_entries select distinct loottable_id, 300000, 1, 4, 1, 0 from npc_types where loottable_id > 0 and level between 0 and 4;

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

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

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

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

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

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

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

You can, of course, change the loottable ID to values other than 300000-300007 or any other value you would prefer to change but this will get you set up for the drops.

This worked perfectly. For those of us without the knowledge to write this, thank you very much.