holly holly

## cloud_front_ips.sh
curl -s "https://ip-ranges.amazonaws.com/ip-ranges.json" |jq -r '.prefixes | map(select(.service == "CLOUDFRONT").ip_prefix) | "set_real_ip_from" + "  " + .[] + ";"'

## github-pandoc.css
/*! normalize.css v2.1.3 | MIT License | git.io/normalize */

/* ==========================================================================
   HTML5 display definitions
   ========================================================================== */

/**
 * Correct `block` display not defined in IE 8/9.
 */

## md_sync_call.sh
#!/bin/sh

TARGET_MD=$1

### call md verifying when idle.
######
# HOW TO USE
### md_sync_call.sh md0

error_exit() {

## README.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                holly
                / README.md
            
            
              Created
              March 4, 2018 06:38
                — forked from magnetikonline/README.md
            
              
                WordPress assorted database clean up SQL queries.
              
          
    WordPress database clean up queries


Orphan rows

wp_posts -> wp_posts (parent/child)
wp_postmeta -> wp_posts
wp_term_taxonomy -> wp_terms
wp_term_relationships -> wp_term_taxonomy
wp_usermeta -> wp_users
wp_posts -> wp_users


Other

wp_postmeta dupes


## method_missing.py
class MethodMissing(object):
    def __getattr__(self, name):
        try:
            return self.__getattribute__(name)
        except AttributeError:
            def method(*args, **kw):
                return self.method_missing(name, *args, **kw)
            return method

    def method_missing(self, name, *args, **kw):

## mysql_secure.sh
#!/bin/bash

aptitude -y install expect

// Not required in actual script
MYSQL_ROOT_PASSWORD=abcd1234

SECURE_MYSQL=$(expect -c "

set timeout 10

## inotify.py
import collections
import ctypes
import ctypes.util

# bit masks
IN_ISDIR      = 0x40000000
IN_ALL_EVENTS = 0xfff

class inotify_event_struct(ctypes.Structure):
    """

## Check server
openssl s_client -cipher EXPORT -connect domain.com:443 < /dev/null 2>/dev/null | grep SSL-Session | wc -l

## getswap.sh
#!/bin/bash
# Get current swap usage for all running processes
# Erik Ljungstrom 27/05/2011
# Updated: 2013-11-13 Yuichiro Saito
SUM=0
OVERALL=0
for DIR in `find /proc/ -maxdepth 1 -type d | egrep "^/proc/[0-9]"` ; do
PID=`echo $DIR | cut -d / -f 3`
PROGNAME=`ps -p $PID -o comm --no-headers`
for SWAP in `grep Swap $DIR/smaps 2>/dev/null| awk '{ print $2 }'`

## tumblr-recent-posts.js
/*
  This widget shows Recent Posts on your Tumblr blog.
  Its dependency is jQuery.

  Usage:

    1) Add html:
      <div id="recent-posts"></div>

    2) Add code into the <head>:
	/! normalize.css v2.1.3 \| MIT License \| git.io/normalize /

	/* ==========================================================================
	HTML5 display definitions
	========================================================================== */

	/**
	* Correct `block` display not defined in IE 8/9.
	*/
	#!/bin/sh

	TARGET_MD=$1

	### call md verifying when idle.
	######
	# HOW TO USE
	### md_sync_call.sh md0

	error_exit() {
	class MethodMissing(object):
	def __getattr__(self, name):
	try:
	return self.__getattribute__(name)
	except AttributeError:
	def method(args, *kw):
	return self.method_missing(name, args, *kw)
	return method

	def method_missing(self, name, args, *kw):
	#!/bin/bash

	aptitude -y install expect

	// Not required in actual script
	MYSQL_ROOT_PASSWORD=abcd1234

	SECURE_MYSQL=$(expect -c "

	set timeout 10
	import collections
	import ctypes
	import ctypes.util

	# bit masks
	IN_ISDIR = 0x40000000
	IN_ALL_EVENTS = 0xfff

	class inotify_event_struct(ctypes.Structure):
	"""
	#!/bin/bash
	# Get current swap usage for all running processes
	# Erik Ljungstrom 27/05/2011
	# Updated: 2013-11-13 Yuichiro Saito
	SUM=0
	OVERALL=0
	for DIR in `find /proc/ -maxdepth 1 -type d \| egrep "^/proc/[0-9]"` ; do
	PID=`echo $DIR \| cut -d / -f 3`
	PROGNAME=`ps -p $PID -o comm --no-headers`
	for SWAP in `grep Swap $DIR/smaps 2>/dev/null\| awk '{ print $2 }'`
	/*
	This widget shows Recent Posts on your Tumblr blog.
	Its dependency is jQuery.

	Usage:

	1) Add html:
	<div id="recent-posts"></div>

	2) Add code into the <head>: