DavidBruchmann

# Handle line endings automatically for files detected as text
# and leave all files detected as binary untouched.
* text=auto

# Force the following filetypes to have unix eols, so Windows does not break them
*.* text eol=lf

# Windows forced line-endings
/.idea/* text eol=crlf

DavidBruchmann

Repos with string or tag "TCA" related to TYPO3

• https://github.com/Nemo64/typo3api
  An api-wrapper around typo3 functionality (currently only tca)
• https://github.com/IchHabRecht/formengine_example
  This is an example, how to add an own TCA field type for TYPO3
• https://github.com/wouter90/tca_analyzer
  Analyzer for TCA changes done in ext_tables.php of installed extensions
• https://github.com/bitpatroon/typo3_tca2
  Allows additional function like conditions to if in pageTSConfig

DavidBruchmann

<?php
namespace HenrikZiegenhain\MyExt\DataProcessor;

/***************************************************************
 *  Copyright notice
 *
 *  (c) 2018 Henrik Ziegenhain <henrik@ziegenhain.me>
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project is

DavidBruchmann

$hex = '';
$result = '';
$encoded = substr($hex, 2);
while(strlen($encoded)) {
    $current = substr($encoded, 0, 2);
    $encoded = substr($encoded, 2);
    $result .= chr(hexDec($current));
}
echo $result;

DavidBruchmann

## THIS IS ONLY TO TRUNCATE A TABLE COMPLETELY

$tablename = 'xyz'

$driver = new \Doctrine\DBAL\Driver\Mysqli\Driver;
$queryBuilder = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(
    \TYPO3\CMS\Core\Database\Query\QueryBuilder::class,
    \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(
        \TYPO3\CMS\Core\Database\Connection::class, $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default'], $driver
    )

DavidBruchmann

"scripts":{
        "command": [
            "echo \"EVENT: command\\n\"",
            "VENDOR\\build\\command::myClassMethod"
        ],
        "pre-command-run": [
            "echo \"EVENT: pre-command-run\\n\"",
            "VENDOR\\build\\preCommandRun::myClassMethod"
        ],

DavidBruchmann

@echo off
cd /D %~dp0
echo Diese Eingabeforderung nicht waehrend des Running beenden
echo Bitte erst bei einem gewollten Shutdown schliessen
echo Please close this command only for Shutdown
echo Apache 2 is starting ...

SET OPENSSL_CONF=F:\___XAMPP___\xampp-portable-win32-5.6.31-0-VC11\apache\conf\openssl.cnf
REM IF EXIST F:\___XAMPP___\xampp-portable-win32-5.6.31-0-VC11\apache\bin
SET PATH=%PATH%;F:\___XAMPP___\xampp-portable-win32-5.6.31-0-VC11\apache\bin

DavidBruchmann

# Just copy all tables from plural to singular naming

create table tx_powermail_domain_model_form LIKE tx_powermail_domain_model_forms;
insert tx_powermail_domain_model_form select * from tx_powermail_domain_model_forms;

create table tx_powermail_domain_model_page LIKE tx_powermail_domain_model_pages;
insert tx_powermail_domain_model_page select * from tx_powermail_domain_model_pages;

create table tx_powermail_domain_model_field LIKE tx_powermail_domain_model_fields;
insert tx_powermail_domain_model_field select * from tx_powermail_domain_model_fields;

DavidBruchmann

/** @var ObjectManager $objm */
$dbParser = $this->objectManager->get(\TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbQueryParser::class);

$doctrineQueryBuilder = $dbParser->convertQueryToDoctrineQueryBuilder($query);
$sql = $doctrineQueryBuilder->getSQL();
$parameters = $doctrineQueryBuilder->getParameters();
\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump(['sql' => $sql, 'parameters' => $parameters], __METHOD__ . ':' . __LINE__);

DavidBruchmann

#
#  Main navigation in Sidebar
#

# General idea: Don't render & cache 'active' and 'current' states in 'expAll' menu, so it becomes cacheable
# over all pages. To regain 'active' and 'current' states, the result of the cached menu is parsed by
# 'stdWrap.replacement', utilizing specific information about the resulting menu item markup to insert them.

# Use COA to decouple the stdWrap ('lib.navSidebar.stdWrap.replacement') needed for RegExp replacement from
# the cached menu ('lib.navSidebar.10'). This way the complete menu can be generically cached without current