Invalid SQL: REPLACE INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('agjfw7fqau75g7hsie60j7jpqgk0v7ln', '216.73.216.77', '1752610811', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatibl', '0', '40', '0', '1752610811', '0'); (The table 'swsessions' is full) Nanacast - Powered By Kayako eSupport Setting up an affiliate link redirect script for having your affiliate links on your domain name

Article Details
URL: http://support.nanacast.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=5
Article ID: 5
Created On: 23 Mar 2009 07:51 PM

Answer To set up a redirect script for hosting your own affiliate links, create a file called .htaccess and place it in the root directory for your domain name.  Or if an htaccess file already exists on your server then you will want to put these lines in your existing file. 

This must be on a server running apache.

In that file, place either of the following:

# support for nanacast link campaigns
RewriteEngine On
RewriteRule ^go/([0-9]+)/?([0-9]*)/?([0-9]*)/?$ http://nanacast.com/vp/$1/$2/$3 [last]

OR

# without support for nanacast link campaigns
RewriteEngine On
RewriteRule ^go/([0-9]+)/?([0-9]*)/?$ http://nanacast.com/vp/$1/$2 [last]

Notes:

1.  "go/" can be any directory that you choose, so long as a directory by that name doesn't already exist on your server
2.  Your affiliates can now use http://example.com/go/your_product_id/affiliate_id/optional_link_campaign_id/  and that will redirect through nanacast.com, set cookies, and end up at your product sales page

Keywords: Affiliate Link, redirect script, redirect link