Skip to content

Instantly share code, notes, and snippets.

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

Erik Pöhler vardumper

🏠
Working from home
View GitHub Profile
@vardumper
vardumper / wordpress-and-woocommerce-development-boilerplate.sh
Last active September 21, 2019 19:59
Working with vardumper/wordpress-and-woocommerce-development-boilerplate
# either fork the repo and clone your fork, or clone this repo directly
git clone git@github.com:vardumper/wordpress-and-woocommerce-development-boilerplate.git my-project-folder
# installs all dependencies, themes and plugins
cd my-project-folder
composer install
# copies the distribution default .env file
cp .env-distribution .env
@vardumper
vardumper / wp-config.php
Created September 22, 2019 11:51
Block external communication via wp_remote_post() and wp_remote_get()
define('WP_HTTP_BLOCK_EXTERNAL', true);
define('WP_ACCESSIBLE_HOSTS', 'api.wordpress.org,*.api.mailchimp.com,api.pay1.de,*.google.com');
@vardumper
vardumper / composer.json
Created September 22, 2019 12:09
Example composer file for Wordpress & WooCommerce
{
"name" : "githubuser/projectname",
"description" : "Project Name",
"type" : "project",
"license" : "GPL",
"authors" : [{
"name" : "Your Name"
}
],
"repositories" : [{
@vardumper
vardumper / .env
Created September 22, 2019 12:18
Example Wordpress .env File
#--------------------------------------------------------------------------------------------------#
# ENVIRONMENT SETTING #
# It can be anything, but "development", "staging" and "production" are supported out of the box. #
# Do not use "development" on production and viceversa, because it has effect on debug settings. #
#--------------------------------------------------------------------------------------------------#
WORDPRESS_ENV=development
#--------------------------------------------------------------------------------------------------#
# MANDATORY DATABASE SETTINGS #
#--------------------------------------------------------------------------------------------------#
@vardumper
vardumper / gist:53c06689f95b720e011440069cdef0ec
Last active January 21, 2022 13:24
Optimise and rebuild Wordpress Meta Table Indexes
CREATE TABLE wp_postmeta_new (
meta_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT UNSIGNED NOT NULL,
meta_key VARCHAR(255) NOT NULL,
meta_value LONGTEXT NOT NULL,
PRIMARY KEY(post_id, meta_key, meta_id), -- to allow dup meta_key for a post
INDEX(meta_id), -- to keep AUTO_INCREMENT happy
INDEX(meta_key)
) ENGINE=InnoDB;
INSERT INTO wp_postmeta_new SELECT * FROM wp_postmeta;
@vardumper
vardumper / customer.sql
Created December 28, 2021 10:01
Customer Import/Export profile for Shopware 6
INSERT INTO `import_export_profile` (
`id`,
`name`,
`system_default`,
`source_entity`,
`file_type`,
`delimiter`,
`enclosure`,
`mapping`,
`created_at`,
@vardumper
vardumper / products.sql
Created December 28, 2021 10:03
Product Import/Export profile for Shopware 6
INSERT INTO `import_export_profile` (
`id`,
`name`,
`system_default`,
`source_entity`,
`file_type`,
`delimiter`,
`enclosure`,
`mapping`,
`created_at`,
@vardumper
vardumper / image-convert.php
Last active February 11, 2023 22:12
Convert Wordpress User Uploads to WebP and update DB references
<?php
declare(strict_types = 1);
use WebPConvert\WebPConvert;
set_time_limit(0);
chdir(dirname(__DIR__)); // one level up to project root
// check requirements
if (! is_file('vendor/autoload.php')) {
echo "File vendor/autoload.php not found. Is the path correct?";
exit();
}
@vardumper
vardumper / build-administration.sh
Created August 20, 2022 09:40
Shopware 6 build-administration.sh with pnpm
#!/usr/bin/env bash
CWD="$(cd -P -- "$(dirname -- "${BASH_SOURCE[0]}")" && pwd -P)"
set -euo pipefail
export PROJECT_ROOT="${PROJECT_ROOT:-"$(dirname "$CWD")"}"
ADMIN_ROOT="${ADMIN_ROOT:-"${PROJECT_ROOT}/vendor/shopware/administration"}"
@vardumper
vardumper / keybase.md
Created January 6, 2023 12:41
Keybase.md

Keybase proof

I hereby claim:

  • I am vardumper on github.
  • I am iroybot (https://keybase.io/iroybot) on keybase.
  • I have a public key ASD1zw5B2rtYT3lkbEQejOPr9FxPzYAcoUKEQ80jp14hAgo

To claim this, I am signing this object: