Reset user scores

marq-104

Greetings,
My users need to retake the tests every so often.
How can I reset users who have completed the courses back to 'zero'?

saguaros

Did you try to remove that test users from selected course?

marq-104

I don't want to remove the users.
I just need to reset their 'completed' status back to 0.
I have to do that for all users who have successfully completed the course.
Perhaps an SQL script is what I need.

saguaros

You can try with 'Reset' button on above screenshot, it will remove all view status, quiz answer, certificate, etc ....

marq-104

Greetings,
This is a great solution, but I have hundreds of users.
Which file contains this function?
Could I run an SQL script instead?

This would give me a list of user_id that have completed the final quiz.
SELECT 'user_id' FROM #_guru_mycertificates WHERE 'completed' = 1

Then reset those users.

Thanks

marq-104

This message is visible to Moderators only

hidden content

manhta

marq-104
Hi,
That's correct. You can change $course_id and $user_id as much as you want.

marq-104

Greetings,
There is a major error in the backend script.
I made a back-up before running the script to reset myself, also the website Super-User.
Then I made another backup.
Something in the script caused me to loose my SU-Status.
Luckily, I could run Akeeba-Backup as administrator.
On restoring the second backup my username was NOT in the list of SU.
Only by restoring the beckup before I reset myself, was my username listed.

Somewhere in your $resetUsers function, if the user being reset is a SU, they loose that status.
Please look into this.

manhta

marq-104 Something in the script caused me to loose my SU-Status.

Hi,
I don't know what is SU-Status. Could you clarify it? I pretty sure, the code above only delete stats and certificate from guru, nothing more.
Regards

marq-104

I am the Super-User for this website.
I'm also in the Administrator group.
When I reset my scores in Guru, it also removed me from the list of Super Users.

Only since administrators can also use Akeeba backup, could I install a backup where I WAS listed and a Super-User.

saguaros

marq-104 Could you share the super admin account so we can replicate this issue?

marq-104

To replicate the issue:
1) make a backup
2) In a GURU front-end, let the super administrator (SA) finish a course and the final exam.
3) make a backup
4) Then, in GURU backend, reset the SA scores.
5) logout then log in as SA

If the same happens to you, then the SA looses his SA status.
If he's not also in another back-end group, like 'administrator', he may also no longer be able to log in to back-end.

Before and after I reset the SA scores I made an Akeeba backup.
When I tried to restore the backup I made AFTER, I was no longer listed as Super Admin in the restoration process.
Only by restoring the backup made BEFORE I reset SA scores, could I again see me listed in as SA.

For security reasons, I can't add strangers to this website's backend.

saguaros

marq-104 Do you have a test site so we can take a closer look and check for you?

marq-104

Sorry, I don't. I only have a copy of the secure site and can't let anyone in.

Did you try the steps I outlined above after creating your own test site?

I have upgraded to Joomla 4.1 and can try again. Perhaps the error is fixed by the upgrade.

saguaros

marq-104 You can upgrade again and let us know.