Activate Defiant Drops

CruelCahal · #23 10-13-2012, 01:30 AM

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

Code:

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