Example #1
0
 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;
 }
Example #2
0
 /**
  * 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;
 }