View Profile and CB Subs

Hi,

I have a user list which shows all the users in my site. Each user in the list has an avatar, their name and a link to View Profile, whether they have an active CB Subs subscription or not.

The behaviour that I am trying to accomplish is that if you click the View Profile link and the person has an active valid subscription you go to their profile page, but if they have not bought a subscription or their subscription has expired the user gets taken to a page that says the user is inactive. Is there a CB Plugin that I could use that will help accomplish this behaviour rather than having to hack core files to do it?

Would the "CB Auto Actions plugin" help with this? if so, how would you set it up?

Thank you.

I recommend filtering your userlist to only display users with an active subscription as it'd be significantly more user friendly. Please see the below topic on how to do this.

www.joomlapolis.com/forum/277-cbsubs-gpl-support/224108-solved-cb-list-management-a-cbsubs#239628

Hi,

Agreed that it would, but that is not the functionality that the client wants. He wants unsubscribe members to show in the list, but not to be able to get more information if they are not subscribed.

So any ideas how to do this?

Best I can suggest is use a redirect action on the profile display trigger. You'll need to use a CB Query Field to query for an active subscription. You'd then condition against the query field and if they don't have an active subscription redirect away.

The below query for example will count how many active subscriptions they have.


The below does the same except for a specific plan.

Hi Kyle,

I added a Query field called cb_activesubscriptions with the first SQL query you have below. I set it to show in my Admin tab. But when I look at any users, that field is not showing up and when I look in the database, there isn't a cb_activesubscriptions field for any of the users in the com_comprofiler table. The cb_activesubscriptions field is published.



In the Auto Action I have the condition if cb_activesubscriptions <= 1 to do the redirect but it always comes back as the condition failed even though the user has 1 active subscription. I set the User field to Automatic.



Thank you for your help with this.

Your left conditional is just a string, it is not a valid substitution. It must be surrounded with brackets (e.g. [FIELD_NAME]). Please see the below tutorial for substitution usage information.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb