Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

shrwnsan

🏠
Working from home
View GitHub Profile
@shrwnsan
shrwnsan / InsertDate.gs
Last active Aug 11, 2018 — forked from thomxc/InsertDate.gs
Google Docs Script Macro: Insert Timestamp (default to HKT/Beijing timezone)
View InsertDate.gs
/**
* The onOpen function runs automatically when the Google Docs document is
* opened. Use it to add custom menus to Google Docs that allow the user to run
* custom scripts. For more information, please consult the following two
* resources.
*
* Extending Google Docs developer guide:
* https://developers.google.com/apps-script/guides/docs
*
* Document service reference documentation:
@shrwnsan
shrwnsan / youtube-to-discord.md
Last active Jul 30, 2018
How to post new uploaded YouTube videos to a Discord channel by using IFTTT
View youtube-to-discord.md

How to post new uploaded YouTube videos to a Discord channel by using IFTTT

  1. Discord > Edit Channel > Webhooks > Create Webhook > Copy Webhook URL

  2. IFTTT > New Applet

  3. If "Youtube" then "Webhook" (in general)

  4. Select source for Youtube (e.g uploaded by you or a channel you're subscribed into)

@shrwnsan
shrwnsan / coins-btc-tracker.sh
Last active Aug 15, 2017
Coins.ph BTC rate tracker. This was actually from a gifted colleague of mine. Did some UX improvements =)
View coins-btc-tracker.sh
#!/bin/bash
AS_OF_DATE=$(date "+%Y-%m-%d %H:%M")
RESULT=$(curl -s https://quote.coins.ph/v1/markets/BTC-PHP | /usr/local/bin/jq -r '.market.bid,.market.ask')
BID=$(echo $RESULT | sed 's/ /-/g' | cut -f1 -d-)
ASK=$(echo $RESULT | sed 's/ /-/g' | cut -f2 -d-)
USD=$(echo "scale=2; $ASK/50" | bc)
echo "$AS_OF_DATE => $BID - $ASK (\$$USD)"
if [ $ASK -lt 200000 ]
@shrwnsan
shrwnsan / .rotate-videos
Last active Jan 23, 2017
Batch rotate videos. Note: This will stream copy the bitstreams, so no encoding is performed. Only the metadata of the first video stream (v:0) is changed here and the player will show the video in a rotated way. (Not all players will support this.)
View .rotate-videos
# Works on the latest ffmpeg
# Source, Stackoverflow http://bit.ly/2k960G7
# brew install ffmpeg
# Default for iPhone
ext=m4v
# Set your directory
for f in /some/dir/*.$ext; do
View jira-filters.md

JIRA Filters

Watched issues not assigned to me

issue in watchedissues() AND assignee != currentuser() ORDER BY assignee ASC

Watched issues not assigned to me that are Done

issue in watchedissues() AND assignee != currentuser() AND resolution = Done ORDER BY assignee ASC

Watched issues not assigned to me that are Unresolved

issue in watchedissues() AND assignee != currentuser() AND resolution = Unresolved ORDER BY assignee ASC

@shrwnsan
shrwnsan / .htaccess
Created Jan 5, 2015
To remove the .php extension from a PHP file for example yoursite.com/wallpaper.php to yoursite.com/wallpaper
View .htaccess
# Removing Extensions
# Source http://alexcican.com/post/how-to-remove-php-html-htm-extensions-with-htaccess/
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^([^\.]+)$ $1.php [NC,L]
@shrwnsan
shrwnsan / rvm2rbenv.txt
Last active May 12, 2020 — forked from brentertz/rvm2rbenv.txt
Migration from RVM to RBENV
View rvm2rbenv.txt
## Prepare ###################################################################
# Remove RVM
rvm implode
sudo rm -rf ~/.rvm
sudo rm -rf ~/.rvmrc
sudo rm -rf /etc/rvmrc
# Also, please check all .bashrc .bash_profile .profile and .zshrc for RVM source lines and delete or comment out if this was a Per-User installation.
View .get-latest-stable-npm
npm install --globel npm@latest
View gulpfile-express.js
var gulp = require('gulp'),
sass = require('gulp-sass'),
browserify = require('gulp-browserify'),
concat = require('gulp-concat'),
embedlr = require('gulp-embedlr'),
refresh = require('gulp-livereload'),
lrserver = require('tiny-lr')(),
express = require('express'),
livereload = require('connect-livereload')
livereloadport = 35729,
@shrwnsan
shrwnsan / sc-dl-min.js
Last active Aug 29, 2015 — forked from duncanbeevers/sc-dl-min.js
Bookmarklet which creates download links on *any* Soundcloud page. Full credit goes to @duncanbeevers, with contributions from @markpiro and @haroldSanchezb -- Last tested on Soundcloud site: 4 Feb 2013 Successful :-)
View sc-dl-min.js
!function(a){var b,c,d,e=$(".sound"),f=require("config").get("client_id");require("lib/connect").getAuthToken();var i,j,k,l,m,h=require("lib/helpers/conversion-helper");for(b=e.length-1;b>=0;b--){c=$(e[b]);var n="https://soundcloud.com"+(c.find(".soundTitle__title").attr("href")||a.location.pathname);k={url:n,client_id:f},m=function(a){return function(b){var c={client_id:f};l=require("lib/url").stringify({query:c},b.stream_url+".mp3"),d=$(a.find(".sound__soundActions .sc-button-group")[0]),j=d.find(".sc-button:first")[0].className.match(/sc-button-((?:small)|(?:medium))/)[1],i=$('<a class="sc-button sc-button-download sc-button-icon sc-button-responsive">Download</a>').attr({title:"Download this sound ("+h.bytesToMB(b.original_content_size)+")",href:l,download:a.find(".soundTitle__title").first().text()+".mp3"}).addClass("sc-button-"+j),0==a.find(".sc-button-download").length&&d.append(i)}}(c),$.getJSON("http://api.soundcloud.com/resolve.json",k).success(m)}}(window);