From dfbabafa5d09ee3960764580a86fe6911583ce31 Mon Sep 17 00:00:00 2001
From: ahollosi <ahollosi@96ab9672-09ca-45d6-a79d-3d69d39ca109>
Date: Mon, 26 Jun 2000 21:26:45 +0000
Subject: [PATCH] Added support for hitcount and MostPopular (%%Mostpopular%%
 markup) quick hack - works only with mySQL so far

git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@114 96ab9672-09ca-45d6-a79d-3d69d39ca109
---
 pgsrc/MostPopular   |  4 ++++
 wiki_display.php3   |  5 ++++-
 wiki_mysql.php3     | 36 +++++++++++++++++++++++++++++++++++-
 wiki_stdlib.php3    | 25 +++++++++++++++++++------
 wiki_transform.php3 |  6 +++++-
 5 files changed, 67 insertions(+), 9 deletions(-)
 create mode 100644 pgsrc/MostPopular

diff --git a/pgsrc/MostPopular b/pgsrc/MostPopular
new file mode 100644
index 000000000..a682a3d23
--- /dev/null
+++ b/pgsrc/MostPopular
@@ -0,0 +1,4 @@
+The 20 most popular pages of this wiki:
+(hitcount, pagename)
+
+%%Mostpopular%%
diff --git a/wiki_display.php3 b/wiki_display.php3
index 0298ca6c2..4bf548e62 100644
--- a/wiki_display.php3
+++ b/wiki_display.php3
@@ -1,4 +1,4 @@
-<!-- $Id: wiki_display.php3,v 1.5 2000-06-18 15:12:13 ahollosi Exp $ -->
+<!-- $Id: wiki_display.php3,v 1.6 2000-06-26 21:26:45 ahollosi Exp $ -->
 <?
    /*
       display.php3: render a page. This has all the display 
@@ -32,4 +32,7 @@
    }
 
    GeneratePage('BROWSE', $html, $pagename, $pagehash);
+   flush();
+
+   IncreaseHitCount($dbi, $pagename);
 ?>
diff --git a/wiki_mysql.php3 b/wiki_mysql.php3
index ecea2f284..042db055b 100644
--- a/wiki_mysql.php3
+++ b/wiki_mysql.php3
@@ -1,4 +1,4 @@
-<!-- $Id: wiki_mysql.php3,v 1.6 2000-06-21 22:59:18 ahollosi Exp $ -->
+<!-- $Id: wiki_mysql.php3,v 1.7 2000-06-26 21:26:45 ahollosi Exp $ -->
 <?
 
    /*
@@ -108,6 +108,29 @@
    }
 
 
+   function IncreaseHitCount($dbi, $pagename)
+   {
+      $res = mysql_query("update hitcount set hits=hits+1 where pagename='$pagename'", $dbi['dbc']);
+
+      if (!mysql_affected_rows($dbi['dbc'])) {
+	 $res = mysql_query("insert into hitcount (pagename, hits) values ('$pagename', 1)", $dbi['dbc']);
+      }
+
+      return $res;
+   }
+
+   function GetHitCount($dbi, $pagename)
+   {
+      $res = mysql_query("select hits from hitcount where pagename='$pagename'", $dbi['dbc']);
+      if (mysql_num_rows($res))
+         $hits = mysql_result($res, 0);
+      else
+         $hits = "0";
+
+      return $hits;
+   }
+
+
    // setup for title-search
    function InitTitleSearch($dbi, $search) {
       $search = addslashes($search);
@@ -146,5 +169,16 @@
       }
    }
 
+   function InitMostPopular($dbi, $limit) {
+      $res = mysql_query("select * from hitcount order by hits desc, pagename limit $limit");
+      
+      return $res;
+   }
 
+   function MostPopularNextMatch($dbi, $res) {
+      if ($hits = mysql_fetch_array($res))
+	 return $hits;
+      else
+         return 0;
+   }
 ?>
diff --git a/wiki_stdlib.php3 b/wiki_stdlib.php3
index bc3d5d9fc..c1df1401e 100644
--- a/wiki_stdlib.php3
+++ b/wiki_stdlib.php3
@@ -1,4 +1,4 @@
-<!-- $Id: wiki_stdlib.php3,v 1.16 2000-06-26 20:05:22 ahollosi Exp $ -->
+<!-- $Id: wiki_stdlib.php3,v 1.17 2000-06-26 21:26:45 ahollosi Exp $ -->
 <?
    /*
       Standard functions for Wiki functionality
@@ -20,7 +20,7 @@
    function GeneratePage($template, $content, $name, $hash)
    {
       global $ScriptUrl, $AllowedProtocols, $templates;
-      global $datetimeformat;
+      global $datetimeformat, $dbi;
 
       if (!is_array($hash))
          unset($hash);
@@ -46,6 +46,10 @@
 			$hash['author'], $page);
          $page = str_replace("#$FieldSeparator#VERSION#$FieldSeparator#",
 			$hash['version'], $page);
+	 if (strstr($page, "#$FieldSeparator#HITS#$FieldSeparator#")) {
+            $page = str_replace("#$FieldSeparator#HITS#$FieldSeparator#",
+			GetHitCount($dbi, $name), $page);
+	 }
       }
 
       // valid only for EditLinks
@@ -105,6 +109,19 @@
       return $formtext;
    }
 
+   function RenderMostPopular() {
+      global $ScriptUrl, $dbi;
+      
+      $query = InitMostPopular($dbi, 20);
+      $result = "<DL>\n";
+      while ($qhash = MostPopularNextMatch($dbi, $query)) {
+	 $result .= "<DD>$qhash[hits] ... " . LinkExistingWikiWord($qhash['pagename']) . "\n";
+      }
+      $result .= "</DL>\n";
+      
+      return $result;
+   }
+
    // converts spaces to tabs
    function CookSpaces($pagearray) {
       return preg_replace("/ {3,8}/", "\t", $pagearray);
@@ -355,10 +372,6 @@
             return LinkExistingWikiWord($linkname);
          } elseif (preg_match("#^($AllowedProtocols):#", $linkname)) {
             return LinkURL($linkname);
-         } elseif ($linkname == 'Search') {
-	    return RenderQuickSearch();
-	 } elseif ($linkname == 'Fullsearch') {
-	    return RenderFullSearch();
 	 } else {
             return LinkUnknownWikiWord($linkname);
          }
diff --git a/wiki_transform.php3 b/wiki_transform.php3
index 191248ad6..ea2989cb2 100644
--- a/wiki_transform.php3
+++ b/wiki_transform.php3
@@ -1,4 +1,4 @@
-<!-- $Id: wiki_transform.php3,v 1.9 2000-06-21 22:57:48 ahollosi Exp $ -->
+<!-- $Id: wiki_transform.php3,v 1.10 2000-06-26 21:26:45 ahollosi Exp $ -->
 <?
    // expects $pagehash and $html to be set
 
@@ -221,6 +221,10 @@ your web server it is highly advised that you do not allow this.
          $html .= SetHTMLOutputMode("", ZERO_DEPTH, 0);
       }
 
+      $tmpline = str_replace("%%Search%%", RenderQuickSearch(), $tmpline);
+      $tmpline = str_replace("%%Fullsearch%%", RenderFullSearch(), $tmpline);
+      $tmpline = str_replace("%%Mostpopular%%", RenderMostPopular(), $tmpline);
+
       $html .= "$tmpline"; // at last, emit the code
    }
 
-- 
2.45.2