imagecms / ImageCMS

                $this->db->query($sql);

                if ($this->input->post('Privileges')) {

                    $idPrivilege = implode(',', $this->input->post('Privileges'));

                    $sql = 'UPDATE shop_rbac_privileges SET group_id = ' . $idNewGroup . ' WHERE id IN(' . $idPrivilege . ')';

                    $this->db->query($sql);

                }

                showMessage('Группа создана');

                if ($this->input->post('action') == 'tomain') {

            $sql = 'UPDATE shop_rbac_group_i18n SET description = ' . $this->db->escape($this->input->post('Description')) . ' WHERE id = ' . $groupId . " AND locale = '" . MY_Controller::getCurrentLocale() . "'";

            $this->db->query($sql);

            if ($this->input->post('Privileges')) {

                $idPrivilege = implode(',', $this->input->post('Privileges'));

                $sql = 'UPDATE shop_rbac_privileges SET group_id = ' . $groupId . ' WHERE id IN(' . $idPrivilege . ')';

                $this->db->query($sql);

            }

            showMessage('Изменения сохранены');

            if ($this->input->post('action') == 'tomain') {

                pjax('/admin/rbac/groupEdit/' . $groupId);

                        $this->db->query($sql);

                    }

                    if ($this->input->post('Privileges')) {

                        foreach ($this->input->post('Privileges') as $idPrivilege) {

                            $sqlPrivilege = 'INSERT INTO shop_rbac_roles_privileges (role_id, privilege_id) VALUES(' . $idCreate . ', ' . $this->db->escape($idPrivilege) . ')';

                            $this->db->query($sqlPrivilege);

                        }

                    }

                    $last_role_id = $this->db->order_by('id', 'desc')->get('shop_rbac_roles')->row()->id;

                    $this->lib_admin->log(lang('The role is created') . '. Id: ' . $last_role_id);

            $after_pos = $this->menu_model->get_item_position($this->input->post('position_after'));

            $after_pos = $after_pos['position'];

            if ($after_pos != FALSE) {

                $position = $after_pos + 1;

                $sql = "UPDATE `menus_data`

                            SET `position`=`position` + 1

                            WHERE `position` > '$after_pos'

                            AND `menu_id`='" . $this->input->post('menu_id') . "'

                            AND `parent_id`='" . $this->input->post('parent_id') . "'

                            ";

                $this->db->query($sql);

            }

        }

        if ($this->input->post('position_after') == 0) {