Home News Contact Us Forum About Us Demos Products F.A.Q.
ARI Soft









Register   Lost Password?
Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin







e-mail: info@ari-soft.com
Shopping Cart
You currently have 0 items in your cart.
Show 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.
    more...

  • 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.
    more...


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?
ARI Soft Forum
Joomla components
ARI Quiz

Manually delete result data
(1 viewing) (1) Guest
component
Go to bottomPage: 12
TOPIC: Manually delete result data
#51728
Manually delete result data 9 Years, 6 Months ago Karma: 0
Hi
I am not an expert programmer, may i know how to delete result with success status thru database?
mrrizal
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#51729
Re:Manually delete result data 9 Years, 6 Months ago Karma: 747
Hello,

Use the following SQL query:

Code:

DELETE 
  SI,S,P,SF,SED 
FROM 
  #__ariquizstatisticsinfo SI LEFT JOIN #__ariquizstatistics S 
    ON SI.StatisticsInfoId = S.StatisticsInfoId
  LEFT JOIN #__ariquizstatistics_pages P
    ON SI.StatisticsInfoId = P.StatisticsInfoId
  LEFT JOIN #__ariquizstatistics_files SF 
    ON S.StatisticsId = SF.StatisticsId
  LEFT JOIN #__ariquiz_statistics_extradata SED 
    ON SED.StatisticsInfoId = SI.StatisticsInfoId
WHERE 
  SI.Status = "Finished" AND SI.Passed = 1


Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#51730
Re:Manually delete result data 9 Years, 6 Months ago Karma: 0
Ok great, I tot it was only ariquizstatisticsinfo table. Is it right to delete specific user, i put UserID in where condition?
mrrizal
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#51731
Re:Manually delete result data 9 Years, 6 Months ago Karma: 747
Correctly.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#51769
Re:Manually delete result data 9 Years, 6 Months ago Karma: 0
Another question with deleting data, can we delete #__ariquizstatisticsinfo.Status with "Process" via Joomla Backend Panel?

I limited my user to take quiz for 1 hour and only 1 attempt.

Some of my data #__ariquizstatisticsinfo.EndDate is NULL and StartDate is already past 1 hour, and Status is Process.
mrrizal
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#51771
Re:Manually delete result data 9 Years, 6 Months ago Karma: 747
The extension doesn't support ability to delete active quiz sessions.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12
ARI Soft Forum
Joomla components
ARI Quiz
Powered by Kunenaget the latest posts directly to your desktop
Useful Links
Products
F.A.Q.
Discount
RSS
Top Products
ARI Data Tables
ARI Sexy Lightbox
ARI Quiz
ARI Stream Quiz - Personal
ARI Smart Content
Help
Forum
F.A.Q.
Home | News | Contact Us | Forum | About Us | Demos | Products | F.A.Q.
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2009