Beiträge von Marcuss

function top_commentator_all() {
    global $wpdb;
     $i = 0;
    ?>
    <div class="walloffame_container">
                <?php $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  '@domain.de%'
        AND comment_author_url NOT LIKE 'http://facebook.com/%'
        AND comment_author_url NOT LIKE 'http://themenfreund.de%'
        AND comment_author_url NOT LIKE 'http://twitter.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); ?>
            <div class="walloffame_stage" style="cursor: pointer;">
            <div class="walloffame_avatar">
             <?php
            echo '<a href="'.$comment->top_commentator.'/" target="_blank">'.get_avatar( $comment, 164 ) .'</a>';
             ?>
            </div>
            <div class="walloffame_info">
            <span class="walloffame_name">
            <?php
            echo $comment->comment_author.' <br />';
            ?>
            </span>
            <span class="walloffame_total">
            <?php
             echo $comment->top_num.' Kommentare'; ?>
            </span>
            </div>
            </div>
            <style="margin-right: 20px;">
            <?php
            $i++;
            if($i%3==0) { ?>
            </div><div class="walloffame_container">
             <?php
            }
        endforeach;
        $i=0;
        }
        ?>
        </div>
            <?php
        }

.topcommenters table{border-spacing:3px;
width:95%;
border: 0;
float: right;
margin: 0 100px;
padding: 16px 50px;
text-align: center;
}




.topcommenters1{
clear:left;
}








.walloffame_container {
    height: 100%;
    overflow: hidden;
    text-align: center;
    margin: 0 120px;
    }
.walloffame_stage {
    border: 0px solid #BBBBBB;
    border-radius: 13px 13px 13px 13px;
    box-shadow: 5px 6px 8px rgba(128, 128, 128, 0.8);
    float: left;
    line-height: 18px;
    margin: 8px;
    padding: 0;
    height: 208px;
    width: 160px;
}
.walloffame_stage:hover {
    opacity: 0.8;
    border: 1px solid #888888;
    box-shadow: 0 1px 5px rgba(64, 64, 64, 0.8);
}
.walloffame_stage img {
    border-radius: 13px 13px 1px 1px;
    border-width: 0 !important;
    margin: 0 !important;
    padding: 0 !important;
}
.walloffame_stage .walloffame_info {
    margin: 3px 5px 0;
    overflow: hidden;
    white-space: nowrap;
}
.walloffame_stage .walloffame_info .walloffame_name {
    font-size: 14px;
    font-weight: bold;
    text-align: center;
}
.walloffame_stage .walloffame_info .walloffame_total {
    font-size: 13px;
    height: 50px;
}
.walloffame_widgetstage {
    border: 1px solid #BBBBBB;
    border-radius: 3px 3px 3px 3px;
    box-shadow: 0 1px 5px rgba(128, 128, 128, 0.8);
    line-height: 20px;
    margin: 8px 5px;
    overflow: hidden;
    padding: 0;
}
.walloffame_widgetstage:hover {
    border: 1px solid #888888;
    box-shadow: 0 1px 5px rgba(64, 64, 64, 0.8);
}
.walloffame_widgetstage .walloffame_avatar {
    float: left;
    margin-right: 18px;
}
.walloffame_widgetstage img {
    border-radius: 3px 3px 3px 3px;
    border-width: 0 !important;
    margin: 0 !important;
    padding: 0 !important;
}
.walloffame_widgetstage .walloffame_name {
    font-size: 14px;
    font-weight: bold;
    overflow: hidden;
    white-space: nowrap;
}
.walloffame_widgetstage .walloffame_total {
    font-size: 13px;
    overflow: hidden;
    white-space: nowrap;
}

function top_trackbacks_jahr() {
    global $wpdb;
    $toptrack_query="SELECT comment_ID, comment_date, DATE_FORMAT(comment_date, '%d.%m.%Y') AS comment_date_ger, comment_post_ID, SUBSTRING_INDEX(REPLACE( comment_author_url, 'www.', '' ) , '/', 3) as top_track, COUNT(*) as top_num FROM $wpdb->comments
        WHERE comment_approved='1'
        AND comment_type IN('trackback', 'pingback')
        AND comment_date >= CURDATE() - INTERVAL 365 DAY
        AND comment_author_url NOT LIKE 'http://domain.de%'
        AND comment_author_url != ''
        AND comment_author_url NOT LIKE 'http://twitter.com%'
        GROUP BY top_track
        Order by top_num DESC, comment_date DESC
        LIMIT 3";
    $toptrack_result = $wpdb->get_results($toptrack_query);
    if ( !empty($toptrack_result) ) {
        echo '<ul>';
        foreach ($toptrack_result as $comment) :
            $post = get_postdata($comment->comment_post_ID);
            $tb_aut = $comment->top_track;
            $tb_aut = str_ireplace("http://", "", $tb_aut);
            echo '<li style="list-style-type:none"><br /><a href="'.$comment->top_track.'/" title="'.$comment->top_track.'"target="_blank">'.$tb_aut.'</a> ('.$comment->top_num.')<br />zuletzt am '.$comment->comment_date_ger.' in:<br /><a href="http://themenfreund.de/'. $post['Title'] .'" title="'.$post['Title'].'">'.$post['Title'].' </a></li>';
        endforeach;
        echo '</ul>';
    }
}

function get_random_posts()
{
        $random_posts = get_posts(
        array(
            'numberposts' => 3,
            'orderby' => 'rand'
        )
    );
        $output = '<ul id="articleList">';
        foreach($random_posts as $post)
    {
        $post_title = $post->post_title;
        $post_permalink = get_permalink($post->ID);
        $thumbnail = get_the_post_thumbnail($post->ID, '40x40_thumb',
            array(
                'class' => '',
                'alt' => trim(strip_tags($post_title)),
                'title' => trim(strip_tags($post_title)),
            )
        );


        $output .= '<li><a href="' . $post_permalink . '" title="' . $post_title . '">' . $thumbnail . '<span>' . $post_title . '</span><div class="clear"></div></a></li>';
    }


    return $output . '</ul>';
}

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>';
 }
 }
 }