Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::General Support

Archive::General Support Archive area for General Support's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
  #1  
Old 08-15-2004, 12:20 PM
CHowell2005
Hill Giant
 
Join Date: Oct 2003
Posts: 104
Default Editing Loot Tables, Loot Drops

I am planning on changing the loot drops/tables...i want all items to drop 100% of the time. By this i do not mean to have a mob with a lootdrop table of low level gems to drop every single gem in that table, but rather have a 100% chance to drop 1 gem from that table. This will be the same case for armor tables ect. But I do want to change the lootdrops for "special"/named items..the good stuff...to 100%....I know how to do this by hand and started a long time ago...but as you know doing this case by case would take quite some time...I am not complaining or whining...just asking if anyone has any suggestions/tips/work arounds that could help me out....danke
  #2  
Old 08-16-2004, 10:49 AM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

Look in the `loottable_entries` table in the database. Change the "probability" field to 100 for all records.

Once you're at a MySQL prompt, a simple SQL statement will do this for you:

Code:
UPDATE loottable_entries SET probability=100;
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
 


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 04:25 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