I have an instance of a moodle course which has a large amount of assignments (263).
Im looking for a solution to grant an extension to an individual student without have to go into each assignment manually.
I have found the Database Table `mdl_assign_user_flags` which record a granted extension and can update using the following query:
INSERT INTO `mdl_assign_user_flags` (`id`, `userid`, `assignment`, `locked`, `mailed`, `extensionduedate`, `workflowstate`, `allocatedmarker`) VALUES (NULL, '1118', '305', '0', '0', '1626649140', NULL, '0');
Does anyone know how I could apply a query that would insert the `extensionduedate` - '1626649140' to multiple assignments i.e. `assignment` '305' through '399' ??
thanks in advance
James.