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?

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 2 Years, 9 Months 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.
The administrator has disabled public write access.
 
#53720
Re:ARI QUIZ lite - Show top 5 scorer 2 Years, 9 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#53721
Re:ARI QUIZ lite - Show top 5 scorer 2 Years, 9 Months 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 ?
The administrator has disabled public write access.
 
#53722
Re:ARI QUIZ lite - Show top 5 scorer 2 Years, 9 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#53723
Re:ARI QUIZ lite - Show top 5 scorer 2 Years, 9 Months ago Karma: 0
Yes I know the controller to modify. How can we modify that query getTopResults() to achieve the desired result ?
The administrator has disabled public write access.
 
#53728
Re:ARI QUIZ lite - Show top 5 scorer 2 Years, 9 Months ago Karma: 670
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
The administrator has disabled public write access.
 
Go to topPage: 123