From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/logs.md | 134 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 125 insertions(+), 9 deletions(-) (limited to 'docs/logs.md') diff --git a/docs/logs.md b/docs/logs.md index 6f1d31b..318b420 100644 --- a/docs/logs.md +++ b/docs/logs.md @@ -1,9 +1,125 @@ -[Database Structure](Database-Structure) > [Auth-Database](Auth-Database) > [logs](logs) - -Column | Type | Description ---- | --- | --- -Time | int(10) unsigned | -Realm | int(10) unsigned | -Type | varchar(250) | -Level | tinyint(3) unsigned | -String | text | +# logs + +`Back-to:Auth` + +**The \`logs\` table** + +This table stores all logs from authserver if database logging in config is enabled. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

time

int(10)

unsigned

 

NO

 

 

 

realm

realm(10)

unsigned

 

NO

 

 

 

type

tinyint(3)

unsigned

 

NO

 

 

 

level

tinyint(3)

unsigned

 

NO

0

 

 

string

text

signed

 

YES

 

 

 

+ +**Description of the fields** + +### time + +A unixtime timestamp indicating when this string was logged. + +### realm + +The [RealmID](realmlist_2130016.html#realmlist-id) 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 + +### level + +Depends on LogLevel in authserver.conf + +- 1 - (Trace) +- 2 - (Debug) +- 3 - (Info) +- 4 - (Warn) +- 5 - (Error) +- 6 - (Fatal) + +### string + +The actual string that has been logged. -- cgit