AzerothCore
arena_season_reward_group
The `arena_season_reward_group` table
Defines which arena teams get rewards at the end of an arena season. Teams need at least 30 games in the season, and members need to have played at least 30% of their team's games. The rewards of each group are in arena_season_reward.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | INT | PRI | AUTO_INCREMENT | ||||
| arena_season | TINYINT | UNSIGNED | NO | ||||
| criteria_type | ENUM | pct,abs | NO | pct | Determines how rankings are evaluated: "pct" - percentage-based (e.g., top 20% of the ladder), "abs" - absolute position-based (e.g., top 10 players). | ||
| min_criteria | FLOAT | NO | |||||
| max_criteria | FLOAT | NO | |||||
| reward_mail_template_id | INT | UNSIGNED | NO | ||||
| reward_mail_subject | VARCHAR(255) | ||||||
| reward_mail_body | TEXT | ||||||
| gold_reward | INT | UNSIGNED | NO |
Description of the fields
id
ID auto incremented.
arena_season
Arena season ID
criteria_type
Determines how rankings are evaluated
| value | comment |
|---|---|
| pct | percentage-based (e.g., top 20% of the ladder) |
| abs | absolute position-based (e.g., top 10 players) |
min_criteria
Start of the ranking range. With pct, a percentage of all teams sorted by rating, for example 0 for the top of the ladder. With abs, the rank of the first team, for example 1 for the best team.
max_criteria
End of the ranking range. With pct, a percentage of all teams, for example 0.5 for the top 0.5%. With abs, the rank of the last team to get the reward.
reward_mail_template_id
ID from MailTemplate.dbc of the mail that sends the item and money rewards. If 0, reward_mail_subject and reward_mail_body are used.
reward_mail_subject
Subject of the reward mail, if no reward_mail_template_id is set.
reward_mail_body
Text of the reward mail, if no reward_mail_template_id is set.
gold_reward
Gold reward in copper.