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 10-31-2014, 03:25 PM
uwill
Sarnak
 
Join Date: Aug 2010
Posts: 45
Default Disabling defiant armor drops.

I searched the forums and it talked about editing lootdrop_entries to disable them, so I searched for defiant gear, found them in items@peq listed at 50005-50631. So I searched lootdrop_entries for 50005 and it's about a page long, I didn't know if this is the way to do it, or if there is a better way for disabling defiant gear from dropping. Thanks.
Reply With Quote
  #2  
Old 10-31-2014, 03:51 PM
devn00b's Avatar
devn00b
Demi-God
 
Join Date: Jan 2002
Posts: 15,658
Default

Quote:
Originally Posted by uwill View Post
I searched the forums and it talked about editing lootdrop_entries to disable them, so I searched for defiant gear, found them in items@peq listed at 50005-50631. So I searched lootdrop_entries for 50005 and it's about a page long, I didn't know if this is the way to do it, or if there is a better way for disabling defiant gear from dropping. Thanks.
SELECT le.* FROM items i
INNER JOIN lootdrop_entries le ON i.id = le.item_id
WHERE i.name like "Crude defiant%"


Change the WHERE clause to find the other types and just remove the rows all at once
__________________
(Former)Senior EQEMu Developer
GuildWars Co-Founder / World Builder.
World Builder and Co-Founder Zek [PVP/Guild Wars/City Takeovers]
Member of the "I hate devn00b" Club
Most Senior EQEMu Member.

Current Work: EverQuest 2 Emulator. Zeklabs Server
Reply With Quote
  #3  
Old 10-31-2014, 05:35 PM
uwill
Sarnak
 
Join Date: Aug 2010
Posts: 45
Default

Thanks again devn00b!
Reply With Quote
  #4  
Old 07-31-2017, 07:02 PM
Fridgecritter
Hill Giant
 
Join Date: Feb 2008
Posts: 188
Default

I've found a crap ton (slightly larger than a metric ton) of posts about defiant armor removal, and adding it, but does anyone know a quick and dirty way to raise the probability of the defiant drops? With bots and fast leveling, I would like to let players have more defiant armor to start with, but I don't want to hand it to them with a quest script or put it on a vendor. I would like it to be like a 10 percent chance.

Sorry for the necro.
Reply With Quote
  #5  
Old 08-01-2017, 12:48 PM
Fridgecritter
Hill Giant
 
Join Date: Feb 2008
Posts: 188
Default

I found it by doing a search for "lootdrop" The thread starter misspelled increase and spelled it incream LOL. Anyhow, here's the query I found. I ran it on a test database on localhost and it returned with 32K hits or something like that. When I compare the entries with the server database that's up and running, the numbers are more, but I wanted to get a few sets of eyes on this since it's from an old post. What do you think of this to increase defiant chance of drop?

I don't understand what most of this is doing with ld at the end, and INNER JOIN I'm gonna have to look up. I'm super interested in what this is doing when it runs.

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;
Reply With Quote
  #6  
Old 08-20-2017, 08:25 PM
The_Beast's Avatar
The_Beast
Discordant
 
Join Date: May 2016
Location: Under a rock
Posts: 290
Default

I've never tried this, (I've done my "cleanups" manually), but it's something that was posted last year.

http://www.eqemulator.org/forums/showthread.php?t=40357

http://xackery.github.io/eqcleanup/
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 03:28 AM.


 

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