View Full Version : How can I get the most poster?
Penicillin
07-28-2008, 01:24 AM
Hello
I want to get the most poster (who posted threads only NOT threads and replies) in my forum.
Can I do that? how?
Thanks
Dismounted
07-28-2008, 07:23 AM
SELECT postusername, COUNT(postuserid) AS totalthreads
FROM thread
GROUP BY postuserid
ORDER BY totalthreads DESC
Penicillin
07-28-2008, 06:11 PM
Working
Thanks very much Dismounted
Sycoloco1212
07-29-2008, 03:19 AM
i goto that page
Maintenance - Execute SQL Query
and i get this error
"You are not authorized to execute SQL queries"
Dismounted
07-29-2008, 06:59 AM
You have to add your user ID to the list of users allowed to execute queries in config.php.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.