install_db.inc.php 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225
  1. <?php
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /**
  4. ==============================================================================
  5. * Install the Dokeos database
  6. * Notice : This script has to be included by index.php
  7. *
  8. * @package dokeos.install
  9. ==============================================================================
  10. */
  11. require_once("install_upgrade.lib.php");
  12. /*
  13. ==============================================================================
  14. MAIN CODE
  15. ==============================================================================
  16. */
  17. //this page can only be access through including from the install script.
  18. if( ! defined('DOKEOS_INSTALL'))
  19. {
  20. echo 'You are not allowed here!';
  21. exit;
  22. }
  23. set_file_folder_permissions();
  24. @mysql_connect($dbHostForm,$dbUsernameForm,$dbPassForm);
  25. if(mysql_errno() > 0)
  26. {
  27. $no=mysql_errno();
  28. $msg=mysql_error();
  29. echo '<hr />['.$no.'] &ndash; '.$msg.'<hr>
  30. The MySQL server doesn\'t work or login / pass is bad.<br /><br />
  31. Please check these values:<br /><br />
  32. <b>host</b> : '.$dbHostForm.'<br />
  33. <b>user</b> : '.$dbUsernameForm.'<br />
  34. <b>password</b> : '.str_repeat('*',strlen($dbPassForm)).'<br /><br />
  35. Please go back to step 3.
  36. <p><button type="submit" class="back" name="step3" value="&lt; Back" >Back</button></p>
  37. </td></tr></table></form></body></html>';
  38. exit();
  39. }
  40. // The system has not been designed to use special SQL modes that were introduced since MySQL 5
  41. @mysql_query("set session sql_mode='';");
  42. // Initialization of the database encoding to be used.
  43. mysql_query("SET SESSION character_set_server='utf8';");
  44. mysql_query("SET SESSION collation_server='utf8_general_ci';");
  45. mysql_query("SET CHARACTER SET 'utf8';");
  46. if($urlForm[strlen($urlForm)-1] != '/')
  47. {
  48. $urlForm=$urlForm.'/';
  49. }
  50. switch ($encryptPassForm) {
  51. case 'md5' :
  52. $passToStore=md5($passForm);
  53. break;
  54. case 'sha1' :
  55. $passToStore=sha1($passForm);
  56. break;
  57. case 'none' :
  58. $passToStore=($passForm);
  59. break;
  60. }
  61. /*
  62. if($encryptPassForm)
  63. {
  64. $passToStore=md5($passForm);
  65. }
  66. else
  67. {
  68. $passToStore=($passForm);
  69. }*/
  70. $dbPrefixForm=eregi_replace('[^a-z0-9_-]','',$dbPrefixForm);
  71. $dbNameForm=eregi_replace('[^a-z0-9_-]','',$dbNameForm);
  72. $dbStatsForm=eregi_replace('[^a-z0-9_-]','',$dbStatsForm);
  73. $dbUserForm=eregi_replace('[^a-z0-9_-]','',$dbUserForm);
  74. if(!empty($dbPrefixForm) && !ereg('^'.$dbPrefixForm,$dbNameForm))
  75. {
  76. $dbNameForm=$dbPrefixForm.$dbNameForm;
  77. }
  78. if(!empty($dbPrefixForm) && !ereg('^'.$dbPrefixForm,$dbStatsForm))
  79. {
  80. $dbStatsForm=$dbPrefixForm.$dbStatsForm;
  81. }
  82. if(!empty($dbPrefixForm) && !ereg('^'.$dbPrefixForm,$dbUserForm))
  83. {
  84. $dbUserForm=$dbPrefixForm.$dbUserForm;
  85. }
  86. $mysqlMainDb=$dbNameForm;
  87. $mysqlStatsDb=$dbStatsForm;
  88. $mysqlUserDb=$dbUserForm;
  89. if(empty($mysqlMainDb) || $mysqlMainDb == 'mysql' || $mysqlMainDb == $dbPrefixForm)
  90. {
  91. $mysqlMainDb=$dbPrefixForm.'main';
  92. }
  93. if(empty($mysqlStatsDb) || $mysqlStatsDb == 'mysql' || $mysqlStatsDb == $dbPrefixForm)
  94. {
  95. $mysqlStatsDb=$dbPrefixForm.'stats';
  96. }
  97. if(empty($mysqlUserDb) || $mysqlUserDb == 'mysql' || $mysqlUserDb == $dbPrefixForm)
  98. {
  99. $mysqlUserDb=$dbPrefixForm.'user';
  100. }
  101. $result=mysql_query("SHOW VARIABLES LIKE 'datadir'") or die(mysql_error());
  102. $mysqlRepositorySys=mysql_fetch_array($result);
  103. $mysqlRepositorySys=$mysqlRepositorySys['Value'];
  104. if(!$singleDbForm)
  105. {
  106. mysql_query("DROP DATABASE IF EXISTS `$mysqlMainDb`") or die(mysql_error());
  107. }
  108. mysql_query("CREATE DATABASE IF NOT EXISTS `$mysqlMainDb`") or die(mysql_error());
  109. if($mysqlStatsDb == $mysqlMainDb && $mysqlUserDb == $mysqlMainDb)
  110. {
  111. $singleDbForm=true;
  112. }
  113. /**
  114. * CREATING THE STATISTICS DATABASE
  115. */
  116. if($mysqlStatsDb != $mysqlMainDb)
  117. {
  118. if(!$singleDbForm)
  119. {
  120. // multi DB mode AND tracking has its own DB so create it
  121. mysql_query("DROP DATABASE IF EXISTS `$mysqlStatsDb`") or die(mysql_error());
  122. mysql_query("CREATE DATABASE `$mysqlStatsDb`") or die(mysql_error());
  123. }
  124. else
  125. {
  126. // single DB mode so $mysqlStatsDb MUST BE the SAME than $mysqlMainDb
  127. $mysqlStatsDb=$mysqlMainDb;
  128. }
  129. }
  130. /**
  131. * CREATING THE USER DATABASE
  132. */
  133. if($mysqlUserDb != $mysqlMainDb)
  134. {
  135. if(!$singleDbForm)
  136. {
  137. // multi DB mode AND user data has its own DB so create it
  138. mysql_query("DROP DATABASE IF EXISTS `$mysqlUserDb`") or die(mysql_error());
  139. mysql_query("CREATE DATABASE `$mysqlUserDb`") or die(mysql_error());
  140. }
  141. else
  142. {
  143. // single DB mode so $mysqlUserDb MUST BE the SAME than $mysqlMainDb
  144. $mysqlUserDb=$mysqlMainDb;
  145. }
  146. }
  147. include("../lang/english/create_course.inc.php");
  148. if($languageForm != 'english')
  149. {
  150. include("../lang/$languageForm/create_course.inc.php");
  151. }
  152. /**
  153. * creating the tables of the main database
  154. */
  155. mysql_select_db($mysqlMainDb) or die(mysql_error());
  156. $installation_settings['{ORGANISATIONNAME}'] = $institutionForm;
  157. $installation_settings['{ORGANISATIONURL}'] = $institutionUrlForm;
  158. $installation_settings['{CAMPUSNAME}'] = $campusForm;
  159. $installation_settings['{PLATFORMLANGUAGE}'] = $languageForm;
  160. $installation_settings['{ALLOWSELFREGISTRATION}'] = trueFalse($allowSelfReg);
  161. $installation_settings['{ALLOWTEACHERSELFREGISTRATION}'] = trueFalse($allowSelfRegProf);
  162. $installation_settings['{ADMINLASTNAME}'] = $adminLastName;
  163. $installation_settings['{ADMINFIRSTNAME}'] = $adminFirstName;
  164. $installation_settings['{ADMINLOGIN}'] = $loginForm;
  165. $installation_settings['{ADMINPASSWORD}'] = $passToStore;
  166. $installation_settings['{ADMINEMAIL}'] = $emailForm;
  167. $installation_settings['{ADMINPHONE}'] = $adminPhoneForm;
  168. $installation_settings['{PLATFORM_AUTH_SOURCE}'] = PLATFORM_AUTH_SOURCE;
  169. $installation_settings['{ADMINLANGUAGE}'] = $languageForm;
  170. $installation_settings['{HASHFUNCTIONMODE}'] = $encryptPassForm;
  171. load_main_database($installation_settings);
  172. /**
  173. * creating the tables of the tracking database
  174. */
  175. mysql_select_db($mysqlStatsDb) or die(mysql_error());
  176. load_database_script('dokeos_stats.sql');
  177. $track_countries_table = "track_c_countries";
  178. fill_track_countries_table($track_countries_table);
  179. /**
  180. * creating the tables of the USER database
  181. * this is where the personal agenda items are storen, the user defined course categories (sorting of my courses)
  182. */
  183. mysql_select_db($mysqlUserDb) or die(mysql_error());
  184. load_database_script('dokeos_user.sql');
  185. ?>