Achievement dbc 548

From Project Skyfire
Revision as of 18:46, 8 August 2021 by Admin (talk | contribs) (add structure for achievement_reward table)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Back to world database list of tables.

The `achievement_reward` table

Stores achievement data that is missing in Achievement.dbc


Structure

Field Type Attributes Key Null Default Extra Comment
ID int(10) unsigned PRI NO 0
title_A int(11) signed NO -1
mapID int(11) signed NO -1
points int(10) unsigned NO 0 Achievement points awarded for completing the achievement, has no use serverside.
flags int(10) unsigned NO 0
count int(10) unsigned NO 0
refAchievement int(10) unsigned NO 0


DB Structure

CREATE TABLE `achievement_dbc` (
	`ID` INT NOT NULL,
	`requiredFaction` INT NOT NULL DEFAULT -1,
	`mapID` INT NOT NULL DEFAULT -1,
	`points` INT NOT NULL DEFAULT '0',
	`flags` INT NOT NULL DEFAULT '0',
	`count` INT NOT NULL DEFAULT '0',
	`refAchievement` INT NOT NULL DEFAULT '0',
	PRIMARY KEY (`ID`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;


Description of the fields

ID

This is the ID of the achievement from Achievement_Criteria.dbc (2nd column)

requiredFaction

Condition:

       Both: -1,
       Horde: 0,
       Alliance: 1

mapID

Condition: Player must be on that map to be allowed criteria updates (-1 if not set)

points

Achievement points awarded for completing the achievement, has no use serverside.

flags

Table

count

Should always be 1.

refAchievement

Should always be 0.