Beiträge von kadafiutc

<?php get_header(); ?>
   <div id="content" class="entry">




<!-- This sets the $curauth variable -->
<?php 
if(isset($_GET['author_name'])) :
$curauth = get_userdatabylogin($author_name); // NOTE: 2.0 bug requires get_userdatabylogin(get_the_author_login());
else :
$curauth = get_userdata(intval($author));
endif;
?>


<h2>Benutzerprofil von: <?php echo $curauth->nickname; ?></h2>
<p>&nbsp;</p>


<fieldset style="border:1px dotted #164576; background: #F3F3F3; padding:5px 10px; width:25%; float:right">
    <p align="center"><strong>Userfoto</strong></p>
</fieldset>


<table width="70%" style="border:1px dotted #164576">
  <tr valign="top">
    <td width="40%"><strong style="color:#164576">Name:</strong></td>
    <td width="60%"><?php echo $curauth->user_firstname; ?> <?php echo $curauth->user_lastname; ?></td>
  </tr>
  <tr valign="top" bgcolor="#F4F4F4">
    <td width="40%"><strong style="color:#164576">Username:</strong></td>
    <td width="60%"><?php echo $curauth->nickname; ?></td>
  </tr>
  <tr valign="top">
    <td width="40%"><strong style="color:#164576">Website:</strong></td>
    <td width="60%"><a href="<?php echo $curauth->user_url; ?>" target="_blank" rel="nofollow"><?php echo $curauth->user_url; ?></a></td>
  </tr>
  <tr valign="top" bgcolor="#F4F4F4">
    <td width="40%"><strong style="color:#164576">E-Mail:</strong></td>
    <td width="60%"><?php echo $curauth->user_email; ?></td>
  </tr>  
  <tr valign="top">
    <td width="40%"><strong style="color:#164576">AIM:</strong></td>
    <td width="60%"><?php echo $curauth->aim; ?></td>
  </tr>
  <!--<tr valign="top" bgcolor="#F4F4F4">
    <td width="40%"><strong style="color:#164576">ICQ:</strong></td>
    <td width="60%"><?php // echo $curauth->user_icq; ?></td>
  </tr> -->
  <!--<tr valign="top">
    <td width="40%"><strong style="color:#164576">MSN:</strong></td>
    <td width="60%"><?php // echo $curauth->user_msn; ?></td>
  </tr> -->
  <tr valign="top" bgcolor="#F4F4F4">
    <td width="40%"><strong style="color:#164576">YAHOO:</strong></td>
    <td width="60%"><?php echo $curauth->yim; ?></td>
  </tr>
  <tr valign="top">
    <td width="40%"><strong style="color:#164576">&Uuml;ber den Benutzer:</strong></td>
    <td width="60%"><?php echo $curauth->description; ?></td>
  </tr>
</table>




<!-- Zurück zur Mitrgliederseite -->
<p align="right">&nbsp;</p>
<p align="right">&nbsp;</p>


<p>&nbsp;</p>
<!-- To Top -->
<div style="border-top:1px solid #999999; width:100%; line-height:5px;">&nbsp;</div>
<div style="float:left; margin-left:0px;" id="functionbarToTop"></div>
<!-- Seite Drucken -->
<div style="width:580px" id="functionbarPrint" align="right"><?php if(function_exists('wp_print')) { print_link(); } ?></div>


</div>
<?php get_sidebar(); ?>
<?php get_footer(); ?>

$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]
   ");

<?php
/*
Plugin Name: Show Top Commentators
Plugin URI: http://www.pfadvice.com/wordpress-plugins/show-top-commentators/
Description: Encourage more feedback and discussion from readers, by rewarding them every time they post a comment! Readers with the most comments are displayed on your Wordpress blog, with their names (linked to their website if they provided one).
Version: 1.05
Author: Nate Sanden
Author URI: http://www.savingadvice.com


Installation Instructions:
http://www.pfadvice.com/wordpress-plugins/show-top-commentators/#install


Shameless Begging: While this plugin is completely free to use, we would greatly appreciate a post telling your readers that you are using this new plugin. By doing so you will encourage us to make other great plugins for WordPress that you can also use in the future!
*/


$ns_options = array(
                    "reset" => "monthly", //reset hourly, daily, weekly, monthly, yearly, all OR # (eg 30 days)
                    "limit"  => 10, //maximum number of commentator's to show
                    "filter_users" => "Administrator,admin", //commma seperated list of users ("nate,jeff,etc").
                    "filter_user_ids" => "1,2", //comma sperated list of user_ids ("1,2")
                    "filter_urls" => "", //commma seperated list of full or partial URL's (www.badsite.com,etc)
                    "none_text" => "None yet!", //if there are no commentators, what should we display?
                    "make_links" => 1, //link the commentator's name to thier website?
                    "number_of_comments" => "y", //show number of comments next to their name? y=yes n=no
                    "name_limit" => 28, //maximum number of characters a commentator's name can be, before we cut it off with an ellipse
                    "start_html" => "<li>",
                    "end_html"   => "</li>",
                   );


