Update Your Referral Link Now

August 27, 2007 by  

If you are a (TLA) publisher you may have received their email notifying publishers that they have begun using

The purpose is to shorten and secure the affiliate referral link.

It’s important that you do this today because your current affiliate link will no longer work starting next month.


I quote their email below

As a Text Link Ads affiliate we’re pleased to let you know that we’ve begun using to shorten and secure our affiliate referral links. We encourage you to update your affiliate links using the following:

Homepage URL

Starter Promo URL

** Please note that our old affiliate urls will no longer work in one week so please update today. Thank you!


Personally I think this move is quite unnecessary and might not be the best thing to do due to the following reasons:

The original affiliate link is already short, making it five characters shorter or so won’t make any different.

While I appreciate their attempt to offer a secure affiliate link, it won’t prevent anyone from signing up with TLA directly. In addition, using a shorter URL service that can be abused by spammers would cost TLA the users’ trust. Some people might be reluctant to click on the link because they don’t know where it may take them.

Anyone who has been promoting TLA heavily would have to hunt down every single links in their blogs and this could mean a lot of unnecessary work. To make this task easier, you can use phpMyAdmin or any MYSQL tool for that matter to update your existing links all at once.

This method works for WordPress blog only. To get started enter the following command into phpMyAdmin

UPDATE `wp_posts` SET `post_content` = REPLACE ( `post_content` , "OLD_TLA_AFF" , "TINYURL_TLA_AFF" )

In case of, the line would be

UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, "", "")



It took me less than one second to update all my TLA links in all my post. I had to update the link on my sidebar manually though. Just be sure to backup your database before running this command.

Did you enjoy this post? Please subscribe via RSS or email.

Related posts


RSS feed | Trackback URI


Comment by Wallace
2007-08-27 17:09:01

it is quite stupid and not necessary to annoy our bloggers, i never hide any affiliate links, anyway i still get some coins every month. btw, seems a rubbish site and TLA have many choices…

Comment by papajoneh
2007-08-27 19:22:19

All credit to thanks for pointing this out gaman. Azmeen from HTNet has something to say about this too. 🙂

Comment by ben
2007-08-27 23:36:00

you can preview tinyurl URL to find out where it leads to first.

Comment by Gaman
2007-08-28 01:53:40

The extra work needed defeats having a short URL in the first place. Besides only a handful of people know how to do the preview

Comment by ben
2007-08-28 16:29:14

Probably not a few people are petitioning TLA to reconsider their plans now?

(Comments wont nest below this level)
Comment by Gaman
2007-08-28 16:51:36

At least I think it won’t help TLA in the long term

Comment by Mr. Rajawang
2007-08-27 23:36:26

why don’t TLA buy its own site that is more shorter if they really want to ?

Comment by
2007-08-28 01:31:15

Thanks for the reminder. I had read this before, but forgot!

Comment by Wahlau.NET
2007-08-28 11:15:15

i believe that the old link still works

Comment by Gaman
2007-08-28 11:59:35

Yes for now but not next month

Comment by Patches and Hacks
2007-09-19 05:54:14

If you don’t want to execute a sql query manually every time you want to change a link you might want to look into my new plugin for wordpress that let’s you use hidden affiliate links that you can easily manage from a nice web interface in wordpress admin.
here is where you can find out more about this free plugin:

Name (required)
E-mail (required - never shown publicly)
Your Comment (smaller size | larger size)
You may use <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> in your comment.

Trackback responses to this post