Skip to content

Instantly share code, notes, and snippets.

View runningnet's full-sized avatar

The men behind! runningnet

  • World
View GitHub Profile
@runningnet
runningnet / deployexample.sh
Last active June 6, 2018 13:11
Typo3 Shell Deployment
#!/usr/bin/env bash
#Gibt den Ordner für das Git an
DIR=/root/projekt/
quelle="${DIR}"app/web/
#Gibt den Default Webroot Ordner an
ziel=/var/www/live/htdocs/
RED='\033[0;31m'
NC='\033[0m' # No Color
NOW=$(date +"%Y-%m-%d:%H:%M:%S")
DELLOGFILE="deletetfiles-$NOW.log"
@runningnet
runningnet / new_gist_file_0
Created April 10, 2017 14:56
Canonical for Content from Page
page.headerData.1337 = TEXT
page.headerData.1337 {
if.isTrue.field = content_from_pid
typolink.parameter.field = content_from_pid
typolink.returnLast = url
dataWrap = <link rel="canonical" href="{$baseURL}|" />
}
@runningnet
runningnet / new_gist_file.sql
Created March 9, 2017 11:31
Datenbank und Tabellen Größen in SQL anzeigen
SELECT
table_schema AS 'Datenbankname',
Round( SUM( data_length ) / 1024 / 1024, 3 ) AS 'Daten (MB)',
Round( SUM( index_length ) / 1024 / 1024, 3 ) AS 'Index (MB)',
Round( Sum( data_length + index_length ) / 1024 / 1024, 3 ) AS 'Gesamt (MB)',
Round( Sum( data_free ) / 1024 / 1024, 3 ) AS 'Freier Speicher (MB)'
FROM information_schema.tables
GROUP BY table_schema ;
@runningnet
runningnet / Find my Ip
Created June 6, 2016 15:22
Find my external IP on Linux
wget http://ipinfo.io/ip -qO -
update table_name set field = replace(field, 'foo', 'bar') where instr(field, 'foo') > 0;
page.headerData.1337 = TEXT
page.headerData.1337 {
if.isTrue.field = content_from_pid
typolink.parameter.field = content_from_pid
typolink.returnLast = url
dataWrap = <link rel="canonical" href="{$baseURL}|" />
}
@runningnet
runningnet / Change_recursive
Last active August 29, 2015 14:17
Files und Folder Recursive ändern
find . -type f -exec chmod 664 {} \;
find . -type d -exec chmod 775 {} \;
[globalVar = TSFE : beUserLogin > 0]
config.simulateStaticDocuments = 0
[global]
@runningnet
runningnet / new_gist_file_0
Created December 29, 2014 16:12
Typo3 in updaten in einer Zeile
rm typo3_src && ln -s typo3_src-XXXX typo3_src