joekolade

let addSelfDestructingEventListener = (element, eventType, callback) => {
    let handler = (e) => {
        callback(e);
        element.removeEventListener(eventType, handler);
    };
    element.addEventListener(eventType, handler);
};

joekolade

/**
 * @param d date
 */

function isDST(d) {
    let jan = new Date(d.getFullYear(),0,1).getTimezoneOffset();
    let jul = new Date(d.getFullYear(),6,1).getTimezoneOffset();
    return Math.min(jan,jul) == d.getTimezoneOffset();  
}

joekolade

UPDATE tt_content
SET bodytext = replace(bodytext, "a", "b");

joekolade

SELECT c.uid as "CE uid", c.pid as "CE pid", uid_foreign, uid_local, count(*) as NumDuplicates

FROM sys_file_reference s
JOIN tt_content c ON (c.uid = s.uid_foreign)

WHERE s.tablenames = "tt_content"
    AND s.deleted = 0
    AND c.deleted = 0

GROUP BY uid_foreign, uid_local 

joekolade

var sticky = function(elementSelector, heightSelector){
		var h = document.querySelector(elementSelector);
		var stuck = false;
		var stickPoint = getDistance(heightSelector);


		function getDistance(heightSelector) {
			var topDist = h.offsetTop || document.querySelector(heightSelector).offsetHeight;
			return topDist;
		}

joekolade

###php_cli### ./typo3/cli_dispatch.phpsh lowlevel_refindex -e

###php_cli### ./typo3/cli_dispatch.phpsh lowlevel_cleaner orphan_records -r ###--dryrun|--AUTOFIX###
###php_cli### ./typo3/cli_dispatch.phpsh lowlevel_cleaner versions -r ###--dryrun|--AUTOFIX###

# Run multiple times
###php_cli### ./typo3/cli_dispatch.phpsh lowlevel_cleaner tx_templavoila_unusedce -r ###--dryrun|--AUTOFIX###
###php_cli### ./typo3/cli_dispatch.phpsh lowlevel_cleaner double_files -r ###--dryrun|--AUTOFIX###
###php_cli### ./typo3/cli_dispatch.phpsh lowlevel_cleaner deleted -r ###--dryrun|--AUTOFIX###

joekolade

# Mac Software Pflege

# update components
upgrade_oh_my_zsh
brew update
composer selfupdate
brew upgrade node
npm install -g npm
nvm install node —latest-npm
nvm install 10 —latest-npm

joekolade

# Pagetree http://wiki.typo3.org/Pagetree
options.pageTree.backgroundColor.1 = rgba(0, 0, 0, 0.1)
#options.pageTree.showPathAboveMounts = 1
options.pageTree.showPageIdWithTitle = 0
options.pageTree.showDomainNameWithTitle = 1
options.pageTree.showNavTitle = 1
#options.pageTree.hideFilter = 1
#options.contextMenu.table.pages.disableItems = info,history,mountAsTreeroot,expandBranch,collapseBranch

# cache control

joekolade

/**
 * Basic Curl-Call
 * @see  http://codular.com/curl-with-php
 */

$url = '###URL###';
$token = '122321231';

// Get cURL resource
$curl = curl_init();

joekolade

// @see https://www.macrone.de/das-html-select-element-pure-css-styling/

$base-padding: 8px;

select {
	-moz-appearance: none;
	-webkit-appearance: none;
	appearance: none;

	&::-ms-expand {