Need a simple affiliate/referral script to track unique visitors

**dwmeso** · 12-11-2007, 09:40 PM

I'm looking for a script that will allow users to sign up for an affiliate ID and track unique hits using that affiliate id

Every affiliate script i find has all this extra stuff in it that i have no use for. I don't want it to track ads or anything like that. I just need it to count unique visitors with a little backend that shows users how many referrals they have accumulated and an admin panel to manage users and show their stats. Also, maybe a page that shows the top 10 affiliates, sorted by the ammount of unique visitors they have referred to my site.

Anyone have any idea where I can find a script like this or what it might cost to have it made?

**mattigins** · 12-12-2007, 02:43 AM

I can do this for you for $50 USD, will take about a week or 2.

Contact me,
MSN: matt@pardio.net

Email: mr.delly2@gmail.com

**dwmeso** · 12-12-2007, 06:37 AM

Do you have a portfolio or any work that I can check out? I was recently ripped off for some other work I needed done, so without feedback or itrader rating I'm a bit hesitant to pay up front.

**chrishirst** · 12-13-2007, 06:11 AM

Amazing how someone can offer up a price without even knowing what server side code it needs!

**habbotothemax** · 12-13-2007, 07:35 AM

Quote:

Originally Posted by mattigins

I can do this for you for $50 USD, will take about a week or 2.

Contact me,
MSN: matt@pardio.net

Email: mr.delly2@gmail.com

Lmao , sure

Quote:

Originally Posted by chrishirst

Amazing how someone can offer up a price without even knowing what server side code it needs!

ahaha i knoo werd

**dwmeso** · 12-14-2007, 05:12 AM

I'd like it to be PHP, by the way.

**chrishirst** · 12-16-2007, 03:44 PM

I have a page view tracking script in PHP somewhere, does the same as this ASP one
I'll dig it out see what it would take to modify it.

**FreelancerStore** · 01-20-2008, 09:08 PM

i agree, some are very greedy for money, no matter what the cost.

Quote:

Originally Posted by chrishirst

Amazing how someone can offer up a price without even knowing what server side code it needs!

**chrishirst** · 01-25-2008, 03:19 PM

get around to this eventually

PHP Code:


			
$DBhost = "host_server";

$DBuser = "UserName";

$DBPass = "PassWord";

$DBName = "Database";



function tracker() {

global $HTTP_SERVER_VARS;

if (array_key_exists("HTTP_REFERER",$_SERVER)) {

    $referer = "'". $HTTP_SERVER_VARS["HTTP_REFERER"] . "'";

} else {

    $referer = "'--'";

}

if (array_key_exists("QUERY_STRING",$_SERVER)) {

    $querystring = "'". $HTTP_SERVER_VARS["QUERY_STRING"] . "'";

} else {

    $querystring = "'--'";

}

$today = "'" . date('Y/m/d') . "'" ;

$now = "'" . date('H:i:s') . "'" ;

$remoteip = "'" . $HTTP_SERVER_VARS["REMOTE_ADDR"] . "'" ;

$page = "'" . $HTTP_SERVER_VARS["PHP_SELF"] . "'" ;

$method = "'" . $HTTP_SERVER_VARS["REQUEST_METHOD"] . "'" ;

$useragent = "'" . $HTTP_SERVER_VARS["HTTP_USER_AGENT"] . "'" ;

$db = mysql_connect($DBhost, $DBuser, $DBpass);

mysql_select_db($DBName, $db);

//$sql ="SELECT * FROM _tracker";

//$result = mysql_query($sql);



$sql = "INSERT INTO _tracker (accessdate,accesstime,remoteip,refererurl,siteurl,querystr,method,useragent) VALUES ($today,$now,$remoteip,$referer,$page,$querystring,$method,$useragent)";

$result = mysql_query($sql);

mysql_close($db);

}

SQL code for creating the DB and tables

Code:

# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 192.168.5.10
# Database:             remote
# Server version:       5.0.27-community-nt
# Server OS:            Win32
# max_allowed_packet:   1048576
# HeidiSQL version:     3.0 RC4 Revision: 334
# --------------------------------------------------------

/*!40100 SET CHARACTER SET latin1;*/


#
# Database structure for database
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `change_database_name` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE change_database_name;


#
# Table structure
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ `_tracker` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `accessdate` date default NULL,
  `accesstime` time default NULL,
  `remoteip` char(15) default NULL,
  `refererurl` char(254) default NULL,
  `siteurl` char(254) default NULL,
  `querystr` char(254) default NULL,
  `method` char(6) default NULL,
  `useragent` char(254) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3425 DEFAULT CHARSET=latin1;

If you need it to get a specific querystring value add it to the script and a database field.
It just needs an admin panel with some built in queries to filter and extract the required records.

**joshua__lim** · 04-22-2008, 07:34 AM

Chrishirst, i tried your code, it is very useful, except one thing, i've to remove " DEFAULT CHARSET=latin1" before it can work.

Has anyone done a console to read from this table? I wish i could do it but i can't program php.