All gists - Opengist

Last active 14 hours ago mariadb

Puts a server into maintenance mode (maxscale), performs full backup, compresses and exits maintenance mode

0 0 1

1	#!/bin/bash
2	SERVER=server_hs2
3	BACKUP_OUTPUT=/tmp/backups
4	set -e
5
6	echo enter maintenance mode
7	maxctrl set server "$SERVER" maintenance
8	mariadb -e "SET GLOBAL wsrep_desync = ON;"
9
10	backup_dir=$(mktemp -d)

Last active 2 weeks ago

0 0 1

1	#!/bin/bash
2	K=000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004
3	echo "$K" \| wc -c
4	# generate secp384r1 key with provided K value
5	# 30 3E SEQUENCE, len 62
6	# 02 01 01 version = 1
7	# 04 30 <bytes of K value> privateKey OCTET STRING
8	# A0 07 06 05 2B 81 04 00 22 [0] parameters = secp384r
9	printf '303e0201010430%s%s' "$K" 'a00706052b81040022' \| xxd -r -p > key.der \
10	&& openssl ec -inform DER -in key.der -out private-key.pem \

Last active 1 month ago

0 0 1

1	journalctl -u anubis@forgejo.service -ef --no-pager --output=json \| jq .MESSAGE \| jq fromjson

Last active 1 month ago

https://unix.stackexchange.com/questions/587646/how-to-get-the-total-duration-of-all-video-files-in-current-folder-and-sub-direc

0 0 1

1	# Recursive all files in dir
2	exiftool -ext mp4 -r -n -q -p '${Duration;$_ = ConvertDuration(our $total += $_)}' . \| tail -n 1
3
4	# More control
5	# calc-durs Replay_* - all files matching glob in single folder only
6	# calc-durations -r Replay_* - recursive in all folders
7	calc-durs() {
8	local -a files
9	if [[ "$1" == "-r" ]]; then
10	shift

Last active 1 month ago steam

Requires https://github.com/darkwater/steam-clip-exporter - Build & run in Steam/clips folder, outputs files in Steam/exports

0 0 1

1	#!/bin/bash
2
3	#build this: https://github.com/darkwater/steam-clip-exporter
4	EXTRACT_PATH=~/git/steam-clip-exporter/target/debug/steam-clip-exporter
5	set -e
6
7	for dir in clip_*; do
8	file="$dir/output.mp4"
9	if [[ ! -f "$file" ]]; then
10	echo Extracting "$dir"

Last active 1 month ago l4d2

makes player redirect movement to the nearest other player

0 0 1

1	float targetPos[MAXPLAYERS+1][3];
2	int targetEnt[MAXPLAYERS+1];
3
4	static char STORE_KEY[] = "SEND_TO_HEAVEN";
5
6	void SendToHeaven_OnActivate(int apologizer, int target, const char[] eventId) {
7	Handle h = CreateTimer(1.0, Timer_Levitate, GetClientUserId(apologizer), TIMER_REPEAT);
8	SorryStore[apologizer].SetBool(STORE_KEY, true);
9	}

Last active 4 months ago script ytdl

acquires links from stdin, downloads with yt-dlp and then rsyncs to media folder

0 0 1

1	#!/bin/sh
2	set -e
3	TMP_PATH=/tmp/yt-dl #$(mktemp -d)
4	mkdir $TMP_PATH \|\| true
5	DEST=/mnt/hs2/main/media/storage/music/
6
7	# Exit if the temp directory wasn't created successfully.
8	if [ ! -e "$TMP_PATH" ]; then
9	>&2 echo "Failed to create temp directory"
10	exit 1

Last active 5 months ago script steam

Updates game folder with steamcmd, with locking

0 0 1

1	#!/bin/bash
2	APPID=222860
3	STEAMCMD_PATH=~/steamcmd/steamcmd.sh
4	if test -f "update.lock"; then
5	echo "update.lock found, cancelling"
6	exit 1
7	fi
8	touch update.lock
9	trap '{ rm -f -- "update.lock"; }' EXIT
10	# Due to some new steamcmd bugs, you cannot install the game except for windows. Valve doesn't seem like they will fix this

Last active 5 months ago

0 0 1

1	rename table stats_games to stats_sessions;
2	create table stats_games
3	(
4	id int unsigned auto_increment primary key,
5	uuid uuid default uuid() not null comment 'legacy campaignID' unique,
6	date_start bigint not null comment 'unix timestamp',
7	date_start_finale int null comment 'unix timestamp of finale',
8	date_end bigint null comment 'unix timestamp',
9	duration_game bigint as (`date_end` - `date_start`) comment 'seconds of game',
10	duration_finale bigint as (`date_end` - `date_start_finale`) comment 'seconds of finale',

Last active 5 months ago steam

Extracts LaunchOptions from steam, showing appid & options. python3 extract.py ~/.local/.steam/steam/userdata/#####/config/localconfig.vdf

0 0 1

1	# initially generated by chatgpt
2	import vdf
3
4	def extract_launch_options(filepath):
5	with open(filepath, 'r', encoding='utf-8') as f:
6	data = vdf.load(f)
7
8	results = []
9
10	def walk(node):