Index: branches/5.2.x/core/units/users/users_item.php =================================================================== diff -u -N -r14631 -r15012 --- branches/5.2.x/core/units/users/users_item.php (.../users_item.php) (revision 14631) +++ branches/5.2.x/core/units/users/users_item.php (.../users_item.php) (revision 15012) @@ -1,6 +1,6 @@ GetID() . ') AND ( (MembershipExpires IS NULL) OR (MembershipExpires >= ' . adodb_mktime() . ') ) ORDER BY IF(GroupId = ' . $this->GetDBField('PrimaryGroupId') . ', 1, 0) DESC'; $groups = $this->Conn->GetCol($sql); @@ -89,7 +89,7 @@ $group_id = $this->Application->ConfigValue('User_SubscriberGroup'); $sql = 'SELECT GroupId - FROM ' . TABLE_PREFIX . 'UserGroup + FROM ' . TABLE_PREFIX . 'UserGroupRelations WHERE (PortalUserId = ' . $this->GetID() . ') AND (GroupId = ' . $group_id . ')'; return $this->Conn->GetOne($sql);