Activate Defiant Drops

[Baruuk]

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;

[Baruuk]

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!

[provocating]

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.

[werebat]

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.

[Shiny151]

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!

[Aeryn]

Originally Posted by Shiny151

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

#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

[Shiny151]

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!

[Warking]

I am also getting the same error:

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

[werebat]

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

[CruelCahal]

For anyone still looking for a working Defiant Loottable, try this, it should all be good.

#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.

[Warkral]

Originally Posted by CruelCahal

For anyone still looking for a working Defiant Loottable, try this, it should all be good.

#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.

[LordAdakos]

For the new loot system:

insert into lootdrop values (100001, 'Crude Defiant');
insert into lootdrop_entries select 100001, id, 1, 1, 3, 0, 0, 127, 1 from items where name like 'Crude Defiant%'; 
insert into loottable_entries select distinct loottable_id, 100001, 1, 1, 0, 4 from npc_types where loottable_id > 0 and level between 0 and 14;

I think ... (the script works, but im still figuring out possibilities)

[Shiny151]

Has anyone noticed if you add defiant based on these scripts you'll sometimes find mobs that are dropping defiant gear that's out of their range? For example, if i only want Elegant Defiant to drop by using this:

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, 1 from npc_types where loottable_id > 0 and level >= 70;

...only mobs equal or higher than level 70 should be dropping this. If I start with a clean database and use the above and then use George's Loot Editor to examine the mobs drop tables in BoT, I see random mobs below level 70 with Elegant gear in their drop tables. How can I prevent this so it stays strictly in range of the mobs level?

[vkrr]

I noticed that too shiny, I first thought it was a bug. Upon closer inspection it appears that there may be a loottable shared that is getting the same application of the loottable_entry. I havnt found a good fix yet, but i hope this info helps

[Shiny151]

I wonder if there's some sort of exclusion we can apply to the sql that if any mob tied to a table is lower than the the required range of the defiant gear that it doesn't add any defiant to the table. I'd prefer that option rather than having to clean up all the loot tables.