next »

Hi.

Sa mga gumagamit ng Show Top Commentators WordPress plugin, mayroon akong paraan para mawala ang mga commentators na walang URL na nilagay. Nasisira kasi minsan ang design ng list kung walang list.

Here's how.

Edit your plugin by either:
(1) editing the plugin file show_top_commentators.php using Notepad, Dreamweaver or your favorite coding tool before uploading it to plugins folder.

or

(2) if it is already uploaded, login to your WordPress blog -> go to Plugins tab -> Plugin Editor -> then choose Show Top Commentators.



After which, find the part with this text:
   $commenters = $wpdb->get_results("
      SELECT COUNT(comment_author) AS comment_comments, comment_author
      FROM $wpdb->comments o
      WHERE $reset_sql
         AND comment_author NOT IN($ns_options[filter_users])
         AND user_id NOT IN($ns_options[filter_user_ids])
         AND comment_author != ''
         AND comment_type != 'pingback'
         AND comment_approved = '1'
      GROUP BY comment_author
      ORDER BY comment_comments DESC LIMIT $ns_options[limit]

and replace it with:
   $commenters = $wpdb->get_results("
      SELECT COUNT(comment_author) AS comment_comments, comment_author
      FROM $wpdb->comments o
      WHERE $reset_sql
         AND comment_author NOT IN($ns_options[filter_users])
         AND user_id NOT IN($ns_options[filter_user_ids])
         AND comment_author != ''
         AND comment_type != 'pingback'
         AND comment_approved = '1'
      GROUP BY comment_author
      ORDER BY comment_comments DESC LIMIT $ns_options[limit]

The difference of the two is that the line AND comment_author !='' is added.

Have fun.

nice mikko salamat! keep on posting