List only unique http referrers

Posted: Sat Oct 02, 2004 3:50 pm

Open index.php in the root Nuke directory.
Around lines 25 through 36 find the following...

Code:

if ($httpref==1) {
$referer = $_SERVER["HTTP_REFERER"];
$referer = check_html($referer, nohtml);
if ($referer=="" OR eregi("^unknown", $referer) OR substr("$referer",0,strlen($nukeurl))==$nukeurl OR eregi("^bookmark",$referer)) {
} else {
$result = $db->sql_query("INSERT INTO ".$prefix."_referer VALUES (NULL, '$referer')");
}
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_referer"));
if($numrows>=$httprefmax) {
$result2 = $db->sql_query("DELETE FROM ".$prefix."_referer");
}
}

Replace with the following...

Code:

if ($httpref==1) {
$url = $_SERVER["HTTP_REFERER"];
$url = check_html($url, nohtml);
if ($url=="" OR eregi("^unknown", $url) OR substr("$url",0,strlen($nukeurl))==$nukeurl OR eregi("^bookmark",$url)) {
echo "";
} elseif ($db->sql_numrows($db->sql_query("SELECT url FROM ".$prefix."_referer WHERE url='$url'")) > 0) {
echo "";
} else {
$result = $db->sql_query("INSERT INTO ".$prefix."_referer VALUES (NULL, '$url')");
}
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_referer"));
if($numrows>=$httprefmax) {
$result2 = $db->sql_query("DELETE FROM ".$prefix."_referer");
}
}

This will stop duplicate referrers from being stored in the database.

Posted: Sat Oct 02, 2004 5:12 pm

Nice nice!

Posted: Sat Oct 02, 2004 7:20 pm

I forgot to mention to NOT use this code if you use a block or module that lists top referrers. Very Happy

Posted: Sat Oct 02, 2004 7:50 pm

Does this includes MSA too? Since it uses it's own database and files to collect information.

Posted: Sat Oct 02, 2004 8:17 pm

If MSA uses it's own database and does not share data with the nuke_referer table then it shouldn't be affected.
Any module or block that shares data from the nuke_referer table is affected by this modification.
I don't use any other blocks/modules that use that table, other than the http referers admin module. I don't know about you, but I get tired of wading through the redundant urls.

Posted: Fri Mar 04, 2005 7:23 am

Does this work with PHPNuke 7.6?

Posted: Fri Mar 04, 2005 2:24 pm

Yes, I believe it will work for PHP-Nuke Version 7.6.

Sergeant Joined: Aug 28, 2004 Posts: 119

I was looking in my index.php (nuke 7.5) and its kinda different:

if ($httpref==1) {
$referer = $_SERVER["HTTP_REFERER"];
$referer = check_html($referer, nohtml);
if ($referer=="" OR eregi("^unknown", $referer) OR substr("$referer",0,strlen($nukeurl))==$nukeurl OR eregi("^bookmark",$referer)) {
} else {
$sql = "INSERT INTO ".$prefix."_referer VALUES (NULL, '$referer')";
$result = $db->sql_query($sql);
}
$sql = "SELECT * FROM ".$prefix."_referer";
$result = $db->sql_query($sql);
$numrows = $db->sql_numrows($result);
if($numrows>=$httprefmax) {
$sql = "DELETE FROM ".$prefix."_referer";
$result = $db->sql_query($sql);
}
}

Any suggestions?

Posted: Mon Mar 14, 2005 12:54 pm

Luciel wrote:

I was looking in my index.php (nuke 7.5) and its kinda different:
Any suggestions?

You can replace it with the code I previously posted.

Sergeant Joined: Aug 28, 2004 Posts: 119

kk, ill do it later today and post the result