Hi Hathwaytech,

I notice on their site that there's a plugin for CB Subs called Content Integration Plugin, which is supposed to be able to show modules based on CB Subs plans. Have you tried that already?

Because CBSubs is a commercial system I can't very easily download it to work on a recipe for you. It's impossible for me to guess what database structure is used - and since the component is apparently encoded, looking at the database tables is likely the only way to find out how everything links together.

If you like I'd be happy to log into your site to take a look and see if I can work out the database structure, so that MetaMod can query it too. Then I could make some general recipes for other CBSubs users. "PM" me with login details if you'd like me to do that.

Thanks,
Stephen

Give a man enough time and he will figure it out. I combined the redirection and standard community builder recipes along with the custom field set per subscription type, and the redirection works just fine:

$user_id = $db->getEscaped((int)($user->id));

 

if ($user_id > 0) {

 $query = "select * from #__comprofiler  where user_id = '$user_id';"; 

 $db->setQuery( $query );

 $row     = $db->loadObject();

 /* you can now get hold of state, phone, fax, website,

  * location, or whatever else they enter. All optional fields

  * like this get prefixed with "cb_" (see below).

  */ 



// find profile type

 $profiletype = $row->cb_profiletype;



// send user to page based on profile type

$app = &JFactory::getApplication();

if ( $profiletype == "Tenant" )

    $app->redirect("http://www.example.com/index.php?option=com_jreviews&Itemid=1");

elseif ( $profiletype == "Landlord" )

    $app->redirect("http://www.example.com/index.php?option=com_content&view=article&id=97&Itemid=181");

elseif ( $profiletype == "Advertiser" )

    $app->redirect("http://www.example.com/index.php?option=com_content&view=article&id=99&Itemid=185");

}

This works fine as is, however it raises some particular issues:

1. It would be better to access #__cbsubs_subscriptions directly instead of via the custom CB field. #__cbsubs_subscriptions has two relevant fields for this (plan_id and user_id). Any ideas on some quick code for this?

2. It would certainly be better to redirect to a menu item rather than a url. How would we go about doing this? Redirection to URL works fine when you set it up, but if you change the menu item it refers to, you will need to change the PHP in metamod too. This certainly applies to the normal redirect you discuss on http://www.metamodpro.com/support/recip … edirection .

Thanks!