Example #1
0
 /**
  * Garbage Collector
  *
  * @param string $maxlifetime Time in seconds until a session expires
  *
  * @return bool
  */
 public function gc($maxlifetime)
 {
     $mintime = time();
     $qb = $this->db->createXoopsQueryBuilder();
     $eb = $qb->expr();
     $qb->deletePrefix($this->sessionTable)->where($eb->lt('expires_at', ':expires'))->setParameter(':expires', $mintime, \PDO::PARAM_INT);
     $this->db->setForce(true);
     return $qb->execute();
 }
Example #2
0
 /**
  * execute an SQL statement
  *
  * @param string $sql   SQL statement to execute
  * @param bool   $force true to use force updates even in safe requests
  *
  * @return mixed result Statement or false if error
  */
 private function execSql($sql, $force = false)
 {
     if ($force) {
         $this->db->setForce(true);
     }
     $result = $this->db->query($sql);
     if (!$result) {
         $this->lastError = $this->db->errorInfo();
         $this->lastErrNo = $this->db->errorCode();
     }
     return $result;
 }