Battleground template 548: Difference between revisions
(Add missing table entry) |
(Update Description) |
||
Line 153: | Line 153: | ||
===id=== | ===id=== | ||
ID# of the battleground. Contained in | ID# of the battleground. Contained in BattlemasterList.dbc. | ||
===MinPlayersPerTeam=== | ===MinPlayersPerTeam=== | ||
Line 173: | Line 173: | ||
===AllianceStartLoc=== | ===AllianceStartLoc=== | ||
The location within the battlegrounds all Alliance players will start. Contained in | The location within the battlegrounds all Alliance players will start. Contained in WorldSafeLocs.dbc. | ||
===AllianceStartO=== | ===AllianceStartO=== | ||
Line 181: | Line 181: | ||
===HordeStartLoc=== | ===HordeStartLoc=== | ||
The location within the battlegrounds all Horde players will start. Contained in | The location within the battlegrounds all Horde players will start. Contained in WorldSafeLocs.dbc. | ||
===HordeStartO=== | ===HordeStartO=== | ||
Line 193: | Line 193: | ||
===Weight=== | ===Weight=== | ||
Determines what battleground(s) will be more frequently chosen when using Random Battleground.<br> | |||
For example: If you want AV to be less often chosen, give 2 and for all other give 3. | |||
===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 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
bla bla bla
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).