Clickbank affiliate link generator

This script came about on one of my trips when I noticed people selling clickbank SALES BOOSTER type scripts.

The first thing of course is that you require a CLICKBANK ID . .

The concept is as follows you enter some links in a database as found on the clickbank website, you add your affiliate ID and display the links on your page , you get commisions based on any leads or sales. With no further ado lets take a look at the database structure .

Our database is quite simple but it consists of 6 fields .

In the following example we use the advertiser field and description field . The programtype and commision fields are added for an exercise for the user , with these you could only select certain types of programs say leads only and this would display only these links. The same goes for percentage you could sort by percentage, display only above a certain percentage .

The following is the MySQL dump of the database with some links available already . Using PhpMyAdmin it is a straightforward task to add this data.

#
# Table structure for table `links`
#

CREATE TABLE links (
ID int(11) NOT NULL auto_increment,
advertiser varchar(50) default NULL,
description text,
progtype varchar(10) default NULL,
commission double default NULL,
clicks int(11) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;

#
# Dumping data for table `links`
#

INSERT INTO links VALUES (1, 'brmarlin', 'get exit killer now and stop all pop ups', 'sale', '40', 0);
INSERT INTO links VALUES (2, 'e2success', 'Email 75 Million Targeted Prospects Every Month', 'sale', '50', 0);
INSERT INTO links VALUES (3, 'acronoid', 'Affordable Attractive & Professional Website Templates', 'sale', '50', 0);
INSERT INTO links VALUES (4, 'fbcom', 'home brewed and hand-rolled Flash banner animations', 'sale', '25', 0);
INSERT INTO links VALUES (5, 'DOMAINSBOT', 'search our huge database of onhold domains', 'sale', '50', 0);
INSERT INTO links VALUES (6, 'ntchosting', '$5.00 web hosting', 'sale', '60', 0);
INSERT INTO links VALUES (7, 'dvdripper', 'Guide to DVDs.', 'sale', '50', 0);
INSERT INTO links VALUES (8, '75million', 'Blast your ads to 2.5million+ recipients EVERYDAY SPAM FREE', 'sale', '50', 0);
INSERT INTO links VALUES (9, 'automail', 'Email more than 1.000.000 opt-in recipients spam free', 'sale', '50', 0);
INSERT INTO links VALUES (10, 'clsurfer', 'Anyone can find out what you have been doing on the Internet', 'sale', '50', 0);