Fatima Alansari falansari

Buttery Smooth Tech: Automate Your Builds in GitHub Actions

Hello, Game Makers! This is Shi Chen from Butterscotch Shenanigans. I work on tools and pipelines to smoothly ship our games to all the platforms we publish on. And we publish on a lot of platforms! Our most cross-platform title, Levelhead, required 7 different builds to be made at least once per day. Without a way to automate those builds, our lives would have been very difficult.

Today, I want to share how we use GitHub Actions as build automation servers to make builds for our upcoming game, Crashlands 2. Build automation servers, or more fancily named, continuous integration and continuous deployment (abbreviated as “CI/CD”) servers, can liberate you from the tedious button-clicking and waiting when you build your project

Pre-requisite

Laragon
Multiple DB are ready to install (look table below)
Unzip tools like 7zip or Winrar
Laragon installation path default is C:\laragon\, might be different depending on where you install this. However we will focus on laragon mysql directory folder which located on C:\laragon\bin\mysql

If you look at Laragon documentation on multiple DB it should be straight forward however i would like to make it as painless as possible with the setup

By default Laragon (Full version) comes with MySQL 8.0.* version. However we will install latest or older version of MySQL show how we switch to one another using Laragon system tray mysql version switch feature.

[WINDOWS] How to enable auto-signing Git commits with GnuPG for programs that don't support it natively

This is a step-by-step guide on how to enable auto-signing Git commits with GPG for every applications that don't support it natively (eg. GitHub Desktop, Eclipse, Git Tower, ...)

Requirements

Install GPG4Win: this software is a bundle with latest version of GnuPG v2, Kleopatra v3 certificate manager, GNU Privacy Assistant (GPA) v0.9 which is a GUI that uses GTK+, GpgOL and GpgEX that are respectively an extension for MS Outlook and an extension for Windows Explorer shell
Install Git for Windows: so you can have a *nix based shell, this software is a bundle with latest version of Git which use MINGW environment, a Git bash shell, a Git GUI and an extension for Windows Explorer shell (Make sure your local version of Git is at least 2.0, otherwise Git don't have support for automatically sign your commits)
Verify

CCA2	Name	CCA3	Nationality
AD	Andorra	AND	Andorran
AE	United Arab Emirates	ARE	Emirati
AF	Afghanistan	AFG	Afghan
AG	Antigua and Barbuda	ATG	Antiguan, Barbudan
AI	Anguilla	AIA	Anguillian
AL	Albania	ALB	Albanian
AM	Armenia	ARM	Armenian
AN	Netherlands Antilles	ANT	Dutch
AO	Angola	AGO	Angolan

Every so often I have to restore my gpg keys and I'm never sure how best to do it. So, I've spent some time playing around with the various ways to export/import (backup/restore) keys.

Method 1

Backup the public and secret keyrings and trust database

cp ~/.gnupg/pubring.gpg /path/to/backups/
cp ~/.gnupg/secring.gpg /path/to/backups/
cp ~/.gnupg/trustdb.gpg /path/to/backups/

or, instead of backing up trustdb...

	# Generate a new pgp key: (better to use gpg2 instead of gpg in all below commands)
	gpg --gen-key
	# maybe you need some random work in your OS to generate a key. so run this command: `find ./* /home/username -type d \| xargs grep some_random_string > /dev/null`

	# check current keys:
	gpg --list-secret-keys --keyid-format LONG

	# See your gpg public key:
	gpg --armor --export YOUR_KEY_ID
	# YOUR_KEY_ID is the hash in front of `sec` in previous command. (for example sec 4096R/234FAA343232333 => key id is: 234FAA343232333)

	CREATE TABLE `countries` (
	`country_code` varchar(2) NOT NULL default '',
	`country_enName` varchar(100) NOT NULL default '',
	`country_arName` varchar(100) NOT NULL default '',
	`country_enNationality` varchar(100) NOT NULL default '',
	`country_arNationality` varchar(100) NOT NULL default '',
	PRIMARY KEY (`country_code`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	--
	-- Dumping data for table `countries`

	#!/bin/sh

	#######################################
	# Bash script to install an AMP stack and PHPMyAdmin plus tweaks. For Debian based systems.
	# Written by @AamnahAkram from http://aamnah.com

	# In case of any errors (e.g. MySQL) just re-run the script. Nothing will be re-installed except for the packages with errors.
	#######################################

	#COLORS