load_global.php 3.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. <?php
  2. require_once(dirname(__FILE__).'/../main/inc/global.inc.php');
  3. require_once(api_get_path(LIBRARY_PATH).'add_course.lib.inc.php');
  4. $cidReq = 'COURSEX';
  5. // check if course exists
  6. $table_course = Database::get_main_table(TABLE_MAIN_COURSE);
  7. $sql = "SELECT code FROM $table_course WHERE code = '$cidReq' ";
  8. $rs = Database::query($sql, __FILE__, __LINE__);
  9. $row = Database::fetch_row($rs);
  10. if (empty($row[0])) {
  11. // create a course
  12. $course_datos = array(
  13. 'wanted_code'=> $cidReq,
  14. 'title'=>$cidReq,
  15. 'tutor_name'=>'John Doe',
  16. 'category_code'=>'LANG',
  17. 'course_language'=>'spanish',
  18. 'course_admin_id'=>'001',
  19. 'db_prefix'=> $_configuration['db_prefix'],
  20. 'firstExpirationDelay'=>'999'
  21. );
  22. $res = create_course($course_datos['wanted_code'], $course_datos['title'],
  23. $course_datos['tutor_name'], $course_datos['category_code'],
  24. $course_datos['course_language'],$course_datos['course_admin_id'],
  25. $course_datos['db_prefix'], $course_datos['firstExpirationDelay']);
  26. }
  27. $course_table = Database::get_main_table(TABLE_MAIN_COURSE);
  28. $course_cat_table = Database::get_main_table(TABLE_MAIN_CATEGORY);
  29. $sql = "SELECT course.*, course_category.code faCode, course_category.name faName
  30. FROM $course_table
  31. LEFT JOIN $course_cat_table
  32. ON course.category_code = course_category.code
  33. WHERE course.code = '$cidReq'";
  34. $result = Database::query($sql,__FILE__,__LINE__);
  35. //create the session
  36. if (Database::num_rows($result)>0) {
  37. $cData = Database::fetch_array($result);
  38. $_cid = $cData['code' ];
  39. $_course = array();
  40. $_course['id' ] = $cData['code' ]; //auto-assigned integer
  41. $_course['name' ] = $cData['title' ];
  42. $_course['official_code'] = $cData['visual_code' ]; // use in echo
  43. $_course['sysCode' ] = $cData['code' ]; // use as key in db
  44. $_course['path' ] = $cData['directory']; // use as key in path
  45. $_course['dbName' ] = $cData['db_name' ]; // use as key in db list
  46. $_course['dbNameGlu' ] = $_configuration['table_prefix'] . $cData['db_name'] . $_configuration['db_glue']; // use in all queries
  47. $_course['titular' ] = $cData['tutor_name' ];
  48. $_course['language' ] = $cData['course_language' ];
  49. $_course['extLink' ]['url' ] = $cData['department_url' ];
  50. $_course['extLink' ]['name'] = $cData['department_name'];
  51. $_course['categoryCode'] = $cData['faCode' ];
  52. $_course['categoryName'] = $cData['faName' ];
  53. $_course['visibility' ] = $cData['visibility'];
  54. $_course['subscribe_allowed'] = $cData['subscribe'];
  55. $_course['unubscribe_allowed'] = $cData['unsubscribe'];
  56. api_session_register('_cid');
  57. api_session_register('_course');
  58. }
  59. $_SESSION['_user']['user_id'] = 1;
  60. $_user['user_id'] = $_SESSION['_user']['user_id'];
  61. $_SESSION['is_courseAdmin'] = 1;
  62. ?>