Post count based contest for posts between certain dates

[TheInformer]

Hi all,

Currently looking to run a contest om our forum running 4.1.8 that will make the member with the most posts between now and a certain date a premium member. What i need is for it to automatically count all posts from when the contest is started (existing post count not included) and then once the pre-defined time is reached it tells us who got the most posts and we can then change their usergroup.

Hope that is clear and easy to follow, look forward to hearing your suggestions

[kh99]

I think I would create a new database table and copy over the userid, username, and posts fields from the existing user table, and then do the same at the end of the contest (or maybe the new table could contain a date field so you could use the same table for start and end). Then at the end of the contest you could find the winner with a query that calculated the difference. Or you could export the table to a spreadsheet if you're more comfortable with that.