Function: nornix_site.session_write_timestamp

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Update session timestamp, returns number of affected rows

CREATE DEFINER=`root`@`localhost` FUNCTION `session_write_timestamp`(vId VARBINARY(32), vVal
LONGBLOB) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Update session timestamp, returns number of affected rows'
BEGIN
 UPDATE phpsession SET accessed = NULL WHERE id = vId;
 RETURN ROW_COUNT();
END