Questlog

From ArcEmu-Wiki
Jump to: navigation, search

Contents

player_guid

Guid of the character (the player).

quest_id

Id of the quest the character (the player) is on.

slot

Need info.

expirytime

This is the unix timestamp of the time when the quest expires ( for timed quests ). When this time comes to pass the quest fails.

explored_area1

If you need to explore areas for a quest if you have explored them it will come here.

explored_area2

If you need to explore areas for a quest if you have explored them it will come here.

explored_area3

If you need to explore areas for a quest if you have explored them it will come here.

explored_area4

If you need to explore areas for a quest if you have explored them it will come here.

mob_kill1

If you need to kill a mob it will come here.

mob_kill2

If you need to kill more than one mob it will come here.

mob_kill3

If you need to kill more than one mob it will come here.

mob_kill4

If you need to kill more than one mob it will come here.

completed

Completion status of the quest.

possible values

  • 0 - incomplete
  • 1 - complete
  • 2 - failed

SQL Structure

CREATE TABLE `questlog` (
  `player_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `quest_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `slot` int(20) unsigned NOT NULL DEFAULT '0',
  `expirytime` int(20) NOT NULL DEFAULT '0',
  `explored_area1` bigint(20) unsigned NOT NULL DEFAULT '0',
  `explored_area2` bigint(20) unsigned NOT NULL DEFAULT '0',
  `explored_area3` bigint(20) unsigned NOT NULL DEFAULT '0',
  `explored_area4` bigint(20) unsigned NOT NULL DEFAULT '0',
  `mob_kill1` bigint(20) NOT NULL DEFAULT '0',
  `mob_kill2` bigint(20) NOT NULL DEFAULT '0',
  `mob_kill3` bigint(20) NOT NULL DEFAULT '0',
  `mob_kill4` bigint(20) NOT NULL DEFAULT '0',
  `completed` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`player_guid`,`quest_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools