Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Development

Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum)

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-31-2018, 04:20 AM
c0ncrete's Avatar
c0ncrete
Dragon
 
Join Date: Dec 2009
Posts: 719
Default

This will help get you started.

This query lists info on what Fabled NPCs are currently in the database. If there is no loottable_id listed, the NPC in question has no loot unless it's scripted. If there is no spawngroupID listed, the NPC in question can only spawn from scripts. If there is no NPC listed... that should be self-explanatory.
Code:
SELECT
  npc_types.id,
  npc_types.name,
  npc_types.loottable_id,
  spawnentry.spawngroupID
FROM
  npc_types
LEFT JOIN
  spawnentry
ON
  spawnentry.npcID = npc_types.id
WHERE
  npc_types.name
LIKE
  '%Fabled%';
Caveat: Just because there is a loottable or spawngroup ID does not mean the NPC will have loot or spawn. There are additional database tables involved in populating both spawns and loot.
__________________
I muck about @ The Forge.
say(rand 99>49?'try '.('0x'.join '',map{unpack 'H*',chr rand 256}1..2):'incoherent nonsense')while our $Noport=1;

Last edited by c0ncrete; 03-31-2018 at 04:27 AM.. Reason: added a caveat...
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 10:48 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3