Re:Insert results in DB table after quiz finish 8 Years, 1 Month ago
|
Karma: 0
|
I'm asking you for a help 1 time per year... I didn't see any errors that's why i'm posting in the forum.
I put the code where you recommend me to put it but is not working. And is not producing any errors
|
|
|
|
|
Re:Insert results in DB table after quiz finish 8 Years, 1 Month ago
|
Karma: 0
|
Where the certificate are record? Or if not how to make them available?
When someone click on the Certificate button this certificate to be recorded inside folder in Ari Quiz?
|
|
|
|
|
Re:Insert results in DB table after quiz finish 8 Years, 1 Month ago
|
Karma: 760
|
Certificates are generated when "Certificate" button is pressed or when attached to email, it is saved to a temporary file which is deleted when page is destroyed.
Regards,
ARI Soft
|
|
|
|
|
Re:Insert results in DB table after quiz finish 7 Years, 9 Months ago
|
Karma: 0
|
Hi,
We need help with something. IS there any way we can insert Country in this file? Before we use the Virtuemart table for the student country. Can you help me with this?
Before we use this: xxx_virtuemart_countries.country_3_code AS 'Country',
JOIN kxmk_virtuemart_countries
ON kxmk_virtuemart_userinfos.virtuemart_country_id = kxmk_virtuemart_countries.virtuemart_country_id
How can we import that code in Ari Quiz 3?
|
|
|
Last Edit: 2017/02/15 16:17 By niki.
|
|
Re:Insert results in DB table after quiz finish 7 Years, 9 Months ago
|
Karma: 0
|
We have this so far inside quizcomplete.php
if ($resultInfo['_Passed'])
{
$query = "INSERT INTO `kxmk_ariquiz_students` (`students_name`, `students_certification`, `students_certification_number`, `students_country`, `students_date_passed`) VALUES('{$resultInfo['UserName']}', '{$resultInfo['QuizName']}', '{$resultInfo['StatisticsInfoId']}00', '{$resultInfo->CountryName}', '{$resultInfo['EndDate']}')";
How to put the xxx_virtuemart_countries.country_3_code AS 'Country',
$query="SELECT #__ariquizstatisticsinfo.*,xxxx_virtuemart_countries.country_3_code AS 'CountryName',
Thanks
|
|
|
Last Edit: 2017/02/15 15:55 By niki.
|
|
Re:Insert results in DB table after quiz finish 7 Years, 9 Months ago
|
Karma: 760
|
Hello,
It is not clear what's difference in your code between "ARI Quiz" v. 2.x and 3.x. 'Country' is retrieved from VirtueMart extension.
Regards,
ARI Soft
|
|
|
|
|
|