Skip to content

Instantly share code, notes, and snippets.

View peterkraume's full-sized avatar

Peter Kraume peterkraume

View GitHub Profile
@peterkraume
peterkraume / powermail.sql
Last active April 14, 2022 14:10
Get the recipient addresses of all powermail forms in a TYPO3 installation
SELECT uid, pid, ExtractValue(pi_flexform, '/T3FlexForms/data/sheet[@index="receiver"]/language/field[@index="settings.flexform.receiver.email"]/value') as value
FROM tt_content WHERE list_type LIKE "%powermail%" AND hidden = 0 AND deleted = 0;
@peterkraume
peterkraume / import-production-data
Created January 9, 2020 11:00
DDEV custom command for .ddev/commands/host
#!/bin/bash
## Description: Fetch and import production data
## Usage: import-production-data
## Example: "ddev import-production-data"
SSH_CREDENTIALS="user@domain.tld"
PRODUCTION_DB_USER="user"
PRODUCTION_DB_PASSWORD="pw"
@peterkraume
peterkraume / imapsync.md
Created March 5, 2018 07:20
Migrate typo3.org emails with homebrew and imapsync
  1. Install Homebrew (if you haven't yet): https://brew.sh/
  2. Install imapsync: brew install imapsync
  3. Sync your mails:
imapsync \
--host1 mail.nine.ch --ssl1 --user1 YOUR.NAME@typo3.org --password1 XXXXX \
--host2 mail.typo3.org --ssl1 --user2 YOUR.NAME@typo3.org --password2 YYYYY
@peterkraume
peterkraume / readme.md
Created March 2, 2018 09:41
how to create a TYPO3 installation to review patches with ddev

how to create a TYPO3 installation to review patches with ddev

This is just a first draft on how to get started. Feedback is welcome!

Prequisites

Install PHP

  • todo
@peterkraume
peterkraume / composer.json
Created December 12, 2017 22:38 — forked from helhum/composer.json
The (currently) ideal TYPO3 composer setup
{
"require": {
"typo3-console/composer-auto-setup": "^0.1",
"georgringer/news": "^6.1",
"helhum/typo3-secure-web": "^0.2.5",
"typo3/cms-introduction": "^3.0"
},
"extra": {
"typo3/cms": {
"cms-package-dir": "{$vendor-dir}/typo3/cms",
@peterkraume
peterkraume / Default.yaml
Created October 26, 2017 06:14
Simple CKEditor Plugin for TYPO3 to insert an icon
# Load default processing options
imports:
- { resource: "EXT:rte_ckeditor/Configuration/RTE/Processing.yaml" }
- { resource: "EXT:rte_ckeditor/Configuration/RTE/Editor/Base.yaml" }
- { resource: "EXT:rte_ckeditor/Configuration/RTE/Editor/Plugins.yaml" }
# Add configuration for the editor
# For complete documentation see http://docs.ckeditor.com/#!/api/CKEDITOR.config
editor:
externalPlugins:
@peterkraume
peterkraume / Page.ts
Created July 20, 2017 09:51
Backport for TYPO3 8.7: PageLayoutView - Allow to disable copy- / translate- buttons
mod {
web_layout {
// disable translation mode for content elements
// backported feature from TYPO3 9.x. See Xclass PageLayoutView.php for details
localization.enableTranslate = 0
}
}
@peterkraume
peterkraume / php.md
Last active January 23, 2024 14:06
CLI PHP Version bei domainfactory ändern

Homeverzeichnis des Kunden:

ln -s /usr/local/bin/php7-70LATEST-CLI ~/php

In den neuen ManagedHosting 64 Bit Umgebungen (ManagedHosting 64, ManagedServer 64 oder Reseller Dedicated 64) ist der Pfad anders, z.B. so:

ln -s /usr/bin/php74 ~/php

Eintrag in .bashrc/.zshrc

@peterkraume
peterkraume / mass-dig.sh
Created June 19, 2015 09:01
List all domains with missing A records
#!/bin/sh
# this script lists only those domain names with missing A records
domainnames="www.google.de
foobar.google.de
www.heise.de"
for domain in $domainnames
do