BibSonomy :: url :: How to Create a Comments Central Page Template in WordPress | Theme Lab
How to Create a Comments Central Page Template in WordPress | Theme Lab
This web page has not been reviewed yet.
rating distribution
average user rating
?
The average rating is computed over all reviews. However, some of them may be invisible to you due to the visibility setting chosen by the reviewers.
(0.0 of 5.0 based on 0 reviews)
    Please log in to take part in the discussion (add own reviews or comments).
    • preview
      <h3>Recent Comments</h3> <ul id="cc-recent-comments"> <?php $max = 7; // number item to get global $wpdb; $sql = "SELECT c.*, p.post_title FROM $wpdb->comments c INNER JOIN $wpdb->posts p ON (c.comment_post_id=p.ID) WHERE comment_approved = '1' AND comment_type not in ('trackback','pingback') ORDER BY comment_date DESC LIMIT $max"; $results = $wpdb->get_results($sql); $template = '%g <a href="%au">%an</a> on <a href="%pu#comment-%cid">%pt</a>'; $echoed = 0; foreach ($results as $row) { $tags = array('%ct','%cd','%g','%pt','%pu','%au','%an','%cid'); $replacements = array($row->comment_title,$row->comment_date,get_avatar($row->comment_author_email,'32'),$row->post_title,get_permalink($row->comment_post_ID),$row->comment_author_url,$row->comment_author,$row->comment_ID); echo '<li>' . str_replace($tags,$replacements,$template) . '</li>'; $echoed = 1; } if ($echoed==0) echo '<li>No comment found.</li>'; ?> </ul> · http://www.themelab.com/2010/02/24/how-to-create-a-comments-central-page-template-in-wordpress/
      4 years ago
      by fabian
      1
      (0)
      No matching items.