Instances

From ArcEmu-Wiki
Revision as of 13:55, 11 March 2010 by Shadoxfix (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

id

GUID of the character.

mapid

Id of the map on which the instance is created.

creation

Date and time of the creation of the instance.

expiration

Time till the expiration of the instance lock.

killed_npc_guids

The Guids of the killed npcs

difficulty

Heroic
Normal

creator_group

Name of the creator of the group

creator_guid

Guid of the creator of the group

persistent

Need info.

instanceid

The id of the instance

SQL Structure

CREATE TABLE `instances` (
  `id` int(30) NOT NULL,
  `mapid` int(30) NOT NULL,
  `creation` int(30) NOT NULL,
  `expiration` int(30) NOT NULL,
  `killed_npc_guids` text NOT NULL,
  `difficulty` int(30) NOT NULL,
  `creator_group` int(30) NOT NULL,
  `creator_guid` int(30) NOT NULL,
  `persistent` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `a` (`mapid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools