Skip to content

arena_team

This table holds the main ArenaTeam information. All created teams or all teams in the process of being created have a record in this table.

Structure ​

FieldTypeAttributesKeyNullDefaultExtraComment
arenaTeamIdintunsignedPRINO0
namevarchar(24)NO
captainGuidintunsignedNO0
typetinyintunsignedNO0
ratingsmallintunsignedNO0
seasonGamessmallintunsignedNO0
seasonWinssmallintunsignedNO0
weekGamessmallintunsignedNO0
weekWinssmallintunsignedNO0
rankintunsignedNO0
backgroundColorintunsignedNO0
emblemStyletinyintunsignedNO0
emblemColorintunsignedNO0
borderStyletinyintunsignedNO0
borderColorintunsignedNO0

 

Description of fields ​

arenaTeamId ​

The ID of the ArenaTeam. This number is unique to each team and is the main method to identify a team.
 

name ​

Name of the Arena team
 

captainGuid ​

The character guid of the ArenaTeam's creator.
 

type ​

Defines the ArenaType:

  • 2: 2vs2 Team
  • 3: 3vs3 Team
  • 5: 5vs5 Team
     

rating ​

Rating of arena team.
 

seasonGames ​

Number of games played this season.
 

seasonWins ​

Number of games won this season.
 

weekGames ​

Number of games played this week.
 

weekWins ​

Number of games won this week.
 

rank ​

Rank of teams in the competition by rating.
 

backgroundColor ​

ARGB color value.

c
alpha = (field & 0xFF000000) >> 48
red   = (field & 0xFF0000) >> 32
green = (field & 0xFF00) >> 16
blue  = (field & 0xFF)

 

emblemStyle ​

file index to
Interface/PvPFrame/Icons/PVP-Banner-Emblem-<emblemStyle>.blp
 

emblemColor ​

ARGB color value.
 

borderStyle ​

file index to
Interface/PvPFrame/PVP-Banner-<2|3|5>-Border-<borderStyle>.blp
 

borderColor ​

ARGB color value.