Add new Edit Delete History Source

Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.

creature_respawn

<-Back-to:Characters

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.

Table Structure

Field	Type	Attributes	Key	Null	Comment
guid	INT	UNSIGNED	PRI	NO	Global Unique Identifier
respawnTime	INT	UNSIGNED		NO
mapId	SMALLINT	UNSIGNED		NO
instanceId	INT	UNSIGNED	PRI	NO	Instance Identifier

Description of the fields

guid

The character guid. See characters.guid.

respawnTime

The time when the creature should be respawned in Unix time.

mapId

field-no-description|3

instance

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.