Playing limit not working

  • John Bongiovanni
  • John Bongiovanni's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 7 months ago #7 by John Bongiovanni
Replied by John Bongiovanni on topic Playing limit not working
Looking at the program logic and the SQL query to determine when the last quiz was taken, I think I have an idea of how this happens, and it correlates with what I'm seeing in the database.
First, we have the parameter set to save all results.
I think your SQL query will return the number of days for the first quiz taken, not the most recent one (if there are multiple ones in results). So if someone takes a quiz and fails, then waits a day (in this case) to take it again and fails,
they will then be able to take it as often as they like.
And this is what I see for the cases where this happens: a fail, wait a day to take again, then multiple takes.
Hope this helps.

Please Log in or Create an account to join the conversation.

  • Christopher Mavros
  • Christopher Mavros's Avatar
  • Offline
  • Administrator
  • Administrator
More
2 years 7 months ago #8 by Christopher Mavros
Replied by Christopher Mavros on topic Playing limit not working
Hello John!
I am astonished to how well you debugged this! We have open positions here if you want to help! :D

You are correct. When purging results is disabled, the first result was used to determine the datetime of the last attempt, so it allowed multiple takes afterwards.

I have now fixed this and it will be included in the next release.
Thank you very much for your help with this.

Christopher Mavros
me@mavxr.com
If you like our extensions, please rate us on the JED!

Please Log in or Create an account to join the conversation.

Moderators: Christopher Mavros