diff options
Diffstat (limited to 'src/server/worldserver')
| -rwxr-xr-x | src/server/worldserver/CommandLine/CliRunnable.cpp | 12 | ||||
| -rw-r--r-- | src/server/worldserver/worldserver.conf.dist | 8 |
2 files changed, 19 insertions, 1 deletions
diff --git a/src/server/worldserver/CommandLine/CliRunnable.cpp b/src/server/worldserver/CommandLine/CliRunnable.cpp index e3a7fef571a..e9da92f9e6b 100755 --- a/src/server/worldserver/CommandLine/CliRunnable.cpp +++ b/src/server/worldserver/CommandLine/CliRunnable.cpp @@ -530,6 +530,18 @@ bool ChatHandler::HandleServerSetDiffTimeCommand(const char *args) return true; } +/// toggle sql driver query logging +bool ChatHandler::HandleServerToggleQueryLogging(const char* /* args */) +{ + sLog.SetSQLDriverQueryLogging(!sLog.GetSQLDriverQueryLogging()); + if(sLog.GetSQLDriverQueryLogging()) + PSendSysMessage(LANG_SQLDRIVER_QUERY_LOGGING_ENABLED); + else + PSendSysMessage(LANG_SQLDRIVER_QUERY_LOGGING_DISABLED); + + return true; +} + /// @} #ifdef linux diff --git a/src/server/worldserver/worldserver.conf.dist b/src/server/worldserver/worldserver.conf.dist index 814e7073deb..368910abf98 100644 --- a/src/server/worldserver/worldserver.conf.dist +++ b/src/server/worldserver/worldserver.conf.dist @@ -405,9 +405,14 @@ CleanCharacterDB = 0 # # SQLDriverLogFile # Log file of SQL driver events. -# For effective query logging you need to build in debug configuration. +# For effective query logging you need to configure SQLDriverQueryLogging. # Default: "" - Empty name for disable # +# SQLDriverQueryLogging +# Log SQL queries to the SQLDriverLogFile and console +# Default: 0 - disabled (Query errors only) +# 1 - enabled (Full query logging - may have performance impact) +# # LogColors # Color for messages (format "normal basic detail debug") # Default: "" - no colors @@ -538,6 +543,7 @@ RaLogFile = "ra_commands.log" ArenaLogFile = "" ArenaLog.ExtendedInfo = 0 SQLDriverLogFile = "" +SQLDriverQueryLogging = 0 LogColors = "" EnableLogDB = 0 DBLogLevel = 2 |