scorm_migrate_clean_db.php 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. <?php
  2. require_once('back_compat.inc.php');
  3. $max_dsp_lp = 0;
  4. $courses_list = array();
  5. $courses_id_list = array();
  6. $courses_dir_list = array();
  7. $sql = "SELECT * FROM ".Database::get_main_table(MAIN_COURSE_TABLE)."";
  8. echo $sql."<br />\n";
  9. $res = api_sql_query($sql,__FILE__,__LINE__);
  10. while ($row = Database::fetch_array($res))
  11. {
  12. //TODO change this db name construction to use DB instead of claro_main.conf settings
  13. $course_pref = Database::get_course_table_prefix();
  14. $dbname = $row['db_name'].'.'.$course_pref;
  15. $courses_list[] = $row['db_name'];
  16. $courses_id_list[$row['code']] = $row['db_name'];
  17. $courses_dir_list[$row['code']] = $row['directory'];
  18. }
  19. foreach($courses_list as $db)
  20. {
  21. echo "Using course db $db<br/>\n";
  22. $lp = Database::get_course_table('lp',$db);
  23. $sql = "TRUNCATE TABLE $lp";
  24. echo "$sql<br />\n";
  25. $res = @mysql_query($sql);
  26. $lp = Database::get_course_table('lp_item',$db);
  27. $sql = "TRUNCATE TABLE $lp";
  28. echo "$sql<br />\n";
  29. $res = @mysql_query($sql);
  30. $lp = Database::get_course_table('lp_view',$db);
  31. $sql = "TRUNCATE TABLE $lp";
  32. echo "$sql<br />\n";
  33. $res = @mysql_query($sql);
  34. $lp = Database::get_course_table('lp_item_view',$db);
  35. $sql = "TRUNCATE TABLE $lp";
  36. echo "$sql<br />\n";
  37. $res = @mysql_query($sql);
  38. }
  39. echo "All done";
  40. ?>