2 /************************************************************************/
4 /************************************************************************/
5 /* Copyright (c) 2010 */
6 /* Inclusive Design Institute */
8 /* This program is free software. You can redistribute it and/or */
9 /* modify it under the terms of the GNU General Public License */
10 /* as published by the Free Software Foundation. */
11 /************************************************************************/
13 //Question for multiple choice.
14 define('TR_SQL_QUESTION_MULTI', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 1, '%s', '%s',
15 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
16 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
17 '', '', '', '', '', '', '', '', '', '', 5, 0)");
19 //Question for True/False
20 define('TR_SQL_QUESTION_TRUEFALSE', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 2, '%s', '%s',
21 '', '', '', '', '', '', '', '', '', '',
22 %s, 0, 0, 0, 0, 0, 0, 0, 0, 0,
23 '', '', '', '', '', '', '', '', '', '', 5, 0)");
26 //Question for Open ended
27 define('TR_SQL_QUESTION_LONG', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 3, '%s', '%s',
28 '', '', '', '', '', '', '', '', '', '',
29 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
30 '', '', '', '', '', '', '', '', '', '', %s, 0)");
33 define('TR_SQL_QUESTION_LIKERT', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 4, '%s', '%s',
34 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
35 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
36 '', '', '', '', '', '', '', '', '', '', 0, 0)");
38 //Question for Ordering
39 define('TR_SQL_QUESTION_ORDERING', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 6, '%s', '%s',
40 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
41 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
42 '', '', '', '', '', '', '', '', '', '', 0, 0)");
44 //Question for MultiAnswer
45 define('TR_SQL_QUESTION_MULTIANSWER', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 7, '%s', '%s',
46 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
47 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
48 '', '', '', '', '', '', '', '', '', '', 0, 0)");
50 //Question for Matching Simple
51 define('TR_SQL_QUESTION_MATCHING', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 5, '%s', '%s',
52 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
53 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
54 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 0, 0)");
56 //Question for Matching Graphical
57 define('TR_SQL_QUESTION_MATCHINGDD', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 8, '%s', '%s',
58 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
59 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
60 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 0, 0)");
62 define('TR_SQL_TEST', "INSERT INTO ".TABLE_PREFIX."tests " .
87 (NULL, %d, '%s', '%s', %d, '%s', '%s', %d, %d, '%s', %d, %d, %d, '%s', '%s', %s, %d, %d, %d, %s, '', %d, %d)");