I'm posting new thread because something happened with the old one (404 error) www.ari-soft.com/ARI-Quiz/56767-Change-the-generated-PDF-Certificate/Page-3.html

I need your help with this task:

In Ari Quiz 2 there was file called quiz_finished.php. The file was located inside /public_html/components/com_ariquiz/frontend_pages

We use to have little code inside this file something like this:



So when user successfully pass the quiz his data is inserted in this table: xxxx_ariquiz_students

Hello,

See "markQuizAsFinished" method in <joomla_directory>/administrator/components/com_ariquiz/models/userquiz.php or create a system plugin, subscribe to "onEndQuiz" event and execute the code in event handler.

Regards,
ARI Soft

In the old file i can see this:

AriEventController::raiseEvent('onEndQuiz', $result);

But i can't find this line of code inside userquiz.php

See <joomla_directory>/components/com_ariquiz/controllers/quizcomplete.php file.

Regards,
ARI Soft

Can you tell me where is that:




Ok. I found it in

function markQuizAsFinished($ticketId, $userId = 0)
{
$db =& $this->getDBO();

But how I can insert the code?

$query = "INSERT INTO `xxxx_ariquiz_students` (`students_name`, `students_certification`, `students_certification_number`, `students_country`, `students_date_passed`) VALUES('{$result['UserName']}', '{$items->Certification}', '{$items->CertificationNumber}', '{$items->CountryName}', '{$result['EndDate']}')";

I send you email