Skip to content

Instantly share code, notes, and snippets.

Sherwin Techico stechico

Block or report user

Report or block stechico

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@stechico
stechico / 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:
@stechico
stechico / 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)

@stechico
stechico / 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 ]
@stechico
stechico / .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

@stechico
stechico / .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]
@stechico
stechico / rvm2rbenv.txt
Last active May 13, 2019 — 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,
@stechico
stechico / 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);
You can’t perform that action at this time.