Removing fabled spaws

[Kilur]

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]

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

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

[Kilur]

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]

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

[Leetsauce]

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!