The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
[sql]SELECT postusername, COUNT(postuserid) AS totalthreads
FROM thread GROUP BY postuserid ORDER BY totalthreads DESC[/sql] |
#3
|
|||
|
|||
Working
Thanks very much Dismounted |
#4
|
|||
|
|||
i goto that page
Maintenance - Execute SQL Query and i get this error "You are not authorized to execute SQL queries" |
#5
|
||||
|
||||
You have to add your user ID to the list of users allowed to execute queries in config.php.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|