Skip to content

Instantly share code, notes, and snippets.

View kitzberger's full-sized avatar

Philipp Kitzberger kitzberger

9 followers · 7 following
  • Ludwigsburg
View GitHub Profile
@kitzberger
kitzberger / XyzRepository.php
Last active October 26, 2018 17:05
Debug Extbase Queries (TYPO3 8.7)
<?php
namespace Vendor\ExtensionName\Domain\Repository;
class XyzRepository extends \TYPO3\CMS\Extbase\Persistence\Repository {
public function findByFoo($value)
{
$query = $this->createQuery();
#$query->setFancyConstrations(...)
$this->debugQuery($query);
@kitzberger
kitzberger / XyzRepository.php
Created November 8, 2018 17:03
Debug Extbase Queries (TYPO3 6+7)
<?php
namespace Vendor\ExtensionName\Domain\Repository;
class XyzRepository extends \TYPO3\CMS\Extbase\Persistence\Repository {
public function findByFoo($value)
{
$query = $this->createQuery();
#$query->setFancyConstrations(...)
$this->debugQuery($query->execute());
@kitzberger
kitzberger / department.php
Last active December 10, 2018 15:19
TYPO3 TCA example for enriched inline/irre relations
<?php
if (!defined('TYPO3_MODE')) {
die('Access denied.');
}
$GLOBALS['TCA']['tx_customext_domain_model_department'] = array(
'ctrl' => array(
'title' => 'LLL:EXT:custom_ext/Resources/Private/Language/locallang_db.xlf:tx_custom_ext_domain_model_department',
// title prefixed by department_id
'label' => 'department_id',
@kitzberger
kitzberger / backup-typo3.sh
Last active February 15, 2023 15:30
#!/bin/bash
DB='xxx'
DB_GROUP=''
WEBROOT='/var/www/vhosts/xxx/html'
FOLDERS=( 'fileadmin' 'uploads' )
read -p "Backup DB? (y/N) " BACKUP_DB
if [ "$BACKUP_DB" == "y" ]; then
TABLES=`mysql --defaults-group-suffix=$DB_GROUP -BN $DB -e "show tables" | egrep -v '(cf_|cache|sys_log|sys_history|sys_refindex|tx_devlog|tx_solr_|tx_realurl_errorlog|zzz_deleted_|TABLE)' | xargs`
@kitzberger
kitzberger / php-compatibility-check.sh
Created February 5, 2019 20:09
PHP Compatibility Check
# -------------------------
# PHP-Compatibility
# -------------------------
# Add dev requirements
composer require --dev phpcompatibility/php-compatibility
# List installed configs (should be none)
bin/phpcs --config-show
@kitzberger
kitzberger / version-compare.php
Created February 19, 2019 12:56
TYPO3/PHP version compare
if (version_compare(PHP_VERSION, '7.0.0', '>=') {
...
}
if (version_compare(TYPO3_version, '8.7.0', '>=') {
...
}
@kitzberger
kitzberger / composer-security-check.sh
Created February 19, 2019 14:00
Check installed composer dependancies for known security vulnerabilities
wget https://get.sensiolabs.org/security-checker.phar
php security-checker.phar security:check composer.lock
# see https://github.com/sensiolabs/security-checker
@kitzberger
kitzberger / .profile
Created March 14, 2019 13:15
Change /bin/sh to /bin/bash
test $SHELL = /bin/sh -a -x /bin/bash && \
SHELL=/bin/bash ENV=~/.bashrc
@kitzberger
kitzberger / AdditionalConfiguration.php
Last active May 11, 2022 12:41
TYPO3: logging
<?php
// Don't log any deprecations
unset($GLOBALS['TYPO3_CONF_VARS']['LOG']['TYPO3']['CMS']['deprecations']);
// Log only errors and higher (default is 'warning')
$GLOBALS['TYPO3_CONF_VARS']['LOG']['writerConfiguration'] = [
\TYPO3\CMS\Core\Log\LogLevel::ERROR => [
\TYPO3\CMS\Core\Log\Writer\FileWriter::class => [],
],
@kitzberger
kitzberger / .bashrc
Created May 13, 2019 07:50
git prompt
# Load one of these files
source /usr/lib/git-core/git-sh-prompt
source /usr/share/git-core/contrib/completion/git-prompt.sh
source /usr/local/git/contrib/completion/git-prompt.sh
source /etc/bash_completion.d/git
# Set flags
GIT_PS1_SHOWDIRTYSTATE=true
GIT_PS1_SHOWUNTRACKEDFILES=true