[pLog-svn] r4271 - plugins/branches/lifetype-1.1/unported/topcommentvisitors

[jondaley at devel.lifetype.net]

Author: jondaley
Date: 2006-11-08 05:47:08 +0000 (Wed, 08 Nov 2006)
New Revision: 4271

Modified:
   plugins/branches/lifetype-1.1/unported/topcommentvisitors/plugintopcommentvisitors.class.php
   plugins/branches/lifetype-1.1/unported/topcommentvisitors/readme.txt
Log:
updated to 1.1.

Modified: plugins/branches/lifetype-1.1/unported/topcommentvisitors/plugintopcommentvisitors.class.php
===================================================================
--- plugins/branches/lifetype-1.1/unported/topcommentvisitors/plugintopcommentvisitors.class.php	2006-11-08 05:22:51 UTC (rev 4270)
+++ plugins/branches/lifetype-1.1/unported/topcommentvisitors/plugintopcommentvisitors.class.php	2006-11-08 05:47:08 UTC (rev 4271)
@@ -8,7 +8,6 @@
      */
     class PluginTopCommentVisitors extends PluginBase
     {
-        var $prefix;
         var $pluginEnabled;
         var $maxVisitors;        
 
@@ -20,10 +19,6 @@
             $this->author = "Mark Wu";
             $this->desc = "This plugin offers the rank list of visitors by number of comments.";
   
-            $this->prefix = Db::getPrefix();
-            
-            $this->db =& Db::getDb();
-            
             $this->locales = Array( "en_UK" , "zh_TW" , "zh_CN" );
             
             $this->init();            
@@ -31,6 +26,7 @@
 
 		function init()
 		{
+			include_once( PLOG_CLASS_PATH."class/template/menu/menu.class.php" );
             $this->registerAdminAction( "topcommentvisitors", "PluginTopCommentVisitorsConfigAction" );
 			$this->registerAdminAction( "updateTopCommentVisitorsConfig", "PluginTopCommentVisitorsUpdateConfigAction" );
 			
@@ -58,20 +54,17 @@
         function getTopCommentVisitors($maxVisitors = 0, $based = 'BLOG')
         {
             $blogId = $this->blogInfo->getId();
+            $prefix = Db::getPrefix();
             
-            if ($based == 'BLOG') {
-                $query = "SELECT ".$this->prefix."articles_comments.user_name,max(".$this->prefix."articles_comments.user_url) AS user_url,count(".$this->prefix."articles_comments.user_name) AS user_count";
-                $query .= " FROM ".$this->prefix."articles_comments,".$this->prefix."articles";
-                $query .= " WHERE ".$this->prefix."articles.blog_id=".$blogId." AND ".$this->prefix."articles_comments.article_id=".$this->prefix."articles.id AND ".$this->prefix."articles.status=1";
-                $query .= " GROUP BY ".$this->prefix."articles_comments.user_name ORDER BY user_count DESC";
-            } elseif ($based == 'SITE') {
-                $query = "SELECT ".$this->prefix."articles_comments.user_name,max(".$this->prefix."articles_comments.user_url) AS user_url,count(".$this->prefix."articles_comments.user_name) AS user_count";
-                $query .= " FROM ".$this->prefix."articles_comments,".$this->prefix."articles";
-                $query .= " WHERE ".$this->prefix."articles_comments.article_id=".$this->prefix."articles.id AND ".$this->prefix."articles.status=1";
-                $query .= " GROUP BY ".$this->prefix."articles_comments.user_name ORDER BY user_count DESC";
-            } else {
-                return false;
-            }
+            $query = "SELECT ".$prefix."articles_comments.user_name, ".
+                "max(".$prefix."articles_comments.user_url) AS user_url, ".
+                "count(".$prefix."articles_comments.user_name) AS user_count ".
+                "FROM ".$prefix."articles_comments,".$prefix."articles WHERE ";
+            if ($based == 'BLOG')
+                $query .= $prefix."articles.blog_id=".$blogId." AND ";
+            $query .= $prefix."articles_comments.article_id=".$prefix."articles.id ".
+                "AND ".$prefix."articles.status=1 ".
+                "GROUP BY ".$prefix."articles_comments.user_name ORDER BY user_count DESC";
 
             if( $maxVisitors > 0 ) 
             {
@@ -80,7 +73,8 @@
                 $query .= " LIMIT " . $this->maxVisitors;
             }
 
-            $result = $this->db->Execute( $query ); 
+            $db =& Db::getDb();
+            $result = $db->Execute( $query ); 
 
             if( !$result ) 
                 return false; 

Modified: plugins/branches/lifetype-1.1/unported/topcommentvisitors/readme.txt
===================================================================
--- plugins/branches/lifetype-1.1/unported/topcommentvisitors/readme.txt	2006-11-08 05:22:51 UTC (rev 4270)
+++ plugins/branches/lifetype-1.1/unported/topcommentvisitors/readme.txt	2006-11-08 05:47:08 UTC (rev 4271)
@@ -1,7 +1,7 @@
 Plugin: Top Comment Visitors
 Author: Mark Wu
-Release Date: 2005/01/23
-Version: 1.0
+Release Date: 2006/11/07
+Version: 1.1
 
 This plugin offers the rank list of visitors by number of comments. Usage as follow:
 
@@ -14,7 +14,7 @@
 2. $based is return the site-wide or blog-wide visitors. "BLOG" means blog-wide, and "SITE" means site-wide. Default is "BLOG".
 
 Example:
-{if $topcommentvisitors->isEnabled()}
+{if $topcommentvisitors && $topcommentvisitors->isEnabled()}
 <h2>Top Comment Visitors</h2>
 <ul>  
 {assign var=commentvisitors value=$topcommentvisitors->getTopCommentVisitors()}
@@ -22,4 +22,4 @@
 <li><a href="{$commentvisitor.user_url}">{$commentvisitor.user_name} ({$commentvisitor.user_count} Comments)</a></li>
 {/foreach}
 </ul>    
-{/if}
\ No newline at end of file
+{/if}