ILIAS  release_5-0 Revision 5.0.0-1144-gc4397b1f87
ilSCORM13Player_sqlite.php
Go to the documentation of this file.
1 <?php
2 
3 self::$SQLCOMMAND['view_cmi_node'] = 'SELECT cmi_node.*
4  FROM cmi_node
5  INNER JOIN cp_node ON cmi_node.cp_node_id = cp_node.cp_node_id
6  WHERE user_id=? AND slm_id=?';
7 
8 self::$SQLCOMMAND['view_cmi_comment'] = 'SELECT cmi_comment.*
9  FROM cmi_comment
10  INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_comment.cmi_node_id
11  INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
12  WHERE user_id=? AND slm_id=?';
13 
14 self::$SQLCOMMAND['view_cmi_correct_response'] = 'SELECT cmi_correct_response.*
15  FROM cmi_correct_response
16  INNER JOIN cmi_interaction
17  ON cmi_interaction.cmi_interaction_id = cmi_correct_response.cmi_interaction_id
18  INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_interaction.cmi_node_id
19  INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
20  WHERE user_id=? AND slm_id=?';
21 
22 self::$SQLCOMMAND['view_cmi_interaction'] = 'SELECT cmi_interaction.*
23  FROM cmi_interaction
24  INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_interaction.cmi_node_id
25  INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
26  WHERE user_id=? AND slm_id=?';
27 
28 self::$SQLCOMMAND['view_cmi_objective'] = 'SELECT cmi_objective.*
29  FROM cmi_objective
30  INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_objective.cmi_node_id
31  INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
32  WHERE user_id=? AND slm_id=?';
33 
34 self::$SQLCOMMAND['view_cmi_package'] = 'SELECT usr_data.usr_id AS user_id,
35  (usr_data.firstname || " " || usr_data.lastname) AS learner_name,
36  sahs_lm.id AS slm_id , sahs_lm.default_lesson_mode AS mode, sahs_lm.credit
37  FROM usr_data , cp_package
38  INNER JOIN sahs_lm ON cp_package.obj_id = sahs_lm.id
39  WHERE user_id=? AND slm_id=?';
40 
41 self::$SQLCOMMAND['delete_cmi_correct_responses'] = 'DELETE FROM
42  cmi_correct_response WHERE cmi_interaction_id IN (
43  SELECT cmi_interaction.cmi_interaction_id FROM cmi_interaction
44  INNER JOIN cmi_node ON cmi_node.cmi_node_id=cmi_interaction.cmi_node_id
45  INNER JOIN cp_node ON cmi_node.cp_node_id=cp_node.cp_node_id
46  WHERE cmi_node.user_id=? AND cp_node.slm_id=?)';
47 
48 self::$SQLCOMMAND['delete_cmi_interactions'] = 'DELETE FROM cmi_interaction
49  WHERE cmi_node_id IN (
50  SELECT cmi_node.cmi_node_id FROM cmi_node
51  INNER JOIN cp_node ON cmi_node.cp_node_id=cp_node.cp_node_id
52  WHERE cmi_node.user_id=? AND cp_node.slm_id=?)';
53 
54 self::$SQLCOMMAND['delete_cmi_comments'] = 'DELETE FROM cmi_comment
55  WHERE cmi_node_id IN (
56  SELECT cmi_node.cmi_node_id FROM cmi_node
57  INNER JOIN cp_node ON cmi_node.cp_node_id=cp_node.cp_node_id
58  WHERE cmi_node.user_id=? AND cp_node.slm_id=?)';
59 
60 self::$SQLCOMMAND['delete_cmi_objectives'] = 'DELETE FROM cmi_objective
61  WHERE cmi_node_id IN (
62  SELECT cmi_node.cmi_node_id FROM cmi_node
63  INNER JOIN cp_node ON cmi_node.cp_node_id=cp_node.cp_node_id
64  WHERE cmi_node.user_id=? AND cp_node.slm_id=?)';
65 
66 self::$SQLCOMMAND['delete_cmi_nodes'] = 'DELETE FROM cmi_node
67  WHERE user_id=? AND cp_node_id IN (
68  SELECT cp_node_id FROM cp_node
69  WHERE slm_id=?)';
70 
71 self::$SQLCOMMAND['delete_cmi_correct_response'] = 'DELETE FROM cmi_correct_response
72  WHERE cmi_interaction_id IN (
73  SELECT cmi_interaction.cmi_interaction_id FROM cmi_interaction
74  INNER JOIN cmi_node ON cmi_node.cmi_node_id=cmi_interaction.cmi_node_id
75  WHERE cmi_node.cp_node_id=?)';
76 
77 self::$SQLCOMMAND['delete_cmi_interaction'] = 'DELETE FROM cmi_interaction
78  WHERE cmi_node_id IN (
79  SELECT cmi_node.cmi_node_id FROM cmi_node
80  WHERE cmi_node.cp_node_id=?)';
81 
82 self::$SQLCOMMAND['delete_cmi_comment'] = 'DELETE FROM cmi_comment
83  WHERE cmi_node_id IN (
84  SELECT cmi_node.cmi_node_id FROM cmi_node
85  WHERE cmi_node.cp_node_id=?)';
86 
87 self::$SQLCOMMAND['delete_cmi_objective'] = 'DELETE FROM cmi_objective
88  WHERE cmi_node_id IN (
89  SELECT cmi_node.cmi_node_id FROM cmi_node
90  WHERE cmi_node.cp_node_id=?)';
91 
92 self::$SQLCOMMAND['delete_cmi_node'] = 'DELETE FROM cmi_node WHERE cp_node_id=?';
93 
94 
95 
96 ?>