Justin Scarpetti doitlikejustin

## unzip.php
<?php

$zip = new ZipArchive;
$res = $zip->open('./unzip.zip');
if($res === TRUE) {
  $zip->extractTo('./');
  $zip->close();
  echo 'woot!';
} else {
  echo 'doh!';

## import_sql.sh
mysql -u USERNAME -p -h localhost DATABASE < FILENAME.sql

## wordpress.htaccess
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

## check_ip_if.php
<?php if($_SERVER['REMOTE_ADDR'] == '999.999.999.999'): ?>

  <?php /* HTML and other goodness goes here */ ?>

<?php endif; ?>

## string_to_slug.php
<?php

// will convert "Hello World!" to "hello-world"
function to_slug($string)
{
  return strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $string)));
}

?>

## change_wp_url.sql
SET @prefix = "wp_";
SET @old = "http://www.old.com";
SET @new = "http://www.new.com";

SET @sql1 = CONCAT('UPDATE ', @prefix, 'options SET option_value = REPLACE(option_value,?,?)');
SET @sql2 = CONCAT('UPDATE ', @prefix, 'posts SET guid = REPLACE(guid,?,?)');
SET @sql3 = CONCAT('UPDATE ', @prefix, 'posts SET post_content = REPLACE(post_content,?,?)');

PREPARE update1 FROM @sql1;
PREPARE update2 FROM @sql2;

## delete_svn_dirs.sh
find ./ -name ".svn" | xargs rm -Rf

## reset_dns_lion.sh
sudo killall -HUP mDNSResponder

## sql_replace.sh
UPDATE _table_ SET _field_ = REPLACE(_field_, '_old_value_', '_new_value_');

## change_user_group.sh
chown -R USERNAME:psacln /var/www/vhosts/DOMAIN/httpdocs/ && chown USERNAME:psaserv /var/www/vhosts/DOMAIN/httpdocs/
	<?php

	$zip = new ZipArchive;
	$res = $zip->open('./unzip.zip');
	if($res === TRUE) {
	$zip->extractTo('./');
	$zip->close();
	echo 'woot!';
	} else {
	echo 'doh!';
	# BEGIN WordPress
	<IfModule mod_rewrite.c>
	RewriteEngine On
	RewriteBase /
	RewriteRule ^index\.php$ - [L]
	RewriteCond %{REQUEST_FILENAME} !-f
	RewriteCond %{REQUEST_FILENAME} !-d
	RewriteRule . /index.php [L]
	</IfModule>
	# END WordPress
	<?php if($_SERVER['REMOTE_ADDR'] == '999.999.999.999'): ?>

	<?php /* HTML and other goodness goes here */ ?>

	<?php endif; ?>
	<?php

	// will convert "Hello World!" to "hello-world"
	function to_slug($string)
	{
	return strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $string)));
	}

	?>
	SET @prefix = "wp_";
	SET @old = "http://www.old.com";
	SET @new = "http://www.new.com";

	SET @sql1 = CONCAT('UPDATE ', @prefix, 'options SET option_value = REPLACE(option_value,?,?)');
	SET @sql2 = CONCAT('UPDATE ', @prefix, 'posts SET guid = REPLACE(guid,?,?)');
	SET @sql3 = CONCAT('UPDATE ', @prefix, 'posts SET post_content = REPLACE(post_content,?,?)');

	PREPARE update1 FROM @sql1;
	PREPARE update2 FROM @sql2;