AJ Tatum ajtatum

DB

SQL Cheatsheet

https://github.com/enochtangg/quick-SQL-cheatsheet - A quick reminder of all relevant SQL queries and examples on how to use them.

DB Diagrams

https://dbdiagram.io/ - A free and simple tool to draw ER diagrams by just writing code.

Misc

Exporting your 2FA tokens from Authy to transfer them into another 2FA application

IMPORTANT - Update regarding deprecation of Authy desktop apps

Past August 2024, Authy stopped supported the desktop version of their apps:
See Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August for details.

And indeed, after a while, Authy changed something in their backend which now prevents the old desktop app from logging in. If you are already logged in, then you are in luck, and you can follow the instructions below to export your tokens.

If you are not logged in anymore, but can find a backup of the necessary files, then restore those files, and re-install Authy 2.2.3 following the instructions below, and it should work as expected.

1. Copy m3u8 link

2. Run command

echo "Enter m3u8 link:";read link;echo "Enter output filename:";read filename;ffmpeg -i "$link" -bsf:a aac_adtstoasc -vcodec copy -c copy -crf 50 $filename.mp4

	using System;
	using System.IO;
	using Microsoft.Azure.WebJobs;
	using Microsoft.Extensions.Logging;
	using System.Net.Http;
	using System.Net.Http.Headers;
	using System.Threading.Tasks;
	using System.Text.Json.Serialization;

	namespace AJTDigital.Mux

	var countryNameToCode = {
	'Afghanistan': 'AF',
	'Aland Islands': 'AX',
	'Albania': 'AL',
	'Algeria': 'DZ',
	'American Samoa': 'AS',
	'Andorra': 'AD',
	'Angola': 'AO',
	'Anguilla': 'AI',
	'Antarctica': 'AQ',

	#!/bin/bash
	conf_path="/etc/nginx/conf.d/$1.conf"

	if [ -f "$conf_path" ]
	then
	conf_text=`cat $conf_path`
	if [[ "$conf_text" == "$2" ]] \|\| [[ "$conf_text" == "localhost:$3" ]]
	then
	echo "Proxy route or localhost port has been used, please manually reconfigure your Nginx configuration."
	else

	// ==UserScript==
	// @name Choco-One-Click
	// @namespace http://tampermonkey.net/
	// @version 0.1.1
	// @description Install software from chocolatey.org with one-click. This requires choco:// protocol support (choco install choco-protocol-support).
	// @author AJ Steers
	// @include http://chocolatey.org/
	// @include https://chocolatey.org/
	// @grant none
	// ==/UserScript==

	<?php
	add_action('plugins_loaded','ao_defer_inline_init');

	function ao_defer_inline_init() {
	if ( get_option('autoptimize_js_include_inline') != 'on' ) {
	add_filter('autoptimize_html_after_minify','ao_defer_inline_jquery',10,1);
	}
	}

	function ao_defer_inline_jquery( $in ) {

	#!/bin/bash

	set -x
	## Mention your database container name
	container_name=

	## Mention your mysql root password
	mysql_root_password=

	DATE=`date +%F-%H-%M-%S`