Battleground template SF - Revision history

Admin at 06:14, 9 January 2013

2013-01-09T06:14:49Z

← Older revision		Revision as of 01:14, 9 January 2013
Line 3:		Line 3:
	\|}		\|}
	{{Back-to:World}}		{{Back-to:World}}
	~~[[Category: SkyFire World database tables]]~~

	<big>'''The `battleground_template` table'''</big>		<big>'''The `battleground_template` table'''</big>
Line 160:		Line 159:

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

			[[DB:World\|Return to world database structure]]

Cheapgamer at 23:44, 9 July 2012

2012-07-09T23:44:58Z

New page

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `battleground_template` table'''</big>

This table hold the basic information about battlegrounds.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|PRI
|NO
|
|
|-
|[[#MinPlayersPerTeam|MinPlayersPerTeam]]
|smallint(5)
|unsigned
|
|NO
|0
|
|-
|[[#MaxPlayersPerTeam|MaxPlayersPerTeam]]
|smallint(5)
|unsigned
|
|NO
|0
|
|-
|[[#MinLvl|MinLvl]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|-
|[[#MaxLvl|MaxLvl]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|-
|[[#AllianceStartLoc|AllianceStartLoc]]
|mediumint(8)
|unsigned
|
|NO
|
|
|-
|[[#AllianceStartO|AllianceStartO]]
|float
|signed
|
|NO
|
|
|-
|[[#HordeStartLoc|HordeStartLoc]]
|mediumint(8)
|unsigned
|
|NO
|
|
|-
|[[#HordeStartO|HordeStartO]]
|float
|signed
|
|NO
|
|
|-
|[[#Weight|Weight]]
|tinyint(2)
|unsigned
|
|NO
|1
|
|-
|[[#ScriptName|ScriptName]]
|char(64)
|signed
|
|NO
|""
|
|-
|[[#Comment|Comment]]
|char(32)
|signed
|
|NO
|
|
|-
|}

<br> <big>'''Description of the fields'''</big>

===id===

ID# of the battleground. Contained in [[BattlemasterList.dbc SF|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 SF|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 SF|WorldSafeLocs.dbc]].

===HordeStartO===

The orientation the Horde. players will be when the spawn (North = 0, moves clockwise).

===Comment====

A simple comment (Generally just the name of the battleground for easy reference).

Marqin at 12:35, 17 September 2011

2011-09-17T12:35:32Z

New page

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `battleground_template` table'''</big>

This table hold the basic information about battlegrounds.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|ID# of the battleground. Contained in BattlemasterList.dbc.
|-
|[[#MinPlayersPerTeam|MinPlayersPerTeam]]
|smallint(5)
|unsigned
|
|The required number of players in each level bracket to start the battleground.
|-
|[[#MaxPlayersPerTeam|MaxPlayersPerTeam]]
|smallint(5)
|unsigned
|
|The maximum number of players that can be in the battleground.
|-
|[[#MinLvl|MinLvl]]
|tinyint(3)
|unsigned
|
|The minimum level you must be to join the battleground.
|-
|[[#MaxLvl|MaxLvl]]
|tinyint(3)
|unsigned
|
|The maximum level you can be to join the battleground (Usually 85).
|-
|[[#AllianceStartLoc|AllianceStartLoc]]
|mediumint(8)
|unsigned
|
|The location within the battlegrounds all Alliance players will start. Contained in WorldSafeLocs.dbc.
|-
|[[#AllianceStartO|AllianceStartO]]
|float
|signed
|
|The orientation the Alliance players will be when the spawn (North = 0, moves clockwise).
|-
|[[#HordeStartLoc|HordeStartLoc]]
|mediumint(8)
|unsigned
|
|The location within the battlegrounds all Horde players will start. Contained in WorldSafeLocs.dbc.
|-
|[[#HordeStartO|HordeStartO]]
|float
|signed
|
|The orientation the Horde. players will be when the spawn (North = 0, moves clockwise).
|-
|[[#Weight|Weight]]
|tinyint(2)
|unsigned
|1
|
|-
|[[#ScriptName|ScriptName]]
|char(64)
|signed
|
|
|-
|[[#Comment|Comment]]
|char(32)
|signed
|
|A simple comment (Generally just the name of the battleground for easy reference).
|-
|}