/*
* referers.php (c) plebian.com 1999-2004
*
* view.php
* View current list of referrers
*/
// put your header file include here
require_once('config.php');
/*
* Get rid of old referrers
*/
if(is_int($number_of_days))
{
$seconds=time()-(86400*$number_of_days);
mysql_query("delete from TW_referers where time < $seconds");
if(mysql_affected_rows())
mysql_query("optimize table TW_referers");
}
/*
* This is the html that will appear in your "top x referrers list" that would usually appear on every page
* Anything starting with $saved will also be in that.
*/
$saved='';
/*
* This is the html that will appear in this page (view all referrers)
* Anything starting with echo will also be in that.
*/
echo '';
$c=mysql_query("select max(id) as id,url,sum(hitsout) as hitsout,count(*) as hitsin from TW_referers group by url having hitsin >= $minimum_hits order by hitsin desc");
$num=mysql_num_rows($c);
if($num>0)
{
$j=1;
while($d=mysql_fetch_object($c))
{
$d->url=stripslashes($d->url);
if($j<=$number_referers)
{
if(array_key_exists($d->url,$url_replace))
{
$url=$url_replace[$d->url];
$get_domain=true;
}
elseif($include_tld)
{
$url=(substr($d->url,0,3)=='www')?substr($d->url,4,strlen($d->url)):$d->url;
$size=strlen($url);
if(!($size>$maxlength))
$get_domain=true;
}
if(!isset($get_domain))
{
$url=explode('.',$d->url);
$url=($url[0]=='www')?$url[1]:$url[0];
$url=substr($url,0,$maxlength);
}
unset($get_domain);
$x=$j%$num_per_row;
/*
* edit me
*
* $d->url == url
* $url == title
* $d->hitsin == hits in from the site
* $d->hitsout == hits sent out to site
*
* to count hits out, you must link to; go.php?$d->id or go.php?j=$d->url
*
* Don't forget to edit line 102 as well
*/
$saved.="id\" title=\"in/out - $d->hitsin/$d->hitsout\" target=\"$d->id\">$url# ";
if($x==0)
{
$saved.="";
if($j<$num)
{
$saved.='';
}
}
$j++;
}
$url=(array_key_exists($d->url,$url_replace))?$url_replace[$d->url]:$d->url;
/*
* edit me
*/
echo "» id\" title=\"in/out - $d->hitsin/$d->hitsout\" target=\"$d->id\">$url";
}
/*
* edit me
*/
$saved.="";
}
else
{
$saved.='no referrers yet';
}
$saved.='';
echo '';
if(is_writable('referrers.txt'))
{
$f=fopen('referrers.txt','w');
fwrite($f,$saved);
fclose($f);
}
else
{
echo "Unable to save referrers.txt: Permission denied.";
}
unset($saved);
// put your footer file include here
?>