Battleground template SF: Difference between revisions
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}} | ||
<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 | |||
| | |||
| | | | ||
|- | |- | ||
|[[#MinPlayersPerTeam|MinPlayersPerTeam]] | |[[#MinPlayersPerTeam|MinPlayersPerTeam]] | ||
Line 28: | Line 31: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#MaxPlayersPerTeam|MaxPlayersPerTeam]] | |[[#MaxPlayersPerTeam|MaxPlayersPerTeam]] | ||
Line 34: | Line 39: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#MinLvl|MinLvl]] | |[[#MinLvl|MinLvl]] | ||
Line 40: | Line 47: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#MaxLvl|MaxLvl]] | |[[#MaxLvl|MaxLvl]] | ||
Line 46: | Line 55: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#AllianceStartLoc|AllianceStartLoc]] | |[[#AllianceStartLoc|AllianceStartLoc]] | ||
Line 52: | Line 63: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
| | |||
| | |||
|- | |- | ||
|[[#AllianceStartO|AllianceStartO]] | |[[#AllianceStartO|AllianceStartO]] | ||
Line 58: | Line 71: | ||
|signed | |signed | ||
| | | | ||
| | |NO | ||
| | |||
| | |||
|- | |- | ||
|[[#HordeStartLoc|HordeStartLoc]] | |[[#HordeStartLoc|HordeStartLoc]] | ||
Line 64: | Line 79: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
| | |||
| | |||
|- | |- | ||
|[[#HordeStartO|HordeStartO]] | |[[#HordeStartO|HordeStartO]] | ||
Line 70: | Line 87: | ||
|signed | |signed | ||
| | | | ||
| | |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 | ||
| | | | ||
| | |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).