CiviCRM Community Forums (archive)

Hello,

I've been testing my new Drupal module (http://drupal.org/project/civimember_roles) on CiviCRM installs that use Domain IDs and ran into a problem. I followed the documentation's guide on how to setup Domain IDs (http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+for+Drupal+-+Configure+Multi-site+Installations). Then I ran this code in my module:

$sql = 'SELECT id, name FROM civicrm_membership_type WHERE domain_id = %1;';
$params = array(1 => array(CIVICRM_DOMAIN_ID, 'Integer'));
$dao =& CRM_Core_DAO::executeQuery($sql, $params);
The code does what I want, only pulling Membership Types that are in the current domain. However when I go to Administer CiviCRM > CiviMember > Membership Types from within Drupal, I see a list of all the Membership Types from all the domains, not just the domain I'm currently using. This isn't a big issue, but it does cause some confusion when you can see Membership Types in CiviCRM that my module isn't displaying.

Has anyone else experienced this? I have been able to reproduce it twice on my localhost, but I am just using the generic test data that comes with CiviCRM. Beside Membership Types, everything else seems to be separated like I would expect (Contacts, Organizations, etc). The odd thing is that CiviMember Status Rules are even separated, which is why I believe this is a bug rather than a feature, but I could be wrong...