public function cleanOldSessions(Mage_Api_Model_User $user) { $timeout = Mage::getStoreConfig('api/config/session_timeout'); $this->_getWriteAdapter()->delete($this->getTable('api/session'), $this->_getReadAdapter()->quoteInto('user_id = ?', $user->getId()) . ' AND ' . new Zend_Db_Expr('(UNIX_TIMESTAMP(\'' . now() . '\') - UNIX_TIMESTAMP(logdate)) > ' . $timeout)); return $this; }
/** * Clean old session * * @param Mage_Api_Model_User $user * @return Mage_Api_Model_Resource_User */ public function cleanOldSessions(Mage_Api_Model_User $user) { $readAdapter = $this->_getReadAdapter(); $writeAdapter = $this->_getWriteAdapter(); $timeout = Mage::getStoreConfig('api/config/session_timeout'); $timeSubtract = $readAdapter->getDateAddSql('logdate', $timeout, Varien_Db_Adapter_Interface::INTERVAL_SECOND); $writeAdapter->delete($this->getTable('api/session'), array('user_id = ?' => $user->getId(), $readAdapter->quote(now()) . ' > ' . $timeSubtract)); return $this; }