Hi there,

I wish to add 2 custom fields to each Quizzes. (2 prices) as we will charge for access to each quiz.

Is there a best practice to add 2 fields, rather than adding them manually to the database and hacking the AriQuiz core code? Is there a plugin perhaps? I am currently using a join table but things could get out of synch..

thanks,
Pete

Hello,

Do you need separate fields in "ariquiz" table or is it suitable if new fields will be stored in JSON format in "ExtraData" field from "ariquiz" table?

Regards,
ARI Soft

Hmm - good question..

I would prefer to have separate fields of course,maybe with a plugin to add access to them via teh Quiz Edit interface (a new tab?)...

..but I guess I could make do with JSON if it made the idea possible, and kept the core code safe from hacking..

I don't need to filter or sort by the prices in SQL, but I do need to know which price is which, so "{"rrp":200,"discount":150}" would work..

How would I allow the customer access to that data in the interface though?

I would assume the JSON options would pop up under Additional Settings ?

Thanks
Pete

OK - I found "com_ariquiz/models/forms/quiz/quiz.xml" and have modified it to add..

<param type="text" name="QuizRrp" size="5" default="" label="COM_ARIQUIZ_LABEL_QUIZRRP" description="COM_ARIQUIZ_DESCR_QUIZRRP" />
<param type="text" name="QuizDiscount" size="5" default="" label="COM_ARIQUIZ_LABEL_QUIZDISCOUNT" description="COM_ARIQUIZ_DESCR_QUIZDISCOUNT" />

..into the ExtraParams elements.. (although this will get overwritten on an update right?) and I now have the extra elements..

Took me a little while find the XML file lol.. Is this what you were going to suggest as a quick mod?

I would still prefer to have another Tab (called Price) with just the two fields in it if there is an easy way to achieve the functionality..

Yes, if you don't need new parameters in separate columns in database table, the most easy way to add them to quiz.xml file.

Regards,
ARI Soft