5 $sql['links_categories'] = 'SELECT cat_id, name, parent_id FROM '.TABLE_PREFIX.'links_categories WHERE owner_id=? AND owner_type='.LINK_CAT_COURSE.' ORDER BY cat_id ASC';
\r
7 $sql['links'] = 'SELECT L.cat_id, Url, LinkName, Description, Approved, SubmitName, SubmitEmail, SubmitDate, hits FROM '.TABLE_PREFIX.'links L INNER JOIN '.TABLE_PREFIX.'links_categories C USING (cat_id) WHERE C.owner_id=? AND C.owner_type='.LINK_CAT_COURSE.' ORDER BY link_id ASC';
\r
10 function links_categories_convert($row, $course_id, $table_id_map, $version) {
\r
12 $new_row[0] = $row[0];
\r
13 $new_row[1] = LINK_CAT_COURSE;
\r
14 $new_row[2] = $course_id;
\r
15 $new_row[3] = $row[1];
\r
16 $new_row[4] = $row[2];
\r
21 function links_convert($row, $course_id, $table_id_map, $version) {
\r
26 $new_row[1] = $table_id_map['links_categories'][$row[0]];
\r
27 $new_row[2] = $row[1];
\r
28 $new_row[3] = $row[2];
\r
29 $new_row[4] = $row[3];
\r
30 $new_row[5] = $row[4];
\r
31 $new_row[6] = $row[5];
\r
32 $new_row[7] = $row[6];
\r
33 $new_row[8] = $row[7];
\r
34 $new_row[9] = $row[8];
\r