mipmip

 # cat=basic; type=string; label=conf1 label : description conf 1
conf1 = 1,2,4,5

mipmip

<?php

// create where clause for query with all enable/delete/start/stop fields 
$wherequery = $this->cObj->enableFields('fe_users'); 

// enable fields in exec_SELECTquery
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery ($fields, $table, '1=1' . $this->cObj->enableFields($table), $groupBy, $orderBy);

// exec_SELECTgetRows returns an array
$userArr = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows( 'uid,name,username,tx_lwhellocolleague_birthday as birthdayDate', 'fe_users','1=1'. $this->cObj->enableFields('fe_users'));

mipmip

<?php
function debugDatabase()
{
	$GLOBALS['TYPO3_DB']->store_lastBuiltQuery = true; 

	$GLOBALS['TYPO3_DB']->debugOutput = true; 
	debug($GLOBALS['TYPO3_DB']->debug_lastBuiltQuery);  
	 t3lib_div::devLog('dbgdb','p3ga',0,array($GLOBALS['TYPO3_DB']->debug_lastBuiltQuery));
}

mipmip

<TCEforms type="array">
	<label>Cover Image</label>
	<config type="array">
		<type>group</type>
		<internal_type>file</internal_type>
		<allowed>gif,png,jpg,jpeg,ai,psd,tif,tiff,eps,pdf</allowed>
		<max_size>10000</max_size>
		<uploadfolder>uploads/tx_templavoila</uploadfolder>
		<show_thumbs>1</show_thumbs>
		<size>1</size>

mipmip

Load up Terminal (Applications > Utilities > Terminal.app) and type the following.

sudo launchctl unload -w /System/Library/LaunchDaemons/com.apple.mDNSResponder.plist
To turn it back on, just do the opposite:

sudo launchctl load -w /System/Library/LaunchDaemons/com.apple.mDNSResponder.plist

mipmip

#!/bin/sh
IFS=$'\n'
net=`networksetup -listallnetworkservices | grep -v asterisk`

for i in $net
do
    networksetup -setv6off "$i"
done
exit 0

mipmip

UPDATE egw_wiki_pages SET wiki_body = replace(`wiki_body`,"http://www.domain.nl/wiki/images/","http://xxx.domain.nl/imgwiki/") where wiki_name='XOR';
UPDATE table SET column = replace(column, regex '%-%', ' ') where id = xxx;

mipmip

CREATE TEMPORARY TABLE keepids (
SELECT MIN(uid) FROM tt_address
GROUP BY (email)
);

DELETE FROM tt_address WHERE uid NOT IN (SELECT * FROM keepids);

DROP TABLE keepids;

mipmip

GRANT ALL PRIVILEGES ON dbname.* to [email protected] IDENTIFIED BY 'dbpassword';
FLUSH PRIVILEGES;

mipmip

#!/bin/sh

export APASS=rootpassword
export DB=dbname
export DBDEST=newdbname
mysqldump -uroot $DB -p$APASS | mysql -uroot -p$APASS $DBDEST