Skip to content

battleground_template Table

Defines core parameters for each battleground: team sizes, level range, spawn locations, and reward spells.

Schema Summary

Field Type Key Null Default Extra
id mediumint(8) unsigned PRI NO
patch tinyint(3) unsigned PRI NO 0
min_players_per_team smallint(5) unsigned NO 0
max_players_per_team smallint(5) unsigned NO 0
min_level tinyint(3) unsigned NO 0
max_level tinyint(3) unsigned NO 0
alliance_win_spell smallint(5) unsigned NO 0
alliance_lose_spell smallint(5) unsigned NO 0
horde_win_spell smallint(5) unsigned NO 0
horde_lose_spell smallint(5) unsigned NO 0
alliance_start_location mediumint(8) unsigned NO 0
horde_start_location mediumint(8) unsigned NO 0
player_loot_id mediumint(8) unsigned NO 0

Field Breakdown

  • id - Primary Key. Battleground ID:
  • 1 - Alterac Valley
  • 2 - Warsong Gulch
  • 3 - Arathi Basin
  • patch - Primary Key. Patch version - the core loads the highest patch ≤ current.
  • min_players_per_team / max_players_per_team - Team size limits.
  • min_level / max_level - Level bracket allowed to queue.
  • alliance_win_spell / alliance_lose_spell - Spell cast on Alliance players on win/loss (from spell_template.entry).
  • horde_win_spell / horde_lose_spell - Same for Horde.
  • alliance_start_location / horde_start_location - WorldSafeLocs.dbc IDs (spawn points).
  • player_loot_id - Reference loot template filled when skinning the bones of dead players in this battleground.