enableAddon('admin\\groups'); // first check form-tan if (!$admin->checkFTAN() || $iGroupId <= 1) { msgQueue::add($oLang->MESSAGE_GENERIC_SECURITY_OFFENSE ); } else { // if FTAN is successful checked and not Administrator group is seleced $sql = 'SELECT GROUP_CONCAT(`username` ORDER BY `username` SEPARATOR \', \') ' . 'FROM `'.$oDb->TablePrefix.'users` ' . 'WHERE `groups_id`=\''.(string)$iGroupId.'\''; if (($sUsers = $oDb->getOne($sql))) { // sorry, this group has users which having this group as the only one group msgQueue::add($oLang->MESSAGE_UNABLE_DELETE_GROUP . '
' . $sUsers); } else { $sql = 'UPDATE `'.$oDb->TablePrefix.'users` ' . 'SET `groups_id`=TRIM(BOTH \',\' FROM REPLACE(CONCAT(\',\',`groups_id`,\',\'),\','.$iGroupId.',\',\',\')) ' . 'WHERE FIND_IN_SET('.$iGroupId.', `groups_id`) AND `user_id`!=1'; // remove Group from Users $oDb->doQuery($sql); $sql = 'SELECT COUNT(*) ' . 'FROM `'.$oDb->TablePrefix.'users` ' . 'WHERE FIND_IN_SET('.$iGroupId.', `groups_id`) AND `user_id`!=1'; if ($oDb->getOne($sql)) { // the group already has assigned users. msgQueue::add($oLang->MESSAGE_RECORD_MODIFIED_FAILED ); } else { $sql = 'DELETE FROM `'.$oDb->TablePrefix.'groups` ' . 'WHERE `group_id`='.$iGroupId; // delete the group itself $oDb->doQuery($sql); msgQueue::add($oLang->MESSAGE_GROUPS_DELETED,true); } } } $admin->print_header(); return ; }