outsmain
commented
10 years ago - Import table sql/LOGIN_LOG.sql
- Record all user activities to table LOGIN_LOG
- Save activity time to LOGIN_LOG.update_date
- Save login user name to LOGIN_LOG.user_name
- Save login user IP address to LOGIN_LOG.user_ip
- Activity status in column LOGIN_LOG.status are
- LOGIN_FAILED User/password is incorrect
- OK no error
- INVALID_TIME Invalid login day/time defined in ACCESS_NAME
- INVALID_COMMAND Not allow command e.g. not allow to open a page
- INVALID_CLIENT Login from invalid host
- Activity name in LOGIN_LOG.command are
- LOGIN user is attempt to login
- LOGOUT user is logged out
- OPEN user open a page, set value of LOGIN_LOG.value to page's URI (not include server name)
- ADD user add something e.g. add user, set LOGIN_LOG.value to user name
- MODIFY user change some value e.g. change e-mail/name/password, set LOGIN_LOG.value to user name
- REMOVE user remove something e.g. delete existing user, set LOGIN_LOG.value to user name
nuengcpe