Replaced Referers page with plugin.

git-svn-id: http://svn.automattic.com/wordpress-mu/trunk@19 7be80a69-a1ef-0310-a953-fb0f7c49ff36

4 files changed, 678 insertions, 455 deletions

diff --git a/wp-inst/wp-admin/menu.php b/wp-inst/wp-admin/menu.php
index e0054d4..c087250 100644
--- a/wp-inst/wp-admin/menu.php
+++ b/wp-inst/wp-admin/menu.php
@@ -28,8 +28,6 @@ $submenu['edit.php'][5] = array(__('Posts'), 1, 'edit.php');
 $submenu['edit.php'][10] = array(__('Pages'), 5, 'edit-pages.php');
 $submenu['edit.php'][15] = array(__('Categories'), 1, 'categories.php');
 $submenu['edit.php'][20] = array(__('Comments'), 1, 'edit-comments.php');
-$referers = $wpdb->get_var( "SELECT sum( visitTimes ) FROM " . $table_prefix . "referer_visitLog WHERE blogID='".$wpblog."' AND dayofmonth='".date( 'j' )."'" );
-$submenu['edit.php'][21] = array(sprintf(__("Referers (%s)"), $referers ), 1, 'referers.php' );
 $awaiting_mod = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0'");
 $submenu['edit.php'][25] = array(sprintf(__("Awaiting Moderation (%s)"), $awaiting_mod), 1, 'moderation.php');
 $submenu['edit.php'][30] = array(__('Files'), 8, 'templates.php');
