CiviCRM Community Forums (archive)

This is great news! Looking forward to the module, which will be a real time saver.

A module that would assign (or un-assign) Drupal users to certain Drupal roles depending on CiviCRM membership status can't be that hard, really, can it? And it would be so useful! Like Gordon's project civicrm_role it could be a cron job, simply periodically comparing the membership status (1, 2, 3 or 4), the cid and the uid. Since the Drupal roles table (rid) has one line for each users role (ie one line for user 6 to have role 3, another line for user 6 to have role 11) it would just be a matter of adding and removing rows of the roles table for that rid that indicates membership. Would be easier if there was just one Drupal role that indicated if a user was a member in good standing or not, but probably more useful if different membership types corresponded to different Drupal roles. Would be nice, if it's possible, for the cron job to run upon changes to the membership table or when a membership is added or renewed, so that updating of the Drupal role happens with as quick a turn-around as possible. Integrating it with Gordon's CiviCRM group/role module would make it quite a powerhouse.<br>In the mean time (now I'm new to this so don't laugh) I have a way to screen visitors to a page to tell if they're members or not. It won't let the page be written for non-members and redirects non-members to a "Sorry, this page is reserved for members" node. If you are a member, the page loads. Here it is. It goes in the body of a PHP formatted Drupal node:
<?

Global $user;
    if ($user->uid < 1){
    drupal_goto ($path='node/XXX');
// Your SORRY page
exit();
}
    elseif ($user->uid >= 1);{
    $userID = crm_uf_get_match_id($user->uid);
}
$query = "SELECT * FROM civicrm_membership WHERE contact_id = $userID";
 
$result2 = mysql_query ($query) or die ("Died");

$field2 = mysql_fetch_object($result2);

if ( $field2->status_id == 1 ) {

// 1 is new member

print (What you want it to print);
}
elseif ( $field2->status_id == 2 ) {

// 2 is current member

print (What you want it to print);
}

elseif ( $field2->status_id == 3 ) {

// 3 is grace period member, 4 is lapsed member

print (What you want it to print);
}
else {
    drupal_goto ($path='node/XXX');
// Your SORRY page
exit();
}

?>Works for me.