|
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 .
ID : unique ID for each adveriser
advertiser : advertiser unique name
description : text description to
display
programtype : Is it a sale , lead
, click etc
commission : what is the percentage
you get
clicks : number of clicks
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 dtaa.
#
# 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);
|