To disable certain creatures

[Brassbright]

Hello, hopefully this is an easy question

I like using .npc delete to remove creatures which would not return after their quest. For example, in the Valley of Trials, once I eliminate them and the warlock in the Valley of Trials, the Vile Familiars should not respawn. I like seeing this "progress."

The repack I prefer is, happily, still receiving updates. When there is an update, the progress is reset. I can go around the world and redo the .npc delete on each individual monster... I wonder is it possible for me to disable the monster in HeidiSQL instead? So what I'd like to learn is what to change in HeidiSQL so that Vile Familiar does not appear in the world, but (if possible) is still available for .npc add (just in case).

Thank you for your consideration!

[stoneharry]

Yes, you can run a query like:

DELETE FROM world.creature WHERE id = your_creature_id;

[Brassbright]

Thank you, stoneharry!

[Brassbright]

I haven't messed up yet, but if I should type a wrong ID, is there any good way to put someone back?