How can I get the most poster?
 

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

[sql]SELECT postusername, COUNT(postuserid) AS totalthreads
FROM thread
GROUP BY postuserid
ORDER BY totalthreads DESC[/sql]

Working
Thanks very much Dismounted

i goto that page

Maintenance - Execute SQL Query

and i get this error

"You are not authorized to execute SQL queries"

You have to add your user ID to the list of users allowed to execute queries in config.php.