Home »
FUDforum »
How To »
find user stats
find user stats [message #36082] |
Sat, 03 March 2007 03:10 |
littleking
Messages: 187 Registered: January 2007
Karma: 2
|
Senior Member |
|
|
for instance, how do i find users who have tons of private message usage so i can ask them to clean it up
|
|
|
Re: find user stats [message #36101 is a reply to message #36082] |
Sun, 04 March 2007 18:00 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
You need to run a query like this:
SELECT ouser_id, SUM(length) FROM fud26_pmsg GROUP BY ouser_id;
this will give you statistics you are looking for.
FUDforum Core Developer
|
|
|
Goto Forum:
Current Time: Sat Nov 23 01:37:33 GMT 2024
Total time taken to generate the page: 0.21147 seconds