<?php defined('C5_EXECUTE') or die("Access Denied.");
 
class CommentCountHelper {
 
   public function comment_count_string($collectionObject, $singular_format, $plural_format, $disabled_message = '') {
      //if ($this->comments_enabled($collectionObject)) {
         $count = $this->comment_count($collectionObject);
         $format = ($count == 1 ? $singular_format : $plural_format);
         return sprintf($format, $count);
      //} else {
      //   return $disabled_message;
      //}
   }
 
   public function comment_get_last($collectionObject) {
      //if ($this->comments_enabled($collectionObject)) {
         $count = $this->comment_count($collectionObject);
         if ($count > 0)
         {
            $string = $this->comment_last($collectionObject);
            return sprintf($string);
         }else
         {
            return "";
         }
      //} else {
      //   return $disabled_message;
      //}
   }
 
   public function comments_enabled($collectionObject) {
      //Determine if a guestbook block exists on the given page
      $db = Loader::db();
      $sql = 'SELECT COUNT(*)'
           . ' FROM CollectionVersionBlocks INNER JOIN Blocks ON (CollectionVersionBlocks.bID = Blocks.bID)'
           . ' INNER JOIN BlockTypes ON (Blocks.btID = BlockTypes.btID)'
           . ' WHERE CollectionVersionBlocks.cID = ?'
           . ' AND (CollectionVersionBlocks.cvID = ? OR CollectionVersionBlocks.cbIncludeAll=1)'
          . ' AND BlockTypes.btHandle = "guestbook"';
      $args = array($collectionObject->getCollectionID(), $collectionObject->getVersionID());
      $count = $db->GetOne($sql, $args);
      return ($count > 0);
   }
 
   public function comment_count($collectionObject) {
      //Query on the collection id as opposed to the block id in case guestbook is an alias of Page Defaults
      // (so we don't get the total count of all instances of that block on all pages).
      $db = Loader::db();
      $sql = 'SELECT COUNT(*) as count FROM btGuestBookEntries WHERE approved=1 AND cID=?';
      $args = Array($collectionObject->cID);
      return $db->GetOne($sql, $args);
 
   }
 
   public function comment_last($collectionObject) {
      //Query on the collection id as opposed to the block id in case guestbook is an alias of Page Defaults
      // (so we don't get the total count of all instances of that block on all pages).
      $db = Loader::db();
      $sql = 'SELECT user_name AS USER, DATE_FORMAT(entryDate,"%M %e, %Y") AS TIME FROM btGuestBookEntries WHERE entryDate=(SELECT MAX(entryDate) FROM btGuestBookEntries WHERE approved=1 AND cID=?)';
      $args = Array($collectionObject->cID);
      $row= $db->GetRow($sql, $args);
      return $row['USER']." replied on ".$row['TIME'];
   }
 
}
 

 
<?php 
defined('C5_EXECUTE') or die("Access Denied.");
$rssUrl = $showRss ? $controller->getRssUrl($b) : '';
$th = Loader::helper('text');
$cc_phrase_singular = '%d comment';
$cc_phrase_plural = '%d comments';
$cc_phrase_disabled = 'Comments disabled';
$cch = Loader::helper('comment_count');
?>
<div class="ccm-page-list">
   <?php  foreach ($pages as $page):
      $title = $th->entities($page->getCollectionName());
      $url = $nh->getLinkToCollection($page);
      $date = $page->getCollectionDatePublic(DATE_APP_GENERIC_MDY_FULL);
      $author = $page->getVersionObject()->getVersionAuthorUserName();
      $target = ($page->getCollectionPointerExternalLink() != '' && $page->openCollectionPointerExternalLinkInNewWindow()) ? '_blank' : $page->getAttribute('nav_target');
      $target = empty($target) ? '_self' : $target;
      $description = $page->getCollectionDescription();
      $description = $controller->truncateSummaries ? $th->shorten($description, $controller->truncateChars) : $description;
      $description = $th->entities($description);   
      ?>
      <div class="entry">
   <div class="title">
     <h3 class="ccm-page-list-title floatleft">
        <a href="<?php  echo $url ?>" target="<?php  echo $target ?>"><?php  echo $title ?></a>
     </h3>
   </div>
     <div class="floatright">
        <p class="commentcount">
            <?php echo $cch->comment_count_string($page, $cc_phrase_singular, $cc_phrase_plural, $cc_phrase_disabled); ?>
        </p>
     </div>
     <br />
   <div class="floatright">
     <p class="lastcomment">
        <a href="<?php  echo $url ?>" target="<?php  echo $target ?>"><?php echo $cch->comment_get_last($page); ?></a>
     </p>
   </div>
   <div class="clearfix"></div>
   <div class="title">
     <h4 class="original_post floatleft">
          <?php  
          echo t('posted by %s on %s',$author,$date);
          ?>
     </h4>
   </div>
   <div class="clearfix"></div>
 
     <div class="ccm-spacer"></div>
     <div class="meta">
        <a href="<?php  echo $url; ?>"><?php  echo t('Read full post'); ?> »</a>
     </div>
      </div>
      <div class="clearfix"><hr /></div>
   <?php  endforeach; ?>
</div>