Battleground template 548: Difference between revisions

From Project Skyfire
Jump to navigation Jump to search
(Update Description)
 
Line 189: Line 189:
===StartMaxDist===
===StartMaxDist===


bla bla bla
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).