Greetings,
We have a course that students must retake every 2 years.
Is there a feature in GURU to reset users in this case?
I tried to write an SQL statement for this.
$sql = "SELECTuser_id,course_idFROM#__guru_mycertificatesWHEREcourse_id= 4 ANDcompleted= 1 ANDdatecertificate< YEAR(NOW()) - $year";
This is supposed to start a process of resetting all users' scores who completed the course X $years ago.
Thanks,
Mark