Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

How to reset the Quiz of user
(1 viewing) (1) Guest
ARI Quiz Lite
Go to bottomPage: 1
TOPIC: How to reset the Quiz of user
#22188
How to reset the Quiz of user 6 Years ago Karma: 0
I'm trying to create a Placement test using ARI Quiz Lite, then I set the test for register user and time limit for the quiz. Because I only create few user account and would like to reuse them again and again.

But the problem is if the previous user didn't finished the quiz, and the account assign to other new student the quiz is continuing the previous one with the same answers and remaining time.

So, how can I reset or clean up the quiz, so that I can assign the same account to other new student.
The administrator has disabled public write access.
 
#22190
Re:How to reset the Quiz of user 6 Years ago Karma: 671
Hello,

The extension saves quiz sessions state for registered users. Use different Joomla! users for different students.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#22193
Re:How to reset the Quiz of user 6 Years ago Karma: 0
Is that any way for admin to check the status of the registered user?
The administrator has disabled public write access.
 
#22194
Re:How to reset the Quiz of user 6 Years ago Karma: 671
Administrators can see results of finished quizzes. If you wish, we can provide a SQL query which will delete all unfinished quizzes for all users or for specific users.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#22231
Re:How to reset the Quiz of user 6 Years ago Karma: 0
that will be great! I need the SQL query. and I'll suggest to add the feature for administrator in the next version.
The administrator has disabled public write access.
 
#22243
Re:How to reset the Quiz of user 6 Years ago Karma: 671
Use the next SQL query:

Code:


DELETE SI,S FROM jos_ariquizstatisticsinfo SI LEFT JOIN jos_ariquizstatistics S ON SI.StatisticsInfoId = S.StatisticsInfoId WHERE SI.Status <> "Finished"



or the next if you want to delete not finished quiz sessions for specific users (for example with user ID equals to 75):

Code:


DELETE SI,S FROM jos_ariquizstatisticsinfo SI LEFT JOIN jos_ariquizstatistics S ON SI.StatisticsInfoId = S.StatisticsInfoId WHERE SI.Status <> "Finished" AND SI.UserId = 75



Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1