Server reporting and data mining - Revision history

Talad: /* report.xml */

2021-02-21T18:52:26Z

report.xml

← Older revision		Revision as of 18:52, 21 February 2021
Line 53:		Line 53:

	<server_report time="Sun Feb 21 17:27:01 2021" now="1613928421" number="576358" client_count="13" mob_births="4810" mob_deaths="4810" player_deaths="49" sold_items="11400" sold_value="5994348" totalMoneyIn="6215083" totalMoneyOut="693285">		<server_report time="Sun Feb 21 17:27:01 2021" now="1613928421" number="576358" client_count="13" mob_births="4810" mob_deaths="4810" player_deaths="49" sold_items="11400" sold_value="5994348" totalMoneyIn="6215083" totalMoneyOut="693285">

			client_count is the current number of connect players. all other statistics are incremental since the startup of the server.

	Second section, one line for each player connected:		Second section, one line for each player connected:

Talad: /* Dynamic view generated by the server at runtime */

2021-02-21T18:46:20Z

Dynamic view generated by the server at runtime

← Older revision		Revision as of 18:46, 21 February 2021
Line 43:		Line 43:

	Planeshift.Server.Status.Report = 1		Planeshift.Server.Status.Report = 1
	Planeshift.Server.Status.Rate = 1000		Planeshift.Server.Status.Rate = 1000 (CHANGE THIS DEFAULT)
	Planeshift.Server.Status.LogFile = /this/report.xml		Planeshift.Server.Status.LogFile = /this/report.xml

Talad: /* Dynamic view generated by the server at runtime */

2021-02-21T18:44:15Z

Dynamic view generated by the server at runtime

@@ Line 38: / Line 38: @@
 == Dynamic view generated by the server at runtime ==
-In the main server dir we have report.xml which contains the following data, generate by ServerStatus class in planeshift\trunk\src\server\serverstatus.h:
+ServerStatus class is generating two xml files, located in the main server dir.
 First section, global data:
@@ Line 52: / Line 62: @@
    <npc name="Aleena Arlavin" characterID="31" kills="0" deaths="0" suicides="0" pos_x="-131.30" pos_y="33.89" pos_z="-86.00" sector="hydlaa_plaza" />
 == Static view generated by rrdtool ==

Talad: /* Wish list */

2021-02-21T18:26:02Z

Wish list

← Older revision		Revision as of 18:26, 21 February 2021
Line 93:		Line 93:
	* The races in % of all characters, and ones with >10 hours of gameplay.		* The races in % of all characters, and ones with >10 hours of gameplay.
	* The average of diff between account creation and last login by quarter.		* The average of diff between account creation and last login by quarter.
	Average damage done by a character to an NPC (server managed creature) within a day.		* Average damage done by a character to an NPC (server managed creature) within a day.
	Average damage done by an NPC (server managed creature) to a character within a day.		* Average damage done by an NPC (server managed creature) to a character within a day.
	Highest amount of tria (virtual money) owned by a user		* Highest amount of tria (virtual money) owned by a user
	How many trias (virtual money) an average guild has after certain amount of hours of existence in bank		* How many trias (virtual money) an average guild has after certain amount of hours of existence in bank
			* Highest amount of tria (virtual money) owned by a guild in bank
			* Details about the total wealth of a guild including or excluding money in bank (sum up money of each player in the guild)

			Items

			* How many users use crafting for creating new items
			* Number of crafted items a day.
			* Number of crafted items used vs looted items.
			* Average value of crafted items.
			* Average value of looted items.

Talad: /* My Plane dynamic view */

2021-02-21T18:22:28Z

My Plane dynamic view

← Older revision		Revision as of 18:22, 21 February 2021
Line 77:		Line 77:

	This is then read by MyPlane when showing the online or offline status of the character		This is then read by MyPlane when showing the online or offline status of the character


			== Main web site statistics ==

			We have a guilds page which is listing the top guild, with creation date and number of members.

			https://www.planeshift.it/guilds

	== Wish list ==		== Wish list ==

Talad: /* Wish list */

2021-02-21T18:21:46Z

Wish list

