Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.

...

Field

Type

Attributes

Key

Null

Default

Extra

Comment

battleground_id

bigint

unsigned

PRI

NO

 

 

 

winnercharacter_factionguid

tinyint

 

 

NO

 

 

 

bracketscore_killing_idblows

tinyint

unsigned

 

NO

 

 

 type

score_deaths

tinyint

unsigned

 

NO

 

 

 date

score_honorable_kills

datetime

 

 

NO

 

 

 date

score_bonus_honor

datetime

  

NO

   

datescore_damage_done

datetime

  

NO

   

datescore_healing_done

datetime

  

NO

   

dateattr_1

datetime

  

NO

   

dateattr_2

datetime

  

NO

   

dateattr_3

datetime

  

NO

   

dateattr_4

datetime

  

NO

   

dateattr_5

datetime

  

NO

   

Description of the fields

battleground_id

An unique value which identifies a BattleGround.

winner_faction

The faction which won the BattleGround:

0 = HORDE

1 = ALLIANCE

2 = NOONE

bracket_id

Identifies the bracket level range:

1 = 10-19

2 = 20-29

3 = 30-39

4 = 40-49

5 = 50-59

6 = 60-69

7 = 70-79

8 = 80

type

The BattleGround type:

1 = Alterac Valley

2 = Warsong Gulch

3 = Arathi Basin

7 = Eye of the Storm

9 = Strand of the Ancients

30 = Isle of Conquest

date

Date and time of BattleGround ending.Link to pvpstats_battlegrounds.id

character_guid

Link to characters.guid

score_*

All scores which are in common between all BattleGrounds

attr_*

All scores which are not in common between all BattleGrounds. This fields changes their mean according to pvpstats_battlegrounds.type