Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2015, 10:14 PM
Pdizzle
Sarnak
 
Join Date: Nov 2013
Location: United States
Posts: 32
Default How to add random items to all mobs

Disclaimer: I'm completely new to building a server, and new to database management. I have some coding experience, but that's about it.

I have Akka's Repack up and running just fine, but now I'm at the beginning stages of playing with the database. I've done a good bit of reading, and I'm sure I have a long way to go but thought I'd ask a couple questions to get me started.

Basic Idea: I'd like to make it so NPCs have a chance to spawn with a random item from the entire item database (in addition to their regular drops).

Advanced Idea: I'd like to do what's described in the "Basic Idea" above, but add criteria changing the chance for the higher level items based on the NPC level (while still making it possible for low level NPCs to drop any item).

In my research I've uncovered two tools (Akka's Diablo loot tool and Georges Diablo tool), but I'm not sure they can accomplish what I want. My very basic understanding of the tools is the following:
Akka's Tool: From what I can tell the tool can generate random items on NPCs when they spawn, but it seems like it only provides items appropriate for the NPC level. Please correct me if I'm wrong.
Georges Tool: I couldn't find any information about this tool. I found a forum post and verbiage on his website that direct me to help/videos for information, but I couldn't find help/videos anywhere.
I'd appreciate any guidance for my request. Thanks in advance! I'm still trying to understand how the different NPC and loot tables connect, and trying to learn query syntax at the same time. On another note, I couldn't find any youtube tutorials dealing with eqemu database alterations. Are there good tutorials/resources out there?
Reply With Quote
  #2  
Old 04-13-2015, 01:49 AM
Furniture
Hill Giant
 
Join Date: Aug 2012
Posts: 205
Default

Easiest way may be to use a single global perl script where it the rolls a random item id number and adds it to its loot table upon spawning or death
Reply With Quote
  #3  
Old 04-28-2015, 08:33 AM
Leetsauce
Hill Giant
 
Join Date: Apr 2010
Posts: 169
Default

http://www.eqemulator.org/forums/showthread.php?t=38286

This is what I used. You can manually define the ID's that it randoms so as to control the outcome. I did this in not only the global_npc.pl in the global folder, but I also do it in the default.pl of certain zones.
Reply With Quote
Reply

Thread Tools
Display Modes

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:09 AM.


 

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