Help:LiquipediaDB/Match

The Match table stores data on matches, games and the participating opponents and players.

match2id

Unique id of the match. Has the format <bracketid>_<groupid>, where the bracket id is the aforementioned one and groupid is a string that uniquely identifies the match in relation to its match group, e.g. R01-M001 for a bracket. Is set automatically by the matchgroup.

match2bracketid

Unique id of the matchgroup (e.g. bracket/matchlist) that the match belongs to. Is expected to be 10 letters, allowed characters are a-z, A-Z and 0-9. Is set automatically by the matchgroup.

winner

An integer indicating the winner of the match. 0 for draws

walkover DEPRECATED

Indicates the reason for a default result. Should only used if |resulttype=default.
- ff: Forfeit (of either opponent)
- dq: Disqualification (of either opponent)
- l (lowercase L): No score known (W/L match)

resulttype DEPRECATED

Indicates the resulttype of a match. If a match proceeded as normal and has a single winner, then this should be left empty. There are a number of instances in which it should be filled in however:
- default: match has a winner, but was not actually played or score is unknown (e.g. because of forfeits)
- np match is not played or cancelled
- draw incase the match is a draw

status

Indicates the status of a match. Currently only two values are supported:
- notplayed match is not played or cancelled
- '' any other status

finished

Indicates if a match is finished or not. 1 indicates finished matches. 0 indicates unfinished matches.

mode

Wiki's choice. Preferably the game mode.

type

Offline or Online

section

The section on the page this match is part of.

game

Which version of the game we are playing. Is this CS 1.6, etc?

patch

Patch version that's in effect when match was played.

date

The date (including time) the match started at.

dateexact

Indicates if the date is exact (1) or estimated (0)

stream

JSON array of streams. (Mostly referring to the LP Special:Stream)

links

JSON array of (external) links. (examples: preview, recap, vod, ... on tl.net)

bestof

Indicates what best of (Bo) format the match is played with.

lrthread DEPRECATED

vod

Link to the VOD for this match

tournament

The full tournament name, with correct formatting.

parent

See parent pages.

parentname DEPRECATED

tickername

The ticker name of the tournament

shortname

The Tournament (series) shortname

series

The full series name, with correct formatting.

icon

The tournament logo icon. This is usually the series icon. See our file conventions.

icondark

The dark mode version of the tournament logo icon. This is usually the series icon. See our file conventions.

liquipediatier

Integer representing the Liquipedia tier.

liquipediatiertype

String specifying the Liquipedia type.

publishertier

String specifying the publisher tier if applicable. For example: Valve majors should have "Major".

extradata

Miscellaneous (mostly wiki specific) additional data.

match2bracketdata

Data about the position of the match in a bracket/matchlist and on the page.

match2opponents

List of opponents as JSON array. See #Match2opponent for more info. For conditioning on these to find matches, two special properties exist. [[opponent::value]] is a shorthand to find matches where any entry has the name property set to value. [[player::value]] does the same for match2players.

match2games

List of maps/games as JSON array. See #Match2game for more info.

match2id

Id of the match the opponent belongs to

match2opponentid

Id of the opponent, aka its position/key in the array of opponents, counting from 1.

type

type of the opponent. Can be one of the following:
- team: if any kind of team format of arbitrary number of team members. The team name is displayed.
- solo: a opponent consisting of a single player. The player name is displayed.
- duo: a opponent consisting of two players. The player names are displayed.
- trio: a opponent consisting of three players. The player names are displayed.
- quad: a opponent consisting of four players. The player names are displayed.

name

Arbitrary name that represents the opponent.

template

Template of the team or (if wanted by the wiki) the team of a solo player, e.g. team liquid.

icon

Team logo belonging to the above set template.

icondark

The dark mode version of the team logo belonging to the above set template.

score

placement

Final placement of the team as number, starting from 1 (the winner).

status

Status of the score of the opponent. Empty if the game has not started, afterwards it can be one of:
- S: regular score if it is set, used in most cases
- W: indicates the opponent reached its placement by a default win
- FF: indicates the opponent has forfeited the match
- DQ: indicates the opponent was disqualifed from the match
- L: indicates the opponent reached its placement by default loss
- D: indicates the opponent reached a draw with unknown score

match2players

List of players as JSON array. See #Match2player for more info.

extradata

Miscellaneous (mostly wiki specific) additional data.

match2id

Id of the match the player belongs to.

match2opponentid

Id of the opponent the player belongs to.

match2playerid

Id of the player, aka its position in the array of players, counting from 1.

name

The pagename of the player.

displayname

The name of the player to be displayed

flag

Flag code or country name of the player.

extradata

Miscellaneous (mostly wiki specific) additional data.

match2id

Id of the match the game belongs to

match2gameid

Id of the game, aka its position in the array of games

subgroup

If the game is a sub-game of another game or a game of a sub-match, this number indicates which game/sub-match it belongs to.

scores

JSON array of scores for the game/map. (e.g. scores[1] is the score opponent1 achieved and so on).

participants

JSON array JSONs for the participating players of the game/map
- This JSON only accepts JSON entries with a key of the structure X_Y (X indicates the match2opponentid, Y indicates the match2playerid).
- The sub-JSON fields can hold wikispecific data and work just like extradata fields.

winner

An integer indicating the winner of the game. 0 for draws

walkover DEPRECATED

Indicates the reason for a default result. Should only used if |resulttype=default.
- ff: Forfeit (of either opponent)
- dq: Disqualification (of either opponent)
- l (lowercase L): No score known (W/L match)

resulttype DEPRECATED

Indicates the resulttype of a game. If a game proceeded as normal and has a single winner, then this should be left empty. There are a number of instances in which it should be filled in however:
- default: game has a winner, but was not actually played or score is unknown (e.g. because of forfeits)
- np game is not played or cancelled
- draw incase the game is a draw

status

Indicates the status of a match. Currently only two values are supported:
- notplayed match is not played or cancelled
- '' any other status

mode

Wiki's choice. Preferably the game mode.

type

Offline or Online

game

Which version of the game we are playing. Is this CS 1.6, etc?

patch

Patch version that's in effect when match was played.

tournament

The full tournament name, with correct formatting.

date

The date (including time) the game started at.

vod

Link to the VOD for this game

map

Name of the map the game was played on

length

The length of the game

parent

See parent pages.

parentname DEPRECATED

extradata

Miscellaneous (mostly wiki specific) additional data.