Beiträge von Marcuss

function updated_article() {
    global $wpdb;
    $Aenderungsdatum = get_post_meta($post->ID, 'Ãnderungsdatum', true);   $upd_query = "SELECT post_date, post_status, post_type, post_modified, 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 ( $Aenderungsdatum != "ja") {
    echo '<small>... keine aktualisierten Artikel</small>';
    }    else
    {
    foreach ($upd_result as $updat) :
        $post_modified_ger = $updat->post_modified_ger;
        $posttitle = $updat->posttitle;
        $postname = $updat->postname;
         $postid = $updat->postid;
    echo '<ol>';
    echo '<li style="list-style-type:none"><div class="akt-titel"><a href="'.$updat->postname.'" title="'.$updat->posttitle.'">'.$updat->posttitle.'</a></div><h6 class="aktualisiert1">Aktualisiert am: '.$updat->post_modified_ger.'</h6></li>';
    echo '</ol>';
    endforeach;}}

function updated_article() {
    global $wpdb;
    $upd_query = "SELECT post_date, post_status, post_type, post_ID, post_modified, 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, $wpdb->postmeta wppostmeta
        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";
        global $wp_query;
    $upd_result = $wpdb->get_results($upd_query);
    $postid = $wp_query->post->ID;
    $Aenderungsdatum = get_post_meta($post->ID, 'Änderungsdatum', true);
    if ( empty($upd_result) || get_post_meta($post->ID, 'Änderungsdatum', false) == 'ja') {
    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;
    echo '<ol>';
    echo '<li style="list-style-type:none"><div class="akt-titel"><a href="'.$updat->postname.'" title="'.$updat->posttitle.'">'.$updat->posttitle.'</a></div><h6 class="aktualisiert1">Aktualisiert am: '.$updat->post_modified_ger.'</h6></li>';
    echo '</ol>';
    endforeach;}

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