local function ch_ban_offline(player,choice)
	local user_id = vRP.getUserId(player)
	vRP.prompt(player,"ID Ban: ","",function(player,idJucator)
    idJucator = parseInt(idJucator)
    vRP.isBanned(idJucator, function(banned)
      if not banned then
        vRP.prompt(player,"Zile Ban: ","",function(player,zileBan)
          zileBan = parseInt(zileBan)
          vRP.prompt(player,"Reason: ","",function(player,cauzaBan)
            local source = vRP.getUserSource(id)
            MySQL.Async.execute("UPDATE vrp_users SET banned = 1 WHERE id = @id", {['@id'] = idJucator}, function()end)
            MySQL.Async.execute("UPDATE vrp_users SET banatDe = @banatDe WHERE id = @id", {['@id'] = idJucator, ['@banatDe'] = GetPlayerName(player)}, function()end)
            MySQL.Async.execute("UPDATE vrp_users SET zileBan = @zileBan WHERE id = @id", {['@id'] = idJucator, ['@zileBan'] = zileBan }, function()end)
            MySQL.Async.execute("UPDATE vrp_users SET cauzaBan = @cauzaBan WHERE id = @id", {['@id'] = idJucator, ['@cauzaban'] = cauzaBan }, function()end)
            vRP.getLastLogin(idJucator, function(last_login)

              local creation_date = os.date("%d/%m/%Y")

              local dayValue, monthValue, yearValue = string.match(creation_date, '(%d+)/(%d+)/(%d+)')

              dayValue, monthValue, yearValue = tonumber(dayValue), tonumber(monthValue), tonumber(yearValue)

              expiry_date = os.date("%d/%m/%Y",os.time{year = yearValue, month = monthValue, day = dayValue }+zileBan*24*60*60)
              MySQL.Async.execute("UPDATE vrp_users SET banPanaPe = @banPanaPe WHERE id = @id", {['@id'] = idJucator, ['@banPanaPe'] = expiry_date }, function()end)
            end)
            TriggerClientEvent("chatMessage", -1, "[SYSTEM]", {255, 0, 0}, "^2Adminul ^3"..GetPlayerName(player).." ^2i-a dat ban lui ^3"..GetPlayerName(source))
			TriggerClientEvent("chatMessage", -1, "[SYSTEM]", {255, 0, 0}, "^2Motiv: ^3"..reason.."^2 | Pentru: ^3"..zileBan.." zile")
			sendToDiscord("Ban temporar", "Jucator: **" .. GetPlayerName(source) .. "** \n Admin: **" .. GetPlayerName(player) .."** \n Motiv: **" .. reason .."** Perioada ban: " .. zileBan .."**", 65280)
          end)
        end)
      end
    end)
	end)
end