How do this with wordpress? Mass replace post content and links

**tonyparra** · 03-21-2012, 01:20 PM

bumppppp

**pr0phet** · 03-21-2012, 01:30 PM

just search and replace the domain names in mysql and then send to your own domain that just refreshes all the 404's etc to your own landing page or to aebn if they catch your refreshes.

**tonyparra** · 03-21-2012, 05:05 PM

Originally posted by pr0phet

just search and replace the domain names in mysql and then send to your own domain that just refreshes all the 404's etc to your own landing page or to aebn if they catch your refreshes.

ok got the first part come again?

**mromro** · 03-21-2012, 05:39 PM

search and replace plugin

http://wordpress.org/extend/plugins/search-and-replace/

**tonyparra** · 03-21-2012, 06:48 PM

fuck it ill just delete this shit

**ottopottomouse** · 03-21-2012, 10:16 PM

Originally posted by tonyparra

ok got the first part come again?

404 page with PHP redirect either to your home page or sponsor - it will collect everyone that goes to one of the replaced links as they don't exist as a file on your domain.

**fris** · 03-22-2012, 05:59 AM

Originally posted by tonyparra

fuck it ill just delete this shit

do search and replace regex, and get the regex for the download box part, if thats the only thing you are removing.

**fris** · 03-22-2012, 06:29 AM

regex could be something like

Code:

$html = '[downloads_box title="big boobs"]http://www.domain.com/files/files.avi.html[/downloads_box]';
$regex = '/\[(\[?)(downloads_box)\b([^\]\/]*(?:\/(?!\])[^\]\/]*)*?)(?:(\/)\]|\](?:([^\[]*+(?:\[(?!\/\2\])[^\[]*+)*+)\[\/\2\])?)(\]?)/s';
$new = preg_replace($regex,' replacement',$html);
echo $html . 'will be replaced with' . $new;

or something

**Brujah** · 03-22-2012, 07:51 AM

It looks like a shortcode plugin or function "downloads_box", could you just deactivate/delete the plugin? Then add this to your functions.php file somewhere to empty the info.

Code:

function my_downloads_box( $atts, $content = null ) {
 return '';
}
add_shortcode( 'downloads_box', 'my_downloads_box' );

**fris** · 03-22-2012, 08:54 AM

Originally posted by Brujah

It looks like a shortcode plugin or function "downloads_box", could you just deactivate/delete the plugin? Then add this to your functions.php file somewhere to empty the info.

Code:

function my_downloads_box( $atts, $content = null ) {
 return '';
}
add_shortcode( 'downloads_box', 'my_downloads_box' );

ya that would be easiest to null the return

**tonyparra** · 03-23-2012, 10:39 PM

you guys are past awesomeness

**fris** · 03-25-2012, 01:24 PM

if you want to remove it completely from the db, here is the code i use/used

Code:

function remove_shortcode_from_db($shortcode = 'button') {

    global $wpdb;

    $posts = $wpdb->get_results("SELECT ID,post_title,post_content FROM $wpdb->posts");
    $regex = '/\[(\[?)('.$shortcode.')\b([^\]\/]*(?:\/(?!\])[^\]\/]*)*?)(?:(\/)\]|\](?:([^\[]*+(?:\[(?!\/\2\])[^\[]*+)*+)\[\/\2\])?)(\]?)/s';

    foreach($posts as $post) {
        $final = preg_replace($regex,'',$post->post_content);
        $change = $wpdb->update( $wpdb->posts, array('post_content' => $final), array('ID' => $post->ID));
    }
}

Code:

remove_shortcode_from_db('downloads_box');

always backup your database before doing any mods like this.

**just a punk** · 03-25-2012, 01:34 PM

Originally posted by tonyparra

How do this with wordpress? Mass replace post content and links.

You are a CyberSEO customer. Am I right? If so, just go to CyberSEO->Tools and find the "PHP Code <?php .. ?>" box. You can use it to modify every existing post (title, content, excerpt). For example, if you want to replace "word1" to "word2" in every post and its excerpt, simple put the following code into the "PHP Code <?php .. ?>" box and click the "Apply" button:

Code:

$post->post_content = str_replace('word1', 'word2', $post->post_content);
$post->post_excerpt = str_replace('word1', 'word2', $post->post_excerpt);

If you want, say, remove "bad_word" for the post tittle, the code will be as simple as this:

Code:

$post->post_title = str_replace('bad_word', '', $post->post_title);

etc

**fris** · 03-25-2012, 03:26 PM

Originally posted by CyberSEO

You are a CyberSEO customer. Am I right? If so, just go to CyberSEO->Tools and find the "PHP Code <?php .. ?>" box. You can use it to modify every existing post (title, content, excerpt). For example, if you want to replace "word1" to "word2" in every post and its excerpt, simple put the following code into the "PHP Code <?php .. ?>" box and click the "Apply" button:

Code:

$post->post_content = str_replace('word1', 'word2', $post->post_content);
$post->post_excerpt = str_replace('word1', 'word2', $post->post_excerpt);

If you want, say, remove "bad_word" for the post tittle, the code will be as simple as this:

Code:

$post->post_title = str_replace('bad_word', '', $post->post_title);

etc

that doesnt revmoe it from the db though, its just being replaced via the post object.

**tonyparra** · 03-27-2012, 01:41 PM

Originally posted by CyberSEO

You are a CyberSEO customer. Am I right? If so, just go to CyberSEO->Tools and find the "PHP Code <?php .. ?>" box. You can use it to modify every existing post (title, content, excerpt). For example, if you want to replace "word1" to "word2" in every post and its excerpt, simple put the following code into the "PHP Code <?php .. ?>" box and click the "Apply" button:

Code:

$post->post_content = str_replace('word1', 'word2', $post->post_content);
$post->post_excerpt = str_replace('word1', 'word2', $post->post_excerpt);

If you want, say, remove "bad_word" for the post tittle, the code will be as simple as this:

Code:

$post->post_title = str_replace('bad_word', '', $post->post_title);

etc

Yes, i didnt consider this option because i bought the site as is. I used a combo of the things above though. BTW Cyberseo rocks

**SZNY** · 03-27-2012, 01:45 PM

Here some queries that can be useful

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

After that you will need to fix URLs of the WordPress posts and pages, which translated from post slug, and stored in database wp_posts table as guid field. The URL values in this field are stored as absolute URLs instead of relative URLs, so it needs to be changed with the following SQL query:

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

If you have linked internally within blog posts or pages with absolute URLs, these links will point to wrong locations after you move the blog location. Use the following SQL commands to fix all internal links to own blog in all WordPress posts and pages:

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

UPDATE `wp_postmeta` SET `meta_value` = replace(meta_value, '212-555-1212', '212-444-1212') WHERE `meta_key` LIKE 'DeptPhone'

How do this with wordpress? Mass replace post content and links

How do this with wordpress? Mass replace post content and links

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment