View Single Post
  #1  
Old 08-15-2016, 06:35 PM
Warkral
Sarnak
 
Join Date: May 2011
Posts: 56
Default Looking for Defiant gear update

Hey all. With the recent changes I was wondering, is Defiant gear set to drop or turned off? What I am looking to do is delete all Defiant gear except crude, and change the drop levels to 1-60. This worked in the past:

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

But now no longer works. Ideas?

EDIT: I found the correct query to disable all Defiant gear, now I just need to insert Crude
Reply With Quote