History: User Category Logs

Description

The purpose of this developpement is to be able to follow and synthesize the activities for a user during a period of time , and the activities around a category during a period of time. In the education context, category can be used to represent a work.

The activities are:
- user login time (the estimation of the logout time is the last url request
- an object viewed or download / edited / posted or created or uploaded

An object is:
- a wiki page
- a wiki comment
- a forum post
- a file (from file gallery, wiki attachment, forum attachment)
- an image (from image gallery, wiki image)
- a message
This is a limited list for now.

What exists in Tikiwiki 1.9.0

Tikiwiki 1.9.0 is collecting some logs that are more on an admin point of view. See Admin-> Tiki Logs. Login, logout, registration, perms changed, group/user assignment, modules assignment, tracker fields change, cache cleaning....
PS: The automatic logout is not memorized.

What needs to be done:

- collect an estimating logout time (the last access to an url is already memorized in tiki in the tiki-sessions table. Needs only to be added to the logs table before before clean)
- collect all this information
- have an interface to display/sort them.

Implementation

Dilemma: Do we upgrade the tiki_logs table or do we create another one?
The actual tiki_logs table is not "effcicient" for filter, statistics purpose. For instance the additionnal parameters as groupname ... are stuck in the message string. It is impossible to translate and inefficient
So I think it is better to create another table that will contain the columns:
user, category, time, object_id, object_type, action
Each line will be for a user or for a category.
For example if a user creates a page in 2 categories, there will be 3 lines: one for the user, and one for each category