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 Lite

ARI QUIZ lite - Show top 5 scorer
(1 viewing) (1) Guest
ARI Quiz Lite
Go to bottomPage: 123
TOPIC: ARI QUIZ lite - Show top 5 scorer
#53719
Re:ARI QUIZ lite - Show top 5 scorer 9 Years, 1 Month ago Karma: 0
For Top Results, Result measure unit is set to Points. But on the result list it shows user with lowest score point. In DB if I sort user on the basis of ORDER BY `tbl_ariquizstatisticsinfo`.`UserScore` DESC it shows different result.
vikram0811
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#53720
Re:ARI QUIZ lite - Show top 5 scorer 9 Years, 1 Month ago Karma: 747
The module sorts data by number of score in percent ( UserScore/MaxScore ). "Measure unit" parameter is used to specify what data will be shown (absolute score or percent), it doesn't affect on sorting.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#53721
Re:ARI QUIZ lite - Show top 5 scorer 9 Years, 1 Month ago Karma: 0
Our quiz has 10 questions, each having 20 points with 20 secs of time. I need to list down top 5 scorer based on highest points scored. If two users have same score then they will be sorted with highest score and minimum time taken.

How can I achieve this ?
vikram0811
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#53722
Re:ARI QUIZ lite - Show top 5 scorer 9 Years, 1 Month ago Karma: 747
We described before how the module sorts data. If you want to change this, it requires modification of the extension. See "getTopResults" method in <joomla_directory>/administrator/components/com_ariquizlite/kernel/Controllers/class.ResultController.php file.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#53723
Re:ARI QUIZ lite - Show top 5 scorer 9 Years, 1 Month ago Karma: 0
Yes I know the controller to modify. How can we modify that query getTopResults() to achieve the desired result ?
vikram0811
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#53728
Re:ARI QUIZ lite - Show top 5 scorer 9 Years, 1 Month ago Karma: 747
If want to sort by earned score instead of percent score, use ORDER BY QSI.UserScore DESC instead of ORDER BY MAX(QSI.UserScore / QSI.MaxScore) DESC

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: 123
ARI Soft Forum
Joomla components
ARI Quiz Lite
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