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_stats'

The `character_stats` table

This table holds information on all the stats regarding the character. Used for external applications such as websites.
See worldserver.conf: PlayerSave.Stats.*

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
guidint(10)

vorzeichenlos

PRInein0Global Unique Identifier, Low part
maxhealthint(10)vorzeichenlosnein0
maxpower1int(10)vorzeichenlosnein0

maxpower2int(10)vorzeichenlosnein0
maxpower3int(10)vorzeichenlosnein0
maxpower4int(10)vorzeichenlos

NO

0
maxpower5int(10)vorzeichenlosnein0
maxpower6int(10)vorzeichenlosnein0
maxpower7

int(10)

vorzeichenlosnein0
strengthint(10)vorzeichenlosnein0
agilityint(10)vorzeichenlosnein0

staminaint(10)vorzeichenlosnein0
intellectint(10)vorzeichenlosnein0
spiritint(10)vorzeichenlos

nein0
armorint(10)vorzeichenlosnein0
resHolyint(10)vorzeichenlosnein0
resFire

int(10)

vorzeichenlosnein0
resNatureint(10)vorzeichenlosnein0
resFrostint(10)vorzeichenlosnein0

resShadowint(10)vorzeichenlosnein0
resArcaneint(10)vorzeichenlosnein0
blockPctfloatvorzeichenlos

nein0
dodgePctfloatvorzeichenlosnein0
parryPctfloatvorzeichenlosnein0
critPctfloatvorzeichenlosnein0
rangedCritPctfloatvorzeichenlosnein0
spellCritPctfloatvorzeichenlosnein0

attackPowerint(10)vorzeichenlosnein0
rangedAttackPowerint(10)vorzeichenlosnein0
spellPowerint(10)

vorzeichenlos

nein0
resilienceint(10)vorzeichenlosnein0

Description of the fields

guid

The guid of the character.

maxhealth

Maximum amount of health that the character has.

maxpower

1 - mana
2 - rage
3 - focus
4 - energy
5 - happiness
6 - rune
7 - runic power

strength

Character's current strength value.

agility

Character's current agility value.

stamina

Character's current stamina value.

intellect

Character's current intellect value.

spirit

Character's current spirit value.

armor

Character's current armor value.

resHoly

Character's current holy resistance value.

resFire

Character's current fire resistance value.

resNature

Character's current nature resistance value.

resFrost

Character's current frost resistance value.

resShadow

Character's current shadow resistance value.

resArcane

Character's current arcane resistance value.

blockPct

Character's current block chance.

dodgePct

Character's current dodge chance.

parryPct

Character's current parry chance.

critPct

Character's current crit chance.

rangedCritPct

Character's current ranged crit chance.

spellCritPct

Character's current spell crit chance.

attackPower

Character's current attackpower.

rangedAttackPower

Character's current ranged attackpower.

spellPower

Character's current spellpower.

resilience

Character's current resilience value.

confluenceTd


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