2 /************************************************************************/
4 /************************************************************************/
5 /* Copyright (c) 2002-2008 by Greg Gay & Harris Wong */
6 /* Inclusive Design Institute */
9 /* This program is free software. You can redistribute it and/or */
10 /* modify it under the terms of the GNU General Public License */
11 /* as published by the Free Software Foundation. */
12 /************************************************************************/
15 //Question for multiple choice.
16 define('AT_SQL_QUESTION_MULTI', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 1, '%s', '%s',
17 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
18 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
19 '', '', '', '', '', '', '', '', '', '', 5, 0)");
21 //Question for True/False
22 define('AT_SQL_QUESTION_TRUEFALSE', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 2, '%s', '%s',
23 '', '', '', '', '', '', '', '', '', '',
24 %s, 0, 0, 0, 0, 0, 0, 0, 0, 0,
25 '', '', '', '', '', '', '', '', '', '', 5, 0)");
28 //Question for Open ended
29 define('AT_SQL_QUESTION_LONG', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 3, '%s', '%s',
30 '', '', '', '', '', '', '', '', '', '',
31 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
32 '', '', '', '', '', '', '', '', '', '', %s, 0)");
35 define('AT_SQL_QUESTION_LIKERT', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 4, '%s', '%s',
36 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
37 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
38 '', '', '', '', '', '', '', '', '', '', 0, 0)");
40 //Question for Ordering
41 define('AT_SQL_QUESTION_ORDERING', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 6, '%s', '%s',
42 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
43 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
44 '', '', '', '', '', '', '', '', '', '', 0, 0)");
46 //Question for MultiAnswer
47 define('AT_SQL_QUESTION_MULTIANSWER', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 7, '%s', '%s',
48 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
49 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
50 '', '', '', '', '', '', '', '', '', '', 0, 0)");
52 //Question for Matching Simple
53 define('AT_SQL_QUESTION_MATCHING', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 5, '%s', '%s',
54 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
55 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
56 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 0, 0)");
58 //Question for Matching Graphical
59 define('AT_SQL_QUESTION_MATCHINGDD', "INSERT INTO ".TABLE_PREFIX."tests_questions VALUES ( NULL, %d, %d, 8, '%s', '%s',
60 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',
61 %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
62 '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 0, 0)");
64 define('AT_SQL_TEST', "INSERT INTO ".TABLE_PREFIX."tests " .
89 (NULL, %d, '%s', '%s', %d, '%s', '%s', %d, %d, '%s', %d, %d, %d, '%s', '%s', %s, %d, %d, %d, %s, '', %d, %d)");