View Single Post
  #1  
Old 11-20-2011, 04:25 PM
Baruuk
Sarnak
 
Join Date: Aug 2005
Posts: 64
Default Adding a lootdrop to NPCs in level range?

Hi guys - been banging my head on the wall on this one for the last hour. I tried following some examples I found for the defiant drop thread, but didn't have any luck. Here's what I'm trying to do...

I have created a lootdrop_id (a unique one with 5% chance drop and multiplier of 1) with the PEQ Database Editor that contains 4 items that were already in the database. I simply want to assign my new lootdrop_id to ALL npcs in a specific level range (for example lvls 5-19).

I'm guessing I have to add my lootdrop_id to all NPCs level range 5-19's loottable - but I'd like to use a SQL command to do this instead of an editor. It's probably simple - but not exactly sure how to code it.

Would anyone know how the command to insert my lootdrop_id into all mobs lvl 5-19's loottable, thereby allowing players to randomly receive these items while hunting?

Thanks in advance.
Reply With Quote