Page 1 of 1
Reset user statistics?
Posted: 12 Jul 2013, 17:09
by bcrivers
Anyone know how to reset user statistics? It is populated with historical data. I want to figure out which of my family members are not using the server in the last 3 months so I can delete their accounts. By resetting data, In three months I can determine who is not using it .
Re: Reset user statistics?
Posted: 14 Jul 2013, 00:43
by Madsonic
bcrivers wrote:Anyone know how to reset user statistics? It is populated with historical data. I want to figure out which of my family members are not using the server in the last 3 months so I can delete their accounts. By resetting data, In three months I can determine who is not using it .
hi there,
try this SQL statment in the db.view
Code: Select all
SELECT username, MAX(played)
FROM statistic_user
GROUP BY username
This show you the last user usage from you server.
best regards
Re: Reset user statistics?
Posted: 19 Jul 2013, 06:16
by bcrivers
Cool, thank you.