Looking for Defiant gear update

[Warkral]

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

[Warkral]

After several failed query's, this one appeared to work:

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 50;

/* Affected rows: 8,538 Found rows: 0 Warnings: 0 Duration for 3 queries: 0.124 sec. */

Just posting this in case anyone runs into the same problem. There are half a dozen or so query's that may or may not work so I like to always post so someone else doesn't have to start a redundant thread.

[N0ctrnl]

You could always just pull the info from a fresh database and stick it into yours. You'll learn a lot in the process. That's generally better than hunting for SQL queries somebody else wrote. Plus, you'll know the functionality of the tables better from working with them.

[Warkral]

Originally Posted by N0ctrnl

You could always just pull the info from a fresh database and stick it into yours. You'll learn a lot in the process. That's generally better than hunting for SQL queries somebody else wrote. Plus, you'll know the functionality of the tables better from working with them.

I admit, I never even thought of that. I wouldn't even know how to search through a database. I really need to take some courses in this stuff.