FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » find user stats
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
find user stats [message #36082] Sat, 03 March 2007 03:10 Go to next message
littleking is currently offline  littleking   United States
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 Go to previous message
Ilia is currently offline  Ilia   Canada
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
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Force ignore?
Next Topic: Deleting Moderation Queue
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 15:27:03 GMT 2024

Total time taken to generate the page: 0.02243 seconds