Skip to content

Instantly share code, notes, and snippets.

View briezler's full-sized avatar

Benjamin Riezler briezler

  • Pixel Ink GmbH
  • Munich
View GitHub Profile
@briezler
briezler / redirectLanguageExcludeIpe
Created September 16, 2016 13:26
htaccess redirect based on language with ip exclusion
RewriteEngine on
RewriteCond %{HTTP:Accept-Language} (de) [NC]
RewriteCond %{REMOTE_ADDR} !=80.81.2.190
RewriteCond %{REMOTE_ADDR} !=
RewriteCond %{REMOTE_ADDR} !=
RewriteRule .* http://www.URL.de/ [R,L]
@briezler
briezler / MySQL replace
Created September 1, 2016 09:40
MySql replace String in column
UPDATE TABLE
SET COL = REPLACE(url, 'domain1.com', 'domain2.com')
Fuck fuck fuck
@briezler
briezler / pagePersmissions.t3
Created January 8, 2016 16:02
TYPO3 Seite neue anlegen - Benutzer u. Benutzergruppenrechte
TCEMAIN.permissions {
# User der Besitzer der Seite ist
userid = 3
# Usergroup die Besitzer der Seite ist
groupid = 1
# Wenn individuelle Zugriffsrechte gesetzt werden sollen
#user = show, editcontent, edit, delete, new
#group = show, editcontent, edit, delete, new
}
@briezler
briezler / powermail_prefilled_date.ts
Created November 11, 2015 12:12
Powermail verstecktes Feld mit vorausgefülltem Datum
plugin.tx_powermail {
settings {
setup {
prefill {
datum = TEXT
datum.data = date:U
datum.strftime = %d.%m.%Y
}
}
}
@briezler
briezler / WebDirectoryBackup.sh
Last active May 16, 2016 23:17
Webdirectory Backup including database
#/bin/bash
# SET Variables
NOW="$(date +"%d-%m-%Y_%H-%M-%S")"
ROOT_PATH="/home/www/p177910/html"
DIRECTORY_TO_SAVE="$ROOT_PATH/typo3"
BACKUP_TO_DIRECTORY="$ROOT_PATH/backup"
LOGFILE="$ROOT_PATH/backup/log/yourlogfile.log"
USER=who
DB_USER=""
@briezler
briezler / mysqlBackup.sh
Created November 19, 2014 05:34
mysql Backup
# Script saves TYPO3 Directory inclusive
# Database
#
# @param dbname
# @param dbuser
# @param dbpassword
# @param backupdir
# @param backupDir
# SET Variables