una/inc/classes/BxDolSessionQuery.php

<?php
/**
 * @package     Dolphin Core
 * @copyright   Copyright (c) BoonEx Pty Limited - http://www.boonex.com/
 * @license     CC-BY - http://creativecommons.org/licenses/by/3.0/
 */
defined('BX_DOL') or die('hack attempt');

bx_import('BxDolDb');

/**
 * @see BxDolSession
 */
class BxDolSessionQuery extends BxDolDb {
    var $sTable;

    function BxDolSessionQuery() {
        parent::BxDolDb();

        $this->sTable = 'sys_sessions';
    }
    function getTableName() {
        return $this->sTable;
    }
    function exists($sId) {
        $sSql = $this->prepare("SELECT `id`, `user_id`, `data` FROM `" . $this->sTable . "` WHERE `id`=? LIMIT 1", $sId);
        $aSession = $this->getRow($sSql);
        return !empty($aSession) ? $aSession : false;
    }
    function save($sId, $aSet) {
        $sSetClause = $this->prepare("`id`=?", $sId);
        foreach($aSet as $sKey => $sValue)
            $sSetClause .= $this->prepare(", `" . $sKey . "`=?", $sValue);
        $sSetClause .= ", `date`=UNIX_TIMESTAMP()";

        return (int)$this->query("REPLACE INTO `" . $this->sTable . "` SET " . $sSetClause) > 0;
    }
    function delete($sId) {
        $sSql = $this->prepare("DELETE FROM `" . $this->sTable . "` WHERE `id`=? LIMIT 1", $sId);
        return (int)$this->query($sSql) > 0;
    }
    function deleteExpired() {
        $sSql = $this->prepare("DELETE FROM `" . $this->sTable . "` WHERE `date` < (UNIX_TIMESTAMP() - ?)", BX_DOL_SESSION_LIFETIME);
        $iRet = (int)$this->query($sSql);
        $this->query("OPTIMIZE TABLE `" . $this->sTable . "`");
        return $iRet;
    }
}