The men behind! runningnet

Working Underground

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 / 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 / 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 / Find my Ip

Created June 6, 2016 15:22

Find my external IP on Linux

wget http://ipinfo.io/ip -qO -

runningnet / update.sql

Created October 14, 2015 10:17

update table_name set field = replace(field, 'foo', 'bar') where instr(field, 'foo') > 0;

runningnet / t3_content_von_andere_seite

Created June 25, 2015 12:35

From http://www.typo3.net/forum/thematik/zeige/thema/112484/?show=1

	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 / errorreporting.php

Created March 31, 2015 10:40

error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);

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 {} \;

runningnet / new_gist_file_0

Created February 11, 2015 10:45

TS if BE user logged in From http://typo3.org/documentation/snippets/sd/48/

	[globalVar = TSFE : beUserLogin > 0]
	config.simulateStaticDocuments = 0
	[global]

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