install_db.inc.php 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
  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 can only be access through including from the install script.
  10. if (!defined('SYSTEM_INSTALLATION')) {
  11. echo 'You are not allowed here!';
  12. exit;
  13. }
  14. $urlForm = api_add_trailing_slash($urlForm);
  15. switch ($encryptPassForm) {
  16. case 'md5' :
  17. $passToStore = md5($passForm);
  18. break;
  19. case 'sha1' :
  20. $passToStore = sha1($passForm);
  21. break;
  22. case 'none' :
  23. $passToStore = $passForm;
  24. break;
  25. }
  26. $dbPrefixForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbPrefixForm);
  27. $dbNameForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbNameForm);
  28. if (!empty($dbPrefixForm) && strpos($dbNameForm, $dbPrefixForm) !== 0) {
  29. $dbNameForm = $dbPrefixForm.$dbNameForm;
  30. }
  31. $dbStatsForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbStatsForm);
  32. if (!empty($dbPrefixForm) && strpos($dbStatsForm, $dbPrefixForm) !== 0) {
  33. $dbStatsForm = $dbPrefixForm.$dbStatsForm;
  34. }
  35. $dbUserForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbUserForm);
  36. if (!empty($dbPrefixForm) && strpos($dbUserForm, $dbPrefixForm) !== 0) {
  37. $dbUserForm = $dbPrefixForm.$dbUserForm;
  38. }
  39. $mysqlMainDb = $dbNameForm;
  40. if (empty($mysqlMainDb) || $mysqlMainDb == 'mysql' || $mysqlMainDb == $dbPrefixForm) {
  41. $mysqlMainDb = $dbPrefixForm.'main';
  42. }
  43. $mysqlStatsDb = $dbStatsForm;
  44. if (empty($mysqlStatsDb) || $mysqlStatsDb == 'mysql' || $mysqlStatsDb == $dbPrefixForm) {
  45. $mysqlStatsDb = $dbPrefixForm.'stats';
  46. }
  47. $mysqlUserDb = $dbUserForm;
  48. if (empty($mysqlUserDb) || $mysqlUserDb == 'mysql' || $mysqlUserDb == $dbPrefixForm) {
  49. $mysqlUserDb = $dbPrefixForm.'user';
  50. }
  51. //This parameter is needed to run a command line to install Chamilo using BNPanel + ISPConfig see #1799
  52. if (!defined('CLI_INSTALLATION')) {
  53. $result = Database::query("SHOW VARIABLES LIKE 'datadir'") or die(Database::error());
  54. $mysqlRepositorySys = Database::fetch_array($result);
  55. $mysqlRepositorySys = $mysqlRepositorySys['Value'];
  56. if (!$singleDbForm) {
  57. Database::query("DROP DATABASE IF EXISTS `$mysqlMainDb`") or die(Database::error());
  58. }
  59. $create_database = true;
  60. if ($singleDbForm) {
  61. if (database_exists($mysqlMainDb)) {
  62. $create_database = false;
  63. }
  64. }
  65. if ($create_database) {
  66. $sql = "CREATE DATABASE IF NOT EXISTS `$mysqlMainDb`";
  67. Database::query($sql) or die(Database::error());
  68. }
  69. }
  70. /**
  71. * CREATING THE STATISTICS DATABASE
  72. */
  73. $mysqlStatsDb = $mysqlMainDb;
  74. /*
  75. if ($mysqlStatsDb != $mysqlMainDb) {
  76. if (!$singleDbForm) {
  77. // multi DB mode AND tracking has its own DB so create it
  78. Database::query("DROP DATABASE IF EXISTS `$mysqlStatsDb`") or die(Database::error());
  79. Database::query("CREATE DATABASE `$mysqlStatsDb`") or die(Database::error());
  80. } else {
  81. // single DB mode so $mysqlStatsDb MUST BE the SAME than $mysqlMainDb
  82. $mysqlStatsDb = $mysqlMainDb;
  83. }
  84. }*/
  85. /**
  86. * CREATING THE USER DATABASE
  87. */
  88. $mysqlUserDb = $mysqlMainDb;
  89. /*
  90. if ($mysqlUserDb != $mysqlMainDb) {
  91. if (!$singleDbForm) {
  92. // multi DB mode AND user data has its own DB so create it
  93. Database::query("DROP DATABASE IF EXISTS `$mysqlUserDb`") or die(Database::error());
  94. Database::query("CREATE DATABASE `$mysqlUserDb`") or die(Database::error());
  95. } else {
  96. // single DB mode so $mysqlUserDb MUST BE the SAME than $mysqlMainDb
  97. $mysqlUserDb = $mysqlMainDb;
  98. }
  99. }*/
  100. // This parameter is needed to run a command line install of Chamilo (needed for Phing)
  101. if (!defined('CLI_INSTALLATION')) {
  102. include api_get_path(SYS_LANG_PATH).'english/create_course.inc.php';
  103. if ($languageForm != 'english') {
  104. include api_get_path(SYS_LANG_PATH).$languageForm.'/create_course.inc.php';
  105. }
  106. }
  107. /**
  108. * Creating the tables of the main database
  109. */
  110. Database::select_db($mysqlMainDb) or die(Database::error());
  111. $installation_settings['{ORGANISATIONNAME}'] = $institutionForm;
  112. $installation_settings['{ORGANISATIONURL}'] = $institutionUrlForm;
  113. $installation_settings['{CAMPUSNAME}'] = $campusForm;
  114. $installation_settings['{PLATFORMLANGUAGE}'] = $languageForm;
  115. $installation_settings['{ALLOWSELFREGISTRATION}'] = true_false($allowSelfReg);
  116. $installation_settings['{ALLOWTEACHERSELFREGISTRATION}'] = true_false($allowSelfRegProf);
  117. $installation_settings['{ADMINLASTNAME}'] = $adminLastName;
  118. $installation_settings['{ADMINFIRSTNAME}'] = $adminFirstName;
  119. $installation_settings['{ADMINLOGIN}'] = $loginForm;
  120. $installation_settings['{ADMINPASSWORD}'] = $passToStore;
  121. $installation_settings['{ADMINEMAIL}'] = $emailForm;
  122. $installation_settings['{ADMINPHONE}'] = $adminPhoneForm;
  123. $installation_settings['{PLATFORM_AUTH_SOURCE}'] = PLATFORM_AUTH_SOURCE;
  124. $installation_settings['{ADMINLANGUAGE}'] = $languageForm;
  125. $installation_settings['{HASHFUNCTIONMODE}'] = $encryptPassForm;
  126. load_main_database($installation_settings);
  127. //Adds the c_XXX courses tables see #3910
  128. require_once api_get_path(LIBRARY_PATH).'add_course.lib.inc.php';
  129. update_Db_course();
  130. /**
  131. * Creating the tables of the tracking database
  132. */
  133. //Database::select_db($mysqlMainDb) or die(Database::error());
  134. load_database_script('db_stats.sql');
  135. $track_countries_table = "track_c_countries";
  136. fill_track_countries_table($track_countries_table);
  137. /**
  138. * Creating the tables of the USER database
  139. * This is where the personal agenda items are storen, the user defined course categories (sorting of my courses)
  140. */
  141. //Database::select_db($mysqlMainDb) or die(Database::error());
  142. load_database_script('db_user.sql');