Table of Contents

Programmieren

HTML

CSS

PHP

mysql

drop all tables

SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')
FROM information_schema.tables
WHERE table_schema = 'MyDatabaseName';

source: https://stackoverflow.com/a/8248281

git

grunt

Typo3

Tags aus Seitentitel löschen

page {
# STANDARD SEITENTITEL ABSCHALTEN
    config.noPageTitle = 1
# SEITENTITEL EINFÜGEN
    headerData.6 = TEXT
    headerData.6.field = title // subtitle
    headerData.6.stdWrap {
        outerWrap = <title>|</title>
        HTMLparser.removeTags = sup
    }
}

Textschnippsel Systemweit suche und Ersetzen

page.stdWrap.parseFunc.short {
  EXAMPLE = Beispiel
}

Quelle: http://www.jochenfroehlich.com/typo3-best-practice/texte-automatisch-ersetzen.html

tt_content.uploads.20.renderObj.10.file.ext = png

Quelle: http://forge.typo3.org/issues/44571

Defaultsprache beim anlegen eines BEUsers ändern

$GLOBALS['TCA']['be_users']['columns']['lang']['config']['default'] = 'de'; in extTables.php

Eigene Extensions im Wizard auftauchen lassen

Next part (basing on this site) is adding your plugin to the New Content Element Wizard as noticed in TYPO3 Wiki since TYPO3 ver. 6.0.0 changed a little, so easiest way is adding something like this into your ext_tables.php:

\TYPO3\CMS\Core\Utility\ExtensionManagementUtility::addPageTSConfig('<INCLUDE_TYPOSCRIPT: source="FILE:EXT:hello/Configuration/TypoScript/pageTsConfig.ts">');

and in /typo3conf/ext/hello/Configuration/TypoScript/pageTsConfig.ts file write add this:

mod.wizards.newContentElement.wizardItems.plugins.elements.tx_hello_news {
    icon = gfx/c_wiz/regular_text.gif
    title = Scared Hello News
    description = Displays Scared News
    tt_content_defValues.CType = hello_news
}

# Below the same for TemplaVoila
templavoila.wizards.newContentElement.wizardItems.plugins.elements.tx_hello_news {
    icon = gfx/c_wiz/regular_text.gif
    title = Scared Hello News
    description = Displays Scared News
    tt_content_defValues.CType = hello_news
}

Source: http://stackoverflow.com/questions/18464356/how-to-quickly-create-custom-content-elements-in-typo3-6-x

Content Columns für Usergruppen ausblenden

Page TsConfig:

TCEFORM.tt_content {
    spaceBefore.disabled = 1
}

User TsConfig:

page.TCEFORM.tt_content {
    spaceBefore.disabled = 1
}

source: http://blog.marit.ag/2007/07/18/wie-blende-ich-bereiche-des-backends-fur-bestimmte-user-aus/

Content Elemente kopieren und anpassen

!UNDER CONSTRUCTION!

t3lib_div::loadTCA('tt_content');
$TCA['tt_content']['columns']['CType']['config']['items'][] = array('Contentslider', 'bxslider','i/tt_content_image.gif');
$TCA['tt_content']['types']['bxslider'] = array(
	//'showitem' => '--palette--;LLL:EXT:cms/locallang_ttc.xml:palette.general;general, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.header;header, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.images, image, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.imagelinks;imagelinks, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.appearance, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.frames;frames, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.image_settings;image_settings, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.access, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.visibility;visibility, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.access;access, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.extended'
	'showitem' => '--palette--;LLL:EXT:cms/locallang_ttc.xml:palette.general;general, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.images, image, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.imagelinks;imagelinks, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.appearance,  --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.image_settings;image_settings, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.access, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.visibility;visibility, --palette--;LLL:EXT:cms/locallang_ttc.xml:palette.access;access, --div--;LLL:EXT:cms/locallang_ttc.xml:tabs.extended'
);
// Achtung Bug!
// Damit CCEs Bilder rendern können, muss die id in der Datei  typo3/sysext/core/Classes/Resource/Service/FrontendContentAdapterService.php eingetragen werden!
// Siehe: http://forge.typo3.org/issues/46067
// --pdieter 20131129