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>