Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 


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 02:54 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3