Letzten Commentare

!-- begin l_sidebar -->
<div id="l_sidebar">
 <ul id="l_sidebarwidgeted">
 <?php if ( function_exists('dynamic_sidebar') && dynamic_sidebar(1) ) : else : ?>
 
 <li id="Recent">
 <h2>Recently Written</h2>
  <ul>
   <?php get_archives('postbypost', 10); ?>
  </ul>
 </li>
 <li id="Categories">
 <h2>Categories</h2>
  <ul>
   <?php wp_list_cats('sort_column=name'); ?>
  </ul>
 </li>
  
 <li id="Archives">
 <h2>Archives</h2>
  <ul>
   <?php wp_get_archives('type=monthly'); ?>
  </ul>
 </li>
 
 <li id="Admin">
 <h2>Admin</h2>
  <ul>
   <?php wp_register(); ?>
   <li><?php wp_loginout(); ?></li>
   <li><a href="http://wordpress.org/">WordPress</a></li>
   <?php wp_meta(); ?>
   <li><a href="http://validator.w3.org/check?uri=referer">XHTML</a></li>
  </ul>
 <?php endif; ?>
 
 <h2>Zuletzt diskutiert</h2>
<ul>
<?php $commenttype = 'even';
foreach($comments as $comment) {
  $post = get_postdata($comment->comment_post_ID); ?>
  <li class="<?php echo $commenttype; ?>">
 <a href="<?php echo get_permalink($post['ID']); ?>" title="<?php echo $post['Title'];?>">Von 
 <?php echo $comment->comment_author; ?> zu 
      <?php echo $post['Title']; ?>
      
</a>
  </li>
  <?php if($commenttype == "even") { $commenttype = "odd"; } else { $commenttype = "even"; } ?>
<?php } ?>
</ul>
</ul>
</div>
<!-- end l_sidebar -->

<!-- Letzte Kommentare -->




<!-- Suche die letzten 10 vom Typ Comment die akzeptiert wurden und sortiere es nach Datum absteigend -->
<?php $comments = $wpdb->get_results("SELECT comment_post_ID, comment_author, comment_author_email, comment_content, comment_date
FROM $wpdb->comments
WHERE comment_type = ''
&& comment_approved = '1'
ORDER BY comment_date DESC LIMIT 5"); ?>




<!-- ab hier der Ausgabeteil -->
<ul>
<?php $commenttype = 'even';
foreach($comments as $comment) {
$post = get_postdata($comment->comment_post_ID); ?>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td>




<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="50" align="left" valign="top"><ul>
<div class="comment-gravatar-sidebar"><?php $gravatar_url = "http://www.gravatar.com/avatar.php?gravatar_id=" . md5(get_comment_author_email()) . "&default=" . urlencode($gravatar_default) . "&size=70"; ?>
<img class="comment-gravatar-sidebar" src="<?php echo $gravatar_url ?>" alt="Gravatar of <?php comment_author() ?>" />
</td>




<td align="left" valign="middle"><b><font size="1"><?php echo $comment->comment_author; ?></font></b><br><b><font size="1"><?php comment_date('j. M Y'); ?></font></b> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="text-align: bottom"><font size="1"> <p align="justify"><?php
echo wp_html_excerpt( $comment->comment_content, 150 ); ?>..."
<a href="<?php echo get_permalink($comment->comment_post_ID); ?>"
rel="external nofollow" title="<?php echo $title; ?>">
<?php echo $title; ?></font></p> </a>
</li>
</td>
</tr>
</table>
<br> <?php if($commenttype == "even") { $commenttype = "odd"; } else { $commenttype = "even"; } ?>
<?php } ?>
</ul>
<!-- Ende Letzte Kommentare -->