diff --git a/wp-inst/wp-admin/referers.php b/wp-inst/wp-admin/referers.php
deleted file mode 100644
index 475770f..0000000
--- a/wp-inst/wp-admin/referers.php
+++ /dev/null
@@ -1,429 +0,0 @@
-<?php
-
-require_once('admin.php');
-$title = "Referers";
-$parent_file = 'edit.php';
-include( '../wp-config.php' );
-require_once("admin-header.php");
-
-$b2varstoreset = array('action','standalone', "day", "order", "num" );
-for ($i=0; $i<count($b2varstoreset); $i += 1) {
-	$b2var = $b2varstoreset[$i];
-	if (!isset($$b2var)) {
-		if (empty($HTTP_POST_VARS["$b2var"])) {
-			if (empty($HTTP_GET_VARS["$b2var"])) {
-				$$b2var = '';
-			} else {
-				$$b2var = $HTTP_GET_VARS["$b2var"];
-			}
-		} else {
-			$$b2var = $HTTP_POST_VARS["$b2var"];
-		}
-	}
-}
-
-function makeHiddenVals()
-{
-    $fields = array( "day", "order", "num", "more", "ignoreDIRECT", "visitID", "internal" );
-    reset( $fields );
-    while( list( $key, $field ) = each( $fields ) ) 
-    { 
-        if( $field == 'action' )
-        {
-            $sep = '?';
-        }
-        else
-        {
-            $sep = '&';
-        }
-
-        global $$field;
-        if( $$field != '' )
-            $vals .= "<input type='hidden' name='".$field."' value='".$$field."'>\n";
-    }
-    return $vals;
-}
-
-function makeURL( $var, $val )
-{
-    $fields = array( "action", "day", "order", "num", "more", "ignoreDIRECT", "visitID", "internal" );
-    reset( $fields );
-    while( list( $key, $field ) = each( $fields ) ) 
-    { 
-        if( $field == 'action' )
-        {
-            $sep = '?';
-        }
-        else
-        {
-            $sep = '&';
-        }
-        if( $field != $var )
-        {
-            global $$field;
-            if( $$field != '' )
-                $url .= $sep.$field."=".$$field;
-        }
-        else
-        {
-            $url .= $sep.$var."=".$val;
-        }
-    }
-    return $url;
-}
-
-if( $action == '' )
-{
-    $action = 'listday';
-    $day = date( 'j' );
-}
-
-print '<div class="wrap">';
-
-if( $action == 'Delete' )
-{
-    if( is_array( $del ) )
-    {
-        reset( $del );
-        while( list( $key, $val ) = each( $del ) ) 
-        { 
-            $query = "DELETE FROM " . $table_prefix . "referer_visitLog
-                      WHERE       visitID = '".$val."'
-                      AND          blogID = '".$wpblog."'";
-            $result = $wpdb->query($query);
-        }
-    }
-    $action = "listday";
-}
-elseif( $action == 'deletedirect' )
-{
-    $query = "DELETE FROM " . $table_prefix . "referer_visitLog
-        WHERE        dayofmonth='".$day."'
-        AND          referingURL = 'DIRECT'
-        AND          blogID = '".$wpblog."'";
-    $result = $wpdb->query($query);
-    printf ("Records deleted: %d\n", $wpdb->rows_affected);
-    $action = "listday";
-}
-elseif( $action == 'Add To Blacklist' )
-{
-    if( is_array( $del ) )
-    {
-        reset( $del );
-        while( list( $key, $val ) = each( $del ) ) 
-        { 
-            $query = "SELECT referingURL
-                      FROM   " . $table_prefix . "referer_visitLog
-                      WHERE  visitID = '".$val."'
-                      AND    blogID = '".$wpblog."'";
-            $result=$wpdb->get_var( $query );
-            if( $result )
-            {
-                $query = "INSERT INTO " . $table_prefix . "referer_blacklist VALUES( NULL, '".$wpblog."', '".$result."', NOW() )";
-                $result = $wpdb->query($query);
-            }
-        }
-    }
-    $action = "listday";
-}
-elseif( $action == 'deleteblacklist' )
-{
-    if( is_array( $del ) )
-    {
-        reset( $del );
-        while( list( $key, $val ) = each( $del ) ) 
-        { 
-                $query = "DELETE FROM " . $table_prefix . "referer_blacklist WHERE ID='".$val."' AND blogID = '".$wpblog."'";
-                $result = $wpdb->query($query);
-        }
-    }
-    $action = "blacklist";
-}
-
-switch( $action )
-{
-    case "blacklist":
-        $query = "SELECT * FROM " . $table_prefix . "referer_blacklist
-                  WHERE  blogID = '".$wpblog."'";
-        $result = $wpdb->get_results($query, ARRAY_A );
-        if( $result )
-        {   
-            print "<div class='wrap'><h2>Referer Blacklist</h2>";
-            print "<form action='referers.php' method='post'>";
-            print "<input type='hidden' name='action' value='deleteblacklist'>";
-            print "<input type='submit' value='Delete'>";
-            print "<table>";
-            $c = 1;
-            while( list( $key, $row1 ) = each( $result ) ) 
-            {
-                if( substr( $row1[ 'URL' ], 0, 16 ) == 'http://www.google' )
-                {
-                    $displayurl = "Google: ". substr( $row1[ 'URL' ], strpos( $row1[ 'URL' ], "search" )+6 );
-                }
-                elseif( strstr( $row1[ 'URL' ], 'search.yahoo' ) )
-                {
-                    $displayurl = "Yahoo: ". substr( $row1[ 'URL' ], strpos( $row1[ 'URL' ], "p=" )+2 );
-                }
-                elseif( strpos( $row1[ 'URL' ], 'www.blueyonder.co.uk' ) )
-                {
-                    $displayurl = "Blueyonder: ". substr( $row1[ 'URL' ], strpos( $row1[ 'URL' ], "q=" )+2 );
-                }
-                else
-                {
-                    $displayurl = $row1[ 'URL' ];
-                }
-                print "<tr><td>$c</td><td><a href='".$row1[ 'URL' ]."'>".$displayurl."</a></td><td><input type='checkbox' name='del[]' value='".$row1['ID']."'></td></tr>\n";
-                $c++;
-            }
-            print "</table>";
-            print "</form>";
-            print "</div>";
-        }
-        else
-        {
-            print "No URLs in blacklist yet!";
-        }
-        break;
-    case "listday":
-
-        $query = "select visitTimes,referingURL,date_format( visitTime, '%k:%i' ) as visitTime2, visitURL, visitID from " . $table_prefix . "referer_visitLog where dayofmonth='".$day."'";
-        if( $wpblog != 'root' )
-            $query .= " and blogID='".$wpblog."'";
-
-	if( $internal == 'yes' )
-	    $query .= " and referingURL NOT LIKE '".get_settings( "siteurl" )."%'";
-
-        if( $ignoreDIRECT == 'yes' )
-            $query .= " and referingURL != 'DIRECT'";
-
-        if( $order == '' || $order == 'time' )
-        {
-            $query .= " order by visitTime desc";
-        }
-        elseif( $order == 'hits' )
-        {
-            $query .= " order by visitTimes desc";
-        }
-        elseif( $order == 'url' )
-        {
-            $query .= " order by visitURL desc";
-        }
-        if( $num == '' )
-        {
-            $num = 0;
-        }
-        if( $more == '' || $more == '0' )
-            $more = '30';
-
-        $query .= " limit $num,$more";
-
-	$result = $wpdb->get_results($query, ARRAY_A );
-        $rows = $wpdb->num_rows;
-        if( $result )
-        {
-            // javascript from http://www.experts-exchange.com/Web/Web_Languages/JavaScript/Q_10105441.html and
-            // http://members.aol.com/grassblad/html/chkAllBut.html
-            print "<script langage='javascript'>
-                <!--
-                function selectAll(cbList,bSelect) {
-                    for (var i=0; i<cbList.length; i++)
-                        cbList[i].selected = cbList[i].checked = bSelect
-                }
-
-                function reverseAll(cbList) {
-                    for (var i=0; i<cbList.length; i++) {
-                        cbList[i].checked = !(cbList[i].checked)
-                            cbList[i].selected = !(cbList[i].selected)
-                    }
-                }
-                //-->
-                </script>";
-            $c = $num+1;
-            $nav = "<br /><div align='center'>";
-            $nav .= "<a href='referers.php?action=month'>Month View</a> | ";
-            $nav .= "<a href='referers.php".makeURL( "num", 0 )."'>Top</a>";
-            if( $ignoreDIRECT == 'yes' )
-            {
-                $nav .= " | <a href='referers.php".makeURL( "ignoreDIRECT", 'no' )."'>Display DIRECT requests</a>";
-            }
-            else
-            {
-                $nav .= " | <a href='referers.php".makeURL( "ignoreDIRECT", 'yes' )."'>Hide DIRECT requests</a>";
-            }
-            if( $internal == 'yes' )
-            {   
-                $nav .= " | <a href='referers.php".makeURL( "internal", 'no' )."'>Display internal requests</a>";
-            }
-            else
-            {   
-                $nav .= " | <a href='referers.php".makeURL( "internal", 'yes' )."'>Hide internal requests</a>";
-            }
-
-            if( $num >= 10 )
-            {
-                if( $num > $more )
-                {
-                    $nav .= " | <a href='referers.php".makeURL( "num", ( $num - $more ) )."'>Previous $more</a>";
-                }
-            }
-            else
-            {
-                $nav .= " | Previous";
-            }
-            if( $rows >= $more )
-            {
-                $nav .= " | <a href='referers.php".makeURL( "num", ($num + $more) )."'>Next $more</a>";
-            }
-            else
-            {
-                $nav .= " | Next";
-            }
-            $nav .= " | <a href='referers.php".makeURL( "more", ($more + 10) )."'>More Hits</a>";
-            $nav .= " | <a href='referers.php".makeURL( "more", ($more - 10) )."'>Less Hits</a>";
-            $nav .= "<br />";
-            print "<div class='wrap'><h2>Referers</h2>";
-            print $nav;
-            $today = date( 'd' );
-            if( $day > $today )
-            {
-                $month = date( 'F', mktime (0,0,0,date("m")-1,date("d"),  date("Y")) );
-            }
-            else
-            {
-                $month = date( 'F' );
-            }
-            print "<form action='referers.php' name='deletedirect'>";
-            print "<input type='hidden' name='action' value='deletedirect'>";
-            print makeHiddenVals();
-            print "</form>";
-            print "<form action='referers.php' name='referers'>";
-            print makeHiddenVals();
-            //print "<input type='hidden' name='action' value='delete'>";
-            print "<table border=0 cellspacing=0 cellpadding=2>";
-            print "<caption> Referers For $day $month</caption>";
-            print "<tr><th>#</th><th>Refering URL</th>
-                   <th><a href='referers.php".makeURL( "order", "hits" )."' title='order by hits'>Hits</a></th>
-                   <th><a href='referers.php".makeURL( "order", "url" )."' title='order by entry page'>Entry Page</a></th>
-                   <th><a href='referers.php".makeURL( "order", "time" )."' title='order by time'>Last</a></th>
-                   <th>Selected</th>
-                   </tr>
-                   <tr><td colspan='6' align='right'><INPUT TYPE=button VALUE='Select All' ONCLICK='selectAll(this.form,true)'>
-                   <INPUT class='edit' TYPE=button VALUE='Clear All' ONCLICK='selectAll(this.form,false)'>
-                   <INPUT class='edit' TYPE=button VALUE='Reverse' ONCLICK='reverseAll(this.form)'>
-                   &nbsp;|&nbsp;<input class='edit' type='submit' name='action' value='Delete' onclick='javascript:document.referers.submit()'>
-                   &nbsp;|&nbsp;<input class='edit' type='submit' name='action' value='Add To Blacklist'>
-                   &nbsp;|&nbsp;<input class='edit' type='button' name='action' value='Delete Direct Referers' onclick='javascript:document.deletedirect.submit()'></td></tr>\n";
-            while( list( $key, $row1 ) = each( $result ) ) 
-            {
-                if( $col == 'f5f5f5' )
-                {
-                    $col = 'ffffff';
-                }
-                else
-                {
-                    $col = 'f5f5f5';
-                }
-                if( $row1[ 'referingURL' ] != 'DIRECT' )
-                {
-                    if( substr( $row1[ 'referingURL' ], 0, 17 ) == 'http://www.google' )
-                    {
-                        $args = parse_url( $row1[ 'referingURL' ] );
-                        parse_str( $args[ 'query' ] );
-                        $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>Google: ".stripslashes( htmlspecialchars( $q ) )."</a>";
-                    }
-                    elseif( strstr( $row1[ 'referingURL' ], 'search.yahoo' ) )
-                    {
-                        $args = parse_url( $row1[ 'referingURL' ] );
-                        parse_str( $args[ 'query' ] );
-                        $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>Yahoo: ".stripslashes( htmlspecialchars( $p ) )."</a>";
-                    }
-                    elseif( strpos( $row1[ 'referingURL' ], 'www.blueyonder.co.uk' ) )
-                    {
-                        $args = parse_url( $row1[ 'referingURL' ] );
-                        parse_str( $args[ 'query' ] );
-                        $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>Blueyonder: ".stripslashes( htmlspecialchars( $q ) )."</a>";
-                    }
-                    else
-                    {
-                        $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>".substr( $row1[ 'referingURL' ], 0, 40 )."</a>";
-                    }
-                }
-                else
-                {
-                    $url = 'DIRECT';
-                }
-                $visitID = $row1[ 'visitID' ];
-                print "<tr bgcolor='#$col'>
-                       <td>".$c."</td>
-                       <td>".$url."</td>
-                       <td>".substr($row1[ 'visitTimes' ],0, 40 )."</td>
-                       <td><a href='".$row1[ 'visitURL' ]."'>".substr($row1[ 'visitURL' ],0, 40 )."</a></td>
-                       <td>".$row1[ 'visitTime2' ]."</td>
-                       <td align='right'><input type=checkbox name='del[]' value='".$visitID."'></td>
-                       </tr>";
-                $c++;
-
-            }
-            print "</table>";
-            print $nav;
-            print "</form>";
-            print "</div>";
-        }
-        break;
-    default:
-        $query = "select sum( visitTimes ) as c, dayofmonth from " . $table_prefix . "referer_visitLog ";
-        if( $wpblog != 'root' )
-            $query .= "where blogID='".$wpblog."' ";
-        $query .= "group by " . $table_prefix . "referer_visitLog.dayofmonth";
-	$result = $wpdb->get_results($query, ARRAY_A );
-        if( $result )
-        {
-            $c = 0;
-            $col = 'ccc';
-            print "<div class='wrap'><h2>Referers</h2>";
-            print "<table><td valign='top'>";
-            print "<table border=1 cellspacing=0 cellpadding=2>";
-            print "<tr><th>Day</th><th>Hits</th>";
-            while( list( $key, $row1 ) = each( $result ) ) 
-            {
-                if( $col == 'f5f5f5' )
-                {
-                    $col = 'ffffff';
-                }
-                else
-                {
-                    $col = 'f5f5f5';
-                }
-                print "<tr bgcolor='#";
-                if( $row1[ 'dayofmonth' ] == date( 'j' ) )
-                {
-                    print "ffdddd";
-                }
-                else
-                {
-                    print $col;
-                }
-                print "'><td><a href='referers.php?action=listday&day=".$row1[ 'dayofmonth' ]."'>".$row1[ 'dayofmonth']."</a></td><td>".$row1[ 'c']."</td></tr>";
-                $c++;
-                if( $c == '15' )
-                {
-                    print "</table>";
-                    print "</td><td valign='top'>";
-                    print "<table border=1 cellspacing=0 cellpadding=2>";
-                    print "<tr><th>Day</th><th>Hits</th>";
-                }
-
-            }
-            print "</table>";
-            print "</td></table>";
-            print "<br><a href='referers.php?action=blacklist'>View Blacklist</a>";
-            print "</div>";
-        }
-        else
-        {
-            print "There are no referers for your site! Wait until Google indexes you!";
-        }
-}
-print "</div>";
-include("admin-footer.php");
-?>
diff --git a/wp-inst/wp-admin/upgrade-schema.php b/wp-inst/wp-admin/upgrade-schema.php
index 16ff9d0..0388640 100644
--- a/wp-inst/wp-admin/upgrade-schema.php
+++ b/wp-inst/wp-admin/upgrade-schema.php
@@ -176,30 +176,6 @@ CREATE TABLE $wpdb->sitemeta (
   KEY meta_key (meta_key),
   KEY site_id (site_id)
 );
