Skip to content

Instantly share code, notes, and snippets.

@donwilson
donwilson / php-serialized-column.php
Last active Feb 22, 2020
PHP Serialized Data previewer in Adminer Editor
View php-serialized-column.php
<?php
/** Display PHP serialized values as table in edit. Using Jakub Vrana and Martin Zeman's JSON Adminer plugin (https://raw.githubusercontent.com/vrana/adminer/master/plugins/json-column.php) as a skeleton for this plugin.
* @link https://www.adminer.org/plugins/#use
* @author Don Wilson, https://pyxol.com/
* @author Jakub Vrana, https://www.vrana.cz/
* @author Martin Zeman (Zemistr), http://www.zemistr.eu/
* @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
*/
class AdminerPHPSerializedColumn {
@donwilson
donwilson / .htaccess
Created Apr 12, 2019
.htaccess block .git directory, .gitignore, and composer files
View .htaccess
RedirectMatch 404 ^/\.git
RedirectMatch 404 ^/composer\.(json|lock|phar)$
@donwilson
donwilson / strip_zalgo.php
Created Feb 12, 2019
function to strip zalgo/"scary" text from regular strings
View strip_zalgo.php
<?php
// zalgo text/scary text stripper
// https://stackoverflow.com/a/32921891/103337
function strip_utf8_zalgo_text($string="") {
$string = preg_replace("~(?:[\p{M}]{1})([\p{M}])+?~uis", "", $string);
return $string;
}
@donwilson
donwilson / blurry-background.html
Created Aug 23, 2018
Image container with blurry background CSS effect
View blurry-background.html
<!doctype html>
<html>
<head>
<title>Blurred Background Image</title>
<style type="text/css">
body {
overflow: hidden;
}
.blur_background_container {
@donwilson
donwilson / grep_current.sh
Created Jul 10, 2018
Grep and ignore _old/ and *CST$ files
View grep_current.sh
#!/bin/bash
CWD=$(pwd)
ARROW="-"
echo ""
echo "===================================="
echo "== Finding: $1"
echo "== - in: $CWD/"
echo "== - skipping paths that match '_old/|CST$'"
@donwilson
donwilson / .bashrc
Created Mar 16, 2018
Add git repo and branch names to colorized bash prompt
View .bashrc
function parse_git_repo {
local repo_path=$(git rev-parse --show-toplevel 2>/dev/null)
[[ ! -z "$repo_path" ]] && basename $repo_path
}
function parse_git_branch {
git branch --no-color 2> /dev/null | sed -e '/^[^*]/d' -e 's/* \(.*\)/\1/'
}
@donwilson
donwilson / server_commands.txt
Last active Dec 8, 2020
Server Setup Helper
View server_commands.txt
#################################
# General Program Installations #
#################################
yum -y install htop screen bzip2 unzip parallel wget nano dos2unix nmap iotop
###########################
# Install Git from Source #
###########################
@donwilson
donwilson / .bashrc
Created Jun 2, 2017
Bash shell colorized
View .bashrc
# http://bashrcgenerator.com
export PS1="\[\033[38;5;7m\][\[$(tput sgr0)\]\[\033[38;5;229m\]\u\[$(tput sgr0)\]\[\033[38;5;249m\]@\[$(tput sgr0)\]\[\033[38;5;51m\]\h\[$(tput sgr0)\]\[\033[38;5;7m\]]\[$(tput sgr0)\]\[\033[38;5;15m\] \[$(tput bold)\]\[$(tput sgr0)\]\[\033[38;5;39m\]\w\[$(tput sgr0)\]\[$(tput sgr0)\]\[\033[38;5;15m\]\n\[$(tput sgr0)\]\[\033[38;5;245m\]\\$\[$(tput sgr0)\]\[\033[38;5;15m\] \[$(tput sgr0)\]"
@donwilson
donwilson / rclone-backup-script.sh
Created May 26, 2017
Back up WWW, MySQL DB and separate content folder to S3 using rclone
View rclone-backup-script.sh
#!/bin/bash
###
# Backup Script
###
# Toggle debug mode for CLI output - "YES" or "NO"
DEBUG="YES"
@donwilson
donwilson / split_text_to_sentences.php
Created May 10, 2017
Extract first X sentences from WordPress post content for post excerpt
View split_text_to_sentences.php
<?php
/**
* Extract out first X sentences from uncleaned raw text
* @param string $text Raw text
* @param int $num_sentences Optional. Number of sentences
* @return string
*/
function extract_sentences_from_text($raw_text, $num_sentences=3) {
$text = $raw_text;
$text = strip_tags($text);