Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2013, 07:03 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default Incream defiant drop rate

how would i increase drop rate for Defiant gear? i found stuff about increasing al drops but thats not what i want
Reply With Quote
  #2  
Old 11-09-2013, 02:31 PM
rencro
Hill Giant
 
Join Date: Sep 2008
Location: So. California
Posts: 219
Default

Are you getting defiant to drop at all?

whats this query come back with?

Code:
SELECT i.Name, i.id, ld.lootdrop_id, ld.chance, lt.droplimit
FROM lootdrop_entries ld 
INNER JOIN items i ON i.id=ld.item_id 
INNER JOIN loottable_entries lt ON ld.lootdrop_id=lt.lootdrop_id 
WHERE i.Name like '%defiant%' and ld.chance = 0;
I assume some 44000 hits or so?
Reply With Quote
  #3  
Old 11-10-2013, 01:47 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

it list chance at 0 and droplimit as 1
Reply With Quote
  #4  
Old 11-10-2013, 03:48 PM
rencro
Hill Giant
 
Join Date: Sep 2008
Location: So. California
Posts: 219
Default

Not sure whats going on with the 40000ish with chance 0, too lazy to look deeply into it, but there are some 5000ish hits with chance != 0.. Lets up these..

Code:
UPDATE lootdrop_entries ld  
INNER JOIN items i ON i.id=ld.item_id 
INNER JOIN loottable_entries lt ON ld.lootdrop_id=lt.lootdrop_id 
SET ld.chance = ld.chance * 4
WHERE i.Name like '%defiant%' and ld.chance > 0 and ld.chance < 25;
That would increase the currently dropping Defiant gear by 4.

Hmm, wonder whats up with all those chance 0's?
Reply With Quote
  #5  
Old 11-11-2013, 05:34 PM
warkid
Hill Giant
 
Join Date: Sep 2013
Location: Barnsley england
Posts: 120
Default

when i try and run tha command... cmd dose not accept it .....
here is command i ran under cmd... to make defiant fropable

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 4;
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:39 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3