Keeping track of post count - 200 post intervals

[OllieUK]

Morning All,

I'm looking for some kind of solution which will notify me whenever a member has made 200 posts, each time they pass the 200 post mark (i.e. 200, 400, 600...)

We're an internet retailer and use our forums as a community for our customers. One of the incentives to get customers to generate content and join in with discussions is that we will issue them with a free next day shipping voucher for every 200 posts they make.

At the moment, as a stop-gap, I'm using the "Top Posters" Plugin, which gives me the number of posts members have made in a 7 day period, however I then need to manually keep a track of these numbers in a spreadsheet so I can issue vouchers when they have been earned. This wouldn't be an issue, but with over 5,500 registered members I can see it's going to become very messy and time consuming!


Not sure whether there is already a modification/plugin which will do what I need - either by presenting the data in a report/table or even by notifying me each time a members passes a 200 post threshold?


It would be simpler if this was a new forum and all members were starting with zero posts, however we have been established for a good number of years and members post count totals range from 0 to 25,000.


Any suggestions/pointers would be much appreciated.


Cheers,

[kh99]

I think I would add a column to the user table that would be used to record the last level for which a voucher was awarded, and initialize it with 200 * FLOOR(posts / 200). Then you could use a scheduled task to check once a day to see if their posts is more than 200 greater than the last level column, and if it is, reset the last level column and add that user to the report. You can use a plugin on hook cron_script_cleanup_daily to add to the existing daily cleanup task (or if you'd prefer you could put a new script in includes/cron and add a new scheduled task).