static function removeJSGroupMember($group_name, $username) { if (file_exists(JPATH_ADMINISTRATOR . '/components/com_community/tables/cache.php')) { require_once JPATH_ADMINISTRATOR . '/components/com_community/tables/cache.php'; } require_once JPATH_SITE . '/components/com_community/libraries/core.php'; require_once JPATH_SITE . '/components/com_community/models/groups.php'; $group = JTable::getInstance('Group', 'CTable'); $groupModel = CFactory::getModel('groups'); $member = JTable::getInstance('GroupMembers', 'CTable'); $group_id = JoomdleHelperGroups::get_js_group_by_name($group_name); if (!$group_id) { return; } $group->load($group_id); // $my = CFactory::getUser($username); $user_id = JUserHelper::getUserId($username); $my = JFactory::getUser($user_id); $db = JFactory::getDBO(); $query = 'DELETE from #__community_groups_members' . ' WHERE groupid=' . $db->Quote($group_id) . ' and memberid=' . $db->Quote($my->id); $db->setQuery($query); if (!$db->query()) { return JError::raiseWarning(500, $db->getError()); } $query = "UPDATE #__community_groups SET membercount=membercount-1 WHERE id =" . $db->Quote($group_id); $db->setQuery($query); if (!$db->query()) { return JError::raiseWarning(500, $db->getError()); } return "OK"; }
function getJSGroupId ($method, $params) { $name = $params[0]; return JoomdleHelperGroups::get_js_group_by_name ($name); }