Datenbank 'characters'
account_data
account_instance_times
account_tutorial
addons
arena_team
arena_team_member
auctionhouse
banned_addons
bugreport
calendar_events
calendar_invites
channels
characters
character_account_data
character_achievement
character_achievement_progress
character_action
character_arena_stats
character_aura
character_banned
character_battleground_data
character_battleground_random
character_declinedname
character_equipmentsets
character_gifts
character_glyphs
character_homebind
character_instance
character_inventory
character_pet
character_pet_declinedname
character_queststatus
character_queststatus_daily
character_queststatus_monthly
character_queststatus_rewarded
character_queststatus_seasonal
character_queststatus_weekly
character_reputation
character_skills
character_social
character_spell
character_spell_cooldown
character_stats
character_talent
corpse
creature_respawn
gameobject_respawn
game_event_condition_save
game_event_save
gm_subsurvey
gm_survey
gm_ticket
groups
group_instance
group_member
guild
guild_bank_eventlog
guild_bank_item
guild_bank_right
guild_bank_tab
guild_eventlog
guild_member
guild_member_withdraw
guild_rank
instance
instance_reset
item_instance
item_loot_items
item_loot_money
item_refund_instance
item_soulbound_trade_data
lag_reports
lfg_data
mail
mail_items
petition
petition_sign
pet_aura
pet_spell
pet_spell_cooldown
pool_quest_save
pvpstats_battlegrounds
pvpstats_players
quest_tracker
reserved_name
updates
updates_include
warden_action
worldstates
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'characters'

Tabelle: 'character_aura'

The `character_aura` table

Contains aura information that is loaded when a character is loaded, so the auras that were on the character when it logged out are still kept when it logs back in. A spell can have up to three auras, one in each of its effects.

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
guid

int(10)

vorzeichenlosPRInein0Global Unique Identifier
caster_guidbigint(20)vorzeichenlosPRInein0Full Global Unique Identifier
item_guidbigint(20)vorzeichenlosPRInein

0

spellmediumint(8)vorzeichenlosPRInein0
effect_masktinyint(3)vorzeichenlosPRInein0
recalculate_masktinyint(3)vorzeichenlosnein0
stackcounttinyint(3)vorzeichenlosnein1
amount0int(11)vorzeichenbehaftetnein0

amount1int(11)vorzeichenbehaftetnein0
amount2int(11)vorzeichenbehaftetnein0
base_amount0int(11)vorzeichenbehaftet

NO

0
base_amount1int(11)vorzeichenbehaftetnein0
base_amount2int(11)vorzeichenbehaftetnein0
maxduration

int(11)

vorzeichenbehaftetnein0
remaintimeint(11)vorzeichenbehaftetnein0
remainchargestinyint(3)vorzeichenlosnein0

Description of the fields

guid

The GUID of the target affected by the aura. See characters/guid

caster_guid

The GUID of the player who casted the aura. See characters/guid

item_guid

The GUID of the item which casted the aura. See item_instance.guid

spell

The spell from which the aura was applied. See Spell.dbc column 1

effect_mask

The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2.

recalculate_mask

field-no-description|5

stackcount

Determines how many stacks of the spell the character has.

amount

The modifier value associated with the aura.

base_amount

field-no-description|8

maxduration

The maximum duration of the aura in ms.

remaintime

The time remaining in ms on the aura. -1 means that the aura is indefinite.

remaincharges

The number of charges remaining on the aura.


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