Simple Promotion / Demotion System

Please, excuse my poor English.
This hack adds a simple system to promote and demote users to certain primary usergroups according to joindate and number of post in a number of days. The posts in the most recent days can be ignored. This is, the posts of today will not be count until have past a number of days.

Installation:
1) Backup your database. If something goes wrong is your problem.
2) Install the product xml.
3) Configure the settings in ACP.
4) Upload the two php files to the folder "cron" of your board.
5) Add a scheduled task for each php.

Note: If you like, change the vbphrases in the product for a better English.

I can´t support this hack, if you can improve it, great.

Versions:
1.00: Initial release.
1.01: Added some options more: Last visit, last post and minimal posts.

[moonclamp]

must be something else then.

Never mind.

[Alfa1]

This could be a usefull mod for my board as well. I want to be able to promote members that:

Have more than a certain amount of reputation
+ are giving both positive and negative ratings
+ have a join date of more than 2 months ago
+ last visited of less than a month ago

Any chance on adding these functions?

[RFViet]

can you add another promotion based on birthday ?? Because my forum has adult section !!

[Alfa1]

Will this be ported to 3.6.2?
Is this hack still supported?

[PixelFx]

any plans for a hack like this or update to this hack for 362? based on promotion / demotions based on post or login in last so many days?

[Stifler]

i get this when i run promotionpost from cron..

Database error in vBulletin 3.5.7:

Invalid SQL:
SELECT user.userid, user.usergroupid as usergroupid, user.joindate as joindate, user.lastvisit as lastvisit, user.lastpost as lastpost, user.posts as posts, post.userid as huserid, count(postid) as totalpost
FROM vb_user LEFT JOIN vb_post ON user.userid = post.userid
WHERE dateline >= 1168016694 AND dateline < 1170435894 AND lastpost > 1170003894 AND lastvisit > 1170003894 AND joindate <= 1170003894 AND posts >= 45 AND usergroupid = 2 GROUP BY huserid HAVING totalpost >= 40;

MySQL Error : Unknown table 'user' in field list
Error Number : 1109

[lazydesis]

Bumppp !!!

[djjeffa]

will this work for 3.6.5? did anyone try it?

[luroca]

Hello, a lot of time without reading this thread but I never supported this hack. It is working very well in vb 3.6.5.

[|Jordan|]

Will this hack work in VB 3.6 ?