← Older revision		Revision as of 18:21, 21 February 2021
Line 80:		Line 80:
	== Wish list ==		== Wish list ==

	Described in the [[Analysis_package]] done for GSoC. ~~Never~~ implemented.		Described in the [[Analysis_package]] done for GSoC.

			The majority was implemented we miss these ones:

			* The races in % of all characters, and ones with >10 hours of gameplay.
			* The average of diff between account creation and last login by quarter.
			Average damage done by a character to an NPC (server managed creature) within a day.
			Average damage done by an NPC (server managed creature) to a character within a day.
			Highest amount of tria (virtual money) owned by a user
			How many trias (virtual money) an average guild has after certain amount of hours of existence in bank

Talad: /* Static view generated by rrdtool */

2021-02-21T18:10:42Z

Static view generated by rrdtool

← Older revision		Revision as of 18:10, 21 February 2021
Line 54:		Line 54:

	== Static view generated by rrdtool ==		== Static view generated by rrdtool ==

			rrdtool is a standard package, you can get it with apt-get rrdtool in Ubuntu

	For accounts and characters created, rrdtool is executing every x minutes:		For accounts and characters created, rrdtool is executing every x minutes:

Talad: /* Dynamic view generated by the server at runtime */

2021-02-21T17:53:29Z

Dynamic view generated by the server at runtime

← Older revision		Revision as of 17:53, 21 February 2021
Line 52:		Line 52:
	<npc name="Aleena Arlavin" characterID="31" kills="0" deaths="0" suicides="0" pos_x="-131.30" pos_y="33.89" pos_z="-86.00" sector="hydlaa_plaza" />		<npc name="Aleena Arlavin" characterID="31" kills="0" deaths="0" suicides="0" pos_x="-131.30" pos_y="33.89" pos_z="-86.00" sector="hydlaa_plaza" />


			== Static view generated by rrdtool ==

			For accounts and characters created, rrdtool is executing every x minutes:

			SELECT Count(*) from accounts;
			SELECT Count(*) from characters;

			This populates pscharacters.rrd and psaccounts.rrd

			Then is reading report.xml and extracting:
			psonline.rrd (Player online)
			psmobs.rrd (NPC birth and deaths)
			psplayers.rrd (Player deaths)
			psecon.rrd (Economy)

	== My Plane dynamic view ==		== My Plane dynamic view ==

Talad: /* Dynamic view generated by the server at runtime */

2021-02-21T17:49:08Z

Dynamic view generated by the server at runtime

← Older revision		Revision as of 17:49, 21 February 2021
Line 51:		Line 51:

	<npc name="Aleena Arlavin" characterID="31" kills="0" deaths="0" suicides="0" pos_x="-131.30" pos_y="33.89" pos_z="-86.00" sector="hydlaa_plaza" />		<npc name="Aleena Arlavin" characterID="31" kills="0" deaths="0" suicides="0" pos_x="-131.30" pos_y="33.89" pos_z="-86.00" sector="hydlaa_plaza" />


			== My Plane dynamic view ==

			Generated by /home/planeshift/myplane/cronjob.php , it takes report.xml present in the main server dir and reads characterid and sector and putting this info in the myplane database

			INSERT INTO `active_characters` (`characterid`,`sector`) VALUES ( :id, :sector )');

			This is then read by MyPlane when showing the online or offline status of the character

	== Wish list ==		== Wish list ==

	Described in the [[Analysis_package]] done for GSoC. Never implemented.		Described in the [[Analysis_package]] done for GSoC. Never implemented.

Talad: /* Dynamic view generated by the server at runtime */

2021-02-21T17:41:20Z

Dynamic view generated by the server at runtime

← Older revision		Revision as of 17:41, 21 February 2021
Line 38:		Line 38:
	== Dynamic view generated by the server at runtime ==		== Dynamic view generated by the server at runtime ==

	In the main server dir we have report.xml which contains ~~this~~ data:		In the main server dir we have report.xml which contains the following data, generate by ServerStatus class in planeshift\trunk\src\server\serverstatus.h:

	First section, global data:		First section, global data:
Line 51:		Line 51:

	<npc name="Aleena Arlavin" characterID="31" kills="0" deaths="0" suicides="0" pos_x="-131.30" pos_y="33.89" pos_z="-86.00" sector="hydlaa_plaza" />		<npc name="Aleena Arlavin" characterID="31" kills="0" deaths="0" suicides="0" pos_x="-131.30" pos_y="33.89" pos_z="-86.00" sector="hydlaa_plaza" />




	== Wish list ==		== Wish list ==

	Described in the [[Analysis_package]] done for GSoC. Never implemented.		Described in the [[Analysis_package]] done for GSoC. Never implemented.