Battleground template SF: Difference between revisions

From Project Skyfire
Jump to navigation Jump to search
No edit summary
 
No edit summary
 
(2 intermediate revisions by one other user not shown)
Line 3: Line 3:
|}
|}
{{Back-to:World}}
{{Back-to:World}}
[[Category: SkyFire World database tables]]


<big>'''The `battleground_template` table'''</big>
<big>'''The `battleground_template` table'''</big>
Line 15: Line 14:
|'''Type'''
|'''Type'''
|'''Attribute'''
|'''Attribute'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Default'''
|'''Comment'''
|'''Comment'''
Line 21: Line 22:
|mediumint(8)
|mediumint(8)
|unsigned
|unsigned
|PRI
|NO
|
|
|
|ID# of the battleground. Contained in BattlemasterList.dbc.
|-
|-
|[[#MinPlayersPerTeam|MinPlayersPerTeam]]
|[[#MinPlayersPerTeam|MinPlayersPerTeam]]
Line 28: Line 31:
|unsigned
|unsigned
|
|
|The required number of players in each level bracket to start the battleground.
|NO
|0
|
|-
|-
|[[#MaxPlayersPerTeam|MaxPlayersPerTeam]]
|[[#MaxPlayersPerTeam|MaxPlayersPerTeam]]
Line 34: Line 39:
|unsigned
|unsigned
|
|
|The maximum number of players that can be in the battleground.
|NO
|0
|
|-
|-
|[[#MinLvl|MinLvl]]
|[[#MinLvl|MinLvl]]
Line 40: Line 47:
|unsigned
|unsigned
|
|
|The minimum level you must be to join the battleground.
|NO
|0
|
|-
|-
|[[#MaxLvl|MaxLvl]]
|[[#MaxLvl|MaxLvl]]
Line 46: Line 55:
|unsigned
|unsigned
|
|
|The maximum level you can be to join the battleground (Usually 85).
|NO
|0
|
|-
|-
|[[#AllianceStartLoc|AllianceStartLoc]]
|[[#AllianceStartLoc|AllianceStartLoc]]
Line 52: Line 63:
|unsigned
|unsigned
|
|
|The location within the battlegrounds all Alliance players will start. Contained in WorldSafeLocs.dbc.
|NO
|
|
|-
|-
|[[#AllianceStartO|AllianceStartO]]
|[[#AllianceStartO|AllianceStartO]]
Line 58: Line 71:
|signed
|signed
|
|
|The orientation the Alliance players will be when the spawn (North = 0, moves clockwise).
|NO
|
|
|-
|-
|[[#HordeStartLoc|HordeStartLoc]]
|[[#HordeStartLoc|HordeStartLoc]]
Line 64: Line 79:
|unsigned
|unsigned
|
|
|The location within the battlegrounds all Horde players will start. Contained in WorldSafeLocs.dbc.
|NO
|
|
|-
|-
|[[#HordeStartO|HordeStartO]]
|[[#HordeStartO|HordeStartO]]
Line 70: Line 87:
|signed
|signed
|
|
|The orientation the Horde. players will be when the spawn (North = 0, moves clockwise).
|NO
|
|
|-
|-
|[[#Weight|Weight]]
|[[#Weight|Weight]]
|tinyint(2)
|tinyint(2)
|unsigned
|unsigned
|
|NO
|1
|1
|
|
Line 82: Line 103:
|signed
|signed
|
|
|NO
|""
|
|
|-
|-
Line 88: Line 111:
|signed
|signed
|
|
|A simple comment (Generally just the name of the battleground for easy reference).
|NO
|
|
|-
|-
|}
|}
<br> <big>'''Description of the fields'''</big>
===id===
ID# of the battleground. Contained in [[BattlemasterList.dbc SF|BattlemasterList.dbc]].
===MinPlayersPerTeam===
The required number of players in each level bracket to start the battleground.
===MaxPlayersPerTeam===
The maximum number of players that can be in the battleground.
===MinLvl===
The minimum level you must be to join the battleground.
===MaxLvl===
The maximum level you can be to join the battleground (Usually 85).
===AllianceStartLoc===
The location within the battlegrounds all Alliance players will start. Contained in [[WorldSafeLocs.dbc SF|WorldSafeLocs.dbc]].
===AllianceStartO===
The orientation the Alliance players will be when the spawn (North = 0, moves clockwise).
===HordeStartLoc===
The location within the battlegrounds all Horde players will start. Contained in [[WorldSafeLocs.dbc SF|WorldSafeLocs.dbc]].
===HordeStartO===
The orientation the Horde. players will be when the spawn (North = 0, moves clockwise).
===Comment====
A simple comment (Generally just the name of the battleground for easy reference).
[[DB:World|Return to world database structure]]

Latest revision as of 01:14, 9 January 2013

Back to world database list of tables.

The `battleground_template` table

This table hold the basic information about battlegrounds.


Structure

Field Type Attribute Key Null Default Comment
id mediumint(8) unsigned PRI NO
MinPlayersPerTeam smallint(5) unsigned NO 0
MaxPlayersPerTeam smallint(5) unsigned NO 0
MinLvl tinyint(3) unsigned NO 0
MaxLvl tinyint(3) unsigned NO 0
AllianceStartLoc mediumint(8) unsigned NO
AllianceStartO float signed NO
HordeStartLoc mediumint(8) unsigned NO
HordeStartO float signed NO
Weight tinyint(2) unsigned NO 1
ScriptName char(64) signed NO ""
Comment char(32) signed NO



Description of the fields

id

ID# of the battleground. Contained in BattlemasterList.dbc.

MinPlayersPerTeam

The required number of players in each level bracket to start the battleground.

MaxPlayersPerTeam

The maximum number of players that can be in the battleground.

MinLvl

The minimum level you must be to join the battleground.

MaxLvl

The maximum level you can be to join the battleground (Usually 85).

AllianceStartLoc

The location within the battlegrounds all Alliance players will start. Contained in WorldSafeLocs.dbc.

AllianceStartO

The orientation the Alliance players will be when the spawn (North = 0, moves clockwise).

HordeStartLoc

The location within the battlegrounds all Horde players will start. Contained in WorldSafeLocs.dbc.

HordeStartO

The orientation the Horde. players will be when the spawn (North = 0, moves clockwise).

Comment=

A simple comment (Generally just the name of the battleground for easy reference).

Return to world database structure

Retrieved from "https://wiki.projectskyfire.org/index.php?title=Battleground_template_SF&oldid=548"