ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
ilSCORM13Player_mysql.php
Go to the documentation of this file.
1<?php
2
3self::$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 cmi_node.user_id=? AND cp_node.slm_id=?';
7
8self::$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 cmi_node.user_id=? AND cp_node.slm_id=?';
13
14self::$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 cmi_node.user_id=? AND cp_node.slm_id=?';
21
22self::$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 cmi_node.user_id=? AND cp_node.slm_id=?';
27
28self::$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 cmi_node.user_id=? AND cp_node.slm_id=?';
33
34self::$SQLCOMMAND['view_cmi_package'] = 'SELECT usr_data.usr_id AS user_id,
35 CONCAT(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 usr_data.usr_id=? AND sahs_lm.id=?';
40
41self::$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
48self::$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
54self::$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
60self::$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
66self::$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
71self::$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
77self::$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
82self::$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
87self::$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
92self::$SQLCOMMAND['delete_cmi_node'] = 'DELETE FROM cmi_node WHERE cp_node_id=?';
93
94
95?>