-CREATE TABLE " . $table_prefix . "referer_blacklist (
-  ID int(11) NOT NULL auto_increment,
-  blogID varchar(32) NOT NULL default '',
-  URL varchar(250) NOT NULL default '',
-  t timestamp(14) NOT NULL,
-  PRIMARY KEY  (ID),
-  KEY blogID (blogID,URL),
-  KEY URL (URL)
-);
-CREATE TABLE " . $table_prefix . "referer_visitLog (
-blogID char( 32 ) default NULL ,
-visitID int( 11 ) NOT NULL AUTO_INCREMENT ,
-visitTime timestamp( 14 ) NOT NULL ,
-visitURL char( 250 ) default NULL ,
-referingURL char( 250 ) default NULL ,
-baseDomain char( 250 ) default NULL ,
-refpost int( 11 ) NOT NULL default '0',
-visitTimes int( 10 ) NOT NULL default '0',
-dayofmonth smallint( 2 ) NOT NULL default '0',
-PRIMARY KEY ( visitID ) ,
-KEY blogID ( blogID ) ,
-KEY refpost ( refpost ) ,
-KEY dayofmonth ( dayofmonth )
-);
 ";
 
 function populate_options() {
diff --git a/wp-inst/wp-content/plugins/doc_referers.php b/wp-inst/wp-content/plugins/doc_referers.php
new file mode 100644
index 0000000..5e6d0bb
--- /dev/null
+++ b/wp-inst/wp-content/plugins/doc_referers.php
@@ -0,0 +1,678 @@
+<?php
+/*
+Plugin Name: Referers
+Plugin URI: http://mu.wordpress.org/
+Description: Display referers to your site
+Version: 0.1
+Author: Donncha O Caoimh
+Author URI: http://blogs.linux.ie/xeer/
+*/
+
+/*  Copyright 2005  Donncha O Caoimh  (email : donncha@linux.ie)
+
+    This program is free software; you can redistribute it and/or modify
+    it under the terms of the GNU General Public License as published by
+    the Free Software Foundation; either version 2 of the License, or
+    (at your option) any later version.
+
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+    GNU General Public License for more details.
+
+    You should have received a copy of the GNU General Public License
+    along with this program; if not, write to the Free Software
+    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+
+class DOC_Referers {
+
+    var $table_version = 0.1;
+
+    function DOC_Referers() {
+	add_action('admin_menu', array(&$this, 'admin_menu'));
+	add_action('admin_footer', array(&$this, 'admin_footer'));
+	add_action('wp_head', array(&$this, 'wp_head'));
+	add_action('template_redirect', array(&$this, 'template_redirect'));
+	$this->settings = get_settings('doc_referers');
+	$this->wpdb_tables();
+
+	if($this->settings['table_version'] != $this->table_version)
+	{
+	    $this->make_tables();
+	    $this->added_tables = true;
+	}
+    }
+
+    function admin_footer()
+    {
+	update_option('doc_referers', $this->settings);
+    }
+
+    function admin_menu()
+    {
+	$pfile = basename(dirname(__FILE__)) . '/' . basename(__FILE__);
+	add_submenu_page('edit.php', 'Referers', 'Referers', 0, $pfile, array(&$this, 'plugin_content'));
+    }
+
+    function wpdb_tables() {
+	global $wpdb, $table_prefix;
+
+	$wpdb->doc_referers  = "{$table_prefix}referer_visitLog";
+	$wpdb->doc_blacklist = "{$table_prefix}referer_blacklist";
+    }
+    function make_tables() {
+	global $wpdb, $table_prefix;
+	if(!include_once(ABSPATH . 'wp-admin/upgrade-functions.php')) {
+	    die(_e('There is was error adding the required tables to the database.  Please refer to the documentation regarding this issue.', 'DOC_Referers'));
+	}
+	$qry = "CREATE TABLE " . $wpdb->doc_blacklist . " (
+		ID int(11) NOT NULL auto_increment,
+		blogID varchar(32) NOT NULL default '',
+		URL varchar(250) NOT NULL default '',
+		t timestamp(14) NOT NULL,
+		PRIMARY KEY  (ID),
+		KEY blogID (blogID,URL),
+		KEY URL (URL)
+		);
+		CREATE TABLE " . $wpdb->doc_referers . " (
+		blogID char( 32 ) default NULL ,
+		visitID int( 11 ) NOT NULL AUTO_INCREMENT ,
+		visitTime timestamp( 14 ) NOT NULL ,
+		visitURL char( 250 ) default NULL ,
+		referingURL char( 250 ) default NULL ,
+		baseDomain char( 250 ) default NULL ,
+		refpost int( 11 ) NOT NULL default '0',
+		visitTimes int( 10 ) NOT NULL default '0',
+		dayofmonth smallint( 2 ) NOT NULL default '0',
+		PRIMARY KEY ( visitID ) ,
+		KEY blogID ( blogID ) ,
+		KEY refpost ( refpost ) ,
+		KEY dayofmonth ( dayofmonth )
+		);
+	";
+	dbDelta($qry);
+
+	$this->settings['table_version'] = $this->table_version;
+	update_option('doc_referers', $this->settings);
+    }
+
+
+    function makeHiddenVals( $day, $order, $num, $more, $ignoreDIRECT, $visitID, $internal )
+    {
+	$fields = array( "day", "order", "num", "more", "ignoreDIRECT", "visitID", "internal" );
+	reset( $fields );
+	while( list( $key, $field ) = each( $fields ) ) 
+	{ 
+	    if( $field == 'action' )
+	    {
+		$sep = '?';
+	    }
+	    else
+	    {
+		$sep = '&';
+	    }
+
+	    if( $$field != '' )
+		$vals .= "<input type='hidden' name='".$field."' value='".$$field."'>\n";
+	}
+	return $vals;
+    }
+
+    function makeURL( $var, $val )
+    {
+	$fields = array( "action", "day", "order", "num", "more", "ignoreDIRECT", "visitID", "internal" );
+	reset( $fields );
+	while( list( $key, $field ) = each( $fields ) ) 
+	{ 
+	    if( $field == 'action' )
+	    {
+		$sep = '?';
+	    }
+	    else
+	    {
+		$sep = '&';
+	    }
+	    if( $field != $var )
+	    {
+		global $$field;
+		if( $$field != '' )
+		    $url .= $sep.$field."=".$$field;
+	    }
+	    else
+	    {
+		$url .= $sep.$var."=".$val;
+	    }
+	}
+	return $url;
+    }
+
+    function plugin_content()
+    {
+	global $wpdb;
+
+	$action = $_GET[ 'action' ];
+	$day    = $_GET[ 'day' ];
+	$del    = $_GET[ 'del' ];
+	$num    = $_GET[ 'num' ];
+	$more   = $_GET[ 'more' ];
+	$ignoreDIRECT = $_GET[ 'ignoreDIRECT' ];
+	$internal = $_GET[ 'internal' ];
+	
+	if( $action == '' )
+	{
+	    $action = 'listday';
+	    $day = date( 'j' );
+	}
+
+	print '<div class="wrap">';
+
+	if( $action == 'Delete' )
+	{
+	    if( is_array( $del ) )
+	    {
+		reset( $del );
+		while( list( $key, $val ) = each( $del ) ) 
+		{ 
+		    $query = "DELETE FROM " . $wpdb->doc_referers . "
+			      WHERE       visitID = '".$val."'";
+		    $result = $wpdb->query($query);
+		}
+	    }
+	    $action = "listday";
+	}
+	elseif( $action == 'deletedirect' )
+	{
+	    $query = "DELETE FROM " . $wpdb->doc_referers . "
+		WHERE        dayofmonth='".$day."'
+		AND          referingURL = 'DIRECT'";
+	    $result = $wpdb->query($query);
+	    printf ("Records deleted: %d\n", $wpdb->rows_affected);
+	    $action = "listday";
+	}
+	elseif( $action == 'Add To Blacklist' )
+	{
+	    if( is_array( $del ) )
+	    {
+		reset( $del );
+		while( list( $key, $val ) = each( $del ) ) 
+		{ 
+		    $query = "SELECT referingURL
+			FROM   " . $wpdb->doc_referers . "
+			WHERE  visitID = '".$val."'";
+		    $result=$wpdb->get_var( $query );
+		    if( $result )
+		    {
+			$query = "INSERT INTO " . $wpdb->doc_blacklist . " VALUES( NULL, 0, '".$result."', NOW() )";
+			$result = $wpdb->query($query);
+		    }
+		}
+	    }
+	    $action = "listday";
+	}
+	elseif( $action == 'deleteblacklist' )
+	{
+	    if( is_array( $del ) )
+	    {
+		reset( $del );
+		while( list( $key, $val ) = each( $del ) ) 
+		{ 
+		    $query = "DELETE FROM " . $wpdb->doc_blacklist . " WHERE ID='".$val."'";
+		    $result = $wpdb->query($query);
+		}
+	    }
+	    $action = "blacklist";
+	}
+
+	switch( $action )
+	{
+	    case "blacklist":
+		$query = "SELECT * FROM " . $wpdb->doc_blacklist;
+	    $result = $wpdb->get_results($query, ARRAY_A );
+	    if( $result )
+	    {   
+		print "<div class='wrap'><h2>Referer Blacklist</h2>";
+		print "<form method='get'>";
+		print '<input type="hidden" name="page" value="' . $_GET['page'] .'"/>';
+		print "<input type='hidden' name='action' value='deleteblacklist'>";
+		print "<input type='submit' value='Delete'>";
+		print "<table>";
+		$c = 1;
+		while( list( $key, $row1 ) = each( $result ) ) 
+		{
+		    if( substr( $row1[ 'URL' ], 0, 16 ) == 'http://www.google' )
+		    {
+			$displayurl = "Google: ". substr( $row1[ 'URL' ], strpos( $row1[ 'URL' ], "search" )+6 );
+		    }
+		    elseif( strstr( $row1[ 'URL' ], 'search.yahoo' ) )
+		    {
+			$displayurl = "Yahoo: ". substr( $row1[ 'URL' ], strpos( $row1[ 'URL' ], "p=" )+2 );
+		    }
+		    elseif( strpos( $row1[ 'URL' ], 'www.blueyonder.co.uk' ) )
+		    {
+			$displayurl = "Blueyonder: ". substr( $row1[ 'URL' ], strpos( $row1[ 'URL' ], "q=" )+2 );
+		    }
+		    else
+		    {
+			$displayurl = $row1[ 'URL' ];
+		    }
+		    print "<tr><td>$c</td><td><a href='".$row1[ 'URL' ]."'>".$displayurl."</a></td><td><input type='checkbox' name='del[]' value='".$row1['ID']."'></td></tr>\n";
+		    $c++;
+		}
+		print "</table>";
+		print "</form>";
+		print "</div>";
+	    }
+	    else
+	    {
+		print "No URLs in blacklist yet!";
+	    }
+	    break;
+	    case "listday":
+
+		$query = "select visitTimes,referingURL,date_format( visitTime, '%k:%i' ) as visitTime2, visitURL, visitID from " . $wpdb->doc_referers . " where dayofmonth='".$day."'";
+
+	    if( $internal == 'yes' )
+		$query .= " and referingURL NOT LIKE '".get_settings( "siteurl" )."%'";
+
+	    if( $ignoreDIRECT == 'yes' )
+		$query .= " and referingURL != 'DIRECT'";
+
+	    if( $order == '' || $order == 'time' )
+	    {
+		$query .= " order by visitTime desc";
+	    }
+	    elseif( $order == 'hits' )
+	    {
+		$query .= " order by visitTimes desc";
+	    }
+	    elseif( $order == 'url' )
+	    {
+		$query .= " order by visitURL desc";
+	    }
+	    if( $num == '' )
+	    {
+		$num = 0;
+	    }
+	    if( $more == '' || $more == '0' )
+		$more = '30';
+
+	    $query .= " limit $num,$more";
+
+	    $result = $wpdb->get_results($query, ARRAY_A );
+	    $rows = $wpdb->num_rows;
+	    if( $result )
+	    {
+		// javascript from http://www.experts-exchange.com/Web/Web_Languages/JavaScript/Q_10105441.html and
+		// http://members.aol.com/grassblad/html/chkAllBut.html
+		print "<script langage='javascript'>
+		    <!--
+		    function selectAll(cbList,bSelect) {
+			for (var i=0; i<cbList.length; i++)
+			    cbList[i].selected = cbList[i].checked = bSelect
+		    }
+
+		function reverseAll(cbList) {
+		    for (var i=0; i<cbList.length; i++) {
+			cbList[i].checked = !(cbList[i].checked)
+			    cbList[i].selected = !(cbList[i].selected)
+		    }
+		}
+		//-->
+		</script>";
+		$c = $num+1;
+		$nav = "<br /><div align='center'>";
+		$nav .= "<a href='edit.php?page=" . $_GET[ 'page' ] . "&action=month'>Month View</a> | ";
+		$nav .= "<a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "num", 0 )."'>Top</a>";
+		if( $ignoreDIRECT == 'yes' )
+		{
+		    $nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "ignoreDIRECT", 'no' )."'>Display DIRECT requests</a>";
+		}
+		else
+		{
+		    $nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "ignoreDIRECT", 'yes' )."'>Hide DIRECT requests</a>";
+		}
+		if( $internal == 'yes' )
+		{   
+		    $nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "internal", 'no' )."'>Display internal requests</a>";
+		}
+		else
+		{   
+		    $nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "internal", 'yes' )."'>Hide internal requests</a>";
+		}
+
+		if( $num >= 10 )
+		{
+		    if( $num > $more )
+		    {
+			$nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "num", ( $num - $more ) )."'>Previous $more</a>";
+		    }
+		}
+		else
+		{
+		    $nav .= " | Previous";
+		}
+		if( $rows >= $more )
+		{
+		    $nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "num", ($num + $more) )."'>Next $more</a>";
+		}
+		else
+		{
+		    $nav .= " | Next";
+		}
+		$nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "more", ($more + 10) )."'>More Hits</a>";
+		$nav .= " | <a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "more", ($more - 10) )."'>Less Hits</a>";
+		$nav .= "<br />";
+		print "<div class='wrap'><h2>Referers</h2>";
+		print $nav;
+		$today = date( 'd' );
+		if( $day > $today )
+		{
+		    $month = date( 'F', mktime (0,0,0,date("m")-1,date("d"),  date("Y")) );
+		}
+		else
+		{
+		    $month = date( 'F' );
+		}
+		print "<form method='GET' name='deletedirect'>";
+		print '<input type="hidden" name="page" value="' . $_GET['page'] .'"/>';
+		print "<input type='hidden' name='action' value='deletedirect'>";
+		print $this->makeHiddenVals( $day, $order, $num, $more, $ignoreDIRECT, $visitID, $internal );
+		print "</form>";
+		print "<form method='GET'  name='referers'>";
+		print '<input type="hidden" name="page" value="' . $_GET['page'] .'"/>';
+		print $this->makeHiddenVals( $day, $order, $num, $more, $ignoreDIRECT, $visitID, $internal );
+		//print "<input type='hidden' name='action' value='delete'>";
+		print "<table border=0 cellspacing=0 cellpadding=2>";
+		print "<caption> Referers For $day $month</caption>";
+		print "<tr><th>#</th><th>Refering URL</th>
+		    <th><a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "order", "hits" )."' title='order by hits'>Hits</a></th>
+		    <th><a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "order", "url" )."' title='order by entry page'>Entry Page</a></th>
+		    <th><a href='edit.php?page=" . $_GET[ 'page' ] . "".$this->makeURL( "order", "time" )."' title='order by time'>Last</a></th>
+		    <th>Selected</th>
+		    </tr>
+		    <tr><td colspan='6' align='right'><INPUT TYPE=button VALUE='Select All' ONCLICK='selectAll(this.form,true)'>
+		    <INPUT class='edit' TYPE=button VALUE='Clear All' ONCLICK='selectAll(this.form,false)'>
+		    <INPUT class='edit' TYPE=button VALUE='Reverse' ONCLICK='reverseAll(this.form)'>
+		    &nbsp;|&nbsp;<input class='edit' type='submit' name='action' value='Delete' onclick='javascript:document.referers.submit()'>
+		    &nbsp;|&nbsp;<input class='edit' type='submit' name='action' value='Add To Blacklist'>
+		    &nbsp;|&nbsp;<input class='edit' type='button' name='action' value='Delete Direct Referers' onclick='javascript:document.deletedirect.submit()'></td></tr>\n";
+		while( list( $key, $row1 ) = each( $result ) ) 
+		{
+		    if( $col == 'f5f5f5' )
+		    {
+			$col = 'ffffff';
+		    }
+		    else
+		    {
+			$col = 'f5f5f5';
+		    }
+		    if( $row1[ 'referingURL' ] != 'DIRECT' )
+		    {
+			if( substr( $row1[ 'referingURL' ], 0, 17 ) == 'http://www.google' )
+			{
+			    $args = parse_url( $row1[ 'referingURL' ] );
+			    parse_str( $args[ 'query' ] );
+			    $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>Google: ".stripslashes( htmlspecialchars( $q ) )."</a>";
+			}
+			elseif( strstr( $row1[ 'referingURL' ], 'search.yahoo' ) )
+			{
+			    $args = parse_url( $row1[ 'referingURL' ] );
+			    parse_str( $args[ 'query' ] );
+			    $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>Yahoo: ".stripslashes( htmlspecialchars( $p ) )."</a>";
+			}
+			elseif( strpos( $row1[ 'referingURL' ], 'www.blueyonder.co.uk' ) )
+			{
+			    $args = parse_url( $row1[ 'referingURL' ] );
+			    parse_str( $args[ 'query' ] );
+			    $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>Blueyonder: ".stripslashes( htmlspecialchars( $q ) )."</a>";
+			}
+			else
+			{
+			    $url = "<a href='".$row1[ 'referingURL' ]."' title='".$row1[ 'referingURL' ]."'>".substr( $row1[ 'referingURL' ], 0, 40 )."</a>";
+			}
+		    }
+		    else
+		    {
+			$url = 'DIRECT';
+		    }
+		    $visitID = $row1[ 'visitID' ];
+		    print "<tr bgcolor='#$col'>
+			<td>".$c."</td>
+			<td>".$url."</td>
+			<td>".substr($row1[ 'visitTimes' ],0, 40 )."</td>
+			<td><a href='".$row1[ 'visitURL' ]."'>".substr($row1[ 'visitURL' ],0, 40 )."</a></td>
+			<td>".$row1[ 'visitTime2' ]."</td>
+			<td align='right'><input type=checkbox name='del[]' value='".$visitID."'></td>
+			</tr>";
+		    $c++;
+
+		}
+		print "</table>";
+		print $nav;
+		print "</form>";
+		print "</div>";
+	    }
+	    break;
+	    default:
+	    $query = "select sum( visitTimes ) as c, dayofmonth from " . $wpdb->doc_referers . " ";
+	    $query .= "group by " . $wpdb->doc_referers . ".dayofmonth";
+	    $result = $wpdb->get_results($query, ARRAY_A );
+	    if( $result )
+	    {
+		$c = 0;
+		$col = 'ccc';
+		print "<div class='wrap'><h2>Referers</h2>";
+		print "<table><td valign='top'>";
+		print "<table border=1 cellspacing=0 cellpadding=2>";
+		print "<tr><th>Day</th><th>Hits</th>";
+		while( list( $key, $row1 ) = each( $result ) ) 
+		{
+		    if( $col == 'f5f5f5' )
+		    {
+			$col = 'ffffff';
+		    }
+		    else
+		    {
+			$col = 'f5f5f5';
+		    }
+		    print "<tr bgcolor='#";
+		    if( $row1[ 'dayofmonth' ] == date( 'j' ) )
+		    {
+			print "ffdddd";
+		    }
+		    else
+		    {
+			print $col;
+		    }
+		    print "'><td><a href='edit.php?page=" . $_GET[ 'page' ] . "&action=listday&day=".$row1[ 'dayofmonth' ]."'>".$row1[ 'dayofmonth']."</a></td><td>".$row1[ 'c']."</td></tr>";
+		    $c++;
+		    if( $c == '15' )
+		    {
+			print "</table>";
+			print "</td><td valign='top'>";
+			print "<table border=1 cellspacing=0 cellpadding=2>";
+			print "<tr><th>Day</th><th>Hits</th>";
+		    }
+
+		}
+		print "</table>";
+		print "</td></table>";
+		print "<br><a href='edit.php?page=" . $_GET[ 'page' ] . "&action=blacklist'>View Blacklist</a>";
+		print "</div>";
+	    }
+	    else
+	    {
+		print "There are no referers for your site! Wait until Google indexes you!";
+	    }
+	}
+	print "</div>";
+
+    }
+
+    function template_redirect() {
+	global $wpdb;
+
+	// delete tomorrow's referers today
+	$tomorrow  = date( "j", mktime (0,0,0,date("m")  ,date("d")+1,date("Y")) );
+	$sec = date( "s" );
+	$hour = date( "G" );
+	if( $sec == 30 && $hour < 2 )
+	{
+	    $sql = "delete from " . $wpdb->doc_referers . " WHERE dayofmonth = '$tomorrow'"; // delete referers from a (month + 1 day) ago.
+	    $wpdb->query($sql);
+	}
+
+	$ref = $_SERVER["HTTP_REFERER"];
+	$currentURL = $_SERVER[ 'REQUEST_URI' ];
+	$fullCurrentURL = "http://" . $_SERVER[ 'HTTP_HOST' ] . $_SERVER[ 'REQUEST_URI' ];
+	if( $ref == '' )
+	{
+	    $ref = "DIRECT";
+	}
+
+	$found = false;
+
+	if( $currentURL[ strlen( $currentURL ) -1 ] == '/' )
+	{
+	    $found = true;
+	}
+	else
+	{
+	    $count_files = array( "wp-admin" );
+	    reset( $count_files );
+	    while( list( $key, $val ) = each( $count_files ) ) 
+	    { 
+		$pos = strpos( $currentURL, $val );
+		if( $pos == true )
+		{
+		    $found = true;
+		}
+	    }
+	    if( $found == true )
+	    {
+		// Don't bother going further - no need to record request!
+		return;
+	    }
+	}
+
+	$ref = $wpdb->escape($ref);
+	if( $ref ) {
+	    $realReferer = true;
+	    $ignorePages = Array( 'lastupdated.php', 'b2rdf.php', 'b2rss2.php', 'b2bookmarklet.php', 'b2referers.php', 'b2commentspopup.php' );
+	    foreach ($ignorePages as $ignoresite){
+		if (stristr($currentURL, $ignoresite)){
+		    $realReferer = false;
+		}
+	    }
+
+	    $ignore = Array(
+		    'http://www.myelin.co.nz/ecosystem/bot.php',
+		    'http://radio.xmlstoragesystem.com/rcsPublic/',
+		    'http://blogdex.media.mit.edu//',
+		    'http://subhonker6.userland.com/rcsPublic/',
+		    'mastadonte.com',
+		    'http://blo.gs/ping.php'
+		    );
+	    foreach ($ignore as $ignoresite){
+		if (stristr($ref, $ignoresite)){
+		    $realReferer = false;
+		}
+	    }
+
+	    $checkRef = true;
+	    // Do we need to check the referer? If it's from a known site we can save some cycles.
+	    $checkReflist = array( "direct", "http://www.technorati.com", "http://www.google", "http://www.yahoo", "http://www.linux.ie", "http://blogs.linux.ie", "http://blo.gs" );
+	    reset( $checkReflist );
+	    while( list( $key, $val ) = each( $checkReflist ) ) 
+	    { 
+		$p = strpos( strtolower( $url ), $val );
+		if( $p !== false )
+		{
+		    $checkRef = false;
+		}
+	    }
+
+	    $doubleCheckReferers = 0; // must make this an option
+	    if( $realReferer && $checkRef && $ref != 'DIRECT' && $doubleCheckReferers)
+	    {
+		//this is so that the page up until the call to
+		//logReferer will get shown before it tries to check
+		//back against the refering URL.
+		flush();
+
+		$goodReferer = 0;
+		$fp = @fopen ($ref, "r");
+		if ($fp){
+		    socket_set_timeout($fp, 5);
+		    $c = 0;
+		    while (!feof ($fp) || $c > 5) {
+			$page .= trim(fgets($fp, 4096));
+			$c++;
+		    }
+		    fclose( $fp );
+		    if (strstr($page,$fullCurrentURL)){
+			$goodReferer = 1;
+		    }
+		}
+
+		if(!$goodReferer){
+		    $realReferer = false;
+		}
+	    }
+
+	    if( $realReferer == true && $ref != 'DIRECT' )
+	    {
+		$query = "SELECT ID FROM " . $wpdb->doc_blacklist . " WHERE URL like '%$ref%'";
+		$result = $wpdb->get_var( $query );
+		if( $result )
+		{
+		    $ref = "DIRECT";
+		}
+	    }
+
+	    $ua = getenv( 'HTTP_USER_AGENT' );
+	    $useragents = array( "http://www.syndic8.com", "http://dir.com/pompos.html", "NaverBot-1.0", "http://help.yahoo.com/help/us/ysearch/slurp", "http://www.google.com/bot.html", "http://www.blogdigger.com/", "http://search.msn.com/msnbot.htm", "Feedster, LLC.", "http://www.breakingblogs.com/timbo_bot.html", "fastbuzz.com", "http://www.pubsub.com/", "http://www.bloglines.com", "http://www.drupal.org/", "Ask Jeeves/Teoma", "ia_archiver", "http://minutillo.com/steve/feedonfeeds/", "larbin_2", "lmspider", "kinjabot", "lickBot 2.0", "Downes/Referrers", "daypopbot", "www.globalspec.com" );
+	    reset( $useragents );
+	    while( list( $key, $val ) = each( $useragents ) ) 
+	    { 
+		if( strpos( $ua, $val ) !== false )
+		{
+		    $realReferer = false;
+		}
+	    }
+
+	    if( $realReferer )
+	    {
+		if( $ref == 'DIRECT' )
+		{
+		    $anchor = $ref;
+		}
+		else
+		{
+		    $anchor = preg_replace("/http:\/\//i", "", $ref);
+		    $anchor = preg_replace("/^www\./i", "", $anchor);
+		    $anchor = preg_replace("/\/.*/i", "", $anchor);
+		}
+		$today = date( "d" );
+
+		$sql = "UPDATE " . $wpdb->doc_referers . "
+		        SET    visitTimes = visitTimes + 1 
+		        WHERE  dayofmonth = '$today'
+			AND    referingURL = '$ref'
+			AND    visitURL   = '$currentURL'";
+		$result = $wpdb->query( $sql );
+		if( $result == false )
+		{
+		    $sql ="insert delayed into " . $wpdb->doc_referers . " (referingURL,visitURL,refpost, visitTimes, dayofmonth)
+			   values ('$ref','$currentURL','$p','1', '$today')";
+		    $result = $wpdb->query( $sql );
+		}
+	    }
+	}
+    }
+}
+
+$doc_referer = new DOC_Referers();
+
+?>