Skip to content

Instantly share code, notes, and snippets.

91.108.56.0/22
91.108.4.0/22
91.108.8.0/22
91.108.16.0/22
91.108.12.0/22
149.154.160.0/20
91.105.192.0/23
91.108.20.0/22
185.76.151.0/24
2001:b28:f23d::/48
@avalarin
avalarin / script.js
Created September 25, 2020 13:15
JIRA Colored Cards
// ==UserScript==
// @name JIRA Colored Labels
// @namespace http://tampermonkey.net/
// @version 0.1
// @description JIRA Colored Cards
// @author avalarin <avalarin@gmail.com>
// @match https://jira.osmp.ru/secure/RapidBoard.jspa*
// @grant none
// ==/UserScript==
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCg3y5suBiVeAQS1RI4dEyPKhsAof2EFGEArapZ9CALI8iY0zfe75/WsWeJFtWXHC7oItX6hg7odYeCHDJu+dwMVCgmvclNGwLQLgvfupC0fZ1EajqFFGyt6dYPvL2cwojfam/ii3gxxTvdivwk/buonbtz47J9px9XIqwOCvKt6lW4HVbHKDnSdNa5xs58gS4cUcVqeqw/CfBIG69+81INUof27qRwbs+M6Cbv/Z9E2fiUP0r4rXXPAZ2g7tCc8nSbB4IiqGe0NSZbnv5J2neq1Ldlpob29wwqlLHRRjw9w8MT5jHAbp5ylMXrxyq33PeHA2v9d+/GOf3CWVbIkYeB a.prokopev@nb300605
@avalarin
avalarin / .gitconfig
Last active October 29, 2018 19:14
gitconfig
[user]
name = Alexander Prokopev
email = avalarin@gmail.com
[alias]
st = status
co = checkout
ci = commit
st = status -uall
lg = log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit --all
amend = commit --amend --no-edit
@avalarin
avalarin / query.sql
Last active June 27, 2016 12:20
Тестовое задание ВТБ
SELECT [Left].Value + 1 AS [Left], [Right].Value AS [Right]
FROM @values AS [Left]
LEFT JOIN @values AS V2 ON [Left].Value + 1 = V2.Value
INNER JOIN (SELECT V.Value - 1 AS Value
FROM @values AS V
LEFT JOIN @values AS V2 ON V.Value - 1 = V2.Value
WHERE V2.Value IS NULL AND V.Value - 1 > (SELECT MIN(Value) FROM @values)) AS [Right]
ON [Right].Value > [Left].Value AND
[Right].Value < (SELECT MIN(Value) FROM @values AS [RightMax] WHERE [RightMax].Value > [Left].Value)
WHERE V2.Value IS NULL AND [Left].Value + 1 < (SELECT MAX(Value) FROM @values)
@avalarin
avalarin / Program.cs
Last active June 28, 2016 05:46
Тестовое задание ВТБ
using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
namespace VTBTask {
class Program {
static void Main(string[] args) {
if (args.Length < 1) {
throw new InvalidOperationException("Invalid arguments, path is required");
@avalarin
avalarin / backup.sh
Last active May 14, 2016 04:25
Сreates a backup archive, encrypts and uploads it to the Google Drive
#!/bin/bash
# Сreates a backup archive, encrypts and uploads it to the Google Drive
# Prerequisites:
# Google Drive CLI Client https://github.com/prasmussen/gdrive
# pv - Pipe Viewer http://www.ivarch.com/programs/pv.shtml
# Directory id in GDrive
GDRIVE_DEST="0B56yBNWt9IFMVHJsMVhpV0poLTQ";
@avalarin
avalarin / openvpn_change_port.md
Last active February 26, 2023 20:24
Изменение порта на котором работает OpenVPN

#Изменение порта на котором работает OpenVPN

Подразумевается что OpenVPN был развернут при помощи Docker с использованием инструкции https://www.digitalocean.com/community/tutorials/how-to-run-openvpn-in-a-docker-container-on-ubuntu-14-04.

Изменить порт 1194 на 443 и протокол с udp на tcp в конфигурационном файле openvpn

docker run --volumes-from $OVPN_DATA --rm -it kylemanna/openvpn sed 's/port 1194/port 443/' /etc/openvpn/openvpn.conf -i.bak
docker run --volumes-from $OVPN_DATA --rm -it kylemanna/openvpn sed 's/proto udp/proto tcp/' /etc/openvpn/openvpn.conf -i.bak
@avalarin
avalarin / .minttyrc
Last active November 19, 2015 09:54
ZSH Theme & Mintty color scheme
BoldAsFont=yes
Font=Consolas
FontHeight=9
FontSmoothing=default
ClicksPlaceCursor=yes
Transparency=low
OpaqueWhenFocused=no
CursorType=line
Term=xterm-256color
BellFlash=no