install_db.inc.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Install the Chamilo database
  5. * Notice : This script has to be included by index.php
  6. *
  7. * @package chamilo.install
  8. */
  9. /* This page is called only during a NEW chamilo installation */
  10. /* This page can only be access through including from the install script. */
  11. /**
  12. * Init checks
  13. */
  14. if (!defined('SYSTEM_INSTALLATION')) {
  15. echo 'You are not allowed here!';
  16. exit;
  17. }
  18. $urlForm = api_add_trailing_slash($urlForm);
  19. switch ($encryptPassForm) {
  20. case 'md5':
  21. $passToStore = md5($passForm);
  22. break;
  23. case 'sha1':
  24. $passToStore = sha1($passForm);
  25. break;
  26. case 'none':
  27. $passToStore = $passForm;
  28. break;
  29. }
  30. $dbPrefixForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbPrefixForm);
  31. $dbNameForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbNameForm);
  32. if (!empty($dbPrefixForm) && strpos($dbNameForm, $dbPrefixForm) !== 0) {
  33. $dbNameForm = $dbPrefixForm.$dbNameForm;
  34. }
  35. $dbStatsForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbStatsForm);
  36. if (!empty($dbPrefixForm) && strpos($dbStatsForm, $dbPrefixForm) !== 0) {
  37. $dbStatsForm = $dbPrefixForm.$dbStatsForm;
  38. }
  39. $dbUserForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbUserForm);
  40. if (!empty($dbPrefixForm) && strpos($dbUserForm, $dbPrefixForm) !== 0) {
  41. $dbUserForm = $dbPrefixForm.$dbUserForm;
  42. }
  43. $mysqlMainDb = $dbNameForm;
  44. if (empty($mysqlMainDb) || $mysqlMainDb == 'mysql' || $mysqlMainDb == $dbPrefixForm) {
  45. $mysqlMainDb = $dbPrefixForm.'main';
  46. }
  47. $mysqlStatsDb = $dbStatsForm;
  48. if (empty($mysqlStatsDb) || $mysqlStatsDb == 'mysql' || $mysqlStatsDb == $dbPrefixForm) {
  49. $mysqlStatsDb = $dbPrefixForm.'stats';
  50. }
  51. $mysqlUserDb = $dbUserForm;
  52. if (empty($mysqlUserDb) || $mysqlUserDb == 'mysql' || $mysqlUserDb == $dbPrefixForm) {
  53. $mysqlUserDb = $dbPrefixForm.'user';
  54. }
  55. //This parameter is needed to run a command line to install Chamilo using BNPanel + ISPConfig see #1799
  56. if (!defined('CLI_INSTALLATION')) {
  57. $result = Database::query("SHOW VARIABLES LIKE 'datadir'") or die(Database::error());
  58. $mysqlRepositorySys = Database::fetch_array($result);
  59. $mysqlRepositorySys = $mysqlRepositorySys['Value'];
  60. $create_database = true;
  61. if (database_exists($mysqlMainDb)) {
  62. $create_database = false;
  63. }
  64. // Create database.
  65. if ($create_database) {
  66. $charset_clause = ' DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci';
  67. $sql = "CREATE DATABASE IF NOT EXISTS `$mysqlMainDb` $charset_clause";
  68. Database::query($sql) or die(Database::error());
  69. }
  70. }
  71. $mysqlStatsDb = $mysqlMainDb;
  72. $mysqlUserDb = $mysqlMainDb;
  73. // This parameter is needed to run a command line install of Chamilo (needed for Phing)
  74. if (!defined('CLI_INSTALLATION')) {
  75. include api_get_path(SYS_LANG_PATH).'english/create_course.inc.php';
  76. if ($languageForm != 'english') {
  77. include api_get_path(SYS_LANG_PATH).$languageForm.'/create_course.inc.php';
  78. }
  79. }
  80. iDatabase::select_db($mysqlMainDb) or die(Database::error());
  81. $installation_settings = array();
  82. $installation_settings['{ORGANISATIONNAME}'] = $institutionForm;
  83. $installation_settings['{ORGANISATIONURL}'] = $institutionUrlForm;
  84. $installation_settings['{CAMPUSNAME}'] = $campusForm;
  85. $installation_settings['{PLATFORMLANGUAGE}'] = $languageForm;
  86. $installation_settings['{ALLOWSELFREGISTRATION}'] = true_false($allowSelfReg);
  87. $installation_settings['{ALLOWTEACHERSELFREGISTRATION}'] = true_false($allowSelfRegProf);
  88. $installation_settings['{ADMINLASTNAME}'] = $adminLastName;
  89. $installation_settings['{ADMINFIRSTNAME}'] = $adminFirstName;
  90. $installation_settings['{ADMINLOGIN}'] = $loginForm;
  91. $installation_settings['{ADMINPASSWORD}'] = $passToStore;
  92. $installation_settings['{ADMINEMAIL}'] = $emailForm;
  93. $installation_settings['{ADMINPHONE}'] = $adminPhoneForm;
  94. $installation_settings['{PLATFORM_AUTH_SOURCE}'] = PLATFORM_AUTH_SOURCE;
  95. $installation_settings['{ADMINLANGUAGE}'] = $languageForm;
  96. $installation_settings['{HASHFUNCTIONMODE}'] = $encryptPassForm;
  97. load_main_database($installation_settings);
  98. $app['monolog']->addInfo("drop_course_tables");
  99. drop_course_tables();
  100. $app['monolog']->addInfo("create_course_tables");
  101. load_database_script($new_version.'/db_course.sql');
  102. $track_countries_table = "track_c_countries";
  103. $app['monolog']->addInfo("fill_track_countries_table");
  104. fill_track_countries_table($track_countries_table);
  105. $app['monolog']->addInfo("locking_settings");
  106. locking_settings();
  107. update_dir_and_files_permissions();