Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your 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.

  • 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.


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?

Insert results in DB table after quiz finish
(1 viewing) (1) Guest
component
Go to bottomPage: 1234
TOPIC: Insert results in DB table after quiz finish
#58685
Re:Insert results in DB table after quiz finish 7 Years, 7 Months 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
The administrator has disabled public write access.
 
#58689
Re:Insert results in DB table after quiz finish 7 Years, 7 Months 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?
The administrator has disabled public write access.
 
#58690
Re:Insert results in DB table after quiz finish 7 Years, 7 Months ago Karma: 748
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
The administrator has disabled public write access.
 
#59656
Re:Insert results in DB table after quiz finish 7 Years, 2 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.
The administrator has disabled public write access.
 
#59657
Re:Insert results in DB table after quiz finish 7 Years, 2 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.
The administrator has disabled public write access.
 
#59663
Re:Insert results in DB table after quiz finish 7 Years, 2 Months ago Karma: 748
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
The administrator has disabled public write access.
 
Go to topPage: 1234