EQEmulator Forums - Removing fabled spaws

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.