Battleground template 548 - Revision history

Admin: /* StartMaxDist */

2021-08-09T01:03:45Z

StartMaxDist

← Older revision		Revision as of 20:03, 8 August 2021
Line 189:		Line 189:
	===StartMaxDist===		===StartMaxDist===

	~~bla bla bla~~		Unknown

	===Weight===		===Weight===

Admin: Update Description

2021-08-09T01:03:20Z

Update Description

← Older revision		Revision as of 20:03, 8 August 2021
Line 153:		Line 153:
	===id===		===id===

	ID# of the battleground. Contained in [[BattlemasterList.dbc ~~SF\|BattlemasterList.dbc]]~~.		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 [[WorldSafeLocs.dbc ~~SF\|WorldSafeLocs.dbc]]~~.		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 [[WorldSafeLocs.dbc ~~SF\|WorldSafeLocs.dbc]]~~.		The location within the battlegrounds all Horde players will start. Contained in WorldSafeLocs.dbc.

	===HordeStartO===		===HordeStartO===
Line 193:		Line 193:
	===Weight===		===Weight===

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

Admin: Add missing table entry

2021-08-09T00:58:51Z

Add missing table entry

← Older revision		Revision as of 19:58, 8 August 2021
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).

Admin: Add content

2021-08-09T00:53:53Z

Add content

New page

{| align="right"
| __TOC__
|}
{{Back-to:World_18414}}

<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>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
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
;
</pre>

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