5 $sql['content'] = 'SELECT content_id, content_parent_id, ordering, last_modified, revision, formatting, release_date, keywords, content_path, title, text, head, use_customized_head, test_message, allow_test_export, content_type FROM '.TABLE_PREFIX.'content WHERE course_id=? ORDER BY content_parent_id, ordering';
\r
7 $sql['primary_resources'] = 'SELECT P.primary_resource_id, P.content_id, P.resource, P.language_code FROM '.TABLE_PREFIX.'primary_resources P, '.TABLE_PREFIX.'content C WHERE C.course_id=? AND P.content_id=C.content_id ORDER BY P.content_id ASC';
\r
9 $sql['primary_resources'] = 'SELECT P.primary_resource_id, P.content_id, P.resource, P.language_code FROM '.TABLE_PREFIX.'primary_resources P, '.TABLE_PREFIX.'content C WHERE C.course_id=? AND P.content_id=C.content_id ORDER BY P.content_id ASC';
\r
11 $sql['primary_resources_types'] = 'SELECT PRT.primary_resource_id, PRT.type_id FROM '.TABLE_PREFIX.'primary_resources_types PRT, '.TABLE_PREFIX.'primary_resources P, '.TABLE_PREFIX.'content C WHERE C.course_id=? AND C.content_id=P.content_id AND P.primary_resource_id = PRT.primary_resource_id ORDER BY PRT.primary_resource_id ASC';
\r
13 $sql['secondary_resources'] = 'SELECT S.secondary_resource_id, S.primary_resource_id, S.secondary_resource, S.language_code FROM '.TABLE_PREFIX.'secondary_resources S, '.TABLE_PREFIX.'primary_resources P, '.TABLE_PREFIX.'content C WHERE C.course_id=? AND C.content_id=P.content_id AND P.primary_resource_id = S.primary_resource_id ORDER BY S.primary_resource_id ASC';
\r
15 $sql['secondary_resources_types'] = 'SELECT SRT.secondary_resource_id, SRT.type_id FROM '.TABLE_PREFIX.'secondary_resources_types SRT, '.TABLE_PREFIX.'secondary_resources S, '.TABLE_PREFIX.'primary_resources P, '.TABLE_PREFIX.'content C WHERE C.course_id=? AND C.content_id=P.content_id AND P.primary_resource_id = S.primary_resource_id AND S.secondary_resource_id = SRT.secondary_resource_id ORDER BY SRT.secondary_resource_id ASC';
\r
17 function related_content_convert($row, $course_id, $table_id_map, $version) {
\r
19 $new_row[0] = $table_id_map['content'][$row[0]];
\r
20 $new_row[1] = $table_id_map['content'][$row[1]];
\r
25 function primary_resources_convert($row, $course_id, $table_id_map, $version) {
\r
29 $new_row[1] = $table_id_map['content'][$row[1]];
\r
34 function primary_resources_types_convert($row, $course_id, $table_id_map, $version) {
\r
38 $new_row[0] = $table_id_map['primary_resources'][$row[0]];
\r
43 function secondary_resources_convert($row, $course_id, $table_id_map, $version) {
\r
47 $new_row[1] = $table_id_map['primary_resources'][$row[1]];
\r
52 function secondary_resources_types_convert($row, $course_id, $table_id_map, $version) {
\r
56 $new_row[0] = $table_id_map['secondary_resources'][$row[0]];
\r
61 function content_convert($row, $course_id, $table_id_map, $version) {
\r
63 if (!isset($order)) {
\r
65 $sql = 'SELECT MAX(ordering) AS ordering FROM '.TABLE_PREFIX.'content WHERE content_parent_id=0 AND course_id='.$course_id;
\r
66 $result = mysql_query($sql, $db);
\r
67 $tmp_row = mysql_fetch_assoc($result);
\r
68 $order = $tmp_row['ordering'] + 1;
\r
72 $new_row[0] = $row[0];
\r
73 $new_row[1] = $course_id;
\r
76 $new_row[3] = $order;
\r
79 $new_row[2] = $table_id_map['content'][$row[1]];
\r
80 $new_row[3] = $row[2];
\r
83 $new_row[4] = $row[3];
\r
84 $new_row[5] = $row[4];
\r
85 $new_row[6] = $row[5];
\r
86 $new_row[7] = $row[6];
\r
87 $new_row[8] = $row[7];
\r
88 $new_row[9] = $row[8];
\r
89 $new_row[10] = $row[9];
\r
90 $new_row[11] = $row[10];
\r
91 $new_row[12] = $row[11];
\r
92 $new_row[13] = $row[12];
\r
93 $new_row[14] = $row[13]; // test_message
\r
94 $new_row[15] = $row[14]; // allow_test_export
\r
95 $new_row[16] = $row[15]; // content_type
\r