EQEmulator Forums - Editing Loot Tables, Loot Drops

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=616)

- - Editing Loot Tables, Loot Drops (https://www.eqemulator.org/forums/showthread.php?t=15357)

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

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;