This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT c.name AS 'ColumnName' | |
| , t.name AS 'TableName' | |
| FROM AutoCRM.sys.columns c | |
| JOIN AutoCRM.sys.tables t | |
| ON c.object_id = t.object_id | |
| WHERE c.name LIKE '%example%' | |
| ORDER BY TableName | |
| , ColumnName; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // ==UserScript== | |
| // @name Facebook Book Scraper | |
| // @namespace http://l33tch.net/ | |
| // @version 1.1 | |
| // @description Get a list of your books off Facebook! | |
| // @author L33tCh | |
| // @match https://*.facebook.com/*/books* | |
| // @grant none | |
| // ==/UserScript== |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Generates changelog day by day | |
| # Can also filter by user | |
| user=$1 | |
| echo "CHANGELOG" | |
| echo ---------------------- | |
| git log --no-merges --author=$user --format="%cd for %an" --date=short | sort -u -r | while read DATE ; do | |
| echo | |
| echo [$DATE] | |
| GIT_PAGER=cat git log --author=$user --no-merges --format="%s" --since="$DATE 00:00" --until="$DATE 23:59" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # URL for speedtest-api (Change this to match your setup) | |
| URL="localhost:3000/api/test/create" | |
| # Path to speedtest-cli (Change this to match the path to your speedtest-cli executable) | |
| SPEEDTEST_CLI_PATH="/usr/bin/speedtest-cli" | |
| # Input Field Seperator for splitting the CSV result into an array | |
| IFS="," |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Log time when entering and exiting an area. This includes tracking hours with multiple clients and travel times. Use this Sheets template: http://bit.ly/2dfsF4k | |
| . | |
| Just update the location to match where you wish to track and the text "Client" in the formatted row section. Feel free to add as many iterations of this Applet for how ever many clients you have. | |
| Until IFTTT allow me to publish, you will have to replace the the "Track your work hours" Do Applet with the detail below and update the first few formatted cells by copying everything within square brackets here: | |
| [ {{OccurredAt}} ||| Manual ||| {{LocationMapURL}} ||| =IF(ISODD(ROW()), "exited", "entered") ] | |
| and replace the formatted row left of " ||| =DATEVALUE(... " with the copy. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Use Gists to store code you would like to remember later on | |
| console.log(window); // log the "window" object to the console |