ChWsbSessionQuery.php

Go to the documentation of this file.

<?php
 
require_once (CH_DIRECTORY_PATH_CLASSES . 'ChWsbDb.php');
 
class ChWsbSessionQuery extends ChWsbDb
{
    var $sTable;
 
    function __construct()
    {
        parent::__construct();
 
        $this->sTable = 'sys_sessions';
    }
    function getTableName()
    {
        return $this->sTable;
    }
    function exists($sId)
    {
        $aSession = $this->getRow("SELECT `id`, `user_id`, `data` FROM `" . $this->sTable . "` WHERE `id`= ? LIMIT 1", [$sId]);
        return !empty($aSession) ? $aSession : false;
    }
    function save($sId, $aSet)
    {
        $sSetClause = "`id`='" . $sId . "'";
        foreach($aSet as $sKey => $sValue)
            $sSetClause .= ", `" . $sKey . "`='" . $sValue . "'";
        $sSetClause .= ", `date`=UNIX_TIMESTAMP()";
 
        return (int)$this->query("REPLACE INTO `" . $this->sTable . "` SET " . $sSetClause) > 0;
    }
    function delete($sId)
    {
        return (int)$this->query("DELETE FROM `" . $this->sTable . "` WHERE `id`='" . $sId . "' LIMIT 1") > 0;
    }
    function deleteExpired()
    {
        $iRet = (int)$this->query("DELETE FROM `" . $this->sTable . "` WHERE `date`<(UNIX_TIMESTAMP()-" . CH_WSB_SESSION_LIFETIME . ")");
        $this->query("OPTIMIZE TABLE `" . $this->sTable . "`");
        return $iRet;
    }
}