Ingo Fabbri infabo

My Elasticsearch cheatsheet with example usage via rest api (still a work-in-progress)

Shortlinks:

ssh (generate key and put on server)
rsync must be available on both machines (deployment host and target host)
PHP cli binary must be available on both machines (deployment host and target host)
composer must be available on deployment host

This patch is not to be confused with the SUPEE-7405 that was released on January 20th, 2016. This is a fix for that patch.

"Yo dawg, we heard you like patching so here's a patch for your patch so you can patch while you're patching." - Xzibit, MCD+

	# Delete all duplicate sys_file_records, where one and the same sys_file UID
	# is related to the same tt_content record
	DELETE t_orig
	FROM sys_file_reference t_orig
	INNER JOIN sys_file_reference t_copy
	WHERE t_orig.tablenames='tt_content'
	AND t_orig.fieldname='image'
	AND t_orig.deleted=0
	AND t_copy.tablenames='tt_content'
	AND t_copy.fieldname='image'

	<?php
	declare(strict_types=1);

	namespace Vendor\Extension\Routing\Aspect;

	use TYPO3\CMS\Core\Routing\Aspect\StaticRangeMapper;

	/**
	* Class StaticPaddedRangeMapper
	* @package Vendor\Extension\Routing\Aspect

	page {
	headerData.50 = TEXT
	headerData.50 {

	if.isTrue.data = site:googleTagManager
	stdWrap.replacement {
	10 {
	search = ###CODE###
	replace.data = site:googleTagManager
	}

	<?php
	use TYPO3\CMS\Core\Database\ConnectionPool;
	use TYPO3\CMS\Core\Utility\GeneralUtility;

	// insert into tt_content (header, crdate, pid) VALUES ("New content", 123456789, 123);
	$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
	$queryBuilder
	->insert('tt_content')
	->values([
	'header' => 'New content',

	find -L app/design/frontend -regex '.*\(shipping\\|billing\\|shipping_method\\|payment\).phtml' -exec grep -L formkey {} \; \
	\| xargs sed -i 's/<\/form>/<?php echo $this->getBlockHtml("formkey") ?><\/form>/g'

	find -L skin/frontend -name 'opcheckout.js' -exec grep -L form_key {} \; \
	\| xargs sed -i 's/if (elements\[i\].name=='\''payment\[method\]'\'') {/if (elements[i].name=='\''payment[method]'\'' \|\| elements[i].name == '\''form_key'\'') {/g'

	<?php

	$realurlConfig = array(
	'init' => array(
	// [...]
	'postVarSet_failureMode'=> false,
	)
	// [...]
	);