Actions

Instance SF

From Project Skyfire

Revision as of 21:30, 7 July 2012 by Cheapgamer (talk | contribs) (Created page with "{| align="right" | __TOC__ |} {{Back-to:Characters}} <big>'''The `instance` table'''</big> This table holds static information on all current instances that have not yet be...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Back to characters database list of tables.


The `instance` table

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(10) unsigned PRI NO 0
map smallint(5) unsigned NO 0
resettime int(10) unsigned NO 0
difficulty tinyint(3) unsigned NO 0
completedEncounters int(10) unsigned NO 0
data tinytext signed NO


Description of the fields

id[edit]

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

map[edit]

The map ID the instance is in. See Map.dbc

resettime[edit]

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

difficulty[edit]

The difficulty of the current instance. 0 = 10-man Normal, 1 = 25-man Normal, 2 = 10-man Heroic, 3 = 25-man Heroic.

completedEncounters[edit]

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

data[edit]

Specific data belonging to the individual instance.