Beiträge von Marcuss

global $wpdb, $comments, $comment;
 if ( !$number = (int) $options['number'] )
 $number = 5;
 else if ( $number < 1 )
 $number = 1;
 else if ( $number > 15 )
 $number = 15;
 $comments = $wpdb->get_results("SELECT comment_type, comment_author, comment_author_email, comment_author_url, comment_ID, comment_post_ID, comment_content FROM $wpdb->comments
  WHERE comment_approved = '1'
  AND comment_type
 NOT LIKE 'pingback' OR 'trackback'
  AND comment_author_url NOT LIKE 'http://domain/account'
  ORDER BY comment_date_gmt
 DESC LIMIT $number");
 if ( $comments ) {
 foreach ($comments as $comment) { 
echo '<li style="list-style-type:none">'. get_avatar( $comment, 32) .'<div class="meta">' . sprintf(__('Von %1$s in: %2$s'), get_comment_author_link(), '<br /><a href="'. get_permalink($comment->comment_post_ID) . '#comment-' . $comment->comment_ID . '" rel="follow me" title="'.get_the_title($comment->comment_post_ID).'">' . get_the_title($comment->comment_post_ID) . '</a></div>') . '<p>', comment_excerpt() ,'</p>';
 echo '</li>';
 }
 }
 }

kein_kommentar() {
global $wpdb;
    $com_query= "SELECT post_type, post_title AS posttitle, ID, post_name AS postname, SUBSTRING(post_content,1,155) AS post_auszug, post_date, comment_status, comment_count FROM $wpdb->posts
                  WHERE comment_count = '0'
                 AND post_status = 'publish'
                  AND comment_status ='open'
                 AND post_type='post'
                 ORDER BY rand()
                 LIMIT 3";
        $com_result = $wpdb->get_results($com_query);
    if ( empty($com_result) ) {
    echo '<h4 class="sidebar-title">Es gibt keinen unkommentierten Artikel</h4>';
    }
    foreach ($com_result as $comm) {
        $ID = $com->ID;
        $posttitle = $comm->posttitle;
        $postname = $comm->postname;
        $post_auszug = $comm->post_auszug;
        echo '<div class="umfrage">';
    echo '<li style="list-style-type:none"><div class="akt-titel"><a href="'. get_permalink($comm->ID).'" title="'.$comm->posttitle.'">'.$comm->posttitle.'</a><br />';
    echo $comm->post_auszug.' ...</div></li></div>';
    }
}

function top_commentator_all() {    
global $wpdb;     
$i = 0;    
echo '<div class="topcommenters">';    
echo '<table border="0" cellSpacing="3" cellPadding="5" width="85%">';
$topcommentator_query="SELECT comment_author, comment_author_email, comment_type, SUBSTRING_INDEX(comment_author_url, '/', 3) as top_commentator, COUNT(*) as top_num FROM $wpdb->comments        
WHERE comment_approved='1'        
AND comment_author_url IS NOT NULL        
AND comment_author_url != ''       
AND comment_author_email NOT LIKE 'xyz@domain.de%'        
AND comment_author_email NOT LIKE 'xyz@domain.de%'        
AND comment_author_url NOT LIKE 'http://twitter.com/%'        
AND comment_author_url NOT LIKE 'http://domain.de%'        
AND comment_author_url NOT LIKE 'http://facebook.com%'        
AND comment_type NOT LIKE 'pingback' OR 'trackback'        
GROUP BY top_commentator        
Order by top_num DESC, comment_date ASC       
LIMIT 18";    
$topcommentator_result = $wpdb->get_results($topcommentator_query);    
if ( !empty($topcommentator_result) ) {
        foreach ($topcommentator_result as $comment) :
            $co_aut = $comment->top_commentator;
            $co_aut = str_ireplace("http://", "", $co_aut);
            echo  '<td>'.get_avatar( $comment, 64 ),' <a href="'.$comment->top_commentator.'/" target="_blank"><br />'.$comment->comment_author.'</a> ('.$comment->top_num.')</td>';           $i++; 
if($i%3==0) {            
echo '</tr><tr>';
                }
        endforeach;
        $i=0;
        }
        echo '</table>';
        echo '</div>';
        }

