The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
I am going to be running a competition on my forum.
I need a way of telling who has posted the most between now and this time next month. Is there any way to run a query of some sort or anything to determine who has made the most posts from 2 seperate dates? Many thanks, Andy |
#2
|
|||
|
|||
![]()
Maybe something like
Code:
SELECT userid, username, posts FROM vb_user ORDER BY posts DESC LIMIT 10 For some reason when I used this in the Maintenance Execute SQL Query box in the ACP, the LIMIT didn't work, so I don't know, maybe there's something wrong with that syntax. Of course the above would have to be executed at the correct times. There's probably a way to do a query on the posts table to find out how many posts were made by each user for any time period. |
#3
|
|||
|
|||
![]()
Hi thanks kh99, i ended up using:
SELECT userid, username, posts FROM user ORDER BY posts DESC LIMIT 10000 in phpmyadmin and downloaded the tables into an excel file so i have a list and then i will run it again in a months time when the competition ends and find the difference between the users posts now and then. Thanks a lot ![]() By the way, the limit works in phpmyadmin ![]() Andy |
#4
|
|||
|
|||
![]()
You could just leave the LIMIT off completely if you want everyone (and I guess the "ORDER BY" as well, or maybe order by id or name instead).
I guess I was just thinking that you'd be interested in the top posters, but of course you won't know who that is until the end. ![]() |
#5
|
|||
|
|||
![]()
I did the same contest but I simply used a mod from this website--- Cyb Advanced Forum Statistics and kept track of it that way.
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|