BibSonomy :: url :: How to Create a Comments Central Page Template in WordPress | Theme Lab

Community Page

How to Create a Comments Central Page Template in WordPress | Theme Lab

http://www.themelab.com/2010/02/24/how-to-create-a-comments-central-page-template-in-wordpress/

    Please log in to take part in the discussion (add own reviews or comments).

    bookmarks  1

    •  

      <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> ·
      4 years and a month ago by @fabian
      (0)
       
       

    publications  

      No matching items.