So to permanently kill all mobs in a dungeon once my adventurers have cleared it, could I simply do something like this?
DELETE FROM spawn2 WHERE zone = 'blackburrow'
Alternatively this would work, but only for spawns that had conditions, right?
UPDATE spawn_conditions
SET onchange = 0
WHERE zone = 'blackburrow'
If all spawns have conditions, that would be preferable, as it's easily reversed. But according to the schema, it seems as if a spawn point does not have to have a condition. So the only sure way to do it is to just delete them spawn points and the conditions.
Of course, I assume if yu are going to delete from spawn2, you should probably cascade delete all referenced rows in spawn_conditions.
I however am confused as to what spawn_entry is for. THere is no doc on that table...
- Rhino
|