Changing affiliate codes in WP post

LD · 2009-05-21, 09:09 AM

Is there a utility for this? This is a mainstream site with amazon ads.

Cleo · 2009-05-21, 09:23 AM

You could use PhpMyAdmin to do a search and replace on the codes in the MySQL database.

LD · 2009-05-21, 11:01 AM

Thanks Cleo...I'm not familiar with using PhpMyAdmin, but it looks pretty straighforward and I have worked with other database tools.

cd34 · 2009-05-21, 11:13 AM

Code:

create table wp_postsbk select * from wp_posts;
update wp_posts set post_content=replace(post_content,'oldstringtoreplace','newstringtouse');

if you mess up:

Code:

delete from wp_posts;
insert into wp_posts select * from wp_postsbk;

HowlingWulf · 2009-05-21, 11:25 AM

A Google search turned up http://thedeadone.net/download/searc...dpress-plugin/

LD · 2009-05-21, 02:34 PM

Google...who woulda thought...

nate · 2009-05-21, 08:15 PM

Quote:

Originally Posted by cd34

Code:

create table wp_postsbk select * from wp_posts;
update wp_posts set post_content=replace(post_content,'oldstringtoreplace','newstringtouse');

Its scary what some people can quote off the top of their head.

LD · 2009-05-21, 11:37 PM

Quote:

Originally Posted by nate

Its scary what some people can quote off the top of their head.

cd34 knows his shit!

Howling, that plug worked like a charm! It took about 5 seconds...no problems whatsoever.

bDok · 2009-05-22, 12:19 AM

I know there is a great plugin for wordpress that is actually great for links like that.

another thing that I know that was just released is a free link directing script. Made by the same guy that did tevs tube script. I'll find a link later.

edit:

nevermind simple google found it.

http://www.bigdotmedia.com/

he's calling it tracking adult links sytem (tals).

so then you can change certain things out real easy in the future.

Simon · 2009-05-22, 07:25 AM

Just a quick note that you may want to always back up your WP databases before using any of the available plugins to change all your codes in one click. That was something that cd34's code handled by first creating a new table and copying your post data into it in case you needed to revert back to it. Anyone who's ever totally screwed a database with search and replace knows the value of that one line of code.

LD · 2009-05-22, 08:31 AM

Quote:

Originally Posted by Simon

Just a quick note that you may want to always back up your WP databases before using any of the available plugins to change all your codes in one click. That was something that cd34's code handled by first creating a new table and copying your post data into it in case you needed to revert back to it. Anyone who's ever totally screwed a database with search and replace knows the value of that one line of code.

yes... i kept a local copy before running the plug.

2009-05-21, 09:09 AM	#1
LD wtfwjd? Join Date: May 2007 Posts: 2,103	Changing affiliate codes in WP post Is there a utility for this? This is a mainstream site with amazon ads. __________________ Artisteer Wordpress Theme Generator Create Custom Themes! My Little Network

2009-05-21, 09:23 AM	#2
Cleo Subversive filth of the hedonistic decadent West Join Date: Mar 2003 Location: Southeast Florida Posts: 27,936	You could use PhpMyAdmin to do a search and replace on the codes in the MySQL database. __________________ Free Rides on Uber and Lyft Uber Car: uberTzTerri Lyft Car: TZ896289

2009-05-21, 11:01 AM	#3
LD wtfwjd? Join Date: May 2007 Posts: 2,103	Thanks Cleo...I'm not familiar with using PhpMyAdmin, but it looks pretty straighforward and I have worked with other database tools. __________________ Artisteer Wordpress Theme Generator Create Custom Themes! My Little Network

2009-05-21, 11:13 AM	#4
cd34 a.k.a. Sparky Join Date: Sep 2004 Location: West Palm Beach, FL, USA Posts: 2,396	Code: create table wp_postsbk select * from wp_posts; update wp_posts set post_content=replace(post_content,'oldstringtoreplace','newstringtouse'); if you mess up: Code: delete from wp_posts; insert into wp_posts select * from wp_postsbk; __________________ SnapReplay.com a different way to share photos - iPhone & Android

2009-05-21, 11:25 AM	#5
HowlingWulf Me fail English? That's unpossible! Join Date: Dec 2003 Location: FL Posts: 1,381	A Google search turned up http://thedeadone.net/download/searc...dpress-plugin/ __________________ WordPress Porn directory theme => Maddos Create a Porn Tube => Video Pornster

2009-05-21, 02:34 PM	#6
LD wtfwjd? Join Date: May 2007 Posts: 2,103	Google...who woulda thought... __________________ Artisteer Wordpress Theme Generator Create Custom Themes! My Little Network

2009-05-22, 12:19 AM	#9
bDok bang bang Join Date: Mar 2005 Location: SD/OC/LA Posts: 3,241	I know there is a great plugin for wordpress that is actually great for links like that. another thing that I know that was just released is a free link directing script. Made by the same guy that did tevs tube script. I'll find a link later. edit: nevermind simple google found it. http://www.bigdotmedia.com/ he's calling it tracking adult links sytem (tals). so then you can change certain things out real easy in the future. __________________ submit to Nymphotic submit to Moistlace

2009-05-22, 07:25 AM	#10
Simon That which does not kill us, will try, try again. Join Date: Aug 2003 Location: Conch Republic Posts: 5,150	Just a quick note that you may want to always back up your WP databases before using any of the available plugins to change all your codes in one click. That was something that cd34's code handled by first creating a new table and copying your post data into it in case you needed to revert back to it. Anyone who's ever totally screwed a database with search and replace knows the value of that one line of code. __________________ "If you're happy and you know it, think again." -- Guru Pitka