Battleground template 548: Difference between revisions
(Add content) |
(Add missing table entry) |
||
Line 89: | Line 89: | ||
|NO | |NO | ||
| | | | ||
| | |||
|- | |||
|[[#StartMaxDist|StartMaxDist]] | |||
|float | |||
|signed | |||
| | |||
|NO | |||
|0 | |||
| | | | ||
|- | |- | ||
Line 178: | Line 186: | ||
The orientation the Horde. players will be when the spawn (North = 0, moves clockwise). | The orientation the Horde. players will be when the spawn (North = 0, moves clockwise). | ||
===StartMaxDist=== | |||
bla bla bla | |||
===Weight=== | |||
bla bla bla | |||
===Comment==== | ===Comment==== | ||
A simple comment (Generally just the name of the battleground for easy reference). | A simple comment (Generally just the name of the battleground for easy reference). |
Revision as of 19:58, 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
bla bla bla
Weight
bla bla bla
Comment=
A simple comment (Generally just the name of the battleground for easy reference).