<ul>
<?php $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 5");
foreach ($result as $post) {
setup_postdata($post);
$postid = $post->ID;
$title = $post->post_title;
$commentcount = $post->comment_count;
if ($commentcount != 0) { ?>
<li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>">
<?php echo $title ?></a> {<?php echo $commentcount ?>}</li>
<?php } } ?>
</ul>
2009-08-22T15:30:43Z
196
35
false
wordpress popular posts
2009-08-22T15:30:43Z
7
function getShortUrl($url) {
$tinyurl = file_get_contents("http://tinyurl.com/api-create.php?url=".$url);
return $tinyurl;
}
2009-04-26T14:42:42Z
paste the function in function.php file and call in you template with:
<?php echo '<a href="'.getShortUrl(get_permalink($post->ID)).'">short url</a>'; ?>
172
35
false
short url in wordpress with tinyurl
2009-04-26T14:42:42Z
7
// comments_count
function comments_count() {
global $wpdb;
$count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'";
echo $wpdb->get_var($count);
}
// < ?php comments_count() ?> comments
// posts_count
function posts_count() {
global $wpdb;
$count = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'";
echo $wpdb->get_var($count);
}
// <?php posts_count() ?></strong> articles
// retro_count
function retro_count() {
global $wpdb;
$count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_type = 'pingback'";
echo $wpdb->get_var($count);
}
// < ?php retro_count() ?> pingbacks
2008-11-18T02:26:17Z
for example: save all functions in 'your_theme/stats.php'
107
35
false
wordpress functions to count posts
2008-11-18T02:26:17Z
7