BackendUserSessionRepository.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Beuser\Domain\Repository;

class BackendUserSessionRepository extends \TYPO3\CMS\Extbase\Persistence\Repository {

    public function findByBackendUser(\TYPO3\CMS\Beuser\Domain\Model\BackendUser $backendUser) {
        $sessions = array();
        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
            'ses_id AS id, ses_iplock AS ip, ses_tstamp AS timestamp',
            'be_sessions',
            'ses_userid = ' . (int)$backendUser->getUid(),
            '',
            'ses_tstamp ASC'
        );
        while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
            $sessions[] = array(
                'id' => $row['id'],
                'ip' => $row['ip'],
                'timestamp' => $row['timestamp']
            );
        }
        $GLOBALS['TYPO3_DB']->sql_free_result($res);
        return $sessions;
    }

    public function switchBackToOriginalUser(\TYPO3\CMS\Core\Authentication\AbstractUserAuthentication $authentication) {
        $updateData = array(
            'ses_userid' => $authentication->user['ses_backuserid'],
            'ses_backuserid' => 0,
        );
        $GLOBALS['TYPO3_DB']->exec_UPDATEquery(
            'be_sessions',
            'ses_id = ' . $GLOBALS['TYPO3_DB']->fullQuoteStr($GLOBALS['BE_USER']->id, 'be_sessions') .
                ' AND ses_name = ' . $GLOBALS['TYPO3_DB']->fullQuoteStr(\TYPO3\CMS\Core\Authentication\BackendUserAuthentication::getCookieName(), 'be_sessions') .
                ' AND ses_userid=' . (int)$GLOBALS['BE_USER']->user['uid'], $updateData
        );
    }

}