//first we need to format options so they are useable
$ns_options = ns_format_options($ns_options);


function ns_substr_ellipse($str, $len) {
   if(strlen($str) > $len) {
      $str = substr($str, 0, $len-3) . "...";
   }
   return $str;
}


//temporary until i can condense this into one query in $commenters
function ns_get_user_url($user) {
   global $wpdb, $ns_options;
    $url = $wpdb->get_var("
       SELECT comment_author_url
       FROM $wpdb->comments
       WHERE comment_author = '".addslashes($user)."'
       AND comment_author_url != 'http://'
       $ns_options[filter_urls]
       ORDER BY comment_date DESC LIMIT 1
   ");
   return $url;
}


function ns_show_top_commentators() {


   global $wpdb, $ns_options;


   if($ns_options["reset"] != '') {
      if(!is_numeric($ns_options["reset"])) {
         $reset_sql = "DATE_FORMAT(comment_date, '$ns_options[reset]') = DATE_FORMAT(CURDATE(), '$ns_options[reset]')";
      } else {
         $reset_sql = "comment_date >= CURDATE() - INTERVAL $ns_options[reset] DAY"; 
      }
   } else {
      $reset_sql = "1=1";
   }


    $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]
   ");


   if(is_array($commenters)) {
       foreach ($commenters as $k) {
          if($ns_options["make_links"] == 1) {
            $url = ns_get_user_url($k->comment_author);
          }
          echo $ns_options["start_html"];
             echo "<a href='http://www.domain.de/?author=" . $k->comment_user_id . "'>";
          echo ns_substr_ellipse($k->comment_author, $ns_options["name_limit"]);
             echo "</a>";
          if($ns_options["number_of_comments"] == 'y') {
                 echo " (" . $k->comment_comments . ")\n";
          }
          echo $ns_options["end_html"] . "\n";
          unset($url);
       }
    } else {
      echo $ns_options["start_html"] . $ns_options["none_text"] . $ns_options["end_html"];;
    }


}


function ns_format_options($options) {
   //$reset needs to turn into %sql format
    if($options["reset"] == "hourly") {
      $options["reset"] = "%Y-%m-%d %H";
   } elseif($options["reset"] == "daily") {
      $options["reset"] = "%Y-%m-%d";
   } elseif($options["reset"] == "weekly") {
      $options["reset"] = "%Y-%v";
   } elseif($options["reset"] == "monthly") {
      $options["reset"] = "%Y-%m";
   } elseif($options["reset"] == "yearly") {
      $options["reset"] = "%Y";
   } elseif($options["reset"] == "all") {
      $options["reset"] = "";
   } elseif(is_numeric($options["reset"])) {
       $options["reset"] = $options["reset"]; //last x days
   } else {
      $options["reset"] = "%Y-%m"; //just use monthly
   }
   //$filter urls needs to be comma seperated with single quotes
   $filter_urls = trim($options["filter_urls"]);
   if($filter_urls) { $filter_urls = explode(",", $filter_urls); } else { $filter_urls = array(); }
   for($i=0; $i<count($filter_urls); $i++) {
      $new_urls .= " AND comment_author_url NOT LIKE '%" . trim($filter_urls[$i]) . "%'";
   }
   //echo $new_urls;
   $options["filter_urls"] = $new_urls;
   //lets trim $limit just for the hell of it. (you never know)
   $options["limit"] = trim($options["limit"]);
   $options["number_of_comments"] = trim($options["number_of_comments"]);
   $options["name_limit"] = trim($options["name_limit"]);
   //$filter_users needs to be comma seperated with single quotes
   $filter_users = trim($options["filter_users"]);
   $filter_users = explode(",", $filter_users);
   for($i=0; $i<count($filter_users); $i++) {
      $new_users[] = "'" . trim($filter_users[$i]) . "'";
   }
   $options["filter_users"] = implode(",", $new_users);
   //filter userids
   $filter_user_ids = trim($options["filter_user_ids"]);
   $filter_user_ids = explode(",", $filter_user_ids);
   for($i=0; $i<count($filter_user_ids); $i++) {
      $new_user_ids[] = "'" . trim($filter_user_ids[$i]) . "'";
   }
   $options["filter_user_ids"] = implode(",", $new_user_ids);
   return $options;
}


?>