Skip to content

Instantly share code, notes, and snippets.

View JackScottAU's full-sized avatar

Jack Scott JackScottAU

View GitHub Profile
@JackScottAU
JackScottAU / Ginger Beer
Created November 22, 2011 11:47
Ginger Beer
Into a 1.25L bottle:
* Juice from one lemon.
* 0.25 teaspoon of baking/brewing yeast.
* 1 cup of sugar (white traditionally, but I'm trying raw and brown in these batches).
* 1 tablespoon of fresh ginger root (I removed the skin, chopped into chunks and then blended with a bit of water).
* Swill these ingredients in with about half a bottle of water.
Shake furiously. Try to get the sugar disolved.
Add enough water to fill the bottle. Leave about half an inch to an inch of air space at the top.
### Keybase proof
I hereby claim:
* I am JackScottAU on github.
* I am jackscottau (https://keybase.io/jackscottau) on keybase.
* I have a public key whose fingerprint is 78C0 CEC6 A138 C5C8 7A2D 0DA3 F3EA BD1A AC83 D520
To claim this, I am signing this object:
@JackScottAU
JackScottAU / settime.py
Created September 9, 2016 03:36
The most useful python script I've ever written...
#!/usr/bin/python
import os
import time
while True:
os.system('date')
time.sleep(0.1)
@JackScottAU
JackScottAU / get_customer_emails.sql
Created July 19, 2017 01:18
Get Customer Emails from WooCommerce
SELECT meta_value AS email, COUNT(meta_value) AS orders
FROM wp_postmeta INNER JOIN wp_posts ON wp_posts.ID = wp_postmeta.post_id
WHERE wp_posts.post_type = 'shop_order' AND wp_postmeta.meta_key = '_billing_email'
GROUP BY meta_value
ORDER BY COUNT(meta_value) DESC;