From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/battleground_template.md | 339 +++++++++++++++++++++++++++++++++++++++--- 1 file changed, 322 insertions(+), 17 deletions(-) (limited to 'docs/battleground_template.md') diff --git a/docs/battleground_template.md b/docs/battleground_template.md index afbb17e..966d6f3 100644 --- a/docs/battleground_template.md +++ b/docs/battleground_template.md @@ -1,17 +1,322 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [battleground_template](battleground_template) - -Column | Type | Description ---- | --- | --- -ID | mediumint(8) unsigned | -MinPlayersPerTeam | smallint(5) unsigned | -MaxPlayersPerTeam | smallint(5) unsigned | -MinLvl | tinyint(3) unsigned | -MaxLvl | tinyint(3) unsigned | -AllianceStartLoc | mediumint(8) unsigned | -AllianceStartO | float | -HordeStartLoc | mediumint(8) unsigned | -HordeStartO | float | -StartMaxDist | float | -Weight | tinyint(3) unsigned | -ScriptName | char(64) | -Comment | char(32) | +# battleground\_template335 + +` Back-to:World ` + +**The \`battleground\_template\` table** + +Contains information about the different battlegrounds, like how many players are needed to start, how many can be inside the same one, and the locations where each side starts. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Atributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

NULL


+


+

MinPlayersPerTeam

smallintint(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

NULL


+


+

AllianceStartO

float

signed


+

NO

NULL


+


+

HordeStartLoc

mediumint(8)

unsigned


+

NO

NULL


+


+

HordeStartO

float

signed


+

NO

NULL


+


+

StartMaxDist

float

signed


+

NO

0


+


+

Weight

tinyint (2)

unsigned


+

NO

1


+


+

ScriptName

char (64)


+


+

NO


+


+


+

Comment

char (32)


+


+

NO


+


+


+

+ +**Description of the fields** + +### id + +The battleground ID. + + ++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

ID

Type

1

Alterac Valley

2

Warsong Gulch

3

Arathi Basin

4

Nagrand Arena

5

Blade's Edge Arena

6

All Arena

7

Eye of the Storm

8

Ruins of Lordaeron

9

Strand of the Ancients

10

Dalaran Sewers

11

The Ring of Valor

30

Isle of Conquest

32

Random battleground

+ +### MinPlayersPerTeam + +Controls the minimum number of players that need to join the battleground on each faction side for the battleground to start. For the battleground to start, all characters (between min and max player values) must be in the same tier. Tiers are set up in ranges of 10 levels except for level 80. So the first tier is 10-19, the next are 20-29, 30-39, 40-49, 50-59, 60-69, 70-79 and finally 80. If characters of different tiers all join the queue, they will join their respective tier's queue and wait for more players of their tier to join the queue. Characters in different tiers can never join the same battleground. + +### MaxPlayersPerTeam + +Controls how many players from each team can join the battleground. + +NOTE2: If left to be 0, trinity will use the default DBC value. + +### MinLvl + +The minimum level that players need to be in order to join the battleground. + +NOTE: If left to be 0, trinity will use the default DBC value. + +### MaxLvl + +The maximum level that players can be to enter the battleground. + +NOTE: If left to be 0, trinity will use the default DBC value. + +### AllianceStartLoc + +The location where the alliance players get teleported to when the battleground first starts. See WorldSafeLocs.dbc + +### AllianceStartO + +The orientation of the alliance players upon teleport into the battleground. North is 0, south is Pi (3.14159). + +### HordeStartLoc + +The location where the horde players get teleported to when the battleground first starts. See WorldSafeLocs.dbc + +### HordeStartO + +The orientation of the horde players upon teleport into the battleground. North is 0, south is Pi (3.14159). + +### 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. -- cgit