PHP searchandreplace_results Examples

Example #1

File: search-and-replace.php Project: Vinnica/theboxerboston.com

function searchandreplace_doit($search_text, $replace_text, $sall = TRUE, $content = TRUE, $guid = TRUE, $id = TRUE, $title = TRUE, $excerpt = TRUE, $meta_value = TRUE, $comment_content = TRUE, $comment_author = TRUE, $comment_author_email = TRUE, $comment_author_url = TRUE, $comment_count = TRUE, $cat_description = TRUE, $tag = TRUE, $user_id = TRUE, $user_login = TRUE, $signups = TRUE)
{
    global $wpdb;
    $myecho = '';
    // slug string
    $search_slug = strtolower($search_text);
    $replace_slug = strtolower($replace_text);
    if (!$sall && !$content && !$id && !$guid && !$title && !$excerpt && !$meta_value && !$comment_content && !$comment_author && !$comment_author_email && !$comment_author_url && !$comment_count && !$cat_description && !$tag && !$user_id && !$user_login && !$signups) {
        return '<div class="error"><p><strong>' . __('Nothing (checkbox) selected to modify!', FB_SAR_TEXTDOMAIN) . '</strong></p></div><br class="clear" />';
    }
    // search at all
    if ('sall' === $sall) {
        $myecho .= "\n" . '<li>' . __('Searching all', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_sall($search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
    }
    // search/replace at all
    if ('srall' === $sall) {
        $myecho .= "\n" . '<li>' . __('Searching & replacing all', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_sall($search_text, $replace_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
    }
    // post content
    if ($content) {
        $myecho .= "\n" . '<li>' . __('Searching post content', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('post_content', 'posts', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET post_content = ";
        $query .= "REPLACE(post_content, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // post id
    if ($id) {
        $myecho .= "\n" . __('Searching ID', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('ID', 'posts', $search_text);
        $myecho .= searchandreplace_results('post_parent', 'posts', $search_text);
        $myecho .= searchandreplace_results('post_id', 'postmeta', $search_text);
        $myecho .= searchandreplace_results('object_id', 'term_relationships', $search_text);
        $myecho .= searchandreplace_results('comment_post_ID', 'comments', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET ID = ";
        $query .= "REPLACE(ID, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET post_parent = ";
        $query .= "REPLACE(post_parent, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->postmeta} ";
        $query .= "SET post_id = ";
        $query .= "REPLACE(post_id, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->term_relationships} ";
        $query .= "SET object_id = ";
        $query .= "REPLACE(object_id, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->comments} ";
        $query .= "SET comment_post_ID = ";
        $query .= "REPLACE(comment_post_ID, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // post guid
    if ($guid) {
        $myecho .= "\n" . '<li>' . __('Searching <abbr title=\\"Global Unique Identifier\\">GUID</abbr>', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('guid', 'posts', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET guid = ";
        $query .= "REPLACE(guid, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // post title
    if ($title) {
        $myecho .= "\n" . '<li>' . __('Searching Title', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('post_title', 'posts', $search_text);
        $myecho .= searchandreplace_results('post_name', 'posts', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET post_title = ";
        $query .= "REPLACE(post_title, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET post_name = ";
        $query .= "REPLACE(post_name, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // post excerpt
    if ($excerpt) {
        $myecho .= "\n" . '<li>' . __('Searching post excerpts', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('post_excerpt', 'posts', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET post_excerpt = ";
        $query .= "REPLACE(post_excerpt, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // meta_value
    if ($meta_value) {
        $myecho .= "\n" . '<li>' . __('Searching metadata', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('meta_value', 'postmeta', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->postmeta} ";
        $query .= "SET meta_value = ";
        $query .= "REPLACE(meta_value, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // comment content
    if ($comment_content) {
        $myecho .= "\n" . '<li>' . __('Searching comments text', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('comment_content', 'comments', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->comments} ";
        $query .= "SET comment_content = ";
        $query .= "REPLACE(comment_content, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // comment_author
    if ($comment_author) {
        $myecho .= "\n" . '<li>' . __('Searching comments authors', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('comment_author', 'comments', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->comments} ";
        $query .= "SET comment_author = ";
        $query .= "REPLACE(comment_author, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // comment_author_email
    if ($comment_author_email) {
        $myecho .= "\n" . '<li>' . __('Searching comments authors e-mails', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('comment_author_email', 'comments', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->comments} ";
        $query .= "SET comment_author_email = ";
        $query .= "REPLACE(comment_author_email, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // comment_author_url
    if ($comment_author_url) {
        $myecho .= "\n" . '<li>' . __('Searching comments authors URLs', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('comment_author_url', 'comments', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->comments} ";
        $query .= "SET comment_author_url = ";
        $query .= "REPLACE(comment_author_url, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // comment_count
    if ($comment_count) {
        $myecho .= "\n" . '<li>' . __('Searching comment counts', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('comment_count', 'posts', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET comment_count = ";
        $query .= "REPLACE(comment_count, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // category description
    if ($cat_description) {
        $myecho .= "\n" . '<li>' . __('Searching category descriptions', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('description', 'term_taxonomy', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->term_taxonomy} ";
        $query .= "SET description = ";
        $query .= "REPLACE(description, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    // tags and category
    if ($tag) {
        $myecho .= "\n" . '<li>' . __('Searching tags', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('name', 'terms', $search_text);
        $myecho .= searchandreplace_results('slug', 'terms', $search_slug);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->terms} ";
        $query .= "SET name = ";
        $query .= "REPLACE(name, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->terms} ";
        $query .= "SET slug = ";
        $query .= "REPLACE(slug, \"{$search_slug}\", \"{$replace_slug}\") ";
        $wpdb->get_results($query);
    }
    // user_id
    if ($user_id) {
        $myecho .= "\n" . '<li>' . __('Searching user IDs', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('ID', 'users', $search_text);
        $myecho .= searchandreplace_results('user_id', 'usermeta', $search_slug);
        $myecho .= searchandreplace_results('post_author', 'posts', $search_slug);
        $myecho .= searchandreplace_results('user_id', 'comments', $search_slug);
        $myecho .= searchandreplace_results('link_owner', 'links', $search_slug);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->users} ";
        $query .= "SET ID = ";
        $query .= "REPLACE(ID, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->usermeta} ";
        $query .= "SET user_id = ";
        $query .= "REPLACE(user_id, \"{$search_slug}\", \"{$replace_slug}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->posts} ";
        $query .= "SET post_author = ";
        $query .= "REPLACE(post_author, \"{$search_slug}\", \"{$replace_slug}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->comments} ";
        $query .= "SET user_id = ";
        $query .= "REPLACE(user_id, \"{$search_slug}\", \"{$replace_slug}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->links} ";
        $query .= "SET link_owner = ";
        $query .= "REPLACE(link_owner, \"{$search_slug}\", \"{$replace_slug}\") ";
        $wpdb->get_results($query);
    }
    // user_login
    if ($user_login) {
        $myecho .= "\n" . '<li>' . __('Searching user logins', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('user_login', 'users', $search_text);
        $myecho .= searchandreplace_results('user_nicename', 'users', $search_slug);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->users} ";
        $query .= "SET user_login = "******"REPLACE(user_login, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
        $query = "UPDATE {$wpdb->users} ";
        $query .= "SET user_nicename = ";
        $query .= "REPLACE(user_nicename, \"{$search_slug}\", \"{$replace_slug}\") ";
        $wpdb->get_results($query);
    }
    // signups on WP multisite
    if ($signups) {
        $myecho .= "\n" . '<li>' . __('Searching signups', FB_SAR_TEXTDOMAIN) . ' ...';
        $myecho .= "\n" . '<ul>' . "\n";
        $myecho .= searchandreplace_results('user_login', 'signups', $search_text);
        $myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
        $query = "UPDATE {$wpdb->signups} ";
        $query .= "SET user_login = "******"REPLACE(user_login, \"{$search_text}\", \"{$replace_text}\") ";
        $wpdb->get_results($query);
    }
    $echo = '<div class="updated fade">' . "\n" . '<ul>';
    $echo .= $myecho;
    $echo .= "\n" . '</ul>' . "\n" . '</div><br class="clear"/>' . "\n";
    return $echo;
}

Example #2

File: search-and-replace.php Project: realfluid/umbaugh

function searchandreplace_doit(
	$search_text,
	$replace_text,
	$all                  = TRUE,
	$content              = TRUE,
	$guid                 = TRUE,
	$id                   = TRUE,
	$title                = TRUE,
	$excerpt              = TRUE,
	$meta_value           = TRUE,
	$comment_content      = TRUE,
	$comment_author       = TRUE,
	$comment_author_email = TRUE,
	$comment_author_url   = TRUE,
	$comment_count        = TRUE,
	$cat_description      = TRUE,
	$tag                  = TRUE,
	$user_id              = TRUE,
	$user_login           = TRUE,
	$signups              = TRUE
	) {
	global $wpdb;

	$myecho = '';
	// slug string
	$search_slug  = strtolower($search_text);
	$replace_slug = strtolower($replace_text);
	
	if (!$all && !$content && !$id && !$guid && !$title && !$excerpt && !$meta_value && 
		!$comment_content && !$comment_author && !$comment_author_email && !$comment_author_url && !$comment_count && 
		!$cat_description && !$tag && !$user_id && !$user_login &&
		!$signups ) {
		return '<div class="error"><p><strong>' . __('Nothing (Checkbox) selected to modify!', FB_SAR_TEXTDOMAIN). '</strong></p></div><br class="clear" />';
	}

	// search at all
	if ($all) {
		$myecho .= "\n" . '<li>' . __('Looking @ all', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_all($search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
	}
	
	// post content
	if ($content) {
		$myecho .= "\n" . '<li>' . __('Looking @ post content', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('post_content', 'posts', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET post_content = ";
		$query .= "REPLACE(post_content, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}

	// post id
	if ($id) {
		$myecho .= "\n" . __('Looking @ ID', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('ID', 'posts', $search_text);
		$myecho .= searchandreplace_results('post_parent', 'posts', $search_text);
		$myecho .= searchandreplace_results('post_id', 'postmeta', $search_text);
		$myecho .= searchandreplace_results('object_id', 'term_relationships', $search_text);
		$myecho .= searchandreplace_results('comment_post_ID', 'comments', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET ID = ";
		$query .= "REPLACE(ID, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET post_parent = ";
		$query .= "REPLACE(post_parent, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);

		$query  = "UPDATE $wpdb->postmeta ";
		$query .= "SET post_id = ";
		$query .= "REPLACE(post_id, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);

		$query  = "UPDATE $wpdb->term_relationships ";
		$query .= "SET object_id = ";
		$query .= "REPLACE(object_id, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);

		$query  = "UPDATE $wpdb->comments ";
		$query .= "SET comment_post_ID = ";
		$query .= "REPLACE(comment_post_ID, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// post guid
	if ($guid) {
		$myecho .= "\n" . '<li>' . __('Looking @ GUID', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('guid', 'posts', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET guid = ";
		$query .= "REPLACE(guid, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// post title
	if ($title) {
		$myecho .= "\n" . '<li>' . __('Looking @ Titeln', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('post_title', 'posts', $search_text);
		$myecho .= searchandreplace_results('post_name', 'posts', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET post_title = ";
		$query .= "REPLACE(post_title, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET post_name = ";
		$query .= "REPLACE(post_name, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// post excerpt
	if ($excerpt) {
		$myecho .= "\n" . '<li>' . __('Looking @ post excerpts', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('post_excerpt', 'posts', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET post_excerpt = ";
		$query .= "REPLACE(post_excerpt, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// meta_value
	if ($meta_value) {
		$myecho .= "\n" . '<li>' . __('Looking @ Meta Daten', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('meta_value', 'postmeta', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->postmeta ";
		$query .= "SET meta_value = ";
		$query .= "REPLACE(meta_value, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// comment content
	if ($comment_content) {
		$myecho .= "\n" . '<li>' . __('Looking @ modifying comments text', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('comment_content', 'comments', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->comments ";
		$query .= "SET comment_content = ";
		$query .= "REPLACE(comment_content, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// comment_author
	if ($comment_author) {
		$myecho .= "\n" . '<li>' . __('Looking @ modifying comments author', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('comment_author', 'comments', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->comments ";
		$query .= "SET comment_author = ";
		$query .= "REPLACE(comment_author, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// comment_author_email
	if ($comment_author_email) {
		$myecho .= "\n" . '<li>' . __('Looking @ modifying comments author e-mail', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('comment_author_email', 'comments', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->comments ";
		$query .= "SET comment_author_email = ";
		$query .= "REPLACE(comment_author_email, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// comment_author_url
	if ($comment_author_url) {
		$myecho .= "\n" . '<li>' . __('Looking @ modifying comments author URLs', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('comment_author_url', 'comments', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->comments ";
		$query .= "SET comment_author_url = ";
		$query .= "REPLACE(comment_author_url, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}

	// comment_count
	if ($comment_count) {
		$myecho .= "\n" . '<li>' . __('Looking @ Comment-Count', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('comment_count', 'posts', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET comment_count = ";
		$query .= "REPLACE(comment_count, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}

	// category description
	if ($cat_description) {
		$myecho .= "\n" . '<li>' . __('Looking @ category description', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('description', 'term_taxonomy', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->term_taxonomy ";
		$query .= "SET description = ";
		$query .= "REPLACE(description, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	// tags and category
	if ($tag) {
		$myecho .= "\n" . '<li>' . __('Looking @ Tags', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('name', 'terms', $search_text);
		$myecho .= searchandreplace_results('slug', 'terms', $search_slug);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->terms ";
		$query .= "SET name = ";
		$query .= "REPLACE(name, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
		
		$query  = "UPDATE $wpdb->terms ";
		$query .= "SET slug = ";
		$query .= "REPLACE(slug, \"$search_slug\", \"$replace_slug\") ";
		$wpdb->get_results($query);
	}

	// user_id
	if ($user_id) {
		$myecho .= "\n" . '<li>' . __('Looking @ User-ID', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('ID', 'users', $search_text);
		$myecho .= searchandreplace_results('user_id', 'usermeta', $search_slug);
		$myecho .= searchandreplace_results('post_author', 'posts', $search_slug);
		$myecho .= searchandreplace_results('link_owner', 'links', $search_slug);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->users ";
		$query .= "SET ID = ";
		$query .= "REPLACE(ID, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
		
		$query  = "UPDATE $wpdb->usermeta ";
		$query .= "SET user_id = ";
		$query .= "REPLACE(user_id, \"$search_slug\", \"$replace_slug\") ";
		$wpdb->get_results($query);
		
		$query  = "UPDATE $wpdb->posts ";
		$query .= "SET post_author = ";
		$query .= "REPLACE(post_author, \"$search_slug\", \"$replace_slug\") ";
		$wpdb->get_results($query);
		
		$query  = "UPDATE $wpdb->links ";
		$query .= "SET link_owner = ";
		$query .= "REPLACE(link_owner, \"$search_slug\", \"$replace_slug\") ";
		$wpdb->get_results($query);
	}

	// user_login
	if ($user_login) {
		$myecho .= "\n" . '<li>' . __('Looking @ User Login', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('user_login', 'users', $search_text);
		$myecho .= searchandreplace_results('user_nicename', 'users', $search_slug);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->users ";
		$query .= "SET user_login = "******"REPLACE(user_login, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
		
		$query  = "UPDATE $wpdb->users ";
		$query .= "SET user_nicename = ";
		$query .= "REPLACE(user_nicename, \"$search_slug\", \"$replace_slug\") ";
		$wpdb->get_results($query);
	}
	
	// signups on WP multisite
	if ($signups) {
		$myecho .= "\n" . '<li>' . __('Looking @ signups', FB_SAR_TEXTDOMAIN) . ' ...';
		
		$myecho .= "\n" . '<ul>' . "\n";
		$myecho .= searchandreplace_results('user_login', 'signups', $search_text);
		$myecho .= "\n" . '</ul>' . "\n" . '</li>' . "\n";
		
		$query  = "UPDATE $wpdb->signups ";
		$query .= "SET user_login = "******"REPLACE(user_login, \"$search_text\", \"$replace_text\") ";
		$wpdb->get_results($query);
	}
	
	$echo  = '<div class="updated fade">' . "\n" . '<ul>';
	$echo .= $myecho;
	$echo .= "\n" . '</ul>' . "\n" . '</div><br class="clear"/>' . "\n";
	
	return $echo;
}