How to Backdate Course and Log data

How to Backdate Course and Log data

by Ronald Leonardo -
Number of replies: 2
Hello, is there a way to backdate all the date and log date within moodle website

I was asked by my supervisor to make a moodle website 
with a single course for research purposes.
Long story short,  the course is done, and running. 
We keep all the logs from all
the participants, teachers, and also the administrator.
But I've only now figured that the website date is all wrong,
maybe because I'm from Indonesia
thus all the log is also wrong
(The date and hour is in the future and somehow it's in different months)


How do I access and change the log database
(I installed moodle using softaculous feature from hosting website
and I do have access to cpanel and root files in the hosting site)
or if there's another alternative solution to this.

I also tried to present just the excel sheet of the log file 
(which i downloaded from moodle and change the log date manually)
but my supervisor wanted me to change the log inside the moodle too.

Ps.
I understand a bit of programming 
(I somehow made it with the help of youtube, basic html, css, basic javascript,
and I know a little about Mysql)
but I can learn so if it's not too much of a bother it'll be really helpful
if there's more detailed explanation and steps.


Sincerely Ronald,


Thank you
Average of ratings: -
In reply to Ronald Leonardo

Re: How to Backdate Course and Log data

by Tim Hunt -
iTaba kei {Sa} iTaba kei {Sa} iTaba kei {Sa} iTaba kei {Sa} iTaba kei {Sa}
In Moodle, dates are stored in the database as Unix timestamps. That is, number of second since 1970-01-01 00:00:00 UTC. They are the displayed in the time-zone of whichever user is logged in (which is set in each user's user profile).

If you have direct access to the database, you could adjust all the times in key tables by applying a offset to all the relevant columns like logstore_standard_log.timecreated - but there are quite a lot of time-related columns. You probably need to look through the DB scheme, and find all the columns with 'time' in the name.
Average of ratings:Useful (2)