Roy Li geekdada

geekdada / create db and grant.mysql

Created June 16, 2014 08:58

新建一个 DB 并授权

	DROP DATABASE IF EXISTS `<db name>`;
	CREATE DATABASE `<db name>`
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

	USE 'mysql';
	GRANT ALL PRIVILEGES ON <db name>.* TO '<username>'@'localhost' IDENTIFIED BY '<password>'

	WITH GRANT OPTION;
	FLUSH PRIVILEGES;

geekdada / gist:53eb32e1032325a2ee60

Last active February 10, 2016 07:18

My Chrome Extensions

	1Password: Password Manager and Secure Wallet https://agilebits.com/onepassword

	Adblock Plus https://chrome.google.com/webstore/detail/cfhdojbkjhnklbpkdaibdccddilifddb

	Alisec Extension https://chrome.google.com/webstore/detail/lapoiohkeidniicbalnfmakkbnpejgbi

	AngularJS Batarang https://chrome.google.com/webstore/detail/ighdmehidhipcmcojjgiloacoafjmpfk

	Awesome Screenshot: Capture & Annotate https://chrome.google.com/webstore/detail/alelhddbbhepgpmgidjdcjakblofbmce

geekdada / blacklist

Last active August 29, 2015 14:08

翻墙代理列表

geekdada / whitelist

Last active April 27, 2016 07:40

域名白名单（GoagentX 导入）

geekdada / main.conf

Last active August 19, 2022 10:16

Surge 配置文件

	[General]
	loglevel = notify
	bypass-system = true

	skip-proxy = 192.168.0.0/16, 10.0.0.0/8, 172.16.0.0/12, 100.84.0.0/16, localhost, .local, .jd.com, *.direct

	bypass-tun = 0.0.0.0/8, 1.0.0.0/9, 1.160.0.0/11, 1.192.0.0/11, 10.0.0.0/8, 14.0.0.0/11, 14.96.0.0/11, 14.128.0.0/11, 14.192.0.0/11, 27.0.0.0/10, 27.96.0.0/11, 27.128.0.0/9, 36.0.0.0/10, 36.96.0.0/11, 36.128.0.0/9, 39.0.0.0/11, 39.64.0.0/10, 39.128.0.0/10, 42.0.0.0/8, 43.224.0.0/11, 45.64.0.0/10, 47.64.0.0/10, 49.0.0.0/9, 49.128.0.0/11, 49.192.0.0/10, 54.192.0.0/11, 58.0.0.0/9, 58.128.0.0/11, 58.192.0.0/10, 59.32.0.0/11, 59.64.0.0/10, 59.128.0.0/9, 60.0.0.0/10, 60.160.0.0/11, 60.192.0.0/10, 61.0.0.0/10, 61.64.0.0/11, 61.128.0.0/10, 61.224.0.0/11, 100.64.0.0/10, 101.0.0.0/9, 101.128.0.0/11, 101.192.0.0/10, 103.0.0.0/10, 103.192.0.0/10, 106.0.0.0/9, 106.224.0.0/11, 110.0.0.0/7, 112.0.0.0/9, 112.128.0.0/11, 112.192.0.0/10, 113.0.0.0/9, 113.128.0.0/11, 113.192.0.0/10, 114.0.0.0/9, 114.128.0.0/11, 114.192.0.0/10, 115.0.0.0/8, 116.0.0.0/8, 117.0.0.0/9, 117.1

geekdada / gist:71adf0c0fd8be7cb33b702855f437067

Created February 10, 2017 18:03

keybase.md

	### Keybase proof

	I hereby claim:

	* I am geekdada on github.
	* I am geekdada (https://keybase.io/geekdada) on keybase.
	* I have a public key whose fingerprint is 7395 FE13 1689 A44A 170A 5867 1880 F8C1 41E4 8CE1

	To claim this, I am signing this object:

geekdada / get-keys-for-github-user.sh

Created February 13, 2017 15:50 — forked from rtlong/get-keys-for-github-user.sh

Put public keys for a github user in ~/.ssh/authorized keys with mucho ease

	IFS="$(printf '\n\t')"

	mkdir -p ~/.ssh

	if ! [[ -f ~/.ssh/authorized_keys ]]; then
	echo "Creating new ~/.ssh/authorized_keys"
	touch ~/.ssh/authorized_keys
	fi

	user=$1

geekdada / delete_branches_older_than.sh

Last active December 3, 2018 05:45 — forked from redthor/delete_branches_older_than.sh

Script to delete branches older than a certain date, modification of 4586456

	# Copy of https://gist.github.com/antonio/4586456
	# With a modification to collect all the branch names so we can make one git request
	# Set DRY_RUN=1 to get an echo of the command

	# Format that works with `git log --since`, e.g. 2018-01-01
	date=$1

	branches=
	for branch in $(git branch -a \| sed 's/^\s*//' \| sed 's/remotes\///' \| grep feature \| grep -v 'master$'); do
	if [[ "$(git log $branch --since $date \| wc -l)" -eq 0 ]]; then

geekdada / hulu_ads_script.js

Created July 18, 2019 06:50

Redirect Hulu ads

	let headers = $response.headers;

	headers['Location'] = 'https://dada-oss.dacdn.top/teehee-network-files/block.mp4';

	$done({
	status: 301,
	headers,
	});

geekdada / handler.js

Created November 4, 2019 02:21

Deploy Surgio gateway to Azure Function

	const createHandler = require("azure-function-express").createHandler;
	const gateway = require("surgio/build/gateway");

	// Binds the express app to an Azure Function handler
	module.exports = createHandler(gateway.createHttpServer());