Demote Users Hack

[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