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 / macos-setup.sh
Last active January 11, 2024 22:18
macOS Setup
#!/bin/bash
ME="Fistname Lastname"
EML="email@website.com"
git config --global alias.co checkout
git config --global alias.br branch
git config --global alias.ci commit
git config --global alias.st status
git config --global user.name $ME
@vardumper
vardumper / config
Created May 11, 2023 08:49
~/.ssh/config Example connecting via IPv6
Host my-server
HostName 9x99:9x9:x99:x9x9::1 # placeholder, replace with your servers IPv6
IdentityFile ~/.ssh/id_rsa
IdentitiesOnly yes
ForwardX11 yes
Port 22 # verify port with sudo ss -tnlp | grep ssh
AddressFamily inet6
User root # placeholder, use real user eg: ubuntu
LogLevel DEBUG
@vardumper
vardumper / craftcms-atomic.stpl
Last active March 31, 2023 07:35
HestiaCP template for Craft CMS 4.*
#=========================================================================#
# Default Craft CMS Template for atomic deploys #
# make sure to set up current/shared/releases folders accordingly #
# DO NOT MODIFY THIS FILE! CHANGES WILL BE LOST WHEN REBUILDING DOMAINS #
# https://docs.hestiacp.com/admin_docs/web.html#how-do-web-templates-work #
#=========================================================================#
server {
listen %ip%:%web_ssl_port% ssl http2;
server_name %domain_idn% %alias_idn%;
@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:

@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 / 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 / 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 / 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 / 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 / .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 #
#--------------------------------------------------------------------------------------------------#