quest ChangeNameWithVip begin
    state start begin
        function isNameAlready(pc_name)
            local index, value = mysql_direct_query("SELECT player.player.name as name FROM player.player;");

            if (index > 0) then
                for num, str in ipairs(value) do
                    if (string.lower(str.name) == string.lower(pc_name)) then return false; end
                end
            end return true;
        end

        function ChangeNameAddVip(new_Name)
            return mysql_direct_query("UPDATE player.player SET name = '"..new_Name.."' WHERE name = '"..pc.get_name().."'");
        end

        function isVipAlreadyAdded()
            return pc.getqf("ChangeNameWithVipUsage") ~= 0;
        end

        when 71173.use begin
            if (ChangeNameWithVip.isVipAlreadyAdded()) then
                syschat("Poti adauga gradul [VIP] doar odata pe caracter!") return;
            end

            say_title(string.format("%s:[ENTER]", item_name(item.get_vnum())))
            say("Acest obiect ofera posibilitatea de a adauga[ENTER]gradul de [VIP] caracterului tau si[ENTER]cu posibilitatea de a schimba numele precedent[ENTER][ENTER]Doresti sa incepi procesul?")
            if (select("Da", "Nu") == 1) then
                say_title(string.format("%s:[ENTER]", item_name(item.get_vnum())))
                say("Introdu numele dorit:")
                local strInput = string.gsub(input(), "[^A-Za-z0-9]", "");
                local input_len = string.len(strInput);

                if (input_len < 3) then say("Numele tau trebuie sa contina cel putin[ENTER]3 caractere.") return; end
                if (input_len > 7) then say("Numele tau trebuie sa fie de maxim[ENTER]7 caractere.") return; end
                if (not ChangeNameWithVip.isNameAlready('[VIP]"..strInput.."')) then say("Acest nume a fost luat de catre alta persoana.[ENTER]Adaugarea numelui a fost anulata.") return; end
                if (not pc.can_warp()) then say("Asteapta 10 secunde de la inchiderea negotului.") return; end

                say("Adaugarea gradului [VIP] a avut succes.[ENTER]Actualizarea acestuia se face dupa 15 min[ENTER]offline de pe caracter/cont.")
                ChangeNameWithVip.ChangeNameAddVip('[VIP]"..strInput.."');
                pc.setqf("ChangeNameWithVipUsage", 1);
                pc.remove_item(item.get_vnum(), 1);
            end
        end
    end
end