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?

Bulk Random Order
(1 viewing) (1) Guest
component
Go to bottomPage: 12
TOPIC: Bulk Random Order
#47991
Bulk Random Order 10 Years, 4 Months ago Karma: 0
Hi.

I want to set a big selection of existing questions to be presented with answers in random. I´ll use a SQL select script for it.

I´ve been searching for the table and field that sets it to random order, with no sucess.

Wich table (and field / value) is this?

Thanks.
The administrator has disabled public write access.
 
#47996
Re:Bulk Random Order 10 Years, 4 Months ago Karma: 748
Hello,

The extension supports ability to select necessary number of questions in random order from question bank (it is possible to specify how many questions from selected bank categories should be selected) and it is also possible to select questions in random order from quiz questions.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#47998
Re:Bulk Random Order 10 Years, 4 Months ago Karma: 0
For sure, I know that.

What I need now is to set the answers (not the questions) to random order. And I don´t want to do it one by one from the questions I still have in bank.

I´ll use a SQL instruction to set the answers from certain categories to random. So, wich table/field/value from ariquiz tables I should use?

Thanks.
The administrator has disabled public write access.
 
#48000
Re:Bulk Random Order 10 Years, 4 Months ago Karma: 748
#__ariquizquestion and #__ariquizquestionversion tables are used for questions.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#48004
Re:Bulk Random Order 10 Years, 4 Months ago Karma: 0
Thanks. I´ll be glad if you indicate me wich table and field is the value to alter answers to random order.
The administrator has disabled public write access.
 
#48009
Re:Bulk Random Order 10 Years, 4 Months ago Karma: 748
If you mean "Specific question settings -> Random order" parameter from "Single Question", "Multiple Question" and etc. See "Data" field in #__ariquizquestionversion table. Data is stored in XML format.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12