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

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

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

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

joekolade

/**
	Breakpoints
 */
 
// define breakpoints
// ------------------------------
$breakpoints: (
	micro: 320px,
	xs: 502px,
	sm: 768px,

joekolade

// Transitions
//
//
$transition-default-duration: ###0.3s###;
$transition-default-timing: ease-out;
$transition-default-delay: 0s;

@mixin transit($prop: all){
  transition: $prop $transition-default-duration $transition-default-timing $transition-default-delay;
}

joekolade

find . \( -name '.DS_Store' -or -name '._*' \) -delete

joekolade

page = PAGE
# page.typeNum = 123
page.10 = FLUIDTEMPLATE
page.10 {

	templateName = TEXT
	templateName.stdWrap {
		cObject = TEXT
		cObject {
			data = levelfield:-2,backend_layout_next_level,slide

joekolade

'Neos.NodeTypes:Page':
  childNodes:
    'main':
      constraints:
        nodeTypes:
          'Neos.NodeTypes:Headline': TRUE
          'Neos.NodeTypes:Text': TRUE
          'Neos.NodeTypes:Image': TRUE
          'Neos.NodeTypes:Html': TRUE
          'Neos.NodeTypes:TwoColumn': TRUE

joekolade

# NodeTypes.yaml

'Neos.NodeTypes:Page':
  properties:
    backgroundimage:
      type: 'Neos\Media\Domain\Model\ImageInterface'
      ui:
        label: 'Hintergrund Bild'
        inspector:
          group: 'document'