function set_user_subsriber()
{
$db = JFactory::getDBO();
$user_id = JRequest::getVar('user_id', null);
$value = JRequest::getVar('value', null);
$query = $db->getQuery(true);
$query->select('group_id')->from('#__user_usergroup_map')->where('user_id=' . $user_id);
$db->setQuery($query);
$groups = $db->loadColumn();
if ($value == 1 && !in_array(KSUsers::getSubscribersGroupID(), $groups)) {
$query = $db->getQuery(true);
$values = array(KSUsers::getSubscribersGroupID(), $user_id);
$query->insert('#__user_usergroup_map')->columns('group_id,user_id')->values(implode(',', $values));
$db->setQuery($query);
$db->Query();
} elseif ($value == 0) {
$query = $db->getQuery(true);
$query->delete('#__user_usergroup_map')->where('user_id=' . $user_id)->where('group_id=' . KSUsers::getSubscribersGroupID());
$db->setQuery($query);
$db->query();
}
$response = array('erros' => 0, 'message' => array());
$response = json_encode($response);
JFactory::getDocument()->setMimeEncoding('application/json');
echo $response;
JFactory::getApplication()->close();
}
public function setUserSubscribeGroup($uid)
{
if (!empty($uid) && $uid > 0) {
$db = JFactory::getDBO();
$groups = JFactory::getUser($uid)->groups;
if (!in_array(KSUsers::getSubscribersGroupID(), $groups)) {
$user_map = new stdClass();
$user_map->group_id = KSUsers::getSubscribersGroupID();
$user_map->user_id = $uid;
try {
$db->insertObject('#__user_usergroup_map', $user_map);
} catch (Exception $e) {
}
}
}
return false;
}
<a rel='{"x":"90%","y":"90%"}' href="<?php
echo JRoute::_('index.php?option=com_ksen&view=users&layout=user&id=' . $this->item->id . '&tmpl=component');
?>
" class="edit km-modal"><?php
echo JText::_('ks_edit');
?>
</a>
</p>
</div>
</td>
<td class="user_login"><?php
echo $this->item->username;
?>
</td>
<td class="user_email"><?php
echo $this->item->email;
?>
</td>
<td class="user_subsriber"><input type="checkbox" value="1" <?php
echo in_array(KSUsers::getSubscribersGroupID(), $this->item->groups) ? 'checked' : '';
?>
></td>
<td class="del"><a href="#"></a></td>
<input type="hidden" class="id" name="items[<?php
echo $this->item->id;
?>
][id]" value="<?php
echo $this->item->id;
?>
">
</tr>
</a>
</div>
<div class="descr">
<?php
echo $this->item->name;
?>
</div>
</td>
<td class="user_login"><?php
echo $this->item->username;
?>
</td>
<td class="user_email"><?php
echo $this->item->email;
?>
</td>
<td class="user_subsriber"><?php
echo in_array(KSUsers::getSubscribersGroupID(), $this->item->groups) ? JText::_('jyes') : JText::_('jno');
?>
</td>
<td class="add">
<a href="#" class="add"></a>
</td>
<input type="hidden" class="id" name="items[<?php
echo $this->item->id;
?>
][id]" value="<?php
echo $this->item->id;
?>
">
</tr>
