 |
SELECT `sessionData` FROM `sys_session` WHERE `sessionID`='239fcab5048a952db779b3817a697439' AND `keepRecord`!='E' |
 |
SELECT `userID` FROM sys_session WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(lastUpdate) > 1440 AND `userID` IS NOT NULL |
 |
UPDATE `sys_session` SET `status`='logged off', `keepRecord`='E' WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(lastUpdate) > 1440 AND `keepRecord`='Y' |
 |
DELETE FROM `sys_session` WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(lastUpdate) > 1440 AND `keepRecord`='N' |