Stankye’s gists

Stankye / wow_ah.py

Created January 23, 2022 02:02

WoW AH API 'thing'

	import aiohttp
	import aiofiles
	import asyncio
	import datetime
	import pprint

	pp = pprint.PrettyPrinter(indent=4)


	async def main():

Stankye / breach.csv

Created January 23, 2022 01:55

compiled list from various sources on state breach laws and stuff'

Alabama	Ala. Code § 8-38-1 et seq.
Alaska	Alaska Stat. § 45.48.010 et seq.
Arizona	Ariz. Rev. Stat. § 18-551 to -552
Arkansas	Ark. Code §§ 4-110-101 et seq.
California	Cal. Civ. Code §§ 1798.29, 1798.82	https://oag.ca.gov/privacy/databreach/list
Colorado	Colo. Rev. Stat. § 6-1-716
Connecticut	Conn. Gen Stat. §§ 36a-701b, 4e-70
Delaware	Del. Code tit. 6, § 12B-101 et seq.	https://attorneygeneral.delaware.gov/fraud/cpu/securitybreachnotification/
Florida	Fla. Stat. §§ 501.171, 282.0041, 282.318(2)(i)
Georgia	Ga. Code §§ 10-1-910 to -912; 46-5-214

Stankye / anime_wikidata.ipynb

Created January 23, 2022 01:38

Some musings about anime and wikidata

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.

Stankye / githoard.py

Last active March 31, 2025 05:54

Makes a list of a Github users stars or public repositories as clonable git url's

	#!/usr/bin/env python3
	# Usage:
	# python githoard.py -u <githubUser> -m <method> -t <githubToken> -o <output>
	#
	# Example:
	# python githoard.py -u stankye -m stars -t <githubToken> -o ./stars.txt
	#
	import argparse
	import os
	from github import Github # pip install PyGithub

Stankye / app.js

Last active December 16, 2021 02:28

mc ws watch

	// Modified https://github.com/sidious38/wsserver-bedrock
	// MIT License

	// Usage:
	// CheckNetIsolation LoopbackExempt -a -n="Microsoft.MinecraftUWP_8wekyb3d8bbwe"
	// npm install ws uuid chokidar
	// node app.js "path/to/functions"
	// /connect localhost:3000

	const chokidar = require("chokidar");

Stankye / gist:3053dbc0ba318eaeb869f57c05face66

Created June 30, 2021 00:36

ffprobe json postgres

	find . -type f -regex '.*\.$mkv\\|avi\\|mp4\\|ogb\\|webm\\|flv\\|mpv$' -exec bash -c 'ffprobe -v quiet -print_format json -show_format -show_streams "{}" \| jq -c "." \| psql --command "COPY tmp (data) FROM STDIN;" postgresql://postgres:hunter2@localhost:5432/postgres ' \;

	WITH streams AS (
	SELECT jsonb_array_elements((data->'streams')) AS stream,
	data -> 'format' AS format
	FROM tmp
	)
	SELECT format ->> 'filename' AS FILE_NAME,
	stream ->> 'codec_name' AS CODEC_NAME,
	stream -> 'height' AS HEIGHT

Stankye / vyos wireguard setup vpn provider

Created January 16, 2021 07:27

vyos wireguard setup vpn provider

	Since this post took me a few searchs to many, hopfully the repost of what i found will end up on search results.

	I used this to set up mullvad wireguard vpn connection from vyos.
	This would work for setting up other vpn providers like torguard.
	This really boring text is mainly for seo so some poor sap does not repeat my hour and a half of suffering.
	The config stuff below is working on 1.4 rolling as of date posted.

	there should be more documentation on the setup of the keys somewhere.

	gen some default keys so you can copy the file perms and stuff'

Stankye / dumb stuff

Created February 25, 2020 06:31

dumbStuff.sh

	# Shows most used commands from $HISTFILE (with sudo)
	cat $HISTFILE \| awk '{print $1}' \| sort \| uniq -c \| sort -nr
	# Shows most used commands from $HISTFILE (without sudo)
	cat $HISTFILE \| sed 's/^sudo//' \| awk '{print $1}' \| sort \| uniq -c \| sort -nr

Stankye / thumbnailz.sh

Last active February 7, 2020 00:11

Creds to seednode

	# Creds to seednode
	# listen for requests to https://my.domain.here/
	server {
	# include shared config
	include /etc/nginx/conf.d/shared.conf;

	# enable LetsEncrypt SSL certs
	ssl_certificate /etc/letsencrypt/live/my.domain.here/fullchain.pem;
	ssl_certificate_key /etc/letsencrypt/live/my.domain.here/privkey.pem;

Stankye / Rclone lsjson Google Drive Elastic mapping

Created January 13, 2020 19:40

Mappings for Rclone lsjson output. ES only takes ndjson so just remove commads / [] and use the _bulk import api.

	find . -type f -regex '.*\.\(mkv\\|avi\\|mp4\\|ogb\\|webm\\|flv\\|mpv\)' -exec bash -c 'ffprobe -v quiet -print_format json -show_format -show_streams "{}" \| jq -c "." \| psql --command "COPY tmp (data) FROM STDIN;" postgresql://postgres:hunter2@localhost:5432/postgres ' \;

	WITH streams AS (
	SELECT jsonb_array_elements((data->'streams')) AS stream,
	data -> 'format' AS format
	FROM tmp
	)
	SELECT format ->> 'filename' AS FILE_NAME,
	stream ->> 'codec_name' AS CODEC_NAME,
	stream -> 'height' AS HEIGHT

R Stankye