priestd09 / wordpress-change-domain-migration.sql

Created January 5, 2025 20:26 — forked from vunb/wordpress-change-domain-migration.sql

Use this SQL script when changing domains on a WordPress site. Whether you’re moving from an old domain to a new domain or you’re changing from a development domain to a production domain this will work. __STEP1: always backup your database. __STEP2: change the ‘oldsite.com’ and ‘newsite.com’ variables to your own. __STEP3: make sure your databa…

	SET @oldsite='http://oldsite.com';
	SET @newsite='http://newsite.com';
	UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
	UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
	UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
	UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

	/* only uncomment next line if you want all your current posts to post to RSS again as new */
	#UPDATE wp_posts SET guid = replace(guid, @oldsite, @newsite);

priestd09 / diskinfo.go

Created November 24, 2020 18:47 — forked from lunny/diskinfo.go

Disk Info for Golang

	package main

	import (
	"fmt"
	"syscall"
	)

	type DiskStatus struct {
	All uint64 `json:"all"`
	Used uint64 `json:"used"`

priestd09 / encoding-video.md

Created November 6, 2020 02:59 — forked from tayvano/encoding-video.md

Encoding Video for the web

Encoding Video

Installing

Install FFmpeg with homebrew. You'll need to install it with a couple flags for webm and the AAC audio codec.

brew install ffmpeg --with-libvpx --with-libvorbis --with-fdk-aacc --with-opus

priestd09 / gist:49e9fcd4c7c2a33842c2e21f1150cdd8

Created November 6, 2020 02:56 — forked from tayvano/gist:6e2d456a9897f55025e25035478a3a50

complete list of ffmpeg flags / commands

	Originall From: Posted 2015-05-29 http://ubwg.net/b/full-list-of-ffmpeg-flags-and-options

	This is the complete list that’s outputted by ffmpeg when running ffmpeg -h full.

	usage: ffmpeg [options] [[infile options] -i infile]… {[outfile options] outfile}…

	Getting help:
	-h — print basic options
	-h long — print more options
	-h full — print all options (including all format and codec specific options, very long)

priestd09 / letsencrypt_2020.md

Created October 15, 2020 18:01 — forked from cecilemuller/letsencrypt_2020.md

How to setup Let's Encrypt for Nginx on Ubuntu 18.04 (including IPv6, HTTP/2 and A+ SSL rating)

How to setup Let's Encrypt for Nginx on Ubuntu 18.04 (including IPv6, HTTP/2 and A+ SLL rating)

Virtual hosts

Let's say you want to host domains first.com and second.com.

Create folders for their files:

priestd09 / nginx

Created February 3, 2020 21:36 — forked from azhao1981/nginx

Golang Websocket Nginx

	#Golang Websocket Server
	server {
	listen 8080;
	server_name wss.morse.io;
	access_log /var/log/nginx/access_log.log;
	error_log /var/log/nginx/error.log;

	#ssl config
	ssl on;
	#Cert Info

priestd09 / handbrake.sh

Created January 29, 2020 22:26 — forked from ralphcrisostomo/handbrake.sh

Batch convert videos with HandBrake CLI

	#!/bin/bash
	# Batch convert videos with HandBrake CLI
	# By Ralph Crisostomo - 2016.04.17
	#
	# Usage :
	# 'sudo ./handbrake.sh /source /destination'
	#
	# Reference :
	# https://forum.handbrake.fr/viewtopic.php?f=6&t=19426
	# https://gist.github.com/czj/1263872

priestd09 / wp-query-ref.php

Created November 15, 2019 20:31 — forked from luetkemj/wp-query-ref.php

WP: Query $args

	// This gist is now maintained on github at https://github.com/luetkemj/wp-query-ref

	<?php
	/**
	* WordPress Query Comprehensive Reference
	* Compiled by luetkemj - luetkemj.github.io
	*
	* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
	* Source: https://core.trac.wordpress.org/browser/tags/4.9.4/src/wp-includes/query.php
	*/

priestd09 / main.go

Created November 5, 2019 16:29 — forked from creack/main.go

A simple golang web server with basic logging, tracing, health check, graceful shutdown and zero dependencies

	package main

	import (
	"context"
	"fmt"
	"log"
	"net/http"
	"os"
	"os/signal"
	"strconv"

priestd09 / git-tag-delete-local-and-remote.sh

Created October 16, 2019 14:46 — forked from mobilemind/git-tag-delete-local-and-remote.sh

how to delete a git tag locally and remote

-# delete local tag '12345'
-git tag -d 12345
-# delete remote tag '12345' (eg, GitHub version too)
-git push origin :refs/tags/12345
-# alternative approach
-git push --delete origin tagName
-git tag -d tagName