Datenbank 'world'
access_requirement
achievement_criteria_data
achievement_dbc
achievement_reward
achievement_reward_locale
areatrigger_involvedrelation
areatrigger_scripts
areatrigger_tavern
areatrigger_teleport
battleground_template
battlemaster_entry
broadcast_text
broadcast_text_locale
command
conditions
creature
creature_addon
creature_classlevelstats
creature_equip_template
creature_formations
creature_loot_template
creature_model_info
creature_onkill_reputation
creature_questender
creature_questitem
creature_queststarter
creature_summon_groups
creature_template
creature_template_locale
creature_template_addon
creature_text
creature_text_locale
disables
disenchant_loot_template
event_scripts
exploration_basexp
fishing_loot_template
gameobject
gameobject_addon
gameobject_loot_template
gameobject_questender
gameobject_questitem
gameobject_queststarter
gameobject_template
gameobject_template_locale
game_event
game_event_arena_seasons
game_event_battleground_holiday
game_event_condition
game_event_creature
game_event_creature_quest
game_event_gameobject
game_event_gameobject_quest
game_event_model_equip
game_event_npcflag
game_event_npc_vendor
game_event_pool
game_event_prerequisite
game_event_quest_condition
game_event_seasonal_questrelation
game_tele
game_weather
gossip_menu
gossip_menu_option
graveyard_zone
instance_encounters
instance_template
item_enchantment_template
item_loot_template
item_set_names
item_template
lfg_dungeon_rewards
lfg_dungeon_template
linked_respawn
locales_gossip_menu_option
locales_item
locales_item_set_names
locales_npc_text
locales_page_text
locales_points_of_interest
locales_quest
mail_level_reward
mail_loot_template
milling_loot_template
npc_spellclick_spells
npc_text
npc_trainer
npc_vendor
outdoorpvp_template
page_text
pet_levelstats
pet_name_generation
pickpocketing_loot_template
playercreateinfo
playercreateinfo_action
playercreateinfo_item
playercreateinfo_skills
playercreateinfo_spell_custom
player_classlevelstats
player_factionchange_achievement
player_factionchange_items
player_factionchange_quests
player_factionchange_reputations
player_factionchange_spells
player_factionchange_titles
player_levelstats
player_xp_for_level
points_of_interest
pool_creature
pool_gameobject
pool_pool
pool_quest
pool_template
prospecting_loot_template
quest_poi
quest_offer_reward
quest_poi_points
quest_request_items
quest_template
quest_template_addon
reference_loot_template
reputation_reward_rate
reputation_spillover_template
script_waypoint
skill_discovery_template
skill_extra_item_template
skill_fishing_base_level
skill_perfect_item_template
skinning_loot_template
smart_scripts
spelldifficulty_dbc
spell_area
spell_bonus_data
spell_custom_attr
spell_dbc
spell_enchant_proc_data
spell_group
spell_group_stack_rules
spell_learn_spell
spell_linked_spell
spell_loot_template
spell_pet_auras
spell_proc
spell_proc_event
spell_ranks
spell_required
spell_scripts
spell_script_names
spell_target_position
spell_threat
transports
trinity_string
updates
updates_include
vehicle_accessory
vehicle_template_accessory
version
warden_checks
waypoints
waypoint_data
waypoint_scripts
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'world'

Tabelle: 'achievement_criteria_data'

The `achievement_criteria_data` table

This table contains the data that a player needs to obtain / complete in order to receive a given achievement.

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
criteria_idmediumint(8)vorzeichenbehaftetPRIneinNULL
typetinyint(3)vorzeichenlosPRInein0
value1medium(8)vorzeichenlosnein0
value2medium(8)vorzeichenlosnein0
ScriptNamechar(64)vorzeichenbehaftetnein

Description of the fields

criteria_id

This is the ID from Achievement_Criteria.dbc.

type

Depending on this value, it will determine how value1 and value2 are used.

Type

Name

0TYPE_NONE
1TYPE_T_CREATURE
2TYPE_T_PLAYER_CLASS_RACE
3TYPE_T_PLAYER_LESS_HEALTH
4TYPE_T_PLAYER_DEAD
5TYPE_S_AURA
6

