EQEmulator Forums - View Single Post - MW_052_053_alpha2 (released 12-21-03)

r2d2atemyhomework · #14 12-23-2003, 07:16 AM

Also if you want to make sure you get loot (but no drops) off of every kill with this database, run the following in mysql:

Code:

update npc_types set loottable_id = 1 where level &lt;= 10 and loottable_id = 0;
update npc_types set loottable_id = 2 where level > 10 and level &lt;=20 and loottable_id = 0;
update npc_types set loottable_id = 3 where level > 20 and level &lt;=30 and loottable_id = 0;
update npc_types set loottable_id = 4 where level > 30 and level &lt;=40 and loottable_id = 0;
update npc_types set loottable_id = 5 where level > 40 and level &lt;=50 and loottable_id = 0;
update npc_types set loottable_id = 6 where level > 50 and level &lt;=60 and loottable_id = 0;
update npc_types set loottable_id = 7 where level > 60 and loottable_id = 0;

Again it's not accurate, but it's better than nothing. This query will maintain any existing loottable values NPCs already have.