Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2019, 08:51 AM
woton
Sarnak
 
Join Date: Mar 2019
Posts: 88
Default boosting drops

Found info on a different thread about boosting drop rates for armor. Changed the drop rate for crude defiant armor in the database to 100% to test and it didn't seem to work. Lucky to get 1 crude defiant with a full clear of crushbone.

http://www.eqemulator.org/forums/sho...hlight=defiant

http://www.eqemulator.org/forums/sho...hlight=defiant

Any help is appreciated.
Reply With Quote
  #2  
Old 11-04-2019, 10:37 AM
jaspen
Hill Giant
 
Join Date: Apr 2016
Posts: 107
Default

Visible pieces of defiant gear are now handled through global loots. Probably best to modify using one of the editors. The non-visible pieces still have not been removed from the npc loot tables and are not in global loot (Unless something very recent has taken place). They are also not comprehensive in the drops.
Reply With Quote
  #3  
Old 11-04-2019, 07:36 PM
woton
Sarnak
 
Join Date: Mar 2019
Posts: 88
Default

we have the crude defiant enabled, just cant seem to increase the drop chance. from what we can see, it says the drop chance is 100 or even more sometimes, but it just wont drop that often.
Reply With Quote
  #4  
Old 11-04-2019, 07:48 PM
Nukerella's Avatar
Nukerella
Fire Beetle
 
Join Date: Jun 2015
Location: Canada
Posts: 28
Default

The tables themselves might have a lower drop chance, or a min/max drop of 0. Increasing these will likely have them drop more often but they may also be mixed in on the tables with other items that you may not want to drop so often, so you will need to go over each table to make sure you are not messing something else up on each table. Perhaps moving them to a separate table altogether will be what you need to do.
Reply With Quote
  #5  
Old 11-04-2019, 11:08 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I bumped the probability of mine up to 18 and noticed a pretty major increase in drop rates.






Code:
SELECT `a`.* FROM `loottable_entries` `a`
INNER JOIN `loottable` `b` ON `b`.`id` = `a`.`loottable_id`
INNER JOIN `global_loot` `c` ON `c`.`loottable_id` = `b`.`id`

Note: I have the 'accoutrements' added to my database..should only be about half of those results.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #6  
Old 11-05-2019, 09:15 AM
woton
Sarnak
 
Join Date: Mar 2019
Posts: 88
Default

appreciate all the replies, will try to do this tonight.

Just finished and got it to work, thx guys.
Reply With Quote
Reply

Thread Tools
Display Modes

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 08:18 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