EQEmulator Forums - Looking for Defiant gear update

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Looking for Defiant gear update (https://www.eqemulator.org/forums/showthread.php?t=40835)

Warkral

08-15-2016 06:35 PM

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

Warkral

08-17-2016 02:39 PM

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.

N0ctrnl

08-17-2016 04:42 PM

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

08-17-2016 05:58 PM

Quote:

Originally Posted by N0ctrnl (Post 250588)

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.

All times are GMT -4. The time now is 06:25 PM.