ARI Soft - Show used time in Top Results module

Home

News

Forum

About Us

Demos

Products

F.A.Q.

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.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Quiz

Show used time in Top Results module

(1 viewing) (1) Guest

component

Page: 12

TOPIC: Show used time in Top Results module

Forum Tools

#55451

Re:Show used time in Top Results module 8 Years, 8 Months ago

Karma: 0

Still trying to get this to work. Any suggestions?

Got the UsedTime from the ClassResultController.php, but where can i place it.

function getTopResults($count = 5)
{

$query = sprintf('SELECT U.name AS UserName, QSI.UserScore, Q.QuizName, (MAX(QSI.UserScore / QSI.MaxScore) * 100) AS PercentScore' .
' FROM #__ariquizstatisticsinfo QSI INNER JOIN #__ariquiz Q' .
' ON QSI.QuizId = Q.QuizId' .
' INNER JOIN #__users U' .
' ON QSI.UserId = U.id' .
' WHERE QSI.UserId > 0 AND QSI.Status = "Finished" AND Q.Status = %d' .
' GROUP BY UserName' .
' ORDER BY QSI.UserScore DESC' .
' LIMIT 0,%d',
ARI_QUIZ_STATUS_ACTIVE, $count);
$this->_db->setQuery($query);
$results = $this->_db->loadObjectList();
if ($this->_db->getErrorNum())
{
//trigger_error('ARI: Couldnt get top user result list.', E_USER_ERROR);
return null;
}

return $results;
}

Peternicolaj

The administrator has disabled public write access.

#55460

Re:Show used time in Top Results module 8 Years, 8 Months ago	Karma: 747
Sorry, but modification of the extension is out of free support. Regards, ARI Soft

admin

The administrator has disabled public write access.

#55463

Re:Show used time in Top Results module 8 Years, 8 Months ago	Karma: 0
It's ok. Just hoped that another user had a solution. The component is not usefull, if the users can't see how much time they spent, so better try find another.

Peternicolaj

The administrator has disabled public write access.

Page: 12

Useful Links