The `creature_respawn` table
This table holds the respawn time when creatures should be respawned in the world. In case of a server crash, this table holds the respawn data so that the creatures don't respawn immediately on server restart. How often the respawn time is saved for creatures can be controlled in worldserver.conf.dist at SaveRespawnTimeImmediately.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
guid | INT | UNSIGNED | PRI | NO | 0 | Global Unique Identifier | |
respawnTime | INT | UNSIGNED | NO | 0 | |||
mapId | SMALLINT | UNSIGNED | NO | 0 | |||
instanceId | INT | UNSIGNED | PRI | NO | 0 | Instance Identifier |
Description of the fields
The character guid. See characters.guid.
The time when the creature should be respawned in Unix time.
field-no-description|3
If the creature was killed in an instance, this field holds the instance ID where this creature should be respawned. Each instance is different depending on the group so this field is vital in keeping track of which creatures should be respawned for which players at what time.