Battleground template SF: Difference between revisions
No edit summary |
Cheapgamer (talk | contribs) No edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 15: | Line 15: | ||
|'''Type''' | |'''Type''' | ||
|'''Attribute''' | |'''Attribute''' | ||
|'''Key''' | |||
|'''Null''' | |||
|'''Default''' | |'''Default''' | ||
|'''Comment''' | |'''Comment''' | ||
Line 21: | Line 23: | ||
|mediumint(8) | |mediumint(8) | ||
|unsigned | |unsigned | ||
|PRI | |||
|NO | |||
| | |||
| | | | ||
|- | |- | ||
|[[#MinPlayersPerTeam|MinPlayersPerTeam]] | |[[#MinPlayersPerTeam|MinPlayersPerTeam]] | ||
Line 28: | Line 32: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#MaxPlayersPerTeam|MaxPlayersPerTeam]] | |[[#MaxPlayersPerTeam|MaxPlayersPerTeam]] | ||
Line 34: | Line 40: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#MinLvl|MinLvl]] | |[[#MinLvl|MinLvl]] | ||
Line 40: | Line 48: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#MaxLvl|MaxLvl]] | |[[#MaxLvl|MaxLvl]] | ||
Line 46: | Line 56: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#AllianceStartLoc|AllianceStartLoc]] | |[[#AllianceStartLoc|AllianceStartLoc]] | ||
Line 52: | Line 64: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
| | |||
| | |||
|- | |- | ||
|[[#AllianceStartO|AllianceStartO]] | |[[#AllianceStartO|AllianceStartO]] | ||
Line 58: | Line 72: | ||
|signed | |signed | ||
| | | | ||
| | |NO | ||
| | |||
| | |||
|- | |- | ||
|[[#HordeStartLoc|HordeStartLoc]] | |[[#HordeStartLoc|HordeStartLoc]] | ||
Line 64: | Line 80: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
| | |||
| | |||
|- | |- | ||
|[[#HordeStartO|HordeStartO]] | |[[#HordeStartO|HordeStartO]] | ||
Line 70: | Line 88: | ||
|signed | |signed | ||
| | | | ||
| | |NO | ||
| | |||
| | |||
|- | |- | ||
|[[#Weight|Weight]] | |[[#Weight|Weight]] | ||
|tinyint(2) | |tinyint(2) | ||
|unsigned | |unsigned | ||
| | |||
|NO | |||
|1 | |1 | ||
| | | | ||
Line 82: | Line 104: | ||
|signed | |signed | ||
| | | | ||
|NO | |||
|"" | |||
| | | | ||
|- | |- | ||
Line 88: | Line 112: | ||
|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). |
Revision as of 18:44, 9 July 2012
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).