Skip to content

Instantly share code, notes, and snippets.

View torrobinson's full-sized avatar
🟣

Tor torrobinson

🟣
View GitHub Profile
@IverCoder
IverCoder / office-guide.md
Last active July 26, 2024 16:08
Install and Activate Microsoft Office for Free - A Step-by-Step Guide

Please leave a star at the GitHub Gist mirror if this guide has helped you! You can also ask questions/assistance there.

Install and Activate Microsoft Office 365 for Free - A Step-by-Step Guide

This is a guide on how to install the latest version of Microsoft Office for free. For this method, we will use the Office Deployment Tool. The Microsoft Office Deployment Tool is a command-line program that IT managers use to configure and deliver Office products to PCs in their businesses, but in this guide, we will use it to install Microsoft Office with additional customization options and download it straight from Microsoft's servers.

NOTE: You will not need to repeat this step again to upgrade. Just keep your Office up to date and you will not have any issues.

NOTE: Make sure you have recently reloaded your number with at least 5GB of internet if you use your mobile internet through a hotspot to download. If your telecom

@oktomus
oktomus / fork-custom-commands.md
Last active July 18, 2024 10:31
Fork custom commands

With custom commands, you are one shortcut away to run commands thanks to the Quick Launch (Ctrl+P, ⌘+P).

Custom commands can be configured in File > Preferences > Custom commands, or by editing the json file custom-commands.json located in AppData/Local/Fork on Windows and ~/Library/Application Support/com.DanPristupov.Fork/custom-commands.json on MacOS.

Please share your own custom commands :)

How to use

Fork commands are posted as comments on this gist. Press CTRL+F to search for commands.

@AymaneHrouch
AymaneHrouch / autosub_reddit.js
Last active July 4, 2024 17:06
Auto subscribe to a lot of subreddits after you move to a new account.
/*
-Visit https://old.reddit.com/subreddits/ using your old account
-Copy link address of "multireddit of your subscriptions"
It will give you a link address like this: https://old.reddit.com/r/[subreddit1+subreddit2...+subredditN]
Please note that if you have a lot of subreddits the link won't work because there's a limit to the link's length, you can simply split it to two or three links
-Visit that link (or links) using your new account.
-Open the console by pressing F12 and then clicking the console tab
-Past the code bellow and press enter. You're welcome :)
*/
const sub = () => {
@torrobinson
torrobinson / dates.sql
Last active September 24, 2021 16:57
DB2 JDE Date Helpers
-- Getting Gregorian Date from Julian Column:
CASE WHEN [JULIAN] IS NULL OR [JULIAN] = 0 THEN '' ELSE CAST(CAST(CAST(((CAST(([JULIAN]-MOD([JULIAN],1000))/1000 AS INT)+1900)*1000)+MOD([JULIAN],1000) AS CHAR(7)) AS DATE) AS CHAR(10)) END
-- Getting Time from 6-digit time (130045 = 1:00:45pm)
CAST(SUBSTR([TIMESTR],1,2) || ':' || SUBSTR([TIMESTR],3,2) || ':' || SUBSTR([TIMESTR],5,2) as TIME)
-- Current Date in JDE Julian Format:
select (YEAR(NOW()) - 1900) || LPAD(DAYOFYEAR(NOW()),3,'0') from sysibm.sysdummy1;
--or
select (100000+(YEAR(curdate())-2000)*1000+dayofyear(curdate())) from sysibm.sysdummy1;
@consti
consti / hosts
Last active June 7, 2024 13:12
/etc/hosts to block shock sites etc.
# This hosts file is brought to you by Dan Pollock and can be found at
# http://someonewhocares.org/hosts/
# You are free to copy and distribute this file for non-commercial uses,
# as long the original URL and attribution is included.
#<localhost>
127.0.0.1 localhost
127.0.0.1 localhost.localdomain
255.255.255.255 broadcasthost
::1 localhost
@adamjohnson
adamjohnson / publickey-git-error.markdown
Last active July 24, 2024 22:08
Fix "Permission denied (publickey)" error when pushing with Git

"Help, I keep getting a 'Permission Denied (publickey)' error when I push!"

This means, on your local machine, you haven't made any SSH keys. Not to worry. Here's how to fix:

  1. Open git bash (Use the Windows search. To find it, type "git bash") or the Mac Terminal. Pro Tip: You can use any *nix based command prompt (but not the default Windows Command Prompt!)
  2. Type cd ~/.ssh. This will take you to the root directory for Git (Likely C:\Users\[YOUR-USER-NAME]\.ssh\ on Windows)
  3. Within the .ssh folder, there should be these two files: id_rsa and id_rsa.pub. These are the files that tell your computer how to communicate with GitHub, BitBucket, or any other Git based service. Type ls to see a directory listing. If those two files don't show up, proceed to the next step. NOTE: Your SSH keys must be named id_rsa and id_rsa.pub in order for Git, GitHub, and BitBucket to recognize them by default.
  4. To create the SSH keys, type ssh-keygen -t rsa -C "your_email@example.com". Th
@shawndumas
shawndumas / soundex.js
Last active February 21, 2024 11:47
Soundex in JavaScript
var soundex = function (s) {
var a = s.toLowerCase().split(''),
f = a.shift(),
r = '',
codes = {
a: '', e: '', i: '', o: '', u: '',
b: 1, f: 1, p: 1, v: 1,
c: 2, g: 2, j: 2, k: 2, q: 2, s: 2, x: 2, z: 2,
d: 3, t: 3,
l: 4,