Logs

From OregonCore Wiki
Jump to: navigation, search

Back to realm database list of tables.


The `logs` table

This table holds log information from the running realm and world processes (if configured to do so). This is an optional table.

Schema Last Modified: Rev 205 - Schema Verified: Rev 665


Structure

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


Description of the fields

time

UNIX Timestamp. To see formatted time you can use this query:

SELECT FROM_UNIXTIME(`time`);

realm

The ID of the realm. See realmlist.id

type

Log entry type. One from the following table.

LogType Description
0 STRING
1 ERROR
2 BASIC
3 DETAIL
4 DEBUG
5 CHAR
6 WORLD
7 RA
8 GM
9 CRASH
10 CHAT

string

Text of log entry.