123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329 |
-
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.Text;
- using Mono.Data.SqliteClient;
- using OpenMetaverse;
- using OpenMetaverse.StructuredData;
- using OpenSim.Region.Framework.Scenes;
- namespace OpenSim.Region.UserStatistics
- {
- public class Clients_report : IStatsController
- {
- #region IStatsController Members
- public string ReportName
- {
- get { return "Client"; }
- }
-
-
-
-
-
-
-
-
-
-
-
- public string RenderJson(Hashtable pModelResult) {
- stats_default_page_values values = (stats_default_page_values) pModelResult["hdata"];
- OSDMap summaryInfo = new OpenMetaverse.StructuredData.OSDMap();
- summaryInfo.Add("totalUsers", new OSDString(values.total_num_users.ToString()));
- summaryInfo.Add("totalSessions", new OSDString(values.total_num_sessions.ToString()));
- summaryInfo.Add("averageClientFPS", new OSDString(values.avg_client_fps.ToString()));
- summaryInfo.Add("averageClientMem", new OSDString(values.avg_client_mem_use.ToString()));
- summaryInfo.Add("averageSimFPS", new OSDString(values.avg_sim_fps.ToString()));
- summaryInfo.Add("averagePingTime", new OSDString(values.avg_ping.ToString()));
- summaryInfo.Add("totalKBOut", new OSDString(values.total_kb_out.ToString()));
- summaryInfo.Add("totalKBIn", new OSDString(values.total_kb_in.ToString()));
- return summaryInfo.ToString();
- }
- public Hashtable ProcessModel(Hashtable pParams)
- {
- SqliteConnection dbConn = (SqliteConnection)pParams["DatabaseConnection"];
- List<ClientVersionData> clidata = new List<ClientVersionData>();
- List<ClientVersionData> cliRegData = new List<ClientVersionData>();
- Hashtable regionTotals = new Hashtable();
- Hashtable modeldata = new Hashtable();
- modeldata.Add("Scenes", pParams["Scenes"]);
- modeldata.Add("Reports", pParams["Reports"]);
- int totalclients = 0;
- int totalregions = 0;
- lock (dbConn)
- {
- string sql = "select count(distinct region_id) as regcnt from stats_session_data";
- SqliteCommand cmd = new SqliteCommand(sql, dbConn);
- SqliteDataReader sdr = cmd.ExecuteReader();
- if (sdr.HasRows)
- {
- sdr.Read();
- totalregions = Convert.ToInt32(sdr["regcnt"]);
- }
- sdr.Close();
- sdr.Dispose();
- sql =
- "select client_version, count(*) as cnt, avg(avg_sim_fps) as simfps from stats_session_data group by client_version order by count(*) desc LIMIT 10;";
- cmd = new SqliteCommand(sql, dbConn);
- sdr = cmd.ExecuteReader();
- if (sdr.HasRows)
- {
- while (sdr.Read())
- {
- ClientVersionData udata = new ClientVersionData();
- udata.version = sdr["client_version"].ToString();
- udata.count = Convert.ToInt32(sdr["cnt"]);
- udata.fps = Convert.ToSingle(sdr["simfps"]);
- clidata.Add(udata);
- totalclients += udata.count;
-
- }
- }
- sdr.Close();
- sdr.Dispose();
- if (totalregions > 1)
- {
- sql =
- "select region_id, client_version, count(*) as cnt, avg(avg_sim_fps) as simfps from stats_session_data group by region_id, client_version order by region_id, count(*) desc;";
- cmd = new SqliteCommand(sql, dbConn);
-
- sdr = cmd.ExecuteReader();
-
- if (sdr.HasRows)
- {
- while (sdr.Read())
- {
- ClientVersionData udata = new ClientVersionData();
- udata.version = sdr["client_version"].ToString();
- udata.count = Convert.ToInt32(sdr["cnt"]);
- udata.fps = Convert.ToSingle(sdr["simfps"]);
- udata.region_id = UUID.Parse(sdr["region_id"].ToString());
- cliRegData.Add(udata);
- }
- }
- sdr.Close();
- sdr.Dispose();
- }
- }
-
- foreach (ClientVersionData cvd in cliRegData)
- {
-
- if (regionTotals.ContainsKey(cvd.region_id))
- {
- int regiontotal = (int)regionTotals[cvd.region_id];
- regiontotal += cvd.count;
- regionTotals[cvd.region_id] = regiontotal;
- }
- else
- {
- regionTotals.Add(cvd.region_id, cvd.count);
- }
-
-
- }
- modeldata["ClientData"] = clidata;
- modeldata["ClientRegionData"] = cliRegData;
- modeldata["RegionTotals"] = regionTotals;
- modeldata["Total"] = totalclients;
- return modeldata;
- }
- public string RenderView(Hashtable pModelResult)
- {
- List<ClientVersionData> clidata = (List<ClientVersionData>) pModelResult["ClientData"];
- int totalclients = (int)pModelResult["Total"];
- Hashtable regionTotals = (Hashtable) pModelResult["RegionTotals"];
- List<ClientVersionData> cliRegData = (List<ClientVersionData>) pModelResult["ClientRegionData"];
- List<Scene> m_scenes = (List<Scene>)pModelResult["Scenes"];
- Dictionary<string, IStatsController> reports = (Dictionary<string, IStatsController>)pModelResult["Reports"];
- const string STYLESHEET =
- @"
- <STYLE>
- body
- {
- font-size:15px; font-family:Helvetica, Verdana; color:Black;
- }
- TABLE.defaultr { }
- TR.defaultr { padding: 5px; }
- TD.header { font-weight:bold; padding:5px; }
- TD.content {}
- TD.contentright { text-align: right; }
- TD.contentcenter { text-align: center; }
- TD.align_top { vertical-align: top; }
- </STYLE>
- ";
- StringBuilder output = new StringBuilder();
- HTMLUtil.HtmlHeaders_O(ref output);
- output.Append(STYLESHEET);
- HTMLUtil.HtmlHeaders_C(ref output);
- HTMLUtil.AddReportLinks(ref output, reports, "");
- HTMLUtil.TABLE_O(ref output, "defaultr");
- HTMLUtil.TR_O(ref output, "");
- HTMLUtil.TD_O(ref output, "header");
- output.Append("ClientVersion");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "header");
- output.Append("Count/%");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "header");
- output.Append("SimFPS");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TR_C(ref output);
- foreach (ClientVersionData cvd in clidata)
- {
- HTMLUtil.TR_O(ref output, "");
- HTMLUtil.TD_O(ref output, "content");
- string linkhref = "sessions.report?VersionString=" + cvd.version;
- HTMLUtil.A(ref output, cvd.version, linkhref, "");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "content");
- output.Append(cvd.count);
- output.Append("/");
- if (totalclients > 0)
- output.Append((((float)cvd.count / (float)totalclients)*100).ToString());
- else
- output.Append(0);
- output.Append("%");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "content");
- output.Append(cvd.fps);
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TR_C(ref output);
- }
- HTMLUtil.TABLE_C(ref output);
- if (cliRegData.Count > 0)
- {
- HTMLUtil.TABLE_O(ref output, "defaultr");
- HTMLUtil.TR_O(ref output, "");
- HTMLUtil.TD_O(ref output, "header");
- output.Append("Region");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "header");
- output.Append("ClientVersion");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "header");
- output.Append("Count/%");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "header");
- output.Append("SimFPS");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TR_C(ref output);
- foreach (ClientVersionData cvd in cliRegData)
- {
- HTMLUtil.TR_O(ref output, "");
- HTMLUtil.TD_O(ref output, "content");
- output.Append(regionNamefromUUID(m_scenes, cvd.region_id));
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "content");
- output.Append(cvd.version);
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "content");
- output.Append(cvd.count);
- output.Append("/");
- if ((int)regionTotals[cvd.region_id] > 0)
- output.Append((((float)cvd.count / (float)((int)regionTotals[cvd.region_id])) * 100).ToString());
- else
- output.Append(0);
- output.Append("%");
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TD_O(ref output, "content");
- output.Append(cvd.fps);
- HTMLUtil.TD_C(ref output);
- HTMLUtil.TR_C(ref output);
- }
- HTMLUtil.TABLE_C(ref output);
- }
- output.Append("</BODY>");
- output.Append("</HTML>");
- return output.ToString();
- }
- public string regionNamefromUUID(List<Scene> scenes, UUID region_id)
- {
- string returnstring = string.Empty;
- foreach (Scene sn in scenes)
- {
- if (region_id == sn.RegionInfo.originRegionID)
- {
- returnstring = sn.RegionInfo.RegionName;
- break;
- }
- }
- if (returnstring.Length == 0)
- {
- returnstring = region_id.ToString();
- }
- return returnstring;
- }
- #endregion
- }
- public struct ClientVersionData
- {
- public UUID region_id;
- public string version;
- public int count;
- public float fps;
- }
- }
|