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)

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2018, 03:15 AM
Tegila
Hill Giant
 
Join Date: Mar 2018
Location: NY
Posts: 127
Default Fabled

I did some searching but didn't find what I'm looking for...

Has anyone put together code to blanket turn on and set spawnrate for Fabled? And turn back off, though I'd guess you really only have to change spawn rate to 0 to turn off. I know a lot are in the database just not on.

Also, has anyone filled out the rest of the fabled? Last I knew on live, fabled hadn't reached GoD2or OoW yet, though it's been a few years.
Reply With Quote
  #2  
Old 03-30-2018, 04:55 AM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 446
Default

You're kind of on the wrong thread for support questions regarding database editing, etc.
(a moderator might move this when noticed)
You should get yourself a good text editor (like Notepad++), which is good for creating and
editing all types of files, including quest scripts, configs and, in this case, .sql queries. It's a
totally free download found here:
https://notepad-plus-plus.org/downlo...-versions.html

These two simple examples set all zones as hotzones and all merc merchant's class to 71.
UPDATE zone SET hotzone = 1;
UPDATE npc_types SET class = 71 WHERE lastname LIKE '%Mercenary Liaison';


Putting those in an .sql query file and running it into database, or if your current database
front end can run those queries, then it speeds things up. But you would need to read up
a lot on the basics for sql. Things like this come in handy, like setting spawn info for a
particular type of NPC. There is many more advanced queries that can be done as well.
But we all learn to walk before we run
(By the way, "sql" stands for Structured Query Language)
Reply With Quote
  #3  
Old 03-30-2018, 10:03 PM
Tegila
Hill Giant
 
Join Date: Mar 2018
Location: NY
Posts: 127
Default

thanks man. i kinda thougth bc i was asking about the development of Fabled mobs, that are all relevant to fully covered expansion here (though added much later as fabled) and that some are here but many arent, maybe it was development, plus it being fabled time on live of course. some of my questions feel like they fit a couple categories sorry.
Reply With Quote
  #4  
Old 03-31-2018, 04:20 AM
c0ncrete's Avatar
c0ncrete
Dragon
 
Join Date: Dec 2009
Posts: 709
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
  #5  
Old 03-31-2018, 04:53 AM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 446
Default

Ya, we were discussing that here, in another thread :

http://www.eqemulator.org/forums/sho...t=41817&page=2
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 08:59 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 - 2018, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3