ko31’s gists

ko31 / bulk-delete-posts.sql

Last active April 19, 2019 08:52

SQL for bulk delete posts, attachments, and meta in WordPress

-DELETE
-  POST,
-  POST_META,
-  ATT,
-  ATT_META
-FROM wp_posts POST
-LEFT JOIN wp_postmeta POST_META
-  ON POST.ID = POST_META.post_id
-LEFT JOIN wp_posts ATT
-  ON POST.ID = ATT.post_parent

ko31 / set_extentions.sh

Created March 2, 2019 09:07

Set extension from file format to image file

	#/bin/sh

	SOURCE=images/*

	for file in ${SOURCE}; do

	mime=$( file -b --mime "${file}" \| grep -o '.*;' )

	case $mime in
	"image/bmp;" ) ext=bmp ;;

ko31 / docker-compose.yml

Created February 13, 2019 23:21

WP Dev Docker + Pure-FTPd

	# WP Dev Docker https://github.com/ko31/wp-dev-docker
	version: '3'

	services:
	db:
	image: mysql:5.7
	volumes:
	- db_data:/var/lib/mysql
	- ./data:/docker-entrypoint-initdb.d
	environment:

ko31 / 2019_senbatsu_school.tsv

Last active February 2, 2019 20:36

⚾第91回選抜高校野球大会出場校データ

地区	学校	出場回数	URL
北海道	札幌大谷	初出場	http://www.s-ohtani.ed.jp/
北海道	札幌第一	2年ぶり3度目	http://www.kibou.ac.jp/daiichi/
東北	八戸学院光星	3年ぶり10度目	http://kh.hachinohe-u.ac.jp/
東北	盛岡大付	2年ぶり5度目	http://www.morifu.jp/
関東・東京	桐蔭学園	16年ぶり6度目	http://toin.ac.jp/
関東・東京	春日部共栄	22年ぶり3度目	https://www.k-kyoei.ed.jp/hs/
関東・東京	山梨学院	5年ぶり3度目	http://www.yghs.ed.jp/
関東・東京	習志野	10年ぶり4度目	http://www.nkc.city.narashino.chiba.jp/narako/
関東・東京	国士舘	10年ぶり9度目	http://hs.kokushikan.ed.jp/

ko31 / functions.php

Created January 22, 2019 02:58

How to add custom status for Woocommerce.

	<?php
	// The following code adds the status "Reserved".

	/**
	* Register new status
	*/
	add_filter( 'init', function () {
	register_post_status( 'wc-reserved', array(
	'label' => 'Reserved',
	'public' => true,

ko31 / sample.json

Last active December 25, 2018 08:43

[{"uid":"urn:uuid:f24c3ed5-a352-4a81-949d-0436ef84fc3f","updateDate":"2018-12-25T08:42:24.0Z","titleText":"\u30c6\u30b9\u30c8\u30bf\u30a4\u30c8\u30eb\u3067\u3059","redirectionUrl":"https:\/\/alexafb.ko31.com\/briefing\/%e3%82%bf%e3%82%a4%e3%83%88%e3%83%ab%e3%81%a7%e3%81%99\/","mainText":"\u30c6\u30b9\u30c8\u672c\u6587\u3067\u3059\u3002"}]

ko31 / SampleFilterAnalytics.php

Created December 19, 2018 16:17

Get reports with multiple condition filters for Google Analytics Reporting API v4

	<?php

	// composer require google/apiclient

	/**
	* @link https://developers.google.com/analytics/devguides/reporting/core/v4/quickstart/service-php
	* @link https://developers.google.com/analytics/devguides/reporting/core/v4/samples
	* @link https://developers.google.com/analytics/devguides/reporting/core/v4/rest/v4/reports/batchGet
	*/

ko31 / HelloAnalytics.php

Last active December 14, 2018 10:26

Get reports with filter for Google Analytics Reporting API v4

	<?php

	// composer require google/apiclient

	/**
	* @link https://developers.google.com/analytics/devguides/reporting/core/v4/quickstart/service-php
	* @link https://developers.google.com/analytics/devguides/reporting/core/v4/samples
	* @link https://developers.google.com/analytics/devguides/reporting/core/v4/rest/v4/reports/batchGet#Operator
	*/

ko31 / issues.sh

Created September 6, 2018 00:46

GitHub issuesからTSV出力するコマンド

	curl -u ":username" "https://api.github.com/repos/:owner/:repos/issues?state=open" \|\
	jq -r '["number","title","html_url"], (.[] \| [.number,.title,.html_url]) \| @tsv' > issues.tsv

ko31 / issues.sh

Created September 6, 2018 00:45

GitHub issuesからCSV出力するコマンド

	curl -u ":username" "https://api.github.com/repos/:owner/:repos/issues?state=open" \|\
	jq -r '["number","title","html_url"], (.[] \| [.number,.title,.html_url]) \| @csv' > issues.csv

Ko Takagi ko31