https://wiki.projectskyfire.org/index.php?title=Instance_SF&feed=atom&action=historyInstance SF - Revision history2024-03-28T17:25:34ZRevision history for this page on the wikiMediaWiki 1.39.1https://wiki.projectskyfire.org/index.php?title=Instance_SF&diff=485&oldid=prevCheapgamer: 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..."2012-07-07T21:30:27Z<p>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..."</p>
<p><b>New page</b></p><div>{| align="right"<br />
| __TOC__<br />
|}<br />
{{Back-to:Characters}}<br />
<br />
<br />
<big>'''The `instance` table'''</big><br />
<br />
This table holds static information on all current instances that have not yet been reset.<br />
<br />
<br />
<big>'''Structure'''</big><br />
{| border="1"<br />
|'''Field'''<br />
|'''Type'''<br />
|'''Attributes'''<br />
|'''Key'''<br />
|'''Null'''<br />
|'''Default'''<br />
|'''Extra'''<br />
|'''Comment'''<br />
|-<br />
|[[#id|id]]<br />
|int(10)<br />
|unsigned<br />
|PRI<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#map|map]]<br />
|smallint(5)<br />
|unsigned<br />
|<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#resettime|resettime]]<br />
|int(10)<br />
|unsigned<br />
|<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#difficulty|difficulty]]<br />
|tinyint(3)<br />
|unsigned<br />
|<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#completedEncounters|completedEncounters]]<br />
|int(10)<br />
|unsigned<br />
|<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#data|data]]<br />
|tinytext<br />
|signed<br />
|<br />
|NO<br />
|<br />
|<br />
|<br />
|}<br />
<br />
<br />
<big>'''Description of the fields'''</big><br />
<br />
==== id ====<br />
The instance ID. This number is unique to every instance.<br />
<br />
==== map ====<br />
The map ID the instance is in. See [[Map.dbc SF|Map.dbc]]<br />
<br />
==== resettime ====<br />
The time when the instance will be reset, in Unix time. This field is zero for raid and heroic instances.<br />
The resettime of raid and heroic instances for every specific group is stored in table [[instance_reset_SF|instance_reset]].<br />
<br />
==== difficulty ====<br />
The difficulty of the current instance. 0 = 10-man Normal, 1 = 25-man Normal, 2 = 10-man Heroic, 3 = 25-man Heroic.<br />
<br />
==== completedEncounters ====<br />
{{field-no-description|5}}<br />
<br />
==== data ====<br />
Specific data belonging to the individual instance.<br />
<br />
<br />
[[Category: SkyFire Characters database tables]]</div>Cheapgamer