Limiting posts per month

[manguish]

Is this possible?

Say i wanted to limit a usergroups posts to 10 per month?

I figured i could do it with promotions, by moving the users when they'd made 10 posts - but there is no time scale.

Once the month ends, and the next starts, i would like the 10 posts to become available again.

Cheers.

[Colin F]

Originally Posted by manguish

Is this possible?

Say i wanted to limit a usergroups posts to 10 per month?

I figured i could do it with promotions, by moving the users when they'd made 10 posts - but there is no time scale.

Once the month ends, and the next starts, i would like the 10 posts to become available again.

Cheers.

You could add a cron job that runs on the first of every month and moves the users back to the first usergroup.

[manguish]

I thought about that but couldn't figure out the sql - any chance of a hand?

[Andreas]

I guess this won't work Colin, he would also have to reset the post counter each month, as otherwiese the users will get promoted to the "over quota" group instantly after 1 post.

[manguish]

Couldn't the cron job also reset posts?

[Andreas]

Sure, but do you want that?

[manguish]

Yes.

I want the users to be able to post to 10, get moved to differing "cripple" user group, then after 30 days - reset post to 0 and move back to original usergroup - therby allowing them 10 posts again.

[Andreas]

Then you could use the following query:
[sql]update user set posts=0, usergroupid=original where usergroupid in (original, crippled)[/sql]

[Colin F]

... and don't forget to exchange original and crippled for the usergroupid's of those usergroups

[manguish]

Hero

Many thanks Colin.