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

Field	Type	Attributes	Key	Null	Default	Extra	Comment
arenaTeamId	int	unsigned	PRI	NO	0
name	varchar(24)			NO
captainGuid	int	unsigned		NO	0
type	tinyint	unsigned		NO	0
rating	smallint	unsigned		NO	0
seasonGames	smallint	unsigned		NO	0
seasonWins	smallint	unsigned		NO	0
weekGames	smallint	unsigned		NO	0
weekWins	smallint	unsigned		NO	0
rank	int	unsigned		NO	0
backgroundColor	int	unsigned		NO	0
emblemStyle	tinyint	unsigned		NO	0
emblemColor	int	unsigned		NO	0
borderStyle	tinyint	unsigned		NO	0
borderColor	int	unsigned		NO	0

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.

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.