Battleground template 548: Difference between revisions
(Update Description) |
|||
Line 189: | Line 189: | ||
===StartMaxDist=== | ===StartMaxDist=== | ||
Unknown | |||
===Weight=== | ===Weight=== |
Latest revision as of 20:03, 8 August 2021
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 | |||
StartMaxDist | float | signed | NO | 0 | ||
Weight | tinyint(2) | unsigned | NO | 1 | ||
ScriptName | char(64) | signed | NO | "" | ||
Comment | char(32) | signed | NO |
DB Structure
CREATE TABLE `battleground_template` ( `id` MEDIUMINT NOT NULL, `MinPlayersPerTeam` SMALLINT NOT NULL DEFAULT '0', `MaxPlayersPerTeam` SMALLINT NOT NULL DEFAULT '0', `MinLvl` TINYINT NOT NULL DEFAULT '0', `MaxLvl` TINYINT NOT NULL DEFAULT '0', `AllianceStartLoc` MEDIUMINT NOT NULL, `AllianceStartO` FLOAT NOT NULL, `HordeStartLoc` MEDIUMINT NOT NULL, `HordeStartO` FLOAT NOT NULL, `StartMaxDist` FLOAT NOT NULL DEFAULT '0', `Weight` TINYINT NOT NULL DEFAULT '1', `ScriptName` CHAR(64) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `Comment` CHAR(32) NOT NULL COLLATE 'utf8_general_ci', PRIMARY KEY (`id`) USING BTREE ) COLLATE='utf8_general_ci' ENGINE=MyISAM ;
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).
StartMaxDist
Unknown
Weight
Determines what battleground(s) will be more frequently chosen when using Random Battleground.
For example: If you want AV to be less often chosen, give 2 and for all other give 3.
Comment=
A simple comment (Generally just the name of the battleground for easy reference).