Reset user statistics?

Need help? Post your questions here.
bcrivers
Posts: 33
Joined: 13 Jan 2013, 16:28
Has thanked: 2 times
Been thanked: 9 times

Reset user statistics?

Unread post 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 .
These users thanked the author bcrivers for the post:
Madsonic
Rating: 7.69%
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

Re: Reset user statistics?

Unread post 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
bcrivers
Posts: 33
Joined: 13 Jan 2013, 16:28
Has thanked: 2 times
Been thanked: 9 times

Re: Reset user statistics?

Unread post by bcrivers »

Cool, thank you.
These users thanked the author bcrivers for the post:
Madsonic
Rating: 7.69%
Post Reply