3 useful scripts when moving Wordpress sites, or when the domain changes:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.domain.com', 'http://www.new.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.domain.com', 'http://www.new.com');

UPDATE wp_posts SET guid = replace(guid, 'http://www.domain.com', 'http://www.new.com');

Wordpress

Spam protection

 

In wp-comments-post.php at the top:


<?php if(!empty($_SERVER['SCRIPT_FILENAME']) && 'wp-comments-post.php' == basename($_SERVER['SCRIPT_FILENAME']) && !isset($_SERVER['HTTP_REFERER'])) : 
header('HTTP/1.1 403 Forbidden');
header('Content-Type: text/plain');
exit;
?>

Add to .htaccess:

#Security
RewriteCond %{REQUEST_METHOD} POST
RewriteCond %{REQUEST_URI} .wp-comments-post\.php*
RewriteCond %{HTTP_REFERER} !.*gregolsen.com.* [OR]
RewriteCond %{HTTP_USER_AGENT} ^$
RewriteRule (.*) http://%{REMOTE_ADDR}/$ [R=301,L]

Wordpress

Search My Site