How to :: Display Most Active Users | ExpressionEngine Community Forums

« Return to ExpressionEngine

How to :: Display Most Active Users

Posted: 13 October 2008 10:30 PM

[ Ignore ]

Summer Student

Total Posts: 13

Joined 01-16-2008

How can I display a list of most active users based on the total comments they post?

Thank you for your time

Profile

Posted: 14 October 2008 12:26 AM

[ Ignore ] [ # 1 ]

Moderator

Total Posts: 15368

Joined 05-15-2004

A custom query, I should think:

SELECT name, COUNT(name) AS number FROM `exp_comments` 
WHERE status = 'o' GROUP BY name ORDER BY number DESC, name ASC 

That should do nicely.

Signature

Everything will be good in the end. If it’s not good, it’s not the end.

Profile

MSG

‹‹ Automatically populate the title field with other custom fields in a SAEF How to force line break with HTML buttons? ››

Post Marker Legend
	New posts		Hot Topic with new posts		New Poll		Moved Topic		Sticky topic
	No new posts		Hot Topic with no new posts		Old Poll		Closed Topic		Announcements

Theme

Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members:	64904	Total Logged-in Users:	49
Total Topics:	81848	Total Anonymous Users:	22
Total Replies:	440038	Total Guests:	254
Total Posts:	521886

Members ( View Memberlist )

Newest Members: whobutsb, Martin Designer, Victor A, From Somebody Else, ericholter, crocomodx, Blackace, Marcos Ortiz Valmaseda, kyneburg, jennsing

Active Members: Alejandro Mut, Alicat, Andru Edwards, applepie23, atlkaren, Bart Kusters, Bas1c, bayowar, bromtec, c.emerson, Capt.Mike, Carlo, Chad Clark, CMc, Crucial, daclarkie, davidlogan, Derek Allard, digitald3, Euan, Flatulent Badger, iain, Ingmar Greil, jennsing, JimGoings, kirkaracha, lebisol, lifeboatcreative, Luke Walding, Lyle Anderson, MarcusNeto, mjds, Nevin Lyne, pico, Robb Ottenhoff, Robert Eerhart, Robin Sowell, robt, ruraldreams, Ruud L. Heerkens, sakana, silenz, socaprice, spacewalk, susansan, TurnItUp Media, Volosatos, wintercounter, xopher

Powered By ExpressionEngine
ExpressionEngine Discussion Forum - Version 2.1.1 (20081028)
Script Executed in 0.5762 seconds