AzerothCore
Pages :
log_encounter
The `log_encounter` table
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| time | DATATIME | SIGNED | NO | ||||
| map | SMALLINT | UNSIGNED | NO | ||||
| difficulty | TINYINT | UNSIGNED | NO | ||||
| creditType | TINYINT | UNSIGNED | NO | ||||
| creditEntry | INT | UNSIGNED | NO | ||||
| playersInfo | TEXT | SIGNED | NO |
Description of the fields
time
The date and time the boss was killed.
map
The map of the encounter. See Map.dbc.
difficulty
The difficulty of the map.
creditType
0 if the encounter was credited by killing a creature, 1 if it was credited by a spell.
creditEntry
The creature entry or spell ID that credited the encounter.
playersInfo
One line per player in the map, with the name, GUID, account, IP, guild, position and the auras on the player as spell(effectMask).