Krzysztof Radzikowski damadorPL

WordPress database clean up queries

Orphan rows
Other
- wp_postmeta dupes

WP All Import Optimizations

If you have a slow import, or if you're running into a lot of server timeouts, then you can follow these steps to optimize your import.

Slow Import Guide

Follow all of the steps listed here: http://www.wpallimport.com/documentation/troubleshooting/slow-imports/.

Skip posts if their data has not changed

Proxmox - Email Alerts Setup (gmail)

SSH into proxmox node and become root user. Run the following commands to download extra software dependencies we'll need.
```
apt update
apt install -y libsasl2-modules
```
Enable 2FA for the gmail account that will be used by going to security settings

Better PowerShell

Theme | History | KeyBinding

in order to make windows powershell more comfortable and add a some theme and features like history binding, auto complete on keypress and so on, if you have used linux teminl wiht zsh for example, we are going to make powershell like that as much as we can.


	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>My FB Reactions Page</title>
	<style>
	html {
	box-sizing: border-box;
	width: 100%;

	<?php

	/**
	* [list_searcheable_acf list all the custom fields we want to include in our search query]
	* @return [array] [list of custom fields]
	*/
	function list_searcheable_acf(){
	$list_searcheable_acf = array("title", "sub_title", "excerpt_short", "excerpt_long", "xyz", "myACF");
	return $list_searcheable_acf;
	}

-<?php
-/**
- * Plugin Name: WooCommerce Remove Billing Fields for Free Virtual Products
- * Plugin URI: https://gist.github.com/BFTrick/7873168
- * Description: Remove the billing address fields for free virtual orders
- * Author: Patrick Rauland
- * Author URI: http://patrickrauland.com/
- * Version: 2.0
- *
- * This program is free software: you can redistribute it and/or modify

	// Place this in wp-config
	define( 'ACF_5_KEY', 'yourkeyhere' );

	// Set ACF 5 license key on theme activation. Stick in your functions.php or equivalent.
	function auto_set_license_keys() {

	if ( ! get_option( 'acf_pro_license' ) && defined( 'ACF_5_KEY' ) ) {

	$save = array(
	'key' => ACF_5_KEY,

	#
	# This is a key generator for the VS Code/Codium extension Monokai Pro
	# https://marketplace.visualstudio.com/items?itemName=monokai.theme-monokai-pro-vscode
	#
	# If you like the extension, you should buy it.
	#
	# 1. Run this script. It will ask for your email (it doesn't have to be real)
	# 2. Run `> Monokai Pro: enter license` from the command palette (ctrl+shift+p)
	# 3. Enter the same email as in step 1, followed by the generated key.
	# 4. DONE! :)

	<#
	.SYNOPSIS
	Optimizes your PSReadline history save file.
	.DESCRIPTION
	Optimizes your PSReadline history save file by removing duplicate
	entries and optionally removing commands that are not longer than
	a minimum length
	.EXAMPLE
	C:\PS> Optimize-PSReadlineHistory
	Removes all the duplicate commands.