Simple Promotion / Demotion System

[luroca]

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.

[Mr Chad]

Tight, does this allow you to add multiple promotions.

[luroca]

Tight, does this allow you to add multiple promotions.No, it only changes between two usergroups. As I said, it?s a very simple system.

Regards

[Ntfu2]

so simple its included in vBulletin already

How is this one different?

[Snake]

Good work! ;)

[luroca]

Good work! ;)Thanks, sir

so simple its included in vBulletin alreadyThere are many things included in vBulletin but I think that not this one; perhaps I am mistaked ...

[Billspaintball]

so simple its included in vBulletin already

How is this one different?
Look at the options in the screenshot.

Looks like it does more than vB can.

[luroca]

Looks like it does more than vB can.Yes, it?s for vBulletin :)

The promotion system in vBulletin (there is not demotion system) computers the total number of posts. This hack works with number of posts in a certain number of days.

Excuse me if I can?t explain it in a better way.

Regards

[Ntfu2]

i see ;) thanks for explaining

[MissKalunji]

i like it but is it possible to only use the demotion one? and i dont really understand how this works..

[luroca]

i like it but is it possible to only use the demotion one? and i dont really understand how this works..You can use only demotionpost.php not adding a scheduled task for promotionpost.php.

This extension is really easy. In the ACP you set some variables and the cron files send some sql instructions to the database changing some users from one usegroup to another. If you see into the php files you?ll understand it sure :)

Regards

[MissKalunji]

how does the demotion works :( im lost

[MissKalunji]

Ok i got it :) thanks

[MissKalunji]

I have a request

Would it be possible to set demotion on last activity time?

me it isnt about post really but the last time YOU LOGGED ON...

[luroca]

Umm, it´s possible. I´ll see how to integrate it.

Regards

[MissKalunji]

Thanks!

[luroca]

Added some options more: Last visit, last post and minimal posts.

If you like, click install :)

Regards

[MissKalunji]

Perfect! thank you so much!

[MissKalunji]

Im kind of lost

I put Time from last post : 30
and time from lat visit 30

For 30 days

Latency time 10 as i dont want to be counting the 10 last post?

demotion time 60 for 60 days (dont get that one)

and when i run demotion

it takes even people who are active like NOW

what am i doing wrong?

[luroca]

latency = 10 exclude posts in the last 10 days, not last 10 posts.

[MissKalunji]

man ig ive up this whole thing is loosing me

[moonclamp]

I'm trying to understand this a bit better.

On the standard system I have a promotion where all users with more than 15 posts ger promoted to a special group.

What I want is to be able to demote members who later on stop posting. IE move them back to the 'registered users' group when they become inactive.

Surely this will put them into a continuous loop ... being demoted for non-activity and then promoted again for having the correct postcount?

Or am I missing something?

[MissKalunji]

thats exacly what im trying to do :-/

[moonclamp]

Well I'm not going to install it until I'm clearer on what this does.

I'm wondering if I could demote members to a new group for lazy users ... but would they get moved back if they decide to start posting again?

[luroca]

I'm trying to understand this a bit better.

On the standard system I have a promotion where all users with more than 15 posts ger promoted to a special group.

What I want is to be able to demote members who later on stop posting. IE move them back to the 'registered users' group when they become inactive.

Surely this will put them into a continuous loop ... being demoted for non-activity and then promoted again for having the correct postcount?

Or am I missing something?If you use the same usergroups in normal promotion and simple promotion, the continuous loop can occurr. My lazy usergroup cannot upgrade to active usergroup with normal promotion, only with simple promotion.

Regards

[moonclamp]

So a member gets out of the lazy usergroup as soon as they start posting again?

[luroca]

So a member gets out of the lazy usergroup as soon as they start posting again?If you set latency time > 0, nope. Example, if you set to 3, three days must pass before the user upgrade if he has enought posts. Perhaps in three days he has not enought posts ...

According to your settings, this one can be a very dinamical product :banana:

Btw, I don?t suport this product and you dont click install, what am i doing here? :D

Regards

[moonclamp]

thank you. I think it;s our language differences that are confusing me.

Installed now :)

[moonclamp]

On running the cronjob

MySQL Error : Unknown table 'user' in field list

is it taking table prefixes into account?

[luroca]

On running the cronjob

MySQL Error : Unknown table 'user' in field list

is it taking table prefixes into account?Yes, it use prefixes.

[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 ?