global $wpdb; ?>    
<?php    
$i = 0;    
$topcommentator_query="SELECT comment_author, comment_author_email, comment_type, SUBSTRING_INDEX(comment_author_url, '/', 3) as top_commentator, COUNT(*) as top_num FROM $wpdb->comments        
WHERE comment_approved='1'         
AND comment_author_url IS NOT NULL        
AND comment_author_url != ''       
AND comment_author_email NOT LIKE 'webbi@themenfreund.de%'        AND comment_author_email NOT LIKE 'kommentar@themenfreund.de%'        AND comment_author_url NOT LIKE 'http://twitter.com/%'        
AND comment_author_url NOT LIKE 'http://themenfreund.de%'        
AND comment_author_url NOT LIKE 'http://facebook.com%'        
AND comment_type NOT LIKE 'pingback' OR 'trackback'        
GROUP BY top_commentator        
Order by top_num DESC, comment_date ASC        
LIMIT 30";    
$topcommentator_result = $wpdb->get_results($topcommentator_query);     if ( !empty($topcommentator_result) ) {        
foreach ($topcommentator_result as $comment) :            
echo '<table border="0" cellSpacing="3" cellPadding="5" bgColor="#eeeeee" width="60%">';           
echo '<tr width="60%">';            
$i=$i+1;             
$co_aut = $comment->top_commentator;            
$co_aut = str_ireplace("http://", "", $co_aut);            
echo  get_avatar( $comment, 32 ),' <a href="'.$comment->top_commentator.'/" target="_blank">'.$comment->comment_author.'</a> ('.$comment->top_num.')';            
if($i%3==0) {            
echo '<br /><br />';               
}        
endforeach;        
$i++;                
}        
?>
</tr>        
</table>

function updated_article() {
    global $wpdb;   
 $upd_query = "SELECT post_date, post_status, post_type, post_modified, SUBSTRING(post_content,1,155) AS post_auszug, DATE_FORMAT(post_modified, '%d.%m.%Y, um %H:%i:%s') AS post_modified_ger, post_title AS posttitle, post_name AS postname, guid AS postid FROM $wpdb->posts        
WHERE post_status = 'publish'        
AND post_type= 'post'        
AND post_modified >= post_date + INTERVAL 5 DAY        
AND post_modified >= CURDATE() - INTERVAL 2 MONTH                
ORDER BY post_modified DESC        
LIMIT 3";        
$upd_result = $wpdb->get_results($upd_query);   
 if ( empty($upd_result) ) {    
echo '<small>... keine aktualisierten Artikel</small>';    
}    
foreach ($upd_result as $updat) :        
$post_modified_ger = $updat->post_modified_ger;        
$posttitle = $updat->posttitle;       
 $postname = $updat->postname;         
$postid = $updat->postid;        
$post_auszug = $updat->post_auszug;    
echo '<ol><li style="list-style-type:none"><div class="akt-titel"><a href="http://themenfreund.de/'.$updat->postname.'" title="'.$updat->posttitle.'">'.$updat->posttitle.'</a><h6 class="aktualisiert1">Aktualisiert am: '.$updat->post_modified_ger.'</h6></div>';   
echo $updat->post_auszug.' ...</li></ol>';   
 endforeach;
}

<h3 class="sidebar-title"><?php _e('Weitere neue Artikel',TS_DOMAIN); ?>:</h3>    	<?php $recent = new WP_Query("showposts=5&offset=3"); while($recent->have_posts()) : $recent->the_post();?>
    	<ol>
<li style="list-style-type:none">
<div class="new-article">
<a href="<?php the_permalink() ?>" rel="bookmark" title="<?php the_title(); ?>"><?php the_title(); ?></a>
</div>
</li>
</ol>
    	<?php add_filter('excerpt_length', 'sb_excerpt_length'); 
 the_excerpt();
remove_filter('excerpt_length', 'sb_excerpt_length'); ?><?php endwhile; ?>