<?php
 
#######################################
## CORE OVERRIDE - EDIT BLOG COMMENT ##
#######################################
 
### alters the original code as shown such that only the comment text is updated upon edit,
### and the original posting timestamp is left unchanged on approval or unapproval.
 
defined('C5_EXECUTE') or die("Access Denied.");
class GuestbookBlockController extends Concrete5_Controller_Block_Guestbook { }
 
class GuestBookBlockEntry extends Concrete5_Controller_Block_GuestbookEntry {
 
   private function adjustCountCache($number=false){
      $ca    = new Cache();
      $db    = Loader::db();         
      $count = $ca->get('GuestBookCount',$this->cID."-".$this->bID);
      if($count && $number){
         $count += $number;            
      } else {
         $q = 'SELECT count(bID) as count
         FROM btGuestBookEntries
         WHERE bID = ?
         AND cID = ?
         AND approved=1';            
         $v = Array($this->bID, $this->cID);
         $rs = $db->query($q,$v);
         $row = $rs->FetchRow();
         $count = $row['count'];
      }
      $ca->set('GuestBookCount',$this->cID."-".$this->bID,$count);
   }
 
   function updateEntry($entryID, $comment, $name, $email, $uID=0 ) {
      $db = Loader::db();
      $txt = Loader::helper('text');
      //$query = "UPDATE btGuestBookEntries SET user_name=?, uID=?, user_email=?, commentText=? WHERE entryID=? AND bID=?";
      $query = "UPDATE btGuestBookEntries SET commentText=?, entryDate = entryDate WHERE entryID=? AND bID=?";
      //$res = $db->query($query, array($txt->sanitize($name), intval($uID), $txt->sanitize($email),$txt->sanitize($comment),$entryID,$this->bID));
      $res = $db->query($query, array($txt->sanitize($comment), $entryID, $this->bID));
   }
 
   function approveEntry($entryID) {
      $db = Loader::db();
      //$query = "UPDATE btGuestBookEntries SET approved = 1 WHERE entryID=? AND bID=?";
       $query = "UPDATE btGuestBookEntries SET approved = 1, entryDate = entryDate WHERE entryID=? AND bID=?";
      $res = $db->query($query, array($entryID, $this->bID));
      $this->adjustCountCache(1);
   }
 
   function unApproveEntry($entryID) {
      $db = Loader::db();
      //$query = "UPDATE btGuestBookEntries SET approved = 0 WHERE entryID=? AND bID=?";
      $query = "UPDATE btGuestBookEntries SET approved = 0, entryDate = entryDate WHERE entryID=? AND bID=?";
      $res = $db->query($query, array($entryID, $this->bID));
      $this->adjustCountCache(-1);
   }
 
}