How to Update Text Link Ads Affiliate TinyURL in One Shot

Filed in: Make Money Online, Text Link Ads tips — August 24th, 2007

Text Link AdsText 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:

PLAIN TEXT
SQL:
  1. UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, "OLD_TLA_AFF", "TINYURL_TLA_AFF")

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.

technorati tags , , , ,

Popularity: 2% [?]

Read also:

« Listed in BOTW Blog Directory
Embed Google Maps to Any Website »

9 Responses to “How to Update Text Link Ads Affiliate TinyURL in One Shot”

Comments Feed | TrackBack URL
  1. #1
    Rice Blogger Says:
    August 24th, 2007 at 1:51 pm

    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

  2. #2
    KennyP Says:
    August 24th, 2007 at 3:55 pm

    I found the new url is redirecting to the old url, so what’s the point

  3. #3
    Bitbot Says:
    August 25th, 2007 at 10:30 am

    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?

  4. #4
    LcF Says:
    August 25th, 2007 at 2:27 pm

    @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. :)

  5. #5
    Bitbot Says:
    August 26th, 2007 at 10:53 am

    Thanks for sharing LiewCF!

  6. #6
    Update Your Text-Link-Ads.com Referral Link Now « Sabahan.com Says:
    August 27th, 2007 at 2:20 pm

    [...] (credit: LiewCF.com) [...]

  7. #7
    Speedlinking 28/08/2008 Says:
    August 28th, 2007 at 9:53 pm

    [...] Update TLA Affiliate Links in One Shot - If you are a TLA publisher, I believe you have received an email from TLA claims that TLA is now using TinyURL.com to shorten and secure its affiliate referral links. Don’t be headache of how to update all the links in your posted articles. LiewCF posted on how to Update Text Link Ads Affiliate TinyURL in One Shot. (I have tried it, I think it’s more than “One” shot…) Tags: No Tags Share This •If you enjoyed this post, get Free Updates by Email or RSS. « Download Latest Shockwave Player adv_username = “kayintkh”; adv_gid = “kayintkh_default”; adtype = “336×280″; _uacct = “UA-1466866-1″; urchinTracker(); [...]

  8. #8
    Patches and Hacks Says:
    September 19th, 2007 at 5:45 am

    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

  9. #9
    toptank Says:
    January 10th, 2008 at 1:40 am

    I never liked TLA. I don’t think Feedvertising will work.

Leave a Reply

Subscribe without commenting