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);
}
