Digiover

<?php
function saotn_post_prerender_prefetch() {
	/* follow me on Twitter: @Jan_Reilink */
	$next_post = get_next_post();
	$prev_post = get_previous_post();
	if ( !empty( $next_post ) ) {
		echo '<link rel="prefetch" href="'.get_permalink( $next_post->ID ).'" />
			<link rel="prerender" href="'.get_permalink( $next_post->ID ).'" />';
	}
	if ( !empty( $prev_post ) ) {

Digiover

<?php
/*
 * enqueue adsbygoogle.js in the footer & 
 * create a WordPress shortcode with your Google AdSense code
 * follow me on Twitter: @Jan_Reilink
 */

function saotn_loadAdsByGoogleJs() {
  wp_register_script( 'google-adsense', '//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js', '', '', true );
  wp_enqueue_script( 'google-adsense' );

Digiover

# blacklistcheck.ps1 - PowerShell script to check
# an IP address blacklist status
# 
# Follow me on Twitter: @Jan_Reilink
# 
# Steps:
# 1. IPv4 IP address input from the command-line:
#    .\blacklistcheck.ps1 1.2.3.4
# 2. reverse the IP address: 1.2.3.4 becomes 4.3.2.1
# 3. append the blacklist zone, e.g .cbl.abuseat.org. 

Digiover

<?php
/**
 * PHP/cURL function to check a web site status. If HTTP status is not 200 or 302, or
 * the requests takes longer than 10 seconds, the website is unreachable.
 * 
 * Follow me on Twitter: @Jan_Reilink
 *
 * @param string $url URL that must be checked
 */
function url_test($url) {

Digiover

-- Clean WordPress Post Meta Data
SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;

-- Clean WordPress  Comment Meta Data
SELECT * FROM wp_commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM wp_comments );
DELETE FROM wp_commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM wp_comments );

SELECT * FROM wp_commentmeta WHERE meta_key LIKE '%akismet%';
DELETE FROM wp_commentmeta WHERE meta_key LIKE '%akismet%';

Digiover

# Ansible can use a custom ssh config file if you configure its 
# ANSIBLE_SSH_ARGS environment variable. Add to your `~/.bashrc`
# 
# source: Windows 11/10 and WSL 2 DevOps environment
# - Sysadmins of the North
# https://www.saotn.org/windows-11-10-and-wsl-2-devops-environment/
# 

export ANSIBLE_SSH_ARGS="-F ~/.ssh/wsl_config"

Digiover

/**
 * Executes an OPTIMIZE TABLE statement on all WordPress database 
 * tables.
 */
public static function saotn_wpdb_optimizer() {
  global $wpdb;
  $tables = $wpdb->get_col( "SHOW TABLES" );
  foreach ( $tables as $table ) {
    $wpdb->query( "OPTIMIZE TABLE $table" );
  }

Digiover

<?php
/**
 * Plugin Name: Clear PHP opcode caches
 * Plugin URI: https://www.saotn.org/wordpress-plugin-flush-php-opcache/
 * Donate URI: https://www.paypal.me/jreilink
 * Description: Purges various PHP opcode and user caches. Currently it tries to clear / purge / flush PHP OPcache and WinCache caches from your web server's memory. This should ease WordPress updates and plugin activation / deactivation.
 * Network: True
 * Version: 1.2
 * Author: Jan Reilink
 * Author URI: https://www.saotn.org

Digiover

# Import a PFX certificate into Windows Server and change its 
# FriendlyName property in PowerShell.
# 
# Using Get-Credential here ensures the password doesn't get saved
# into PowerShell's history file.
#   -- see https://www.saotn.org for more PowerShell goodness :)
# 

$CommonName = "CHANGEME"
$CertFileName = "CHANGEME.pfx"

Digiover

# Query Win32_PerfRawData_W3SVC_WebService for all metric labels (names), including all website names hosted in IIS
# 
# The Web Service object includes counters specific to the World Wide Web Publishing Service.
(Get-CimInstance -EA SilentlyContinue -Query "select * from Win32_PerfRawData_W3SVC_WebService" -Namespace root\cimv2).Name

# https://www.saotn.org/monitor-website-performance-in-iis-with-zabbix/