Consistent commit messages that are easily readable & searchable.
commit_type(project_component): [issue_reference] short_message
optional_extended_message
roydejong
/ mysql-backup-to-s3
Last active
August 13, 2021 07:29
Cron script: MySQL Nightly Backups to S3
This file contains 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 | |
| # /etc/cron.daily/mysql-s3-backup | |
| # Before use, install AWS CLI and use "aws configure" to set up credentials with write access to your s3 bucket | |
| # See https://docs.aws.amazon.com/cli/latest/userguide/install-cliv2-linux.html#cliv2-linux-install | |
| DB_USER=XXX | |
| DB_NAME=XXX | |
| DB_PASS=XXX |
roydejong
/ progrids-install.md
Last active
September 13, 2023 14:06
Installing ProGrids v3 in Unity 2018.3
ProGrids seems to have disappeared from the Unity Package Manager as of Unity 2018.3.
It is possible to install ProGrids v2 via the Asset Store, but it's an old and incompatible version.
Per Sayama3:
In 2021, you still can use it but it's different :
- Go to the Package Manager
roydejong
/ is_touch_device.js
Created
January 7, 2019 03:16
JavaScript: Detect touch device (react compatible)
This file contains 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
| function is_touch_device() { | |
| try { | |
| let prefixes = ' -webkit- -moz- -o- -ms- '.split(' '); | |
| let mq = function (query) { | |
| return window.matchMedia(query).matches; | |
| }; | |
| if (('ontouchstart' in window) || (typeof window.DocumentTouch !== "undefined" && document instanceof window.DocumentTouch)) { | |
| return true; |
roydejong
/ UnityDiscordRPCDebugLogger.cs
Last active
January 7, 2019 05:47
Unity: Debug logger class for the DiscordRPC C# Wrapper Library
This file contains 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
| using DiscordRPC.Logging; | |
| using System; | |
| using UnityEngine; | |
| public class DiscordDebugLogger : DiscordRPC.Logging.ILogger | |
| { | |
| /// <summary> | |
| /// The level of logging to apply to this logger. | |
| /// </summary> | |
| public LogLevel Level { get; set; } |
roydejong
/ NativeWinAlert.cs
Last active
March 31, 2024 15:53
Unity: NativeWinAlert (Windows MessageBox / Alert Dialog for Unity games)
This file contains 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
| using System; | |
| using System.Runtime.InteropServices; | |
| /// <see>https://docs.microsoft.com/en-us/windows/desktop/api/winuser/nf-winuser-messagebox</see> | |
| public static class NativeWinAlert | |
| { | |
| [System.Runtime.InteropServices.DllImport("user32.dll")] | |
| private static extern System.IntPtr GetActiveWindow(); | |
| public static System.IntPtr GetWindowHandle() |
roydejong
/ floatval-locale-guess.php
Last active
May 1, 2022 19:38
PHP: Parse raw input as a float, with best guess for the decimal character (dot or comma). Useful if you do not know original locale or when you are processing user input.
This file contains 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
| <?php | |
| function parseFloatGuess($rawValue) { | |
| if (!$rawValue) { | |
| return 0; | |
| } | |
| $lastCommaPosition = strrpos($rawValue, ','); | |
| $lastDotPosition = strrpos($rawValue, '.'); |
roydejong
/ wkhtmltopdf-setup-with-xvfb-and-php.md
Last active
May 25, 2023 13:38
Set up wkhtmltopdf 0.12.6 on Ubuntu server + xvfb runtime + PHP integration
Find the download URL for the latest binary from the official Downloads page.
At the time of writing, this is v0.12.6, which was released on June 11, 2020.
Download the binary, and then install the package and its dependencies. For example:
wget https://github.com/wkhtmltopdf/packaging/releases/download/0.12.6.1-2/wkhtmltox_0.12.6.1-2.jammy_amd64.deb
sudo dpkg -i wkhtmltox_0.12.6.1-2.jammy_amd64.deb
roydejong
/ pouchdb-create-or-update-merge.js
Last active
July 4, 2017 14:02
PouchDB: Add or update record (sync / merge)
This file contains 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
| static addOrUpdate(id, document) { | |
| return new Promise(function (resolve, reject) { | |
| let doStore = function (originalDocument) { | |
| // Merge the document: First, set the ID. Then apply the existing doc on top if possible. Finally, apply the changed doc. | |
| let mergedDoc = { | |
| _id: id | |
| }; | |
| if (originalDocument) { | |
| for (let key in originalDocument) { |
roydejong
/ map_country_to_continent.php
Created
May 23, 2017 13:14
PHP: Array mapping country ISO codes to continent codes
This file contains 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
| $mapCountryToContinent = array( | |
| "AF" => "AS", | |
| "AX" => "EU", | |
| "AL" => "EU", | |
| "DZ" => "AF", | |
| "AS" => "OC", | |
| "AD" => "EU", | |
| "AO" => "AF", | |
| "AI" => "NA", | |
| "AQ" => "AN", |
NewerOlder