Skip to content

Instantly share code, notes, and snippets.

View EthraZa's full-sized avatar
🏠
Working from home

Allan Brazute EthraZa

🏠
Working from home
View GitHub Profile
@EthraZa
EthraZa / Adminer_FS_SQL.js
Created October 18, 2022 14:35
Adminer SQL Edit Fullscreen Bookmarklet - https://bookmarkify.it/53844
/**
:: Adminer.org SQL Edit Fullscreen Bookmarklet ::
Add to your bookmarks using: https://bookmarkify.it/53844
How to: Click the bookmark when editing a SQL command in Adminer. Press ESC to exit fullscreen.
*/
var s = document.getElementsByClassName('sqlarea')[0];
if (s) {
s.style.backgroundColor = window.getComputedStyle(document.body, null).getPropertyValue('background-color');
s.requestFullscreen();
}
@EthraZa
EthraZa / DO_upd_domain.sh
Last active July 20, 2021 16:52
Digital Ocean - Update DNS records with Droplets internal private IPs and hostname
#!/bin/bash
#
# Digital Ocean - Update DNS records with Droplets internal private IPs and hostname
# DO_upd_domain.sh:
#
# 2021-07-20 - v1.1 - By EthraZa <Allan Brazute>
# Add: Update only powers and --flush switch to recreate the domain
#
# 2021-07-15 - v1.0 - By EthraZa <Allan Brazute>
#
@EthraZa
EthraZa / RefreshFormula.gs
Last active March 16, 2021 20:01
Google Sheets script: function refreshFormula(aToResfresh); For each cell in the array, force refresh the containing formula.
/**
* Google Sheets script: function refreshFormula(aToResfresh)
* For each cell in the array, force refresh the containing formula.
*
* @param {Array} aToResfresh The array of cells with formula to force refresh.
* @return {Void}
*/
function refreshFormula(aToResfresh = []) {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(),
sheet = spreadsheet.getActiveSheet(),
@EthraZa
EthraZa / CountCellsByBgColor.gs
Last active March 15, 2021 14:22
Google Sheets: For each cell in a range, with a given background color, count or sum it.
/**
* Google Sheets script: countCellsByBgColor(inputRange, colorReference, operation = 'count')
* For each cell in a range, with a given background color, count or sum it.
*
* @param {String} inputRange The range of cells to check for the background color.
* @param {String} colorReference The cell with the background color to count.
* @param {String} operation [count|sum] The operation to perform over selected range.
* @param {Int} eachRow The number of rows to jump to at each interaction loop.
* @param {Int} eachColumn The number of columns to jump to at each interaction loop.
* @return {Number} The number of cells with a matching background.
@EthraZa
EthraZa / post-receive.sh
Created July 26, 2020 00:38
One Git hooks script to rule them all
#!/bin/sh
# Config
APPDIR="/tmp"
# Setup
HOOKS=$(basename "$0")
HOOKSDIR=$(dirname $(dirname "$0"))
HOOKSLOG="${HOOKSDIR}/${HOOKS}.log"
@EthraZa
EthraZa / sshd.sh
Created July 8, 2019 16:51
Termux simple init script - Goes in $PREFIX/etc/profile.d/
ENABLED=1
PROC="sshd"
CMD=$PROC
if [ $ENABLED = 1 ] ; then
if pgrep -f $PROC >/dev/null ; then
echo "[$PROC is running]"
else
echo "[Starting $PROC...]" && $CMD && echo "[OK]"
fi
@EthraZa
EthraZa / spiderstruct.php
Last active June 6, 2019 12:00
Spider Struct :: Mirror files from some remote place, based on a source directory structure, to a distination directory
<?php
/**
* Spider Struct - by Allan.Brazute
* Mirror files from some remote place, based on a source directory structure, to a distination directory
*
* Usage: spiderstruct.php /local_src_structure_path/ /output_path/ http://base_url/
*/
$localSrc = (isset($argv[1]) && $argv[1])? $argv[1] : '';
$localDst = (isset($argv[2]) && $argv[2])? $argv[2] : '';
@EthraZa
EthraZa / BorgBackup.sh
Last active December 13, 2019 08:26
A Borg Backup script for a centralized storage server to backup other servers
#!/bin/bash
##
# BORG Backup
#
# [1.0] 2014-10-30 :: Allan Brazute
# - Assimilation
#
# All hosts need to have ssh and borg
# Backup Repository host may also need a compress tool like pigz
@EthraZa
EthraZa / backmark.sh
Created October 27, 2017 20:28
Backmark.sh Will create a pool of binary and text files with random content, duplicate then in two directories and backup it twice with multiple tools to compare their time and size.
#!/bin/bash
##
# Backmark.sh
#
# Will create a pool of binary and text files with random content,
# duplicate then in two directories and backup it twice
# with multiple tools to compare their time and size.
#
# Simple like that.
@EthraZa
EthraZa / lets-issue-cert.sh
Last active October 6, 2017 19:58
Issue a LetsEncrypt SSL certificate using acme.sh
#!/bin/bash
# Issue a LetsEncrypt SSL certificate using acme.sh
#
# ISPConfig 3 preparation:
# Enable the SSL option and Add a self-signed certificate on SSL tab within Sites/Domains to create the needed configurations.
#
if [ -z "$*" ]; then
printf "\n issue-cert.sh domain.com \n\n"