Who has posted the most?

[Blade-uk]

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

[kh99]

Maybe something like

SELECT userid, username, posts FROM vb_user ORDER BY posts DESC LIMIT 10

where 'vb_' is whatever your TABLE_PREFIX is, of course.

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.

[Blade-uk]

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

[kh99]

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.

[FitgirlWorld]

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.