Changeset 1379 for plugins/topWriter/_widgets.php

Timestamp:

08/10/09 23:33:28 (14 years ago)

Author:

JcDenis

Message:

topWriter 0.2:

• Fixed php 5.3 compatibility
• Fixed PostGreSQL compatibility
• Added option to exclude post authors from comment list

File:

• plugins/topWriter/_widgets.php (modified) (11 diffs)

plugins/topWriter/_widgets.php

@@ -11 +11 @@
 # -- END LICENSE BLOCK ------------------------------------
 
-if (!defined('DC_RC_PATH')) return;
+if (!defined('DC_RC_PATH')){return;}
 
 $core->addBehavior('initWidgets',array('topWriterWidget','init'));
@@ -17 +17 @@
 class topWriterWidget
 {
-     public static function init(&$w)
+     public static function init($w)
      {
           $w->create('topcom',__('Top comments'),
@@ -31 +31 @@
                __('Ascending') => 'asc',__('Descending') => 'desc'));
           $w->topcom->setting('limit',__('Limit:'),'10','text');
+          $w->topcom->setting('exclude',__('Exclude post writer from list'),0,'check');
           $w->topcom->setting('homeonly',__('Home page only'),1,'check');
 
@@ -48 +49 @@
      }
 
-     public static function topCom(&$w)
+     public static function topCom($w)
      {
           global $core;
@@ -54 +55 @@
           if ($w->homeonly && $core->url->type != 'default') return;
 
-          $rs = $core->con->select( 
-               'SELECT COUNT(comment_id) AS comment_count, '.
-               'comment_author, comment_email, comment_site '.
-               "FROM ".$core->prefix."post P,  ".$core->prefix."comment C ".
-               'WHERE P.post_id=C.post_id '.
-               "AND blog_id='".$core->con->escape($core->blog->id)."' ".
-               'AND post_status=1 AND comment_status=1 '.
-               self::period('comment_dt',$w->period).
-               'GROUP BY C.comment_email '.
-               'ORDER BY  comment_count '.($w->sort == 'asc' ? 'ASC' : 'DESC').
-               ', comment_dt DESC '.
-               $core->con->limit(abs((integer) $w->limit))
-          );
+          $req =
+          'SELECT COUNT(*) AS count, comment_email '.
+          "FROM ".$core->prefix."post P,  ".$core->prefix."comment C ".
+          'WHERE P.post_id=C.post_id '.
+          "AND blog_id='".$core->con->escape($core->blog->id)."' ".
+          'AND post_status=1 AND comment_status=1 '.
+          self::period('comment_dt',$w->period);
+
+          if ($w->exclude) {
+               $req .= 
+               'AND comment_email NOT IN ('.
+               ' SELECT U.user_email '.
+               ' FROM '.$core->prefix.'user U'.
+               ' INNER JOIN '.$core->prefix.'post P ON P.user_id = U.user_id '.
+               " WHERE blog_id='".$core->con->escape($core->blog->id)."' ".
+               ' GROUP BY U.user_email) ';
+          }
+
+          $req .=
+          'GROUP BY comment_email '.
+          'ORDER BY count '.($w->sort == 'asc' ? 'ASC' : 'DESC').' '.
+          $core->con->limit(abs((integer) $w->limit));
+          
+          $rs = $core->con->select($req);
 
           if ($rs->isEmpty()) return;
 
           $content = '';
-          $res = array();
           $i = 0;
           while($rs->fetch()){
+               $user = $core->con->select(
+                    "SELECT * FROM ".$core->prefix."comment WHERE comment_email='".$rs->comment_email."' "
+               );
+
+               if (!$user->comment_author) continue;
+
                $i++;
                $rank = '<span class="topcomments-rank">'.$i.'</span>';
 
-               if ($rs->comment_site) {
-                    $author = '<a href="'.$rs->comment_site.'" title="'.
-                         __('Author link').'">'.$rs->comment_author.'</a>';
-               } else
-                    $author = $rs->comment_author;
-
-               if ($rs->comment_count == 0)
+               if ($user->comment_site) {
+                    $author = '<a href="'.$user->comment_site.'" title="'.
+                         __('Author link').'">'.$user->comment_author.'</a>';
+               }
+               else
+                    $author = $user->comment_author;
+
+               if ($rs->count == 0)
                     $count = __('no comment');
-               elseif($rs->comment_count == 1)
+
+               elseif ($rs->count == 1)
                     $count = __('one comment');
+
                else
-                    $count = sprintf(__('%s comments'),$rs->comment_count);
+                    $count = sprintf(__('%s comments'),$rs->count);
 
                $content .= '<li>'.str_replace(
@@ -97 +117 @@
           }
 
+          if ($i < 1) return;
+
           return 
           '<div class="topcomments">'.
@@ -104 +126 @@
      }
 
-     public static function topPost(&$w)
+     public static function topPost($w)
      {
           global $core;
@@ -111 +133 @@
 
           $rs = $core->con->select(
-          'SELECT COUNT(P.post_id) AS post_count, '.
-          'U.user_id, U.user_name, U.user_firstname, U.user_displayname, U.user_email '.
+          'SELECT COUNT(*) AS count, U.user_id '.
           "FROM ".$core->prefix."post P ".
           'INNER JOIN '.$core->prefix.'user U ON U.user_id = P.user_id '.
@@ -119 +140 @@
           self::period('post_dt',$w->period).
           'GROUP BY U.user_id '.
-          'ORDER BY post_count '.($w->sort == 'asc' ? 'ASC' : 'DESC').
-          ', post_dt DESC '.
+          'ORDER BY count '.($w->sort == 'asc' ? 'ASC' : 'DESC').', U.user_id ASC '.
           $core->con->limit(abs((integer) $w->limit)));
 
@@ -128 +148 @@
           $i = 0;
           while($rs->fetch()){
+               $user = $core->con->select(
+                    "SELECT * FROM ".$core->prefix."user WHERE user_id='".$rs->user_id."' "
+               );
+
+               $author = dcUtils::getUserCN($user->user_id,$user->user_name,
+                    $user->user_firstname,$user->user_displayname);
+
+               if (empty($author)) continue;
+
                $i++;
                $rank = '<span class="topentries-rank">'.$i.'</span>';
 
-               $author = dcUtils::getUserCN($rs->user_id,$rs->user_name,
-                    $rs->user_firstname,$rs->user_displayname);
-
                if ($core->blog->settings->authormode_active) {
                     $author = '<a href="'.
-                         $core->blog->url.$core->url->getBase("author").'/'.$rs->user_id.'" '.
+                         $core->blog->url.$core->url->getBase("author").'/'.$user->user_id.'" '.
                          'title="'.__('Author posts').'">'.$author.'</a>';
-               } elseif ($rs->user_url) {
-                    $author = '<a href="'.$rs->user_url.'" title="'.
+               }
+               elseif ($user->user_url) {
+                    $author = '<a href="'.$user->user_url.'" title="'.
                          __('Author link').'">'.$author.'</a>';
                }
 
-               if ($rs->post_count == 0)
+               if ($rs->count == 0)
                     $count = __('no post');
-               elseif($rs->post_count == 1)
+
+               elseif ($rs->count == 1)
                     $count = __('one post');
+
                else
-                    $count = sprintf(__('%s posts'),$rs->post_count);
+                    $count = sprintf(__('%s posts'),$rs->count);
 
                $content .= '<li>'.str_replace(
@@ -156 +185 @@
                ).'</li>';
           }
+
+          if ($i < 1) return;
 
           return