After several failed query's, this one appeared to work:
Code:
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.
Threaded Mode
