Hi,

I've been trying different possibilities for this but I can't get it to work as I'd like to, maybe someone can help?

• I have a community where members pay monthly, semi-annual or annual plans to subscribe to the site.
• Members come and go, and may be off for several months before coming back in on the same or a different payment plan.
• I'd like to give those users who have been members for more than two years a "Gold" Status and those more than 5 years a "Platinum" status.
• The "status" would mean higher access levels, i.e. Registered -> Gold -> Platinum, which would mean extra content available to them and wider forum (Kunena) access.
• I'm not charging for this extra status, and I can't assign it manually, too many users.
• Their Payment plan should still rule access to the site, if their payment plan expires, they are out altogether, if they resubscribe to one of the payment plans then they'd have the elevated access automatically.

My idea was to set a new field in CB, that would indicate if they were Registered (0), Gold (1) or Platinum (2). Since calculating the paid time they've been members isn't as straight forward as looking at their registration date, I'm planning on doing a cronjob to run once or twice a month (sum of money paid) to update that field.

I tried setting a new plan for Gold and Platinum, lifetime for free, with the option of it only showing as an upgrade if the cb field condition was met, and one of the other paying plans was active.

The problem I'm having is that when the paying subscription expires, the user still has access, because of the Gold/Platinum plan. Access to the site and User Access levels remain untouched after expiration.

Is there a way to set the plans to accommodate this, or is there another way?

Also I'd rather they didn't have to cancel their current paying plan (many are on annual plans) and subscribe again to get the elevated access.

Thank you,
Tomás

Hi Kyle,

Thank you, I'm trying to understand CB Auto Actions, which seems very powerful. I think I have the solution from what you mentioned, with some tweaks.

The goal is to reward longevity (of payments) in our community with access to extra forum area and downloads, without it being a separate subscription.

The workflow I've come up with to be as efficient as possible with the lowest load on the server is as follows:

• I've created an extra CB filed, cb_heritage, as radio buttons with 3 values: 0=Members,1=Gold & 2=Platinum.
  
• I've created usergroups Gold and Platinum above Registered for them.
  
• I'm creating a SQL Query to determine who has achieved these rights and writing to that CB filed the appropriate value. I decided to do this as an outside cronjob, because I only need it to run at most every 2 weeks and it's not simple since I have to consider the registration date, how much money they've paid so far and if they paid a year in advance, when was that payment. Otherwise I'm not covering all the possibilities of users coming and going with different plans and taking breaks.
  
• On the first run of the query I'll assign the new usergroups to those active members who match the settings.
  
• Once this is set, it makes it much easier going forward, 2 very simple rules in CB Auto Actions:
  
  1. When a user logs in, if they don't have an active subscription then usergroups Gold and Platinum are removed. Here I don't need to check if they have the heritage status or not, if they don't have it, it doesn't make a difference.
     Type: Usergroup,
     Trigger: onAfterUserLoginSuccess,
     Condition: would be an existing active subscription (I haven't figured out how to set that condition)
     Action: remove Gold and Platinum Usergroups
     
     
  2. When a new subscription is made it should check for heritage status, and if so grant the usergroup that matches.
     a)
     Type: Usergroup,
     Trigger: -on user subscription - is there such a trigger, I couldn't find it..
     Condition: [cb_heritage] = 1
     Action: add Gold Usergroup
     b)
     Type: Usergroup,
     Trigger: -on user subscription - is there such a trigger, I couldn't find it..
     Condition: [cb_heritage] = 2
     Action: add Platinum Usergroup

The bolded parts are what I need some help with.

Thank you

Tomás

Hi Kyle,

This has got me almost there.

I've come up with a php file that when run, calculates who's earned Gold or Platinum Status, and updates the appropriate filed in the db. The calculation is not as simple for me as what you've written (wish it was) because most of our members take "breaks" and come back after a few months. Since I "allow gaps" in the renewals and many people switch between monthly, yearly and 6-month plans, looking at their current plan would disqualify most members that do qualify and qualify some who don't. I've resorted to adding up all their payments and prorating annual payments if they were made within the last year (also adjusting for the year plan discount), same for the 6-months plan. I do have a few exceptions to consider manually (free memberships and those paying with checks), but it is working fine, and tests ok.

Now what I realized is that what I effectively want is a Kunena Rank that provides extra access levels. I was originally going to show it as an extra "badge" on their membership, like the "Plan Image" but the Kunena Rank is a better fit for me.

What you wrote for me (thank you), works great against the CB field. I only removed the Plan ID condition since I want it to work for any plan.

Now I want it to work for the Kunena Rank field, which I do have in my CB Field list, but it doesn't work and my guess is because it's a "calculated" field and not an actual CB field in the Comprofiler table.

This is what I have:

Plan Active Gold
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var2] Equal To A
2: [cb_forumrank] Equal To 13 (the corresponding rank ID for Gold)
Enable usergroup Gold

Plan Active Platinum
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var2] Equal To A
2: [cb_forumrank] Equal To 14 (the corresponding rank ID for Platinum)
Enable usergroup Platinum

Plan Expired
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var2] Not Equal To A
Disable usergroups Gold & Platinum

So the question is can I condition against the Forum Rank field somehow, or do I have to use my [cb_heritage] radio button field that I created and tie it externally to the rank?

Thanks,
Tomás