[Fixed] Player pets/minions/familiars spawned in world

[ Fixed ] Player pets/minions/familiars spawned in world - Printable Version

+- Zeklabs (https://www.zeklabs.com)
+-- Forum: General (https://www.zeklabs.com/forumdisplay.php?fid=3)
+--- Forum: Bug Reports (https://www.zeklabs.com/forumdisplay.php?fid=7)
+--- Thread: [ Fixed ] Player pets/minions/familiars spawned in world (/showthread.php?tid=134)
Player pets/minions/familiars spawned in world - devn00b - 03-02-2020

There are lots of player pets spawned as actual NPC's in the world. This weekend (if not sooner) I'll sit down and knock out a query to remove most of it, if not all.
RE: Player pets/minions/familiars spawned in world - devn00b - 03-12-2020

This should solve the issue across the board.
Code:
delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%familiar%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%mercenary%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%spirit companion%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%minion%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%earthen avatar%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%rotting thrall%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%diseased servant%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Split%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%warder%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%undying adherent%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet gorg%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Twin%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%warder%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Elemental Dominance%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Shift%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Possessed Essence%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian soldier%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%igneous apprentice%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%shadowy stalker%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian recruit%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim spellbinder%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet gazer");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim sorcerer%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%kitten.%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%undead knight%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%dedicated jack-o-lanterne%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Duplicate%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Master Tinkerer's Companion%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Reflection%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%aery outrider%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%cognatic bixie bopper%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%nightshade%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Warrior of Zek%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Servant of Vazaelle%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%slimy slug friend%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Valiant Beast");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Underfoot Attendant%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%fiery magician%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%aquatic warder%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%lizard");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian myrmidon");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%dreadnought%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%tellurian champion");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%wisp");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%squire%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%igneous adept%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim terror%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim heretic%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%pet monkey%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%grim thulian%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet goblin runt%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%Personae Mirror%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%aery hunter%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%attack hawk%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%frostpaw kitten%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%void beast%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%slimy slug friend%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Pariah of Bertoxxulous");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%icy companion%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%orc priest%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Minion of Thule");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Minion of Ro");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Minion of Hate");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%inferno golem%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pack pony%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%servant%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%water elemancer%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%igneous savant%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%siren%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%pet goblin runt%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Healing Companion");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%sacrament%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Gavel of Justice");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%feline friend");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Friend of Growth");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%wind sensei%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%animated dagger%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Child of Karana");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%Beloved of Bristlebane");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%'s%shadowy assassin%");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "%A magical puppet");

delete FROM spawn_location_entry WHERE spawn_id IN (SELECT id FROM spawn WHERE sub_title LIKE "<%'s%Mercenary%>");