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-04-2018, 06:37 AM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default Defiant - Global Loot ?

Was reading this in the PEQ Changelog : (Feb, 2018 ) Silly me, wasn't up to date on this, haha

- Global Loot Tables implemented

- Defiant has been moved to global loot tables now

Found here:
http://peqtgc.com/forums/index.php?t...11-2018.15417/

It did mention something in the source code changelog about a global loot system, but I didn't
pay much attention to it at the time.

I did notice, (an empty) global_loot table in DB, as well as skip_global_loot in npc_types table,
which "I think" is supposed to have a value of 0 or 1. Current value for all npc_types is set to 0
Have no idea if this is going to be something easier to work with for loot, but I have to get it
all figured out and how it works. My bucket list is galloping, while I'm trotting :P
Reply With Quote
  #2  
Old 04-04-2018, 12:19 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,164
Default

optional/2018_02_11_GlobalDefiant.sql

Use the editor. Only thing it can't do right now is create the tables, but you can attache the tables to a dummy NPC, make it, then make global_loot entries with the editor and detach the loot table from the dummy NPC. (At least until the editor lets you edit loot tables not attached to NPCs)

skip_global_loot does exactly what you think (the devs stated their global loot system they can flag NPCs to not check global loot, so that's what we do)
Reply With Quote
  #3  
Old 04-04-2018, 01:38 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Ok, that points us all in the right direction. Thank you very much Sir
Reply With Quote
  #4  
Old 08-20-2018, 12:59 AM
eldarian's Avatar
eldarian
Fire Beetle
 
Join Date: May 2017
Posts: 25
Default

So im not sure why this field was added in a more recent version (compared to fall of 2017) but when i migrated to a remote host for my server from my desktop this caused an issue, stating this table was unknown " npc_types.skip_global_loot
" so i removed the column and my npc then spawned. When i had this column enabled it would not spawn a single npc in the world, if u need more help feel free to find me on the eqemu discord.
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 05:21 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