Skip to content

Instantly share code, notes, and snippets.

@Mikhael-Danilov
Mikhael-Danilov / gist:bc4bc7698bb893c78bf8e081ca2a7b7f
Created February 18, 2024 22:42
Make copy of all mp4 in current directory with square pixel
#!/bin/bash
mkdir cnv
for file in *.mp4; do
ffmpeg -i "$file" -vf "scale=trunc(iw*sar/2)*2:ih,setsar=1" "cnv/$file"
done
@Mikhael-Danilov
Mikhael-Danilov / stream_to_youtube.sh
Last active April 3, 2020 10:27 — forked from olasd/stream_to_youtube.sh
Stream video to youtube via ffmpeg
#! /bin/bash
#
# Diffusion youtube avec ffmpeg
# Configurer youtube avec une résolution 720p. La vidéo n'est pas scalée.
VBR="2500k" # Bitrate de la vidéo en sortie
FPS="30" # FPS de la vidéo en sortie
QUAL="medium" # Preset de qualité FFMPEG
YOUTUBE_URL="rtmp://a.rtmp.youtube.com/live2" # URL de base RTMP youtube
@Mikhael-Danilov
Mikhael-Danilov / postgres_queries_and_commands.sql
Created December 23, 2019 13:01 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
for i = 0,RPD.Dungeon.level:getLength()-1 do --Проходим по всем клеткам карты
local maybeMob = RPD.Actor:findChar(i) --Есть ли кто?
if maybeMob and maybeMob ~= RPD.Dungeon.hero then --Есть и это не герой
RPD.Mob:makePet(maybeMob, RPD.Dungeon.hero) --Пробуем сделать из него питомца
end
end
@Mikhael-Danilov
Mikhael-Danilov / RD_gist_1.lua
Created March 12, 2019 20:13
Выдаем герою случайный предмет. Один раз.
local storage = require "scripts/lib/storage" — подключаем библиотеку для работы с сейвами
local key = "ItemGiven" —id нашей записи о том что предмет выдан
if not storage.get(key) then —если предмет ещё не давали
local items = {"Dagger","RatHide"} — список предметов
local item = RPD.ItemFactory:itemByName(items[math.random(1,#items)]) — создаем предмет из списка
RPD.Dungeon.hero:collect(item) —даем предмет герою
storage.put(key,true) — запоминаем что дали предмет
end
@Mikhael-Danilov
Mikhael-Danilov / mmc.sh
Created October 16, 2018 12:56
Memory mapping counter
!#/bin/bash
maxn=0
for fn in /proc/*; do
if [ -e $fn/maps ] ; then
n=$(cat $fn/maps | wc -l)
if [ $n -gt $maxn ] ; then
maxn=$n
echo $fn "->" $n
@Mikhael-Danilov
Mikhael-Danilov / gist:f666585f5a311fa41e172e4134af9b77
Created March 23, 2018 13:59
PostgreSql connection usage by user & app
select count(*), application_name from pg_stat_activity GROUP BY application_name,usename;
@Mikhael-Danilov
Mikhael-Danilov / gist:8038969
Created December 19, 2013 13:21
Get all externals in comples svn repo
svn propget svn:externals -R
export NDK=d:/adt-bundle-windows-x86_64-20130917/android-ndk-r9
export NDKABI=14
export NDKVER=$NDK/toolchains/arm-linux-androideabi-4.8
export NDKP=$NDKVER/prebuilt/windows-x86_64/bin/arm-linux-androideabi-
export NDKF="--sysroot $NDK/platforms/android-$NDKABI/arch-arm"
export NDKARCH="-march=armv7-a -mfloat-abi=softfp -Wl,--fix-cortex-a8"
export NDK_MAKE=$NDK/prebuilt/windows-x86_64/bin/make.exe
make HOST_CC="gcc -m32" CROSS=$NDKP TARGET_FLAGS="$NDKF $NDKARCH" TARGET_SYS="Linux" clean default
@Mikhael-Danilov
Mikhael-Danilov / subs.sh
Last active December 16, 2015 06:10 — forked from evansd/gist:1639992
simple script to do simple replace in source tree
#!/bin/bash
if [ -z "$1" -o -z "$2" ]; then
echo "Usage: substitute FROM_STRING TO_STRING [OPTION]..."
echo
echo "Replace all occurrences of FROM_STRING (a sed-compatible regular"
echo "expression) with TO_STRING in all files for which ack matches"
echo "FROM_STRING."
echo
echo "Any additional options are passed directly to ack (e.g.,"