I think I'm missing something... Is there a way to list the top posters during a given time period? I don't need it to display on the board, just need to look it up myself.
Top Posters Per Month
Collapse
X
-
-
You can use something similar to this, but modify it for the last month:
Code:SELECT COUNT(post.postid) AS count, user.username FROM user AS user LEFT JOIN post AS post ON (post.userid = user.userid) WHERE post.dateline > UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) GROUP BY post.userid ORDER BY count DESC
Code:SELECT COUNT(post.postid) AS count, user.username FROM user AS user LEFT JOIN post AS post ON (post.userid = user.userid) WHERE post.dateline > UNIX_TIMESTAMP('yyyy-mm-dd 00:00:00') AND post.dateline < UNIX_TIMESTAMP('yyyy-mm-dd 00:00:00') GROUP BY post.userid ORDER BY count DESC
-
-
Custom code is required to put the records into an HTML format for display on your forum pages. I recommend you post on www.vbulletin.org about this.Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment