Access requirement SF: Difference between revisions

From Project Skyfire
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
Line 171: Line 171:


This field is for any comment you want to make about the requirements. It is arbitrary text.
This field is for any comment you want to make about the requirements. It is arbitrary text.
[[Category:DB:World]]
 
[[DB:World|Return to world database structure]]

Latest revision as of 01:07, 9 January 2013

Back to world database list of tables.


The `access_requirement` table

This table contains the access requirements to enter an instance.


Structure

Field Type Attributes Key Null Default Extra Comment
mapId mediumint (8) unsigned PRI NO
difficulty tinyint(3) unsigned PRI NO
level_min tinyint(3) unsigned NO 0
level_max tinyint(3) unsigned NO 0
item mediumint(8) unsigned NO 0
item2 mediumint(8) unsigned NO 0
quest_done_A mediumint(8) unsigned NO 0
quest_done_H mediumint(8) unsigned NO 0
completed_achievement mediumint(8) unsigned NO 0
quest_failed_text text signed YES NULL
comment text signed YES NULL


Description of the fields

mapId

This is the access_id field from the instance_template table, or the access_id field from the areatrigger_teleport. It is an arbitrary number that merely links the requirements to an instance_template, or areatrigger_teleport

difficulty

5 man dungeons - 0 for normal, 1 for heroic, 2 for epic (not used yet)

10 man dungeons - 0 for normal, 2 for heroic

25 man dungeons - 1 for normal, 3 for heroic

level_min

The minimum level that you must be in order to enter the instance.

level_max

The maximum level that you can be in order to enter the instance.

item

An item that you must have in your inventory to enter the instance. This item can not be in the bank.

item2

A second item that you must have in your inventory. This item can not be in the bank.

quest_done_A

A quest that you must have completed. This field is only for alliance.

quest_done_H

A quest that you must have completed. This field is only for horde.

completed_achievement

An achievement that must be completed by the player to enter an instance.

quest_failed_text

The text that is shown if you try and enter the instance without having completed the quest.

comment

This field is for any comment you want to make about the requirements. It is arbitrary text.

Return to world database structure