DB:Auth:logs

Back to auth database list of tables.

The `logs` table

This table stores all logs from the server if database logging (EnableLogDB in config) is enabled.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
time	int(14)	signed		NO
realm	int(4)	signed		NO
type	int(4)	signed		NO
string	text	signed		YES

Description of the fields

time

A unixtime timestamp indicating when this string was logged.

realm

The RealmID of the realm this log string came from. 0 if realmd.

type

The type of log this is:

LOG_TYPE_STRING = 0 --- a normal informative string
LOG_TYPE_ERROR  = 1 --- some sort of error
LOG_TYPE_BASIC  = 2 --- basic information
LOG_TYPE_DETAIL = 3 --- detailed information
LOG_TYPE_DEBUG  = 4 --- debugging information
LOG_TYPE_CHAR   = 5 --- character-related
LOG_TYPE_WORLD  = 6 --- world packet dump
LOG_TYPE_RA     = 7 --- remote access logs
LOG_TYPE_GM     = 8 --- gm command logs
LOG_TYPE_CRASH  = 9 --- crash alarm logs
LOG_TYPE_CHAT   = 10 -- chat/message logs

string

The actual string that has been logged.