How To Update Text Link Ads Affiliate URL Easily
ADVERTISEMENTSLast month Text Link Ads (TLA) started using tinyurl.com to shorten and secure it’s affiliate referral links and had asked TLA publishers to update their affiliate links before the end of the month.
I have used my TLA affiliate links in many posts and so I had not updated my posts until I found an easier method thanks to Liew who has explained on how to update all the old TLA affiliate links in one shot (WordPress only) using Mass String Replace in MySQL.
Using the below MySQL query, I was able to update all my posts containing Text Link Ads affiliate links in a few seconds:
UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, "OLD_TLA_AFF", "NEW_TLA_AFF")
Please note that OLD_TLA_AFF should be replaced with your old Text Link Ads affiliate URL and NEW_TLA_AFF replaced with the new Text Link Ads affiliate URL.
If you have not signed up for Text Link Ads yet, do try them out and make money by selling links on your blog. Also read my Text Link Ads review and my post on how to make more money with Text Link Ads.
Search JohnTP.com or view a random post
Related Articles
Find out what I am doing currently by .
Posted on September 13th, 2007 | Category: Make Money Online |
Mike - Twenty Steps
September 14, 2007 at 6:53 am
John - you might be interested to know that because so many TLA affiliates kicked up about this that they actually reversed the decision and it’s no longer compulsory to change the affiliate links.
Rob Malon
September 14, 2007 at 6:20 pm
Those horrible tiny urllinks
I still don’t understand why…
I wrote a tutorial on how to cover them and other affiliate links up, hope its useful in conjunction with this:
http://www.robmalon.com/increa.....ing-links/
Ajay
September 15, 2007 at 9:00 pm
Actually, an easier way to do this is to install the Search and Replace plugin for WordPress and then use it.
newbies may find it a problem to edit the database.
I got an easier system. I use a click counter on my blog for this and then just link to that. That means changing in a single location only.
Patches and Hacks
September 19, 2007 at 3:14 am
If you want to hide the affiliate links so that you don’t have to change all the posts again if any of them changes, and you are using wordpress you might want to look into my new plugin that will let you manage such links from your wordpress admin.
the pluging is free and you can find out more about it here:
http://patchlog.com/wordpress/.....ate-links/
JTPRATT's Blogging Mistakes
September 27, 2007 at 11:48 pm
Personally John, I don’t know why you or others would use TLA when you could get a google penalty for using Text Link Ads. I know many use them still, but it’s a complete violation of google’s web quality guidelines. With a google penalty you could lose all of your google traffice overnight - I won’t risk that, which is why I took my text link ads down.
Mike - Twenty Steps
October 1, 2007 at 6:23 pm
Sorry but that’s completely inaccurate. You will NOT be delisted from the index for running TLA on your site. Google have clearly stated that the only penalty for buying or selling links is the reduction in your sites ability to pass PageRank. This is yet another example of the Google FUD Factor.
JTPRATT's Blogging Mistakes
October 2, 2007 at 12:00 am
I don’t agree. Matt Cutts has been VERY clear that buying links for traffic is fine, but buying links for link juice (like TLA does) is completely against their quality guidelines. That’s why using something like AdBrite is fine (ads served with javascript) and TLA is not (you can’t use rel=”nofollow” at all).
Mike - Twenty Steps
October 2, 2007 at 4:36 am
He’s also been very clear that the only penalty is removing the ability to pass PageRank. You won’t be deindexed.
JTPRATT's Blogging Mistakes
October 2, 2007 at 6:11 am
Show me where he’s said that you will remove the ability to pass page rank and you will absolutely not incur a -30 or -950 penalty? If he has said this I have not yet seen it.