instance

This table holds static information on all current instances that have not yet been reset.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
id	int	unsigned	PRI	NO	0
map	smallint	unsigned	MUL	NO	0
resettime	bigint	unsigned	MUL	NO	0
difficulty	tinyint	unsigned	MUL	NO	0
completedEncounters	int	unsigned		NO	0
data	tinytext			NO

Description of fields

id

The instance ID. This number is unique to every instance.  

map

The Map ID the instance is in.  

resettime

The Unix timestamp when the instance will be reset. This field is zero for raid and heroic instances. The resettime of raid and heroic instances for every specific group is stored in instance_reset.  

difficulty

ID	Name
0	RAID_DIFFICULTY_10MAN_NORMAL / DUNGEON_DIFFICULTY_NORMAL
1	RAID_DIFFICULTY_25MAN_NORMAL / DUNGEON_DIFFICULTY_HEROIC
2	RAID_DIFFICULTY_10MAN_HEROIC
3	RAID_DIFFICULTY_25MAN_HEROIC

 

completedEncounters

Bitmask of completed encounters, where EncounterBit is DungeonEncounter OrderIndex of the matching entry. completedEncounters |= 1 << EncounterBit;  

data

String of space separated values in 3 parts

1. Header: space separated chars of DataHeader from InstanceMapScript header file (usually instance shorthand)
2. BossState: encounterState in order of encounters
3. MiscData (optional): state of doors, timers, events unique to this instance, manually defined in InstanceMapScript.