Demote Users Hack

[Rebecca217]

I'm interested in a hack which automatically demotes users to the default user group if they haven't made X number of posts in Y number of days. I don't think it would be difficult to do, but I don't have the expertise to do it.

This hack would be excellent to curb those users who make a certain number of posts to get promoted and gain greater site access, but then never maintain reasonable activity level.

Anyone up for the challenge?

Rebecca

[tnguy3n]

This idea is the same as this request?
https://vborg.vbsupport.ru/showthread.php?t=74992

[Rebecca217]

Hi tnguy3n,

That is similar, but I'm not looking for anything quite as fancy. There's no need to store/reapply the old usergroup.

Here's what I have figured out so far:

1) It seems the easiest way to do this is to turn the vb automatic promotions off completely, and instead run this hack as a script through the vb scheduled tasks. That way you avoid any conflict with the promotion system.

2) I'm only dealing with two user groups ("Member" and "Active Member"). I believe the script will just have to run two MySQL queries:

a) One query would bump any "Active Members" that have fallen below the required post/week level down into the default "Members" group
b) The second query would basically pick up the function of the deactivated vb promotion system. It would bump users who met the required posts/week criteria into the "Active Users" group.

4) I don't need anything fancy (like an Admin CP interface). I'm very comfortable editing variables within a php file. I just don't yet have the ability to write something like this from scratch.

Another note: I noticed 006's "Require X posts in the last Y hours to play games in the arcade" hack has the postnumber/timeperiod function already worked out. Maybe something like this could be adjusted for the promote/demote hack?

Again, I'm no php or MySQL expert, so this is just my guess at how something like this might work. I greatly appreciate any input and help.

Thanks!

Rebecca