Skip to content

Instantly share code, notes, and snippets.

View mfcodeworks's full-sized avatar
🗺️
Working Remotely

MF Codeworks mfcodeworks

🗺️
Working Remotely
View GitHub Profile
SELECT id, address, datetime, price, ROUND(6371 * acos(cos(radians(1.329380)) * cos(radians(event_lat)) * cos(radians(event_lng) - radians(103.775595)) + sin(radians(1.329380)) * sin(radians(event_lat))), 3) as distance
FROM jobs
WHERE (6371 * acos(cos(radians(1.329380)) * cos(radians(event_lat)) * cos(radians(event_lng) - radians(103.775595)) + sin(radians(1.329380)) * sin(radians(event_lat)))) < 50
ORDER BY distance DESC;
SELECT StrangerId, COUNT(MutualFollowing) AS MutualFollowingCount
FROM (
SELECT
CASE WHEN f.following_user = mf.friendId THEN f.user ELSE f.following_user END AS StrangerId,
CASE WHEN f.user = mf.friendId THEN f.user ELSE f.following_user END AS MutualFollowing
FROM (
SELECT
CASE WHEN user = 1 THEN following_user
ELSE user
END AS friendId
@mfcodeworks
mfcodeworks / encrypted-storage.js
Last active August 3, 2023 05:08
Encrypted storage with localstorage
// Constants
const passphrase = 'password',
key = 'data',
object = { foo: 'bar' };
// Log original item
console.log('Original object', object);
// Store item with encryption
setItem(key, object, passphrase);
sudo apt update
sudo apt upgrade -y
sudo apt dist-upgrade -y
sudo apt install nginx redis-server curl dirmngr apt-transport-https lsb-release ca-certificates -y
curl -sL https://deb.nodesource.com/setup_12.x | sudo -E bash -
sudo apt -y install nodejs
sudo apt -y install gcc g++ make
sudo ufw allow 'Nginx HTTP'
sudo apt install mariadb-server -y
sudo mysql_secure_installation
@mfcodeworks
mfcodeworks / main.js
Created September 11, 2019 07:55
Electron Angular Configuration
const {app, BrowserWindow} = require('electron');
const url = require('url');
const path = require('path');
let mainWindow;
function createWindow() {
mainWindow = new BrowserWindow({
width: 1000,
height: 800,
@mfcodeworks
mfcodeworks / setup.bat
Last active November 16, 2020 15:24
Windows Setup Script
@echo THIS MUST BE RUN WITH WINDOWS POWERSHELL FOR INITIAL CHOCOLATEY INSTALLATION
Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))
choco install brave jre8 firefox 7zip vlc notepadplusplus git openssh putty nodejs sysinternals jdk8 chocolatey-windowsupdate.extension vcredist140 netfx-4.7.1-devpack filezilla teamviewer dotnetfx dotnet3.5 vcredist2015 dotnet4.5 python winscp vscode rainmeter sourcetree qbittorrent androidstudio composer goggalaxy gimp irfanview spotify
@mfcodeworks
mfcodeworks / encrypted-forage.js
Created November 1, 2019 04:25
Encrypted storage with localforage.js
// Constants
const passphrase = 'A3PnGzWjxGuAYtFu',
key = 'data',
object = { foo: 'bar' };
// Log original item
console.log('Original object', object);
// Store item with encryption
setItem(key, object, passphrase)
@mfcodeworks
mfcodeworks / encrypted-forage.ts
Created November 1, 2019 04:29
Encrypted storage with localforage.js typescript version
// Declare for typescript
declare var CryptoJS: any;
declare var localforage: any;
// Constants
const passphrase = 'A3PnGzWjxGuAYtFu',
key = 'data',
object = { foo: 'bar' };
// Log original item
@mfcodeworks
mfcodeworks / argon2id-miner.js
Last active November 27, 2019 00:10
Web miner using Argon2id hashing from argon2-browser package
export default class Miner {
constructor(difficulty = 1, block = undefined) {
this.difficulty = difficulty;
this.block = block || {
id: 1,
time: new Date().getTime(),
prevHash: 'd5cd02605f5dd530caa73c799ee75d92b8e637986ab4b23875c2fa95da7d5674',
data: {
foo: 42
}
const secureMathRandom = () => {
// Divide a random UInt32 by the maximum value (2^32 -1) to get a result between 0 and 1
return window.crypto.getRandomValues(new Uint32Array(1))[0] / 4294967295;
}