Wordpress help - Mass changing links in posts? - GoFuckYourself.com

Shoplifter · 05-27-2010, 12:18 PM

Any easy way to change sponsor links throughout a few hundred Wordpress posts?

Thanks thanks thanks

fris · 05-27-2010, 01:02 PM

theirs a search and replace wordpress plugin

Marquis85 · 05-27-2010, 01:03 PM

I'm looking for one as well but for the time being, the plugin called SEO Smart Links might be what you're looking for.

Emil · 05-27-2010, 01:10 PM

update `wp_posts` set `post_content` = replace(`post_content`, ‘replace_that’, ‘with_this’);

GrouchyAdmin · 05-27-2010, 01:26 PM

Quote:

Originally Posted by Emil

update `wp_posts` set `post_content` = replace(`post_content`, ?replace_that?, ?with_this?);

This will do.

FlexxAeon · 05-27-2010, 01:32 PM

Quote:

Originally Posted by Emil

update `wp_posts` set `post_content` = replace(`post_content`, ?replace_that?, ?with_this?);

there ya go

been having to do this a lot lately unfortunately

Fat Panda · 05-27-2010, 01:33 PM

i would use search and replace

d-null · 05-27-2010, 01:39 PM

the op might be talking about mass changing varying links throughout a blog, in which case the problem becomes much more difficult

say you have 1000 different links to different landing pages within a sponsor that turned bad, you need a sophisticated regexp or something to find those link strings and pull them out and replace them with something else

zargan · 05-27-2010, 01:47 PM

Quote:

Originally Posted by Shoplifter

Any easy way to change sponsor links throughout a few hundred Wordpress posts?

Thanks thanks thanks

maybe re.place wordpress plugin will help you ...

Shoplifter · 05-27-2010, 02:08 PM

Quote:

Originally Posted by d-null

the op might be talking about mass changing varying links throughout a blog, in which case the problem becomes much more difficult

say you have 1000 different links to different landing pages within a sponsor that turned bad, you need a sophisticated regexp or something to find those link strings and pull them out and replace them with something else

Right. This is about changing sponsor links in many hand written posts.

I think there might be quite a demand for this these days lol..l.

fris · 05-27-2010, 02:31 PM

stop hand coding each link, its best, so you can just change them via the link ad manager. without dealing with the hassle

Houdini · 05-27-2010, 03:08 PM

Had the same problem on a 1200+ posts blog and used this plugin. Worked like a charm.

http://thedeadone.net/download/searc...dpress-plugin/

LoveSandra · 05-28-2010, 01:37 AM

Bump for you

Hentaikid · 05-28-2010, 05:15 AM

What emil said, only you do it in phpmyadmin working on the database not in wordpress itself

05-27-2010, 12:18 PM	#1
Shoplifter Richest man in Babylon Industry Role: Join Date: Jan 2002 Location: Posts: 10,002 Posts: 5,679	Wordpress help - Mass changing links in posts? Any easy way to change sponsor links throughout a few hundred Wordpress posts? Thanks thanks thanks

05-27-2010, 01:02 PM	#2
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,248	theirs a search and replace wordpress plugin __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

05-27-2010, 01:03 PM	#3
Marquis85 Confirmed User Industry Role: Join Date: Apr 2009 Posts: 622	I'm looking for one as well but for the time being, the plugin called SEO Smart Links might be what you're looking for. __________________ Last 3 months SCORECash ratio: 1:237

05-27-2010, 01:10 PM	#4
Emil Confirmed User Join Date: Feb 2007 Location: Sweden Posts: 5,623	update `wp_posts` set `post_content` = replace(`post_content`, ‘replace_that’, ‘with_this’); __________________ Free 🅑🅘🅣🅒🅞🅘🅝🅢 Every Hour (Yes, really. Free ₿itCoins.) (Signup with ONLY your Email and Password. You can also refer people and get even more.)

05-27-2010, 01:39 PM	#8
d-null . . . Industry Role: Join Date: Apr 2007 Location: NY Posts: 13,724	the op might be talking about mass changing varying links throughout a blog, in which case the problem becomes much more difficult say you have 1000 different links to different landing pages within a sponsor that turned bad, you need a sophisticated regexp or something to find those link strings and pull them out and replace them with something else __________________ __________________ Looking for a custom TUBE SCRIPT that supports massive traffic, load balancing, billing support, and h264 encoding? Hit up Konrad! Looking for designs for your websites or custom tubesite design? Hit up Zuzana Designs Check out the #1 WordPress SEO Plugin: CyberSEO Suite

05-27-2010, 01:33 PM	#7
Fat Panda Porn is Dead. Move along. Industry Role: Join Date: Aug 2006 Posts: 13,295	i would use search and replace

05-27-2010, 02:31 PM	#11
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,248	stop hand coding each link, its best, so you can just change them via the link ad manager. without dealing with the hassle __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

05-27-2010, 03:08 PM	#12
Houdini Confirmed User Join Date: Dec 2001 Location: SoCal Posts: 1,651	Had the same problem on a 1200+ posts blog and used this plugin. Worked like a charm. http://thedeadone.net/download/searc...dpress-plugin/

05-28-2010, 01:37 AM	#13
LoveSandra So Fucking Banned Join Date: Aug 2008 Location: Just Blow Me Posts: 10,551	Bump for you

05-28-2010, 05:15 AM	#14
Hentaikid Confirmed User Join Date: Nov 2002 Posts: 1,249	What emil said, only you do it in phpmyadmin working on the database not in wordpress itself