EQEmulator Forums - Activate Defiant Drops

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

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Activate Defiant Drops (https://www.eqemulator.org/forums/showthread.php?t=33764)

Hmm trying this again with the pasted code below. You had nodrop = 1 above. However when I look at Crude Defiant items in the database they are marked as tradeable. I'm trying this again with:

#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 0 and 4;

Yep that did it - thanks Werebat. That's what I get for modifying the code :) I had changed the nodrop to 0 instead of 1. It populated fine this time. Now I just need code to remove nodrop from items :) I'll look that up thanks again!

Pardon my asking, but what would be the easiest way to completely remove a Lootdrop_ID from all NPCs from lvl 1-4? For example, I had created the Lootdrop_ID of 100001 for those level ranges, but now that I no longer need it (and it is in every mob lvl 1-4's loot table), I'd like to remove it. I'm guessing it's a SQL query - I'm just a tad new to those.

Thanks!

Quote:

Originally Posted by Baruuk (Post 203492)

Now I just need code to remove nodrop from items :) I'll look that up thanks again!

Code:

update variables set value=1 where varname='DisableNoDrop';

Anyone find a work around to get these drops rates lower ? I too like the idea of any mob having the potential to drop something, but 1% seems way too high. I can already tell from a week of killing that 1% global will be too high. Maybe .05 would be a good number. What about maybe a filler item that is nothing ? I guess that would not work either though.

You could "dilute" it. For example, if you have a lootdrop made up of a crude defiant bracer set at 1%, then it will have a 1% chance of dropping. Now if you add a ration or some other item to that lootdrop, then there is a 1% chance of dropping either one based on their pcts.

Ration 50%
Defiant Armor Piece 50%
Lootdrop at 1% means there is a .05 (half a percent) chance of dropping the defiant piece.

Ration 90%
Defiant Armor Piece 10%
Lootdrop at 1% means there is a .01 (tenth of a percent) chance of dropping the defiant piece.

That is how I understand it. I have a solo server so when a defiant drop occurs it usually not usable by my class so it is still rare for me to find one I can actually use. I also did the same with the Melee Augments and Gloomingdeep items since I dont use the tutorial.

In another post, the same thing was suggested. I think I am going to do that.

Would anyone have an update to this code? In the most recent database this code doesn't work anymore. I get an error of:

* SQL Error: Column count doesn't match value count at row 1 */

Thanks!

Quote:

Originally Posted by Shiny151 (Post 209876)

Would anyone have an update to this code? In the most recent database this code doesn't work anymore. I get an error of:

* SQL Error: Column count doesn't match value count at row 1 */

Thanks!

Just needs min and max levels adding to lootdrop entries

Code:

#add defiant drops

insert into lootdrop values (100001, 'Crude Defiant');

insert into lootdrop_entries select 100001, id, 1, 1, 2, 0, 127 from items where name like 'Crude Defiant%' and nodrop = 1; 

insert into loottable_entries select distinct loottable_id, 100001, 1, 4 from npc_types where loottable_id > 0 and level between 0 and 4;



insert into lootdrop values (100002, 'Simple Defiant');

insert into lootdrop_entries select 100002, id, 1, 1, 2, 0, 127 from items where name like 'Simple Defiant%' and nodrop = 1; 

insert into loottable_entries select distinct loottable_id, 100002, 1, 4 from npc_types where loottable_id > 0 and level between 5 and 14;



insert into lootdrop values (100003, 'Rough Defiant');

insert into lootdrop_entries select 100003, id, 1, 1, 2, 0, 127 from items where name like 'Rough Defiant%' and nodrop = 1; 

insert into loottable_entries select distinct loottable_id, 100003, 1, 4 from npc_types where loottable_id > 0 and level between 15 and 25;



insert into lootdrop values (100004, 'Ornate Defiant');

insert into lootdrop_entries select 100004, id, 1, 1, 2, 0, 127 from items where name like 'Ornate Defiant%' and nodrop = 1; 

insert into loottable_entries select distinct loottable_id, 100004, 1, 4 from npc_types where loottable_id > 0 and level between 26 and 36;



insert into lootdrop values (100005, 'Flawed Defiant');

insert into lootdrop_entries select 100005, id, 1, 1, 2, 0, 127 from items where name like 'Flawed 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 37 and 47;



insert into lootdrop values (100006, 'Intricate Defiant');

insert into lootdrop_entries select 100006, id, 1, 1, 2, 0, 127 from items where name like 'Intricate Defiant%' and nodrop = 1; 

insert into loottable_entries select distinct loottable_id, 100006, 1, 4 from npc_types where loottable_id > 0 and level between 48 and 58;



insert into lootdrop values (100007, 'Elaborate Defiant');

insert into lootdrop_entries select 100007, id, 1, 1, 2, 0, 127 from items where name like 'Elaborate Defiant%' and nodrop = 1; 

insert into loottable_entries select distinct loottable_id, 100007, 1, 4 from npc_types where loottable_id > 0 and level between 59 and 69;



insert into lootdrop values (100008, 'Elegant Defiant');

insert into lootdrop_entries select 100008, id, 1, 1, 2, 0, 127 from items where name like 'Elegant Defiant%' and nodrop = 1; 

insert into loottable_entries select distinct loottable_id, 100008, 1, 4 from npc_types where loottable_id > 0 and level >= 70;

Not something i use myself, but should work

Quote:

Just needs min and max levels adding to lootdrop entries

Yes I noticed that too and tried this. For some reason I received the same error. I'll try it again this weekend. Perhaps I'm overlooking something.

Thanks!

I am also getting the same error:

SQL Error: Column count doesn't match value count at row 1 */

The recent loot system changed the table structures. I fixed it to match the new table structures but have not posted yet.

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.

Quote:

Originally Posted by CruelCahal (Post 213288)

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.

This worked perfectly. For those of us without the knowledge to write this, thank you very much.