How to Update Text Link Ads Affiliate TinyURL in One Shot
Text Link Ads (TLA) have begun using TinyURL.com to shorten and secure its affiliate referral links.
TLA publishers are advised to update their TLA affiliate links immediately because the old affiliate URLs will no longer work after August 2007.
If you only have TLA affiliate links on your website template, it is easy to update the URLs. However, if you have a couple of posts with TLA affiliate links in the post body like me (Text Link Ads Tips, it could be troublesome to dig them out and edit one by one.
Here I show you how to update all the old TLA affiliate links in one shot (WordPress only) using Mass String Replace in MySQL:
[sql]UPDATE wp_posts SET post_content = REPLACE(post_content, “OLD_TLA_AFF”, “TINYURL_TLA_AFF”)[/sql]
OLD_TLA_AFF — your old Text Link Ads affiliate URL.
TINYURL_TLA_AFF — the new Text Link Ads affiliate URL using TinyURL.com you received.
Using the MySQL query, I updated all the posts containing TLA affiliate links in 1 minute. Fast, clean, and easy! :)
By the way, here I assume you know how to run a MySQL query. Contact me if you need help.
I always wanted to make my blog contents available in different languages but no auto translation services are accurate enough to be read by human.
duller.kukuchew.com actually notify me on my blog saying that this may be a prank, I believe there is some chance….better stick to original until it is verify
I found the new url is redirecting to the old url, so what’s the point
Hey liewCF, thanks for bringing attention to this ad service. I know you’ve tried out various ad programs before so my question is, which ad program (nuffnang, TLA, Google Ads, Advertlets etc) is the most effective revenue generator?
@Bitbot: AdSense is still my biggest earner. CPM ads and TLA do well too. I am not a member of nuffnang/advertlets yet. It is not important which one is most effective to me, but which one most effective to You. :)
Thanks for sharing LiewCF!
This is a great tip, but if you don’t want to go into executing mysql queries every time a link changes you might want to look into my new plugin for wordpress that hides the affiliate links and let’s you manage them from the wordpress admin
You can find out more about this plugin here:
http://patchlog.com/wordpress/hidden-affiliate-links/
the plugin is Free
I never liked TLA. I don’t think Feedvertising will work.