Character achievement progress

From ArcEmu-Wiki
Jump to: navigation, search

Description

A table that contains the progress of an achievement. Like having a quest in your quest log but only fulfilling half of its criteria.


Contents



Guid

Character guid


criteria

Contains data on what needs doing.


counter

current achievement points


date

get current achievement date


SQL Structure

CREATE TABLE `character_achievement_progress` (
  `guid` int(10) unsigned NOT NULL DEFAULT '0',
  `criteria` int(10) unsigned NOT NULL DEFAULT '0',
  `counter` int(10) DEFAULT NULL,
  `date` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`guid`,`criteria`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools