Battleground template 548: Difference between revisions

From Project Skyfire
Jump to navigation Jump to search
(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).