Arenateams

From ArcEmu-Wiki
Revision as of 15:50, 4 June 2010 by Marforius (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

Table that stores information on arena teams, their rankings, type, everything about them.


Contents



id

Auto incremented number - Unique ID identifying the Arena Team


type

Identifies the type of the Arena Team Settings:

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


leader

GUID of the arena team leader (reference to characters table, guid column)


name

Name of the arena team


emblemstyle

Number of the emblem style


emblemcolour

Number of the emblem colour


borderstyle

Number of the border style


bordercolour

Number of the border colour


backgroundcolour

Number of the background colour


rating

Arena team rating


data

ranking

Ranking of the team arena


player_data1

Name of arena team member


player_data2

Name of arena team member


player_data3

Name of arena team member


player_data4

Name of arena team member


player_data5

Name of arena team member


player_data6

Name of arena team member


player_data7

Name of arena team member


player_data8

Name of arena team member


player_data9

Name of arena team member


player_data10

Name of arena team member


SQL Structure

CREATE TABLE `arenateams` (
  `id` int(30) NOT NULL,
  `type` int(30) NOT NULL,
  `leader` int(30) NOT NULL,
  `name` varchar(150) NOT NULL,
  `emblemstyle` int(40) NOT NULL,
  `emblemcolour` bigint(40) NOT NULL,
  `borderstyle` int(40) NOT NULL,
  `bordercolour` bigint(40) NOT NULL,
  `backgroundcolour` bigint(40) NOT NULL,
  `rating` int(30) NOT NULL,
  `data` varchar(150) NOT NULL,
  `ranking` int(30) NOT NULL,
  `player_data1` varchar(60) NOT NULL,
  `player_data2` varchar(60) NOT NULL,
  `player_data3` varchar(60) NOT NULL,
  `player_data4` varchar(60) NOT NULL,
  `player_data5` varchar(60) NOT NULL,
  `player_data6` varchar(60) NOT NULL,
  `player_data7` varchar(60) NOT NULL,
  `player_data8` varchar(60) NOT NULL,
  `player_data9` varchar(60) NOT NULL,
  `player_data10` varchar(60) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;    
Personal tools