Spencer Heywood heywoodlh

## wp-replace-sql-url
UPDATE wp_options SET option_value = replace(option_value, 'http://travelspective.com', 'http://localhost/tsbuild/build') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://travelspective.com', 'http://localhost/tsbuild/build');

UPDATE wp_posts SET post_content = replace(post_content, 'http://travelspective.com', 'http://localhost/tsbuild/build');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://travelspective.com', 'http://localhost/tsbuild/build');

## weblogin.sh
#!/usr/bin/env bash

help_message() {
echo "Usage: $0 'username' 'password' 'https://urltologin.com'"
}

if [ -z $1 ]
then
	help_message
	exit 2

## headless-vbox.sh
#!/usr/bin/env bash

#Requirements:
# 1. ssh needs to be running on vm
# 2. VM_NAME and USER variable need to be set

#Set these variables (VM_NAME should equal the name of your virtualbox vm, USER should equal the name of your vm username)

VM_NAME=""

## clean-up.ps1
<# REMEMBER TO SetExecutionPolicy Unrestricted -Force #>


<# Download tech tools #>

## ip-scan.sh
#!/usr/bin/env bash

IP=$(sudo arp-scan --localnet --numeric --quiet --ignoredups | grep -E '([a-f0-9]{2}:){5}[a-f0-9]{2}' | awk '{print $1}')

echo $IP | fmt -w 1

## tarsnap-backup-notification.sh
#!/usr/bin/env bash

## This script assumes that ssmtp is already configured on the server.

KEYFILE="/tmp/tarsnap.key"
EMAIL="joe@myemail.com"
BACKUP_NAME="$(uname -n)-server-backup-$(date +%Y-%m-%d_%H-%M-%S)"
DATA_PATH="/tmp/path1 /tmp/path2"
TOTAL_BACKUPS='3'
EXCLUDE="" #space separated paths if you need multiple exclusions

## generic-portforward.sh
#!/usr/bin/env bash
PORT='80'
SSH_PORT='22'
USERNAME='root'
HOSTNAME='myserver.com'

if ssh -p "$SSH_PORT" -t -t -L 9000:127.0.0.1:"$PORT" "$USERNAME"@"$HOSTNAME" &
then
	SSH_PID=$(echo $!)
	sleep 5

## OS X macOS Install ISO Creator
#!/bin/bash

################################
#   OS X Install ISO Creater   #
#                              #
# Author: shela                #
################################

#######################################
# Declarations

## password-change.ps1
$domainServer = 'ad.mydomain.com'

$username = Read-Host -Prompt 'Username: '

$newPassword = Read-Host -AsSecureString -Prompt 'Password: '

Set-ADAccountPassword -Identity $username -Reset -NewPassword $newPassword

## account-lookup.ps1
$domainServer = 'ad1.mydomain.com'

$user = Read-Host -Prompt 'Last Name: '

get-aduser -f {SurName -eq $User}
	#!/usr/bin/env bash

	help_message() {
	echo "Usage: $0 'username' 'password' 'https://urltologin.com'"
	}

	if [ -z $1 ]
	then
	help_message
	exit 2
	#!/usr/bin/env bash

	#Requirements:
	# 1. ssh needs to be running on vm
	# 2. VM_NAME and USER variable need to be set

	#Set these variables (VM_NAME should equal the name of your virtualbox vm, USER should equal the name of your vm username)

	VM_NAME=""
	<# REMEMBER TO SetExecutionPolicy Unrestricted -Force #>







	<# Download tech tools #>
	#!/usr/bin/env bash

	IP=$(sudo arp-scan --localnet --numeric --quiet --ignoredups \| grep -E '([a-f0-9]{2}:){5}[a-f0-9]{2}' \| awk '{print $1}')

	echo $IP \| fmt -w 1
	#!/usr/bin/env bash

	## This script assumes that ssmtp is already configured on the server.

	KEYFILE="/tmp/tarsnap.key"
	EMAIL="joe@myemail.com"
	BACKUP_NAME="$(uname -n)-server-backup-$(date +%Y-%m-%d_%H-%M-%S)"
	DATA_PATH="/tmp/path1 /tmp/path2"
	TOTAL_BACKUPS='3'
	EXCLUDE="" #space separated paths if you need multiple exclusions
	#!/usr/bin/env bash
	PORT='80'
	SSH_PORT='22'
	USERNAME='root'
	HOSTNAME='myserver.com'

	if ssh -p "$SSH_PORT" -t -t -L 9000:127.0.0.1:"$PORT" "$USERNAME"@"$HOSTNAME" &
	then
	SSH_PID=$(echo $!)
	sleep 5
	#!/bin/bash

	################################
	# OS X Install ISO Creater #
	# #
	# Author: shela #
	################################

	#######################################
	# Declarations
	$domainServer = 'ad.mydomain.com'

	$username = Read-Host -Prompt 'Username: '

	$newPassword = Read-Host -AsSecureString -Prompt 'Password: '

	Set-ADAccountPassword -Identity $username -Reset -NewPassword $newPassword
	$domainServer = 'ad1.mydomain.com'

	$user = Read-Host -Prompt 'Last Name: '

	get-aduser -f {SurName -eq $User}