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 / 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
@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 / 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 / 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
}
Fuck fuck fuck
@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')
@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 / gaOptOut
Last active March 9, 2017 19:14
GoogleAnalytics Opt Out script
USAGE:
<a onclick="alert('Google Analytics wurde deaktiviert');" href="javascript:gaOptout()">Google Analytics deaktivieren</a>
The Script needs to be included in all pages.
<script type="text/javascript">
// Set to the same value as the web property used on the site
var gaProperty = 'UA-{GA_ID}-x';
// Disable tracking if the opt-out cookie exists.
@briezler
briezler / Nginx Config Kirby
Last active June 30, 2017 15:59
Nginx Config Kirby
# Don't hint these as folders
rewrite ^/(content|site|kirby)$ /error last;
# block content
rewrite ^/content/(.*).(txt|md|mdown)$ /error last;
# block all files in the site and kirby folder from being accessed directly
rewrite ^/(site|kirby)/(.*)$ /error last;
# removes trailing slashes (prevents SEO duplicate content issues)
@briezler
briezler / rsync_remote_dir.sh
Created March 14, 2017 18:11
rsycn remote Server via ssh
rsync -avzbe ssh user@example.com:/remote/directory/path /local/directory/path