Alright, tweaked it a bit and got a pretty nice one going. I noticed GeorgeS updated also(shoulda checked sooner) So paired with his popup Spawngroup editor and this query, also clicking the X by the zone name on the spawngroup popup so it turns to all. You can copy the ID from the query and paste it in NPCID in georges, then quickly edit the spawn rate or disable. The query also shows you the spawn chance and if the spawngroup is enabled. Saved me tons of time locating the fabled and adjusting the spawngroup spawnrating to = 100% rotation, and disabling things like exterminators and more. It also shows you the zone they spawn in so you dont waste time looking at each one.
To search, just change "Exterminator_" to the search NPCName(keyword) you are looking for. Example, Fabled, Exterminator, Magus, whatever you want, full or partial names.
Code:
SELECT npc_types.id, npc_types.name, npc_types.lastname, spawn2.zone, spawn2.enabled, spawn2.id, spawnentry.spawngroupID, spawnentry.chance
FROM npc_types
JOIN spawnentry ON spawnentry.npcID = npc_types.id
JOIN spawn2 ON spawn2.spawngroupID = spawnentry.spawngroupID
WHERE npc_types.name LIKE '%Exterminator_%'
AND spawnentry.chance > '0';
EDIT : Added npc_types.lastname to SELECT list so you can change the WHERE npc_types.name to npc_types.lastname and change WHERE to npc_types.lastname and search for beserker to quickly cleanup all beserker spawns(GMs,Tome Merchants) if you are cleaning them out or any other search by last name.
Threaded Mode
