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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2008, 03:55 AM
RCPD0715
Sarnak
 
Join Date: Feb 2008
Posts: 67
Default Tedious!!!

Someone please tell me there is a better/easier way to add loot to a whole zone of mobs than one by one....I started just using George's NPC Loot editor to edit one by one mobs by looking them up on Alla and then searching for the item ID...WOW that takes a long time...any help? I am working on putting loot on all OoW mobs right now....so tired!!! thanks
Reply With Quote
  #2  
Old 04-16-2008, 06:35 AM
fault
Hill Giant
 
Join Date: Sep 2005
Posts: 114
Default

try using the PEQ Item Editor, located at the peq site (projecteq.net)


you can alternatively learn the database structure and use a sql query to update all said mobs with all loot you want them to have. mysql.com to learn about UPDATE INTO/REPLACE INTO and the syntax.
Reply With Quote
  #3  
Old 04-17-2008, 04:11 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

I just make a list of loot for the zone using Alla's or raidloot.com and then make loot tables. The only ones you have to do mob by mob are mainly the named that you want to have different loot tables.

If you have a bunch of trash mobs in the zone and you want them all to have the same loot, just make 1 loot table that you want for them and copy and paste that loot table ID down the line of mobs in that zone. I think adding loot is one of the easier things to making a custom server hehe. Takes a little time, but I can normally do it in an hour or so.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #4  
Old 04-17-2008, 07:01 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

The next version comming soon will have the ability to propogate fields across a search list, so if you search for you npc's in a zone and want to add a common drop to all, you'll be able to do so easily.

This was by request , a feature I think is good to have

I'll let you know when it's ready for prime time...

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #5  
Old 04-17-2008, 06:43 PM
RCPD0715
Sarnak
 
Join Date: Feb 2008
Posts: 67
Default

awesome!! thanks man...i would be lost without your tools
Reply With Quote
  #6  
Old 04-18-2008, 12:41 PM
thepoetwarrior
Discordant
 
Join Date: Aug 2007
Posts: 307
Default

Navicat Queries + NPC Loot Editor = Pwnage.
Reply With Quote
Reply


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 06:37 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