Seb Kay SebKay

## find-duplicate-wp-post-meta.php
<?php
global $wpdb;

$duplicates = $wpdb->get_results("SELECT PM1.meta_id, PM1.post_id, PM1.meta_key, PM1.meta_value, PM2.meta_id, PM2.post_id, PM2.meta_key, PM2.meta_value
FROM {$wpdb->postmeta} PM1, {$wpdb->postmeta} PM2
WHERE
    PM1.meta_id > PM2.meta_id
    AND PM1.post_id = PM2.post_id
    AND PM1.meta_value = PM2.meta_value
    AND PM1.meta_key = PM2.meta_key

## find-duplicate-wp-post-meta.sql
SELECT PM1.meta_id, PM1.post_id, PM1.meta_key,  PM1.meta_value, PM2.meta_id, PM2.post_id, PM2.meta_key, PM2.meta_value
FROM wp_postmeta PM1, wp_postmeta PM2
WHERE
    PM1.meta_id > PM2.meta_id
    AND PM1.post_id = PM2.post_id
    AND PM1.meta_value = PM2.meta_value
    AND PM1.meta_key = PM2.meta_key
--  AND PM1.meta_key = '_wp_attachment_image_alt'
ORDER BY PM1.post_id ASC LIMIT 1000 OFFSET 0

## hirepage.php
<?php
/*
Plugin Name: Hierarchical Pages
Version: 1.6.1
Plugin URI: http://www.wlindley.com/website/hierpage/
Description: Adds sidebar widgets to display a context-based list of "nearby" pages, and to display nested categories.
Author: William Lindley
Author URI: http://www.wlindley.com/
Text Domain: hierarchical-pages
License: GPL2

## composer.json
"scripts": {
    "build:dev": [
        "composer install",
        "@artisan:build",
        "@assets:build"
    ],
    "build:prod": [
        "composer install --no-interaction --prefer-dist --optimize-autoloader",
        "@artisan:build",
        "@assets:build"

## polylang-posts-without-language.php
<?php

new \WP_Query([
    'post_type'      => ['post', 'page'],
    'posts_per_page' => -1,
    'lang'           => '',
    'fields'         => 'ids',
    'tax_query' => [
        [
            'taxonomy'  => 'language',

## see-certbot-lets-encrypt-certificates.sh
certbot certificates

## install-xdebug-mac.sh
# Install PHP via Homebrew
brew install php@7.4

# Install Xdebug via Pecl
pecl install xdebug

# Enable Xdebug in php.ini
nano /usr/local/etc/php/7.4/php.ini

# Add this to php.ini

## install-storybook-webpack-5-vue-3.sh
 npx sb@next init
 npx sb init --builder webpack5 -f

## phpmd-save-to-html.sh
./vendor/bin/phpmd ./ html cleancode,codesize,controversial,design,naming,unusedcode --exclude vendor/ --reportfile report.html

## enter-docker-container-filesystem.sh
docker exec -it [ID] bash
	<?php
	global $wpdb;

	$duplicates = $wpdb->get_results("SELECT PM1.meta_id, PM1.post_id, PM1.meta_key, PM1.meta_value, PM2.meta_id, PM2.post_id, PM2.meta_key, PM2.meta_value
	FROM {$wpdb->postmeta} PM1, {$wpdb->postmeta} PM2
	WHERE
	PM1.meta_id > PM2.meta_id
	AND PM1.post_id = PM2.post_id
	AND PM1.meta_value = PM2.meta_value
	AND PM1.meta_key = PM2.meta_key
	SELECT PM1.meta_id, PM1.post_id, PM1.meta_key, PM1.meta_value, PM2.meta_id, PM2.post_id, PM2.meta_key, PM2.meta_value
	FROM wp_postmeta PM1, wp_postmeta PM2
	WHERE
	PM1.meta_id > PM2.meta_id
	AND PM1.post_id = PM2.post_id
	AND PM1.meta_value = PM2.meta_value
	AND PM1.meta_key = PM2.meta_key
	-- AND PM1.meta_key = '_wp_attachment_image_alt'
	ORDER BY PM1.post_id ASC LIMIT 1000 OFFSET 0
	<?php
	/*
	Plugin Name: Hierarchical Pages
	Version: 1.6.1
	Plugin URI: http://www.wlindley.com/website/hierpage/
	Description: Adds sidebar widgets to display a context-based list of "nearby" pages, and to display nested categories.
	Author: William Lindley
	Author URI: http://www.wlindley.com/
	Text Domain: hierarchical-pages
	License: GPL2
	"scripts": {
	"build:dev": [
	"composer install",
	"@artisan:build",
	"@assets:build"
	],
	"build:prod": [
	"composer install --no-interaction --prefer-dist --optimize-autoloader",
	"@artisan:build",
	"@assets:build"
	<?php

	new \WP_Query([
	'post_type' => ['post', 'page'],
	'posts_per_page' => -1,
	'lang' => '',
	'fields' => 'ids',
	'tax_query' => [
	[
	'taxonomy' => 'language',
	# Install PHP via Homebrew
	brew install php@7.4

	# Install Xdebug via Pecl
	pecl install xdebug

	# Enable Xdebug in php.ini
	nano /usr/local/etc/php/7.4/php.ini

	# Add this to php.ini