[php-blog-cvs] jBlog db.sql,1.4,1.5 index.php,1.4,1.5 jBlog_functions.inc.php,1.10,1.11 jBlog_layout.php,1.4,1.5

[<gsc...@us...>]

Update of /cvsroot/php-blog/jBlog
In directory sc8-pr-cvs1:/tmp/cvs-serv32503

Modified Files:
	db.sql index.php jBlog_functions.inc.php jBlog_layout.php 
Log Message:
added referrer tracking


Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/jBlog/db.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- db.sql	4 Mar 2003 21:09:21 -0000	1.4
+++ db.sql	5 Mar 2003 01:10:16 -0000	1.5
@@ -60,3 +60,14 @@
   name text,
   primary key  (id)
 ) type=myisam;
+
+#
+# Table structure for table 'jBlog_referrers'
+# 
+
+CREATE TABLE jBlog_referrers (
+  url varchar(128) NOT NULL default '',
+  day date NOT NULL default '0000-00-00',
+  count int(11) NOT NULL default '0',
+  PRIMARY KEY  (url,day)
+) TYPE=MyISAM;

Index: index.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/index.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- index.php	4 Mar 2003 00:43:58 -0000	1.4
+++ index.php	5 Mar 2003 01:10:17 -0000	1.5
@@ -1,6 +1,7 @@
 <?php
 session_start();
 include_once("jBlog_config.inc.php");
+jBlog_track_referrer();
 
 $uri = $_SERVER['REQUEST_URI'];
 if (preg_match('@/archives/@', $uri)) {

Index: jBlog_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_functions.inc.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- jBlog_functions.inc.php	4 Mar 2003 22:49:50 -0000	1.10
+++ jBlog_functions.inc.php	5 Mar 2003 01:10:17 -0000	1.11
@@ -936,6 +936,37 @@
     return 0;
 }
 
+function jBlog_track_referrer() {
+    global $jBlog;
+    global $_SERVER;
+    $update = "UPDATE $jBlog[dbPrefix]referrers
+               SET count = count + 1 
+               WHERE url = '$_SERVER[HTTP_REFERER]' 
+               AND day = now()"; 
+    $insert = "INSERT into $jBlog[dbPrefix]referrers
+              (url, day, count)
+              VALUES ('$_SERVER[HTTP_REFERER]', now(), 1)";
+    $rs = mysql_db_query($jBlog['dbName'], $update);
+    if(mysql_affected_rows() == 0) {
+        mysql_db_query($jBlog['dbName'], $insert);
+    }
+}    
+
+function jBlog_displayTopReferrers() {
+    global $jBlog;
+    $query = "SELECT url, sum(count) total
+              FROM $jBlog[dbPrefix]referrers
+              GROUP BY url
+              ORDER BY total";
+    $cursor = mysql_db_query($jBlog['dbName'], $query);
+    if($num_rows = mysql_num_rows($cursor)) {
+        echo "<b>Top Referrers<b><br>";
+        while($row = mysql_fetch_assoc($cursor)) {
+            preg_match("#//([^/]+)#", $row[url], $matches);
+            echo "<a href=\"$row[url]\">$matches[1] ($row[total])</a><br>";
+        }     
+    }
+}
 define("JBLOG_FUNCTIONS_LOADED", true);
 ?>
 

Index: jBlog_layout.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_layout.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- jBlog_layout.php	4 Mar 2003 22:49:51 -0000	1.4
+++ jBlog_layout.php	5 Mar 2003 01:10:17 -0000	1.5
@@ -106,6 +106,7 @@
                 }
             ?>
             <a href='?jBlog[action]=archives'>Older...</a><p>
+            <?= jBlog_displayTopReferrers() ?><p>
             <b>Superuser:</b><br>
             <a href="<?=$jBlog['jBlogHTTPPath']?>jBlog_admin.php">$ su -</a><p>
             This blog powered by <a href="http://sourceforge.net/projects/php-blog">jBlog</a>!