Add new Edit Delete History Source

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.

instance_encounters

The `instance_encounters` table

Definitions of instance encounters. Used by LFG.

Table Structure

Field	Type	Attributes	Key	Null	Default	Comment
entry	INT	UNSIGNED	PRI	NO	0	Unique entry from DungeonEncounter.dbc
creditType	TINYINT	UNSIGNED		NO	0
creditEntry	INT	UNSIGNED		NO	0
lastEncounterDungeon	SMALLINT	UNSIGNED		NO	0	If not 0, LfgDungeon.dbc entry for the instance it is last encounter in
comment	varchat(255)	SIGNED		NO	"

Description of the fields

See enum EncounterCreditType.

ENCOUNTER_CREDIT_KILL_CREATURE = 0

ENCOUNTER_CREDIT_CAST_SPELL = 1

If creditType = 0, then value for this field is creature entry. See creature_template.entry

If creditType = 1, then value for this field is a spell. See Spell.dbc.

Reference to LfgDungeon.dbc entry for the instance it which is this encounter last. If 0, encounter is not last one.

Instance encounter comment for easy identification. Encounter name used only.