Up: Further developing
Previous: Further developing
The method of checking the login time for the user is needed to prevent system before unclosed session. There are three columns in the users table which are used by this method: session_status column which is fill in during the logging (the flag of this column is set as ACTIVE), last_login column which is fill in by the logging timestamp and last_activ_time column which is updated during the user session. The last column is updated by the actual timestamp everytime when the user executes some action on the database. In the same time algorithm checks also the activation time for the all others users and compares it with the actual time. If the difference for some user is greater then defined timeout then the user session is closed. The timeout should be defined as a global value in the configuration file.
Checking the login time and the current status of the users