docs/mods/_standard/reading_list/module_backup.php

   1 <?php\r
   2 \r
   3 $sql = array();\r
   4 $sql['external_resources']  = 'SELECT resource_id, type, title, author, publisher, date, comments, id, url FROM '.TABLE_PREFIX.'external_resources WHERE course_id=?';\r
   5 \r
   6 $sql['reading_list']  = 'SELECT resource_id, required, date_start, date_end, comment FROM '.TABLE_PREFIX.'reading_list WHERE course_id=?';\r
   7 \r
   8 function external_resources_convert($row, $course_id, $table_id_map, $version) {\r
   9         $new_row = array();\r
  10         $new_row[0]  = $row[0]; // resource_id\r
  11         $new_row[1]  = $course_id;\r
  12         $new_row[2]  = $row[1]; // type\r
  13         $new_row[3]  = $row[2]; // title\r
  14         $new_row[4]  = $row[3]; // author\r
  15         $new_row[5]  = $row[4]; // publisher\r
  16         $new_row[6]  = $row[5]; // date\r
  17         $new_row[7]  = $row[6]; // comments\r
  18         $new_row[8]  = $row[7]; // id\r
  19         $new_row[9]  = $row[8]; // url\r
  20 \r
  21         return $new_row;\r
  22 }\r
  23 \r
  24 function reading_list_convert($row, $course_id, $table_id_map, $version) {\r
  25         $new_row = array();\r
  26         $new_row[0]  = 0; // reading_id\r
  27         $new_row[1]  = $course_id;\r
  28         $new_row[2]  = $table_id_map['external_resources'][$row[0]]; // resource_id\r
  29         $new_row[3]  = $row[1]; // required\r
  30         $new_row[4]  = $row[2]; // date_start\r
  31         $new_row[5]  = $row[3]; // date_end\r
  32         $new_row[6]  = $row[4]; // comment\r
  33 \r
  34         return $new_row;\r
  35 }\r
  36 ?>