From 1b7c8cf7b54da6e1a59f9fc1039e78189be3815e Mon Sep 17 00:00:00 2001 From: onefang Date: Wed, 7 Aug 2019 07:45:44 +1000 Subject: Testing MySQLRaw's SELECT. --- OpenSim/Server/Handlers/Web/WebServerInConnector.cs | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/OpenSim/Server/Handlers/Web/WebServerInConnector.cs b/OpenSim/Server/Handlers/Web/WebServerInConnector.cs index bc34bae..568b7d6 100644 --- a/OpenSim/Server/Handlers/Web/WebServerInConnector.cs +++ b/OpenSim/Server/Handlers/Web/WebServerInConnector.cs @@ -212,6 +212,17 @@ namespace OpenSim.Server.Handlers.Web reply["str_response_string"] = loggedOnPage(body, fields); } } + else if ("list" == fields["doit"].ToString()) + { + List< Hashtable > rows = m_database.Select("GridUser", "Login > UNIX_TIMESTAMP(FROM_UNIXTIME(UNIX_TIMESTAMP(now()) - 2419200))"); + foreach (Hashtable row in rows) + { + string line = ""; + foreach (DictionaryEntry c in row) + line = line + " | " + (string) c.Value; + m_log.Info("[MariaDB RAW]: " + line); + } + } else { reply["str_response_string"] = loggedOnPage(body, fields); -- cgit v1.1