Skip to content

Instantly share code, notes, and snippets.

View agarzon's full-sized avatar
🕶️
Hunting bugs....

AG agarzon

🕶️
Hunting bugs....
  • Zend Certified Engineer
  • Canada, Montreal
View GitHub Profile
@agarzon
agarzon / sdk-downloader.ps1
Created July 12, 2023 01:21
Download all the MSFS SDK msi installers automatically (flight simulator)
$version = Read-Host "Enter the version (default: 0.21.1):"
if ([string]::IsNullOrWhiteSpace($version)) {
$version = "0.21.1"
}
$baseUrl = "https://sdk.flightsimulator.com/files/installers/$version/"
$urls = @(
"MSFS_SDK_Documentation_Installer_$version.0.msi",
"MSFS_SDK_Core_Installer_$version.0.msi",
@agarzon
agarzon / clearCache.sh
Created March 30, 2023 13:19
gitlab-runner clear cache script
#!/bin/bash
#Variables
gitlabUrl="https://gitlab.yourdomain.com"
configFile="/etc/gitlab-runner/config.toml"
gitlabTolken="" # Get it from https://gitlabUrl/profile/account API read access token
# Get GitLab Runner tokens from config.toml
mapfile -t runner_tokens < <(sudo grep -oP 'token = "\K[^"]+' ${configFile})
@agarzon
agarzon / winds.lua
Created May 2, 2019 12:26
lua script x-plane visual helper
require("graphics")
local window_x = 40 -- Display position from right edge of window
local window_y = 40 -- Display position from top edge of window
local show_wind = false
DataRef("WIND_DIR", "sim/cockpit2/gauges/indicators/wind_heading_deg_mag", "readonly")
DataRef("WIND_SPEED", "sim/cockpit2/gauges/indicators/wind_speed_kts", "readonly")
DataRef("HEADING", "sim/flightmodel/position/psi", "readonly")
@agarzon
agarzon / texture-selector.go
Created November 12, 2018 18:53
Zibo texture selector for x-plane
// This command line program helps to install 4k or 2k textures in the Zibo's B738
// Author: Alexander Garzon
// Multi-platform. It should work with WIN, OS and Linux. Just be sure the file has execution permisstions.
// Tested with Zibo 3.31
package main
import (
"fmt"
"io"
@agarzon
agarzon / whmcs-export.sql
Created November 2, 2018 21:40
WHMCS export hosting services
SELECT tblhosting.domain, tblservers.name, tblhosting.domainstatus, tblproducts.name , CONCAT(tblclients.firstname, ' ', tblclients.lastname) AS Client, tblclients.status AS Clientstatus
FROM tblhosting
LEFT JOIN tblproducts ON tblhosting.packageid = tblproducts.id
LEFT JOIN tblservers ON tblhosting.server = tblservers.id
LEFT JOIN tblclients ON tblhosting.userid = tblclients.id
WHERE tblhosting.domainstatus IN ('Active', 'Suspended')
ORDER BY tblservers.id ASC
INTO OUTFILE '/tmp/whmcs.csv';
@agarzon
agarzon / shred.sh
Created October 4, 2017 15:38
Securely erasing all files in folders recursively
#!/bin/bash
#If you want more "passes" change vzun0 for vzun1 or any other number (process will be slower!)
find /mnt/backup -type f -print0 | xargs -0 shred -vzun0
@agarzon
agarzon / docker-compose.yml
Last active August 5, 2021 20:10
My docker-compose.yml for development
gitlab:
image: 'gitlab/gitlab-ce:latest'
container_name: gitlab
restart: always
hostname: 'gitlab.mcu.dc'
environment:
GITLAB_OMNIBUS_CONFIG: |
external_url 'http://gitlab.mcu.dc:8090'
gitlab_rails['gitlab_shell_ssh_port'] = 2290
gitlab_rails['smtp_enable'] = true
@agarzon
agarzon / senderscore.sh
Created February 10, 2017 16:54
Check Sender Score from IP using command line. bash script
#!/usr/bin/env bash │ject-with tcp-reset
# usage: ./senderscore.sh 74.91.28.11
if [ -z "$1" ]
then
echo "IP is missing as arguemnt."
exit
fi
IP=$1
@agarzon
agarzon / phplint.sh
Last active October 4, 2017 21:21
Recursive PHP linting
find . -name "*.php" -print0 | xargs -0 -n1 -P $(nproc) php -l | grep -v '^No'
@agarzon
agarzon / install-php-tools.sh
Last active October 27, 2021 03:48
Install globally popular PHP dev tools like composer, phpunit, phpcs, phpmd, phpcpd, deployer, robo, codeception, etc.
#!/bin/bash
#To execute it directly: sudo bash <(curl -s https://gist.githubusercontent.com/agarzon/ecb0b92d4c8e1bbde126534c76721a58/raw/install-php-tools.sh)
BIN_PATH=/usr/local/bin/
#COMPOSER
sudo curl -LsS https://getcomposer.org/composer.phar -o ${BIN_PATH}composer
sudo chmod a+x ${BIN_PATH}composer