Timestat

Hi!
I am using Moodle 2.7 and installed Timestat (block_timestat_moodle26_2014041101) and I have added it to one course and it is calculating nothing!
Why this is happening? Looking forward to get help!

Time stored in database field is in seconds format.

Dear Łukasz Sanokowski,
What is the unif of timespent field in the mdl_block_timestat table ? It's by minute or second or hour, how to count it's real time ? Thanks a lot.

The table mdl_block_timestat contains a "log_id" field which references to particular record in mdl_log table. The "timespent" field is a time, measured in second, which was spent on Moodle site, on page which is described in "mdl_log" table with "mdl_log.id" = "mdl_block_timestat.log_id"

Dear Łukasz Sanokowski
I can use phpmyadmin or other plugin to use sql query, but I don't know it's relationship between mdl_log and mdl_block_timestat. (I don't know the field definition of mdl_block_timestat)
Thanks a lot.

Hello Anderson
There is no fixed SQL query build in. The query is generated dynamically with use of parameters set in this app form.

Dear partners,
If there sql example which we can join mdl_block_timestat and mdl_log table to list time spent by course or account ? Thanks a lot.

Hi,
Your plugin is not working in Moodle 3.1 as you are retrieving the data from legacy log which is disable in 3.1 version. so do we have any method to resolve this issue.
Looking forward for your reply.

Hi Anderson
Timestat have some influence on overall Moodle performance. It have to store data (amount of time spent online) in database. The query is executed on exit of every displayed webpage (for example on reload, going to another url etc.). During this there is executed query which find latest record in log table of particular user in particular course. If the log table is big, this query can take some time, especially on slow server. If the speed now is too slow for you, consider improving performance of your server (that is the obvious answer ;), or reduce size of the log table - timestat works on legacy log table, there is a parameter named "loglifetime" when you can set a maximum lifetime of log entries.
Regards

Dear partners,
We found after install timestat blocks, the speed of moodle website become a little slow. Is there any suggestion for adjust the question ? Thank you.

Good morning,
I installed its plugin, made various changes and php activated log_legacy, the problem is that does not count the right time.
For example we have entered a time MINIMUM to complete a lesson, 2 hours, in order to unlock the voice CERTIFICATE and download a certificate of course completion.
But when I go to counted per time with timestat it tells me 12 minutes, when it is impossible to complete the lesson because you have to put two hours, and I see that log_standard began the lesson at 13:04 and ended at 15:30.
Why timestat makes me a count wrong?

Also addition to above note I have tried with latest version,but still facing same issue.

Hi,
I have instilled timestat block(release 1.2.1) on moodle 2.8.
But when user is just enrolled one course and user visit the course for first time and suppose user spent10 min on course.
Then I go to block and then click on 'Calculate',it does not show any record.
But when user visits course for second time and spent 5 min. Then I go to block and then click on 'Calculate',it shows record for 2 visit that is course with 5 min spent on course.
Why this is happening? Am I missing something?
Thanks,
Komal.

Hi,
Thanks for your reply.
I have tried with latest version also,still facing same problem.

Komal, please try latest version (1.2.2.1)