Recent Entries

Popular Entries

query('showposts=10'); $i = 0; while ($popular->have_posts()) : $popular->the_post(); $total = get_comments_number(); if ($total > 5) { if($i < 5) { ?>

Recent Comments

comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' ORDER BY comment_date_gmt DESC LIMIT 10"; $comments = $wpdb->get_results($sql); $output = false; $output .= "\n

"; foreach ($comments as $comment) { $output .= "\n
• ". get_avatar($comment, 32) ."".strip_tags($comment->comment_author) .":" . "ID) . "#comment-" . $comment->comment_ID . "\" title=\"on " . $comment->post_title . "\">" . strip_tags($comment->com_excerpt) ."
"; } $output .= "\n

"; $output .= $post_HTML; echo $output;?>

Top Comments

get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 10"); foreach ($result as $topten) { $postid = $topten->ID; $title = $topten->post_title; $commentcount = $topten->comment_count; if ($commentcount != 0) { ?>