bizfreak22

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

##Windows users:

cmder will be refered as console

##Mac Os, Ubuntu and windows users continue here:

Hey there, apparently people are still using this Gist from 2013! It's out of date! Consult the Github docs.

Create a GitHub account on github.com.
Download either [GitHub for Mac][1] or [GitHub for Windows][2], depending on your operating system. Open the app and log in using the account you just created.
(On Mac): After you login, click advanced and make sure that your name and email are correct. Then, click "Install Command Line Tools", just in case you want to start using the command line later in life.
Create a new repository in your GitHub application. Name it your-username.github.io. The name is very important. Note the folder that GitHub is saving the repository to. Make sure the "Push to GitHub?" box is checked.
Move your website's files into the folder that GitHub just created when you made the repository. IMPORTANT: Your homepage HTML file must be called "index.html", and it must exist in the top-level

The main difference between the two pages is the method of sending messages. Recieving messages is the same in both.

Send messages to iframe using iframeEl.contentWindow.postMessage Recieve messages using window.addEventListener('message')

Steps to deploy a Node.js app to DigitalOcean using PM2, NGINX as a reverse proxy and an SSL from LetsEncrypt

If you use the referal link below, you get $10 free (1 or 2 months) https://m.do.co/c/5424d440c63a

I will be using the root user, but would suggest creating a new user

	#!/bin/bash
	export DEBIAN_FRONTEND=noninteractive;
	echo "[] Starting Install... []"
	echo "[] Upgrade installed packages to latest []"
	echo -e "\nRunning a package upgrade...\n"
	apt-get -qq update && apt-get -qq dist-upgrade -y
	apt full-upgrade -y
	apt-get autoclean

	echo "[] Install stuff I use all the time []"

	// Source: https://intoli.com/blog/scrape-infinite-scroll/

	const fs = require('fs');
	const puppeteer = require('puppeteer');

	function extractItems() {
	const extractedElements = document.querySelectorAll('main > div > div:nth-child(4) > article > div > div > div img');
	const items = [];
	for (let element of extractedElements) {
	items.push(element.src);

	const puppeteer = require('puppeteer');

	// PROXY and PORT
	const proxy = 'zproxy.lum-superproxy.io';
	const port = 22225;

	// USER and PASS
	let proxyUsername = 'username';
	const proxyPassword = 'password';

	const puppeteer = require('puppeteer');
	const fs = require('fs');
	const config = require('./config.json');
	const cookies = require('./cookies.json');

	(async () => {
	console.log('Hello World');
	//insert code here

	let browser = await puppeteer.launch({ headless: false });

	Download Google Drive files with WGET

	Example Google Drive download link:

	https://docs.google.com/open?id=[ID]
	To download the file with WGET you need to use this link:

	https://googledrive.com/host/[ID]

	Example WGET command: