The Ventrino LTE Manual Exchange comes with a number of high gravity ClickBank links. These were added so that there is something to see with some viariety to get you started. I expted people would delete them and a few of their own prior to launch. However I was asked if they could be updated to use the owners hop link, which they can. Here’s how it’s done:
Run the following code in your SQL viewer or phpmyadmin, whatever you prefer, but replace your-clickbank-id-here with your ClickBank ID.
UPDATE links SET link = REPLACE( link, 'ratemyop', 'your-clickbank-id-here' )
Don’t change anything else, make sure you do not disturb the ‘ otherwise it won’t work.
The code will replace all of the “ratemyop” entriies with your ID instead.
Tags: Affiliate Links, ClickBank, MySQL, SQL, traffic exchange, traffic exchange script