TYPE_S_AREA

7TYPE_T_AURA
8TYPE_VALUE
9TYPE_T_LEVEL
10TYPE_T_GENDER
11TYPE_SCRIPT
12TYPE_MAP_DIFFICULTY
13TYPE_MAP_PLAYER_COUNT
14TYPE_T_TEAM
15TYPE_S_DRUNK
16TYPE_HOLIDAY
17TYPE_BG_LOSS_TEAM_SCORE
18TYPE_INSTANCE_SCRIPT
19TYPE_S_EQUIPED_ITEM
20TYPE_MAP_ID
21TYPE_S_PLAYER_CLASS_RACE
22TYPE_NTH_BIRTHDAY
23TYPE_S_KNOWN_TITLE

value1

*TYPE_T_CREATURE

*TYPE_T_PLAYER_CLASS_RACE

    • The target here is a valid class (paste class list). value2 must also be set

*TYPE_T_PLAYER_LESS_HEALTH

    • The percentage of health that the target must reach.

*TYPE_T_PLAYER_DEAD

    • The faction of the target player (must match player attempting achievement).

*TYPE_S_AURA

    • The spell ID of the aura that must be on the player. value2 must also be set.

*TYPE_S_AREA

*TYPE_T_AURA

    • The spell ID of the aura that must be on the target. value2 must also be set.

*TYPE_VALUE

    • Value to compare needed to attain achievement. This value is used in conjunction with another type. (see value2 for comparisation type)

*TYPE_T_LEVEL

    • The minimum level that the target can be.

*TYPE_T_GENDER

    • Gender: 0=Male, 1=Female

*TYPE_SCRIPT

    • Used to disable an achievement if all requirements are not defined. Would usually be used if not all are known.

*TYPE_MAP_DIFFICULTY

    • Map difficulty: (for dungeons)
      • Normal = 0
      • Heroic = 1
    • Map difficulty: (for raids)
      • 10 Man Normal = 0
      • 25 Man Normal = 1
      • 10 Man Heroic = 2
      • 25 Man Heroic = 3

*TYPE_MAP_PLAYER_COUNT

    • The number of other players that must be in the zone. (not sure if it is minimum or maximum).

*TYPE_T_TEAM

    • The target must be on this team: Alliance = 469, Horde = 67

*TYPE_S_DRUNK

    • How drunk the player must be:
      • DRUNKEN_SOBER = 0
      • DRUNKEN_TIPSY = 1
      • DRUNKEN_DRUNK = 2
      • DRUNKEN_SMASHED = 3

*TYPE_HOLIDAY

*TYPE_BG_LOSS_TEAM_SCORE

    • Player's team win bg and opposition team have team score in range. // Min. score

*TYPE_INSTANCE_SCRIPT

    • Make instance script call for check current criteria requirements fit.

*TYPE_S_EQUIPED_ITEM

*TYPE_MAP_ID

*TYPE_S_PLAYER_CLASS_RACE

    • The Source here is a valid class (paste class list). value2 must also be set

*TYPE_NTH_BIRTHDAY

  • Number of Birthday

*TYPE_S_KNOWN_TITLE

value2

*TYPE_T_PLAYER_CLASS_RACE
*TYPE_S_PLAYER_CLASS_RACE

*TYPE_S_AURA

    • Effect Index of the aura

*TYPE_T_AURA

    • Effect Index of the aura

*TYPE_BG_LOSS_TEAM_SCORE

    • Max. score

*TYPE_S_EQUIPED_ITEM

*TYPE_VALUE

  • ComparisationType:

    COMP_TYPE_EQ=0
    COMP_TYPE_HIGH = 1
    COMP_TYPE_LOW = 2
    COMP_TYPE_HIGH_EQ = 3
    COMP_TYPE_LOW_EQ = 4

ScriptName

The ScriptName for when scripting it in the core.
This might also be 'SmartTrigger'. It will than useSmartAI.


Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
WoW Portal MPOG TOP WoW Servers NET Private Server
Gametoor Top 100 Arena Top G Top of Games Oxigen Top 100 List
Facebook YouTube
Impressum