arenateams

This table contains the information about the arena teams.

Structure

Field Type Default Comment
id int(30)    
type int(30)    
leader int(30)    
name varchar(150)    
emblemstyle int(40)    
emblemcolour bigint(40)    
borderstyle int(40)    
bordercolour bigint(40)    
backgroundcolour bigint(40)    
rating int(30)    
data varchar(150)    
ranking int(30)    
player_data1 varchar(60)    
player_data2 varchar(60)    
player_data3 varchar(60)    
player_data4 varchar(60)    
player_data5 varchar(60)    
player_data6 varchar(60)    
player_data7 varchar(60)    
player_data8 varchar(60)    
player_data9 varchar(60)    
player_data10 varchar(60)    

id

This is id of the aren team.

type

0 = 2v2
1 = 3v3
2 = 5v5 

leader

The guid id row guid from characters table.

name

The name of the arena team.

emblemstyle

The style of the emblem.

emblemcolour

The colour for the emblem.

borderstyle

The style of the border.

bordercolour

The colour of the border.

backgroundcolour

The background colour.

rating

The rating of the arena team.

data

ranking

The ranking for the aren team.

player_data1-10

Name of arena team member row name from characters table.