EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Feature Requests (https://www.eqemulator.org/forums/forumdisplay.php?f=612)
-   -   Removing fabled spaws (https://www.eqemulator.org/forums/showthread.php?t=39433)

Kilur 03-03-2015 09:18 PM

Removing fabled spaws
 
Is there a way to remove fabled spawns from a server? I didnt see a setting for it, but is there a sql or something that can be run to remove just the fabled spawns but leave the rare spawns in the game? It would be awesome if there was a server setting for this!

Kingly_Krab 03-03-2015 09:27 PM

Well, you could write a rather elaborate SQL, or you could just run this to pull up all the spawn entries of fabled mobs.
Code:

SELECT
    s.*
FROM
    `spawnentry` s
INNER JOIN `npc_types` n ON s.`npcID` = n.`id`
WHERE
    n.`name` LIKE '%Fabled%';


Kilur 03-07-2015 07:51 PM

Awesome - now I have the list. How do I remove them without killing the normal rare npc's that spawn with the fabled?

Kingly_Krab 03-07-2015 09:11 PM

Just select them all and delete them, simple enough, haha.

Leetsauce 03-16-2015 07:22 AM

I used this as well. Thank you, KK. Where we have fabled loot dropping from the regular mob at a lower percentage chance, I felt it would be prudent to flat out remove the fabled spawns, and this made it super easy.

Thanks again!


All times are GMT -4. The time now is 02:22 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.