classes/captcha/CaptchaDAO.inc.php

<?php

// $Id: CaptchaDAO.inc.php,v 1.7 2008/07/01 01:16:09 asmecher Exp $


import('captcha.Captcha');

class CaptchaDAO extends DAO {
   function &getCaptchasBySessionId($sessionId) {
      $captchas = array();

      $result = &$this->retrieve('SELECT * FROM captchas WHERE session_id = ?', $sessionId);

      while (!$result->EOF) {
         $captchas[] = &$this->_returnCaptchaFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $captchas;
   }

   function &getExpiredCaptchas($lifespan = 86400) {
      $captchas = array();
      $threshold = time() - $lifespan;

      $result = &$this->retrieve('SELECT c.* FROM captchas c LEFT JOIN sessions s ON (s.session_id = c.session_id) WHERE s.session_id IS NULL OR c.date_created <= ' . $this->datetimeToDB($threshold));

      while (!$result->EOF) {
         $captchas[] = &$this->_returnCaptchaFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $captchas;
   }

   function &getCaptcha($captchaId) {
      $result = &$this->retrieve(
         'SELECT * FROM captchas WHERE captcha_id = ?', $captchaId
      );

      $captcha = null;
      if ($result->RecordCount() != 0) {
         $captcha = &$this->_returnCaptchaFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $captcha;
   }  

   function &_returnCaptchaFromRow($row) {
      $captcha = &new Captcha();
      $captcha->setCaptchaId($row['captcha_id']);
      $captcha->setSessionId($row['session_id']);
      $captcha->setValue($row['value']);
      $captcha->setDateCreated($this->datetimeFromDB($row['date_created']));

      HookRegistry::call('CaptchaDAO::_returnCaptchaFromRow', array(&$captcha, &$row));

      return $captcha;
   }

   function insertCaptcha(&$captcha) {
      $captcha->setDateCreated(Core::getCurrentDate());
      $this->update(
         sprintf('INSERT INTO captchas
            (session_id, value, date_created)
            VALUES
            (?, ?, %s)',
            $this->datetimeToDB($captcha->getDateCreated())),
         array(
            $captcha->getSessionId(),
            $captcha->getValue()
         )
      );

      $captcha->setCaptchaId($this->getInsertCaptchaId());
      return $captcha->getCaptchaId();
   }

   function getInsertCaptchaId() {
      return $this->getInsertId('captchas', 'captcha_id');
   }  

   function deleteCaptcha(&$captcha) {
      $result = $this->update('DELETE FROM captchas WHERE captcha_id = ?', $captcha->getCaptchaId());
   }

   function updateCaptcha(&$captcha) {
      $this->update(
         sprintf('UPDATE article_captchas
            SET
               session_id = ?,
               value = ?,
               date_created = %s
            WHERE captcha_id = ?',
            $this->datetimeToDB($captcha->getDateCreated())),
         array(
            $captcha->getSessionId(),
            $captcha->getValue(),
            $captcha->getCaptchaId()
         )
      );
   }
}

?>

---