Create

Edit

Moderate

Moderate comments

get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND post_date_gmt < '$today' ORDER BY post_date DESC LIMIT 5") ) : ?>

»

"; the_title(); echo '

get_results("SELECT ID, post_title, post_date_gmt FROM $wpdb->posts WHERE post_status = 'publish' AND post_date_gmt > '$today'") ) : ?>

$post->post_title in " . human_time_diff( current_time('timestamp', 1), strtotime($post->post_date_gmt) ) . "

get_results("SELECT comment_author, comment_author_url, comment_ID, comment_post_ID FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 5") ) : ?>

»

' . get_the_title($comment->comment_post_ID) . '

(', ')

get_var("SELECT COUNT(*) FROM $tablecomments WHERE comment_approved = '0'") ) : ?>

get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'"); if (0 < $numposts) $numposts = number_format($numposts); $numcomms = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'"); if (0 < $numcomms) $numcomms = number_format($numcomms); $numcats = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->categories"); if (0 < $numcats) $numcats = number_format($numcats); ?>

There are currently posts and comments, contained within categories.

get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'draft' AND post_author = $user_ID"); if ($drafts) { ?>

post_title = stripslashes($draft->post_title); if ($draft->post_title == '') $draft->post_title = sprintf(__('Post #%s'), $draft->ID); echo "$draft->post_title"; ++$i; } ?> .