AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
lfg_dungeon_rewards
The `lfg_dungeon_encounters` table
table-no-description|0
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| dungeonId | INT | UNSIGNED | PRI | NO | 0 | Dungeon entry from dbc | |
| maxlevel | TINYINT | UNSIGNED | PRI | NO | 0 | Max level at which this reward is rewarded | |
| firstQuestId | INT | UNSIGNED | NO | 0 | Quest id with rewards for first dungeon this day | ||
| firstMoneyVar | INT | UNSIGNED | NO | 0 | Money multiplier for completing the dungeon first time in a day with less players than max | ||
| firstXPVar | INT | UNSIGNED | NO | 0 | Experience multiplier for completing the dungeon first time in a day with less players than max | ||
| otherQuestId | INT | UNSIGNED | NO | 0 | Quest id with rewards for Nth dungeon this day | ||
| otherMoneyVar | INT | UNSIGNED | NO | 0 | Money multiplier for completing the dungeon Nth time in a day with less players than max | ||
| otherXPVar | INT | UNSIGNED | NO | 0 | Experience multiplier for completing the dungeon Nth time in a day with less players than max |
Description of the fields
dungeonId
Dungeon ID from LFGDungeons.dbc
maxlevel
Max level at which this reward is rewarded
firstQuestId
Quest_template.id with rewards for first dungeon this day.
firstMoneyVar
Money multiplier for completing the dungeon first time in a day with less players than max.
firstXPVar
Experience multiplier for completing the dungeon first time in a day with less players than max.
otherQuestId
Quest_template.id with rewards for Nth dungeon this day
otherMoneyVar
Money multiplier for completing the dungeon Nth time in a day with less players than max.
otherXPVar
Experience multiplier for completing the dungeon Nth time in a day with less players than max.