4 $sql['news'] = 'SELECT date, formatting, title, body FROM '.TABLE_PREFIX.'news WHERE course_id=? ORDER BY news_id ASC';
\r
8 // not sure what to call this.
\r
9 // it takes a CSV row and returns a valid SQL row (ie. all the correct fields).
\r
11 function news_convert($row, $course_id, $table_id_map, $version) {
\r
14 if (!isset($member_id)) {
\r
16 $sql = "SELECT member_id FROM ".TABLE_PREFIX."courses WHERE course_id=$course_id";
\r
17 $result = mysql_query($sql, $db);
\r
18 $member_row = mysql_fetch_assoc($result);
\r
19 $member_id = $member_row['member_id'];
\r
23 $new_row[1] = $course_id;
\r
24 $new_row[2] = $member_id;
\r
25 $new_row[3] = $row[0];
\r
26 $new_row[4] = $row[1];
\r
27 $new_row[5] = $row[2];
\r
28 $new_row[6] = $row[3];
\r