Reset user statistics?
Reset user statistics?
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 .
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Reset user statistics?
hi there,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 .
try this SQL statment in the db.view
Code: Select all
SELECT username, MAX(played)
FROM statistic_user
GROUP BY username
best regards