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: Fri Nov 22 21:34:35 GMT 2024
Total time taken to generate the page: 0.14998 seconds
Calendar
Search
Help
Members
Register
Login
Home
]