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


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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 12 Years, 5 Months 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 12 Years, 5 Months ago Karma: 747
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 12 Years, 5 Months 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 12 Years, 5 Months ago Karma: 747
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 12 Years, 4 Months 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 12 Years, 4 Months ago Karma: 747
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