sec_update_user_session_info (private)

 sec_update_user_session_info user_id

Defined in packages/acs-tcl/tcl/security-procs.tcl

Update the session info in the users table. Should be called when the user login either via permanent cookies at session creation time or when they login by entering their password.

Parameters:

user_id (required)

Testcases:

No testcase defined.

Source code:

    db_dml update_last_visit {}
    db_release_unused_handles

Generic XQL file:

<fullquery name="sec_update_user_session_info.update_last_visit">
    <querytext>

        update users
        set second_to_last_visit = last_visit,
            last_visit = current_timestamp,
            n_sessions = n_sessions + 1
        where user_id = :user_id

      </querytext>
</fullquery>

packages/acs-tcl/tcl/security-procs.xql

PostgreSQL XQL file:

packages/acs-tcl/tcl/security-procs-postgresql.xql

Oracle XQL file:

packages/acs-tcl/tcl/security-procs-oracle.xql