install.php

   1 <?php /// $Id$
   2       /// install.php - helps admin user to create a config.php file
   3
   4 /// If config.php exists already then we are not needed.
   5
   6 if (file_exists('./config.php')) {
   7     header('Location: index.php');
   8     die;
   9 } else {
  10     $configfile = './config.php';
  11 }
  12
  13 ///==========================================================================//
  14 /// We are doing this in stages
  15 define ('WELCOME',            0); /// 0. Welcome and language settings
  16 define ('COMPATIBILITY',      1); /// 1. Compatibility
  17 define ('DIRECTORY',          2); /// 2. Directory settings
  18 define ('DATABASE',           3); /// 2. Database settings
  19 define ('ADMIN',              4); /// 4. Administration directory name
  20 define ('ENVIRONMENT',        5); /// 5. Administration directory name
  21 define ('DOWNLOADLANG',       6); /// 6. Load complete lang from download.moodle.org
  22 define ('SAVE',               7); /// 7. Save or display the settings
  23 define ('REDIRECT',           8); /// 8. Redirect to index.php
  24 ///==========================================================================//
  25
  26
  27 /// This has to be defined to avoid a notice in current_language()
  28 define('SITEID', 0);
  29
  30 /// Begin the session as we are holding all information in a session
  31 /// variable until the end.
  32
  33 session_name('MoodleSession');
  34 @session_start();
  35
  36 /// make sure PHP errors are displayed to help diagnose problems
  37 @error_reporting(1023); //E_ALL not used because we do not want strict notices in PHP5 yet
  38 @ini_set('display_errors', '1');
  39
  40 if (! isset($_SESSION['INSTALL'])) {
  41     $_SESSION['INSTALL'] = array();
  42 }
  43
  44 $INSTALL = &$_SESSION['INSTALL'];   // Makes it easier to reference
  45
  46 /// detect if install was attempted from diferent directory, if yes reset session to prevent errors,
  47 /// dirroot location now fixed in installer
  48 if (!empty($INSTALL['dirroot']) and $INSTALL['dirroot'] != dirname(__FILE__)) {
  49     $_SESSION['INSTALL'] = array();
  50 }
  51
  52 /// If it's our first time through this script then we need to set some default values
  53
  54 if ( empty($INSTALL['language']) and empty($_POST['language']) ) {
  55
  56     /// set defaults
  57     $INSTALL['language']        = 'en_utf8';
  58
  59     $INSTALL['dbhost']          = 'localhost';
  60     $INSTALL['dbuser']          = '';
  61     $INSTALL['dbpass']          = '';
  62     $INSTALL['dbtype']          = 'mysql';
  63     $INSTALL['dbname']          = 'moodle';
  64     $INSTALL['prefix']          = 'mdl_';
  65
  66     $INSTALL['downloadlangpack']       = false;
  67     $INSTALL['showdownloadlangpack']   = true;
  68     $INSTALL['downloadlangpackerror']  = '';
  69
  70 /// To be used by the Installer
  71     $INSTALL['wwwroot']         = '';
  72     $INSTALL['dirroot']         = dirname(__FILE__);
  73     $INSTALL['dataroot']        = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'moodledata';
  74
  75 /// To be configured in the Installer
  76     $INSTALL['wwwrootform']         = '';
  77     $INSTALL['dirrootform']         = dirname(__FILE__);
  78
  79     $INSTALL['admindirname']    = 'admin';
  80
  81     $INSTALL['stage'] = WELCOME;
  82 }
  83
  84 //==========================================================================//
  85
  86 /// Set the page to Unicode always
  87
  88 header('Content-Type: text/html; charset=UTF-8');
  89
  90 /// Was data submitted?
  91
  92 if (isset($_POST['stage'])) {
  93
  94     /// Get the stage for which the form was set and the next stage we are going to
  95
  96     /// Store any posted data
  97     foreach ($_POST as $setting=>$value) {
  98         $INSTALL[$setting] = $value;
  99     }
 100
 101     if ( $goforward = (! empty( $_POST['next'] )) ) {
 102         $nextstage = $_POST['stage'] + 1;
 103     } else if (! empty( $_POST['prev'])) {
 104         $nextstage = $_POST['stage'] - 1;
 105         $INSTALL['stage'] = $_POST['stage'] - 1;
 106     } else if (! empty( $_POST['same'] )) {
 107         $nextstage = $_POST['stage'];
 108     }
 109
 110     $nextstage = (int)$nextstage;
 111
 112     if ($nextstage < 0) {
 113         $nextstage = WELCOME;
 114     }
 115
 116
 117 } else {
 118
 119     $goforward = true;
 120     $nextstage = WELCOME;
 121
 122 }
 123
 124 //==========================================================================//
 125
 126 /// Fake some settings so that we can use selected functions from moodlelib.php and weblib.php
 127
 128 $SESSION->lang = (!empty($_POST['language'])) ? $_POST['language'] : $INSTALL['language'];
 129 $CFG->dirroot = $INSTALL['dirroot'];
 130 $CFG->libdir = $INSTALL['dirroot'].'/lib';
 131 $CFG->dataroot = $INSTALL['dataroot'];
 132 $CFG->admin = $INSTALL['admindirname'];
 133 $CFG->directorypermissions = 00777;
 134 $CFG->running_installer = true;
 135 $COURSE->id = 0;
 136
 137 /// Include some moodle libraries
 138
 139 require_once($CFG->libdir.'/adminlib.php');
 140 require_once($CFG->libdir.'/setuplib.php');
 141 require_once($CFG->libdir.'/moodlelib.php');
 142 require_once($CFG->libdir.'/weblib.php');
 143 require_once($CFG->libdir.'/deprecatedlib.php');
 144 require_once($CFG->libdir.'/adodb/adodb.inc.php');
 145 require_once($CFG->libdir.'/environmentlib.php');
 146 require_once($CFG->libdir.'/xmlize.php');
 147 require_once($CFG->libdir.'/componentlib.class.php');
 148 require_once($CFG->dirroot.'/version.php');
 149
 150 /// Set version and release
 151 $INSTALL['version'] = $version;
 152 $INSTALL['release'] = $release;
 153
 154 /// Have the $db object ready because we are going to use it often
 155 define ('ADODB_ASSOC_CASE', 0); //Use lowercase fieldnames for ADODB_FETCH_ASSOC
 156 $db = &ADONewConnection($INSTALL['dbtype']);
 157 $db->SetFetchMode(ADODB_FETCH_ASSOC);
 158
 159 /// guess the www root
 160 if ($INSTALL['wwwroot'] == '') {
 161     list($INSTALL['wwwroot'], $xtra) = explode('/install.php', qualified_me());
 162     $INSTALL['wwwrootform'] = $INSTALL['wwwroot'];
 163
 164     // now try to guess the correct dataroot not accessible via web
 165     $CFG->wwwroot = $INSTALL['wwwroot'];
 166     $i = 0; //safety check - dirname might return some unexpected results
 167     while(is_dataroot_insecure()) {
 168         $parrent = dirname($CFG->dataroot);
 169         $i++;
 170         if ($parrent == '/' or $parrent == '.' or preg_match('/^[a-z]:\\\?$/i', $parrent) or ($i > 100)) {
 171             $CFG->dataroot = ''; //can not find secure location for dataroot
 172             break;
 173         }
 174         $CFG->dataroot = dirname($parrent).'/moodledata';
 175     }
 176     $INSTALL['dataroot'] = $CFG->dataroot;
 177 }
 178
 179 $headstagetext = array(WELCOME       => get_string('chooselanguagehead', 'install'),
 180                        COMPATIBILITY => get_string('compatibilitysettingshead', 'install'),
 181                        DIRECTORY     => get_string('directorysettingshead', 'install'),
 182                        DATABASE      => get_string('databasesettingshead', 'install'),
 183                        ADMIN         => get_string('admindirsettinghead', 'install'),
 184                        ENVIRONMENT   => get_string('environmenthead', 'install'),
 185                        DOWNLOADLANG  => get_string('downloadlanguagehead', 'install'),
 186                        SAVE          => get_string('configurationcompletehead', 'install')
 187                         );
 188
 189 $substagetext = array(WELCOME       => get_string('chooselanguagesub', 'install'),
 190                       COMPATIBILITY => get_string('compatibilitysettingssub', 'install'),
 191                       DIRECTORY     => get_string('directorysettingssub', 'install'),
 192                       DATABASE      => get_string('databasesettingssub', 'install'),
 193                       ADMIN         => get_string('admindirsettingsub', 'install'),
 194                       ENVIRONMENT   => get_string('environmentsub', 'install'),
 195                       DOWNLOADLANG  => get_string('downloadlanguagesub', 'install'),
 196                       SAVE          => get_string('configurationcompletesub', 'install')
 197                        );
 198
 199
 200
 201 //==========================================================================//
 202
 203 /// Are we in help mode?
 204
 205 if (isset($_GET['help'])) {
 206     $nextstage = -1;
 207 }
 208
 209
 210
 211 //==========================================================================//
 212
 213 /// Are we in config download mode?
 214
 215 if (isset($_GET['download'])) {
 216     header("Content-Type: application/x-forcedownload\n");
 217     header("Content-Disposition: attachment; filename=\"config.php\"");
 218     echo $INSTALL['config'];
 219     exit;
 220 }
 221
 222
 223
 224
 225
 226 //==========================================================================//
 227
 228 /// Check the directory settings
 229
 230 if ($INSTALL['stage'] == DIRECTORY) {
 231
 232     error_reporting(0);
 233
 234     /// check wwwroot
 235     if (ini_get('allow_url_fopen') && false) {  /// This was not reliable
 236         if (($fh = @fopen($INSTALL['wwwrootform'].'/install.php', 'r')) === false) {
 237             $errormsg .= get_string('wwwrooterror', 'install').'<br />';
 238             $INSTALL['wwwrootform'] = $INSTALL['wwwroot'];
 239         }
 240     }
 241     if ($fh) fclose($fh);
 242
 243     /// check dirroot
 244     if (($fh = @fopen($INSTALL['dirrootform'].'/install.php', 'r')) === false ) {
 245         $errormsg .= get_string('dirrooterror', 'install').'<br />';
 246         $INSTALL['dirrootform'] = $INSTALL['dirroot'];
 247     }
 248     if ($fh) fclose($fh);
 249
 250     /// check dataroot
 251     $CFG->dataroot = $INSTALL['dataroot'];
 252     if (make_upload_directory('sessions', false) === false ) {
 253         $errormsg .= get_string('datarooterror', 'install').'<br />';
 254     }
 255     if ($fh) fclose($fh);
 256
 257     if (!empty($errormsg)) $nextstage = DIRECTORY;
 258
 259     error_reporting(7);
 260 }
 261
 262
 263
 264 //==========================================================================//
 265
 266 /// Check database settings if stage 3 data submitted
 267 /// Try to connect to the database. If that fails then try to create the database
 268
 269 if ($INSTALL['stage'] == DATABASE) {
 270
 271     /// different format for postgres7 by socket
 272     if ($INSTALL['dbtype'] == 'postgres7' and ($INSTALL['dbhost'] == 'localhost' || $INSTALL['dbhost'] == '127.0.0.1')) {
 273         $INSTALL['dbhost'] = "user='{$INSTALL['dbuser']}' password='{$INSTALL['dbpass']}' dbname='{$INSTALL['dbname']}'";
 274         $INSTALL['dbuser'] = '';
 275         $INSTALL['dbpass'] = '';
 276         $INSTALL['dbname'] = '';
 277
 278         if ($INSTALL['prefix'] == '') { /// must have a prefix
 279             $INSTALL['prefix'] = 'mdl_';
 280         }
 281     }
 282
 283     if ($INSTALL['dbtype'] == 'mysql') {  /// Check MySQL extension is present
 284         if (!extension_loaded('mysql')) {
 285             $errormsg = get_string('mysqlextensionisnotpresentinphp', 'install');
 286             $nextstage = DATABASE;
 287         }
 288     }
 289
 290     if ($INSTALL['dbtype'] == 'mysqli') {  /// Check MySQLi extension is present
 291         if (!extension_loaded('mysqli')) {
 292             $errormsg = get_string('mysqliextensionisnotpresentinphp', 'install');
 293             $nextstage = DATABASE;
 294         }
 295     }
 296
 297     if ($INSTALL['dbtype'] == 'postgres7') {  /// Check PostgreSQL extension is present
 298         if (!extension_loaded('pgsql')) {
 299             $errormsg = get_string('pgsqlextensionisnotpresentinphp', 'install');
 300             $nextstage = DATABASE;
 301         }
 302     }
 303
 304     if ($INSTALL['dbtype'] == 'mssql') {  /// Check MSSQL extension is present
 305         if (!function_exists('mssql_connect')) {
 306             $errormsg = get_string('mssqlextensionisnotpresentinphp', 'install');
 307             $nextstage = DATABASE;
 308         }
 309     }
 310
 311     if ($INSTALL['dbtype'] == 'mssql_n') {  /// Check MSSQL extension is present
 312         if (!function_exists('mssql_connect')) {
 313             $errormsg = get_string('mssqlextensionisnotpresentinphp', 'install');
 314             $nextstage = DATABASE;
 315         }
 316     }
 317
 318     if ($INSTALL['dbtype'] == 'odbc_mssql') {  /// Check ODBC extension is present
 319         if (!extension_loaded('odbc')) {
 320             $errormsg = get_string('odbcextensionisnotpresentinphp', 'install');
 321             $nextstage = DATABASE;
 322         }
 323     }
 324
 325     if ($INSTALL['dbtype'] == 'oci8po') {  /// Check OCI extension is present
 326         if (!extension_loaded('oci8')) {
 327             $errormsg = get_string('ociextensionisnotpresentinphp', 'install');
 328             $nextstage = DATABASE;
 329         }
 330     }
 331
 332     if (empty($INSTALL['prefix']) && $INSTALL['dbtype'] != 'mysql' && $INSTALL['dbtype'] != 'mysqli') { // All DBs but MySQL require prefix (reserv. words)
 333         $errormsg = get_string('dbwrongprefix', 'install');
 334         $nextstage = DATABASE;
 335     }
 336
 337     if ($INSTALL['dbtype'] == 'oci8po' && strlen($INSTALL['prefix']) > 2) { // Oracle max prefix = 2cc (30cc limit)
 338         $errormsg = get_string('dbwrongprefix', 'install');
 339         $nextstage = DATABASE;
 340     }
 341
 342     if ($INSTALL['dbtype'] == 'oci8po' && !empty($INSTALL['dbhost'])) { // Oracle host must be blank (tnsnames.ora has it)
 343         $errormsg = get_string('dbwronghostserver', 'install');
 344         $nextstage = DATABASE;
 345     }
 346
 347     if (empty($errormsg)) {
 348
 349         error_reporting(0);  // Hide errors
 350
 351         if (! $dbconnected = $db->Connect($INSTALL['dbhost'],$INSTALL['dbuser'],$INSTALL['dbpass'],$INSTALL['dbname'])) {
 352             $db->database = ''; // reset database name cached by ADODB. Trick from MDL-9609
 353             if ($dbconnected = $db->Connect($INSTALL['dbhost'],$INSTALL['dbuser'],$INSTALL['dbpass'])) { /// Try to connect without DB
 354                 switch ($INSTALL['dbtype']) {   /// Try to create a database
 355                     case 'mysql':
 356                     case 'mysqli':
 357                         if ($db->Execute("CREATE DATABASE {$INSTALL['dbname']} DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;")) {
 358                             $dbconnected = $db->Connect($INSTALL['dbhost'],$INSTALL['dbuser'],$INSTALL['dbpass'],$INSTALL['dbname']);
 359                         } else {
 360                             $errormsg = get_string('dbcreationerror', 'install');
 361                             $nextstage = DATABASE;
 362                         }
 363                         break;
 364                 }
 365             }
 366         } else {
 367         /// We have been able to connect properly, just test the database encoding now.
 368         /// It must be Unicode for 1.8 installations.
 369             $encoding = '';
 370             switch ($INSTALL['dbtype']) {
 371                 case 'mysql':
 372                 case 'mysqli':
 373                 /// Get MySQL character_set_database value
 374                     $rs = $db->Execute("SHOW VARIABLES LIKE 'character_set_database'");
 375                     if ($rs && !$rs->EOF) {
 376                         $records = $rs->GetAssoc(true);
 377                         $encoding = $records['character_set_database']['Value'];
 378                         if (strtoupper($encoding) != 'UTF8') {
 379                         /// Try to set the encoding now!
 380                             if (! $db->Metatables()) {  // We have no tables so go ahead
 381                                 $db->Execute("ALTER DATABASE `".$INSTALL['dbname']."` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci");
 382                                 $rs = $db->Execute("SHOW VARIABLES LIKE 'character_set_database'");  // this works
 383
 384                             }
 385                         }
 386                         /// If conversion fails, skip, let environment testing do the job
 387                     }
 388                     break;
 389                 case 'postgres7':
 390                 /// Skip, let environment testing do the job
 391                     break;
 392                 case 'oci8po':
 393                 /// Skip, let environment testing do the job
 394                     break;
 395             }
 396         }
 397     }
 398
 399     error_reporting(7);
 400
 401     if (($dbconnected === false) and (empty($errormsg)) ) {
 402         $errormsg = get_string('dbconnectionerror', 'install');
 403         $nextstage = DATABASE;
 404     }
 405 }
 406
 407
 408
 409 //==========================================================================//
 410
 411 /// If the next stage is admin directory settings OR we have just come from there then
 412 /// check the admin directory.
 413 /// If we can open a file then we know that the admin name is correct.
 414
 415 if ($nextstage == ADMIN or $INSTALL['stage'] == ADMIN) {
 416     if (!ini_get('allow_url_fopen')) {
 417         $nextstage = ($goforward) ? ENVIRONMENT : DATABASE;
 418     } else if (($fh = @fopen($INSTALL['wwwrootform'].'/'.$INSTALL['admindirname'].'/environment.xml', 'r')) !== false) {
 419         $nextstage = ($goforward) ? ENVIRONMENT : DATABASE;
 420         fclose($fh);
 421     } else {
 422         $nextstage = ($goforward) ? ENVIRONMENT : DATABASE;
 423         //if ($nextstage != ADMIN) {
 424         //    $errormsg = get_string('admindirerror', 'install');
 425         //    $nextstage = ADMIN;
 426         // }
 427     }
 428 }
 429
 430 //==========================================================================//
 431
 432 // Check if we can navigate from the environemt page (because it's ok)
 433
 434 if ($INSTALL['stage'] == ENVIRONMENT) {
 435     error_reporting(0);  // Hide errors
 436     $dbconnected = $db->Connect($INSTALL['dbhost'],$INSTALL['dbuser'],$INSTALL['dbpass'],$INSTALL['dbname']);
 437     error_reporting(7);  // Show errors
 438     if ($dbconnected) {
 439     /// Execute environment check, printing results
 440         if (!check_moodle_environment($INSTALL['release'], $environment_results, false)) {
 441              $nextstage = ENVIRONMENT;
 442         }
 443     } else {
 444     /// We never should reach this because DB has been tested before arriving here
 445         $errormsg = get_string('dbconnectionerror', 'install');
 446         $nextstage = DATABASE;
 447     }
 448 }
 449
 450
 451
 452 //==========================================================================//
 453
 454 // Try to download the lang pack if it has been selected
 455
 456 if ($INSTALL['stage'] == DOWNLOADLANG && $INSTALL['downloadlangpack']) {
 457
 458     $downloadsuccess = false;
 459     $downloaderror = '';
 460
 461     error_reporting(0);  // Hide errors
 462
 463 /// Create necessary lang dir
 464     if (!make_upload_directory('lang', false)) {
 465         $downloaderror = get_string('cannotcreatelangdir', 'error');
 466     }
 467
 468 /// Download and install component
 469     if (($cd = new component_installer('http://download.moodle.org', 'lang16',
 470         $INSTALL['language'].'.zip', 'languages.md5', 'lang')) && empty($errormsg)) {
 471         $status = $cd->install(); //returns COMPONENT_(ERROR | UPTODATE | INSTALLED)
 472         switch ($status) {
 473             case COMPONENT_ERROR:
 474                 if ($cd->get_error() == 'remotedownloaderror') {
 475                     $a = new stdClass();
 476                     $a->url = 'http://download.moodle.org/lang16/'.$pack.'.zip';
 477                     $a->dest= $CFG->dataroot.'/lang';
 478                     $downloaderror = get_string($cd->get_error(), 'error', $a);
 479                 } else {
 480                     $downloaderror = get_string($cd->get_error(), 'error');
 481                 }
 482             break;
 483             case COMPONENT_UPTODATE:
 484             case COMPONENT_INSTALLED:
 485                 $downloadsuccess = true;
 486             break;
 487             default:
 488                 //We shouldn't reach this point
 489         }
 490     } else {
 491         //We shouldn't reach this point
 492     }
 493
 494     error_reporting(7);  // Show errors
 495
 496     if ($downloadsuccess) {
 497         $INSTALL['downloadlangpack']       = false;
 498         $INSTALL['showdownloadlangpack']   = false;
 499         $INSTALL['downloadlangpackerror']  = $downloaderror;
 500     } else {
 501         $INSTALL['downloadlangpack']       = false;
 502         $INSTALL['showdownloadlangpack']   = false;
 503         $INSTALL['downloadlangpackerror']  = $downloaderror;
 504     }
 505 }
 506
 507
 508
 509 //==========================================================================//
 510
 511 /// Display or print the data
 512 /// Put the data into a string
 513 /// Try to open config file for writing.
 514
 515 if ($nextstage == SAVE) {
 516
 517     $str  = '<?php  /// Moodle Configuration File '."\r\n";
 518     $str .= "\r\n";
 519
 520     $str .= 'unset($CFG);'."\r\n";
 521     $str .= "\r\n";
 522
 523     $str .= '$CFG->dbtype    = \''.$INSTALL['dbtype']."';\r\n";
 524     $str .= '$CFG->dbhost    = \''.addslashes($INSTALL['dbhost'])."';\r\n";
 525     if (!empty($INSTALL['dbname'])) {
 526         $str .= '$CFG->dbname    = \''.$INSTALL['dbname']."';\r\n";
 527         // support single quotes in db user/passwords
 528         $str .= '$CFG->dbuser    = \''.addsingleslashes($INSTALL['dbuser'])."';\r\n";
 529         $str .= '$CFG->dbpass    = \''.addsingleslashes($INSTALL['dbpass'])."';\r\n";
 530     }
 531     $str .= '$CFG->dbpersist =  false;'."\r\n";
 532     $str .= '$CFG->prefix    = \''.$INSTALL['prefix']."';\r\n";
 533     $str .= "\r\n";
 534
 535     $str .= '$CFG->wwwroot   = \''.s($INSTALL['wwwrootform'],true)."';\r\n";
 536     $str .= '$CFG->dirroot   = \''.s($INSTALL['dirrootform'],true)."';\r\n";
 537     $str .= '$CFG->dataroot  = \''.s($INSTALL['dataroot'],true)."';\r\n";
 538     $str .= '$CFG->admin     = \''.s($INSTALL['admindirname'],true)."';\r\n";
 539     $str .= "\r\n";
 540
 541     $str .= '$CFG->directorypermissions = 00777;  // try 02777 on a server in Safe Mode'."\r\n";
 542     $str .= "\r\n";
 543
 544     $str .= 'require_once("$CFG->dirroot/lib/setup.php");'."\r\n";
 545     $str .= '// MAKE SURE WHEN YOU EDIT THIS FILE THAT THERE ARE NO SPACES, BLANK LINES,'."\r\n";
 546     $str .= '// RETURNS, OR ANYTHING ELSE AFTER THE TWO CHARACTERS ON THE NEXT LINE.'."\r\n";
 547     $str .= '?>';
 548
 549     umask(0137);
 550
 551     if (( $configsuccess = ($fh = @fopen($configfile, 'w')) ) !== false) {
 552         fwrite($fh, $str);
 553         fclose($fh);
 554     }
 555
 556
 557     $INSTALL['config'] = $str;
 558 }
 559
 560
 561
 562 //==========================================================================//
 563
 564 ?>
 565 <html dir="<?php echo (right_to_left() ? 'rtl' : 'ltr'); ?>">
 566 <head>
 567 <link rel="shortcut icon" href="theme/standard/favicon.ico" />
 568 <title>Moodle Install</title>
 569 <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
 570 <?php css_styles() ?>
 571 <?php database_js() ?>
 572
 573 </head>
 574
 575 <body>
 576
 577
 578 <?php
 579 if (isset($_GET['help'])) {
 580     print_install_help($_GET['help']);
 581     close_window_button();
 582 } else {
 583 ?>
 584
 585
 586 <table class="main" align="center" cellpadding="3" cellspacing="0">
 587     <tr>
 588         <td class="td_mainlogo">
 589             <p class="p_mainlogo"><img src="pix/moodlelogo-med.gif" width="240" height="60" alt="Moodle logo"></p>
 590         </td>
 591         <td class="td_mainlogo" valign="bottom">
 592             <p class="p_mainheader"><?php print_string('installation', 'install') ?></p>
 593         </td>
 594     </tr>
 595
 596     <tr>
 597         <td class="td_mainheading" colspan="2">
 598             <p class="p_mainheading"><?php echo $headstagetext[$nextstage] ?></p>
 599             <?php /// Exceptionaly, depending of the DB selected, we show some different text
 600                   /// from the standard one to show better instructions for each DB
 601                 if ($nextstage == DATABASE) {
 602                     echo '<script type="text/javascript" defer="defer">window.onload=toggledbinfo;</script>';
 603                     echo '<div id="mysql" name="mysql">' . get_string('databasesettingssub_mysql', 'install');
 604                     echo '<p align="center">' . get_string('databasesettingswillbecreated', 'install') . '</p>';
 605                     echo '</div>';
 606
 607                     echo '<div id="mysqli" name="mysqli">' . get_string('databasesettingssub_mysqli', 'install');
 608                     echo '<p align="center">' . get_string('databasesettingswillbecreated', 'install') . '</p>';
 609                     echo '</div>';
 610
 611                     echo '<div id="postgres7" name="postgres7">' . get_string('databasesettingssub_postgres7', 'install') . '</div>';
 612
 613                     echo '<div id="mssql" name="mssql">' . get_string('databasesettingssub_mssql', 'install');
 614                 /// Link to mssql installation page
 615                     echo '<p align="right"><a href="http://docs.moodle.org/en/Installing_MSSQL_for_PHP" target="_blank">';
 616                     echo '<img src="pix/docs.gif' . '" alt="Docs" class="iconhelp" />';
 617                     echo get_string('moodledocslink', 'install') . '</a></p>';
 618                     echo '</div>';
 619
 620                     echo '<div id="mssql_n" name="mssql">' . get_string('databasesettingssub_mssql_n', 'install');
 621                 /// Link to mssql installation page
 622                     echo '<p align="right"><a href="http://docs.moodle.org/en/Installing_MSSQL_for_PHP" target="_blank">';
 623                     echo '<img src="pix/docs.gif' . '" alt="Docs" />';
 624                     echo get_string('moodledocslink', 'install') . '</a></p>';
 625                     echo '</div>';
 626
 627                     echo '<div id="odbc_mssql" name="odbc_mssql">'. get_string('databasesettingssub_odbc_mssql', 'install');
 628                 /// Link to mssql installation page
 629                     echo '<p align="right"><a href="http://docs.moodle.org/en/Installing_MSSQL_for_PHP" target="_blank">';
 630                     echo '<img src="pix/docs.gif' . '" alt="Docs" class="iconhelp" />';
 631                     echo get_string('moodledocslink', 'install') . '</a></p>';
 632                     echo '</div>';
 633
 634                     echo '<div id="oci8po" name="oci8po">' . get_string('databasesettingssub_oci8po', 'install');
 635                 /// Link to oracle installation page
 636                     echo '<p align="right"><a href="http://docs.moodle.org/en/Installing_Oracle_for_PHP" target="_blank">';
 637                     echo '<img src="pix/docs.gif' . '" alt="Docs" class="iconhelp" />';
 638                     echo get_string('moodledocslink', 'install') . '</a></p>';
 639                     echo '</div>';
 640                 } else {
 641                     if (!empty($substagetext[$nextstage])) {
 642                         echo '<p class="p_subheading">' . $substagetext[$nextstage] . '</p>';
 643                     }
 644                 }
 645             ?>
 646         </td>
 647     </tr>
 648
 649     <tr>
 650         <td class="td_main" colspan="2">
 651
 652 <?php
 653
 654 if (!empty($errormsg)) echo "<p class=\"errormsg\" align=\"center\">$errormsg</p>\n";
 655
 656
 657 if ($nextstage == SAVE) {
 658     $INSTALL['stage'] = WELCOME;
 659     $options = array();
 660     $options['lang'] = $INSTALL['language'];
 661     if ($configsuccess) {
 662         echo "<p>".get_string('configfilewritten', 'install')."</p>\n";
 663
 664         echo "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\">\n";
 665         echo "<tr>\n";
 666         echo "<td width=\"33.3%\">&nbsp;</td>\n";
 667         echo "<td width=\"33.3%\">&nbsp;</td>\n";
 668         echo "<td width=\"33.3%\" align=\"right\">\n";
 669         print_single_button("index.php", $options, get_string('continue'));
 670         echo "</td>\n";
 671         echo "</tr>\n";
 672         echo "</table>\n";
 673
 674     } else {
 675         echo "<p class=\"errormsg\">".get_string('configfilenotwritten', 'install')."</p>";
 676
 677         echo "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\">\n";
 678         echo "<tr>\n";
 679         echo "<td width=\"33.3%\">&nbsp;</td>\n";
 680         echo "<td width=\"33.3%\" align=\"center\">\n";
 681         $installoptions = array();
 682         $installoptions['download'] = 1;
 683         print_single_button("install.php", $installoptions, get_string('download', 'install'));
 684         echo "</td>\n";
 685         echo "<td width=\"33.3%\" align=\"right\">\n";
 686         print_single_button("index.php", $options, get_string('continue'));
 687         echo "</td>\n";
 688         echo "</tr>\n";
 689         echo "</table>\n";
 690
 691         echo "<hr />\n";
 692         echo "<div style=\"text-align: ".fix_align_rtl("left")."\">\n";
 693         echo "<pre>\n";
 694         print_r(s($str));
 695         echo "</pre>\n";
 696         echo "</div>\n";
 697     }
 698 } else {
 699     $formaction = (isset($_GET['configfile'])) ? "install.php?configfile=".$_GET['configfile'] : "install.php";
 700     form_table($nextstage, $formaction);
 701 }
 702
 703 ?>
 704
 705         </td>
 706     </tr>
 707 </table>
 708
 709 <?php
 710 }
 711 ?>
 712
 713 </body>
 714 </html>
 715
 716
 717
 718
 719
 720
 721
 722
 723
 724
 725 <?php
 726
 727
 728 //==========================================================================//
 729
 730 function form_table($nextstage = WELCOME, $formaction = "install.php") {
 731     global $INSTALL, $db;
 732
 733     /// Print the standard form if we aren't in the DOWNLOADLANG page
 734     /// because it has its own form.
 735     if ($nextstage != DOWNLOADLANG) {
 736         $needtoopenform = false;
 737 ?>
 738         <form id="installform" method="post" action="<?php echo $formaction ?>">
 739         <input type="hidden" name="stage" value="<?php echo $nextstage ?>" />
 740
 741 <?php
 742     } else {
 743         $needtoopenform = true;
 744     }
 745 ?>
 746     <table class="install_table" cellspacing="3" cellpadding="3" align="center">
 747
 748 <?php
 749     /// what we do depends on the stage we're at
 750     switch ($nextstage) {
 751         case WELCOME: /// Welcome and language settings
 752 ?>
 753             <tr>
 754                 <td class="td_left"><p><?php print_string('language') ?></p></td>
 755                 <td class="td_right">
 756                 <?php choose_from_menu (get_installer_list_of_languages(), 'language', $INSTALL['language'], '') ?>
 757                 </td>
 758             </tr>
 759
 760 <?php
 761             break;
 762         case COMPATIBILITY: /// Compatibilty check
 763             $compatsuccess = true;
 764
 765             /// Check that PHP is of a sufficient version
 766             print_compatibility_row(inst_check_php_version(), get_string('phpversion', 'install'), get_string('phpversionerror', 'install'), 'phpversionhelp');
 767             /// Check session auto start
 768             print_compatibility_row(!ini_get_bool('session.auto_start'), get_string('sessionautostart', 'install'), get_string('sessionautostarterror', 'install'), 'sessionautostarthelp');
 769             /// Check magic quotes
 770             print_compatibility_row(!ini_get_bool('magic_quotes_runtime'), get_string('magicquotesruntime', 'install'), get_string('magicquotesruntimeerror', 'install'), 'magicquotesruntimehelp');
 771             /// Check unsupported PHP configuration
 772             print_compatibility_row(ini_get_bool('magic_quotes_gpc') || (!ini_get_bool('register_globals')), get_string('globalsquotes', 'install'), get_string('globalsquoteserror', 'install'), 'globalsquoteshelp');
 773             /// Check safe mode
 774             print_compatibility_row(!ini_get_bool('safe_mode'), get_string('safemode', 'install'), get_string('safemodeerror', 'install'), 'safemodehelp', true);
 775             /// Check file uploads
 776             print_compatibility_row(ini_get_bool('file_uploads'), get_string('fileuploads', 'install'), get_string('fileuploadserror', 'install'), 'fileuploadshelp', true);
 777             /// Check GD version
 778             print_compatibility_row(check_gd_version(), get_string('gdversion', 'install'), get_string('gdversionerror', 'install'), 'gdversionhelp', true);
 779             /// Check memory limit
 780             print_compatibility_row(check_memory_limit(), get_string('memorylimit', 'install'), get_string('memorylimiterror', 'install'), 'memorylimithelp', true);
 781
 782
 783             break;
 784         case DIRECTORY: /// Directory settings
 785 ?>
 786
 787             <tr>
 788                 <td class="td_left"><p><?php print_string('wwwroot', 'install') ?></p></td>
 789                 <td class="td_right">
 790                     <input type="text" size="40"name="wwwrootform" value="<?php p($INSTALL['wwwrootform'],true) ?>" />
 791                 </td>
 792             </tr>
 793             <tr>
 794                 <td class="td_left"><p><?php print_string('dirroot', 'install') ?></p></td>
 795                 <td class="td_right">
 796                     <input type="text" size="40" name="dirrootform" disabled="disabled" value="<?php p($INSTALL['dirrootform'],true) ?>" />
 797                 </td>
 798             </tr>
 799             <tr>
 800                 <td class="td_left"><p><?php print_string('dataroot', 'install') ?></p></td>
 801                 <td class="td_right">
 802                     <input type="text" size="40" name="dataroot" value="<?php p($INSTALL['dataroot'],true) ?>" />
 803                 </td>
 804             </tr>
 805
 806 <?php
 807             break;
 808         case DATABASE: /// Database settings
 809 ?>
 810
 811             <tr>
 812                 <td class="td_left"><p><?php print_string('dbtype', 'install') ?></p></td>
 813                 <td class="td_right">
 814                 <?php choose_from_menu (array('mysql' => get_string('mysql', 'install'),
 815                                               'mysqli' => get_string('mysqli', 'install'),
 816                                               'oci8po' => get_string('oci8po', 'install'),
 817                                               'postgres7' => get_string('postgres7', 'install'),
 818                                               'mssql' => get_string('mssql', 'install'),
 819                                               'mssql_n' => get_string('mssql_n', 'install'),
 820                                               'odbc_mssql' => get_string('odbc_mssql', 'install')),
 821                                         'dbtype', $INSTALL['dbtype'], '', 'toggledbinfo();') ?>
 822                 </td>
 823             </tr>
 824             <tr>
 825                 <td class="td_left"><p><?php print_string('dbhost', 'install') ?></p></td>
 826                 <td class="td_right">
 827                     <input type="text" size="40" name="dbhost" value="<?php p($INSTALL['dbhost']) ?>" />
 828                 </td>
 829             </tr>
 830             <tr>
 831                 <td class="td_left"><p><?php print_string('database', 'install') ?></p></td>
 832                 <td class="td_right">
 833                     <input type="text" size="40" name="dbname" value="<?php p($INSTALL['dbname']) ?>" />
 834                 </td>
 835             </tr>
 836             <tr>
 837                 <td class="td_left"><p><?php print_string('user') ?></p></td>
 838                 <td class="td_right">
 839                     <input type="text" size="40" name="dbuser" value="<?php p($INSTALL['dbuser']) ?>" />
 840                 </td>
 841             </tr>
 842             <tr>
 843                 <td class="td_left"><p><?php print_string('password') ?></p></td>
 844                 <td class="td_right">
 845                     <input type="password" size="40" name="dbpass" value="<?php p($INSTALL['dbpass']) ?>" />
 846                 </td>
 847             </tr>
 848             <tr>
 849                 <td class="td_left"><p><?php print_string('dbprefix', 'install') ?></p></td>
 850                 <td class="td_right">
 851                     <input type="text" size="40" name="prefix" value="<?php p($INSTALL['prefix']) ?>" />
 852                 </td>
 853             </tr>
 854
 855 <?php
 856             break;
 857         case ADMIN: /// Administration directory setting
 858 ?>
 859
 860             <tr>
 861                 <td class="td_left"><p><?php print_string('admindirname', 'install') ?></p></td>
 862                 <td class="td_right">
 863                     <input type="text" size="40" name="admindirname" value="<?php p($INSTALL['admindirname']) ?>" />
 864                 </td>
 865             </tr>
 866
 867
 868 <?php
 869             break;
 870         case ENVIRONMENT: /// Environment checks
 871 ?>
 872
 873             <tr>
 874                 <td colspan="2">
 875                 <?php
 876                     error_reporting(0);  // Hide errors
 877                     $dbconnected = $db->Connect($INSTALL['dbhost'],$INSTALL['dbuser'],$INSTALL['dbpass'],$INSTALL['dbname']);
 878                     error_reporting(7);  // Show errors
 879                     if ($dbconnected) {
 880                     /// Execute environment check, printing results
 881                         check_moodle_environment($INSTALL['release'], $environment_results, true);
 882                     } else {
 883                     /// We never should reach this because DB has been tested before arriving here
 884                         $errormsg = get_string('dbconnectionerror', 'install');
 885                         $nextstage = DATABASE;
 886                         echo '<p class="errormsg" align="center">'.get_string('dbconnectionerror', 'install').'</p>';
 887                     }
 888                 ?>
 889                 </td>
 890             </tr>
 891
 892 <?php
 893             break;
 894         case DOWNLOADLANG: /// Download language from download.moodle.org
 895 ?>
 896
 897             <tr>
 898                 <td colspan="2">
 899                 <?php
 900                 /// Get array of languages, we are going to use it
 901                     $languages=get_installer_list_of_languages();
 902                 /// Print the download form (button) if necessary
 903                     if ($INSTALL['showdownloadlangpack'] == true && substr($INSTALL['language'],0,2) != 'en') {
 904                         $options = array();
 905                         $options['downloadlangpack'] = true;
 906                         $options['stage'] = DOWNLOADLANG;
 907                         $options['same'] = true;
 908                         print_simple_box_start('center');
 909                         print_single_button('install.php', $options, get_string('downloadlanguagebutton','install', $languages[$INSTALL['language']]), 'POST');
 910                         print_simple_box_end();
 911                     } else {
 912                 /// Show result info
 913                     /// English lang packs aren't downloaded
 914                         if (substr($INSTALL['language'],0,2) == 'en') {
 915                             print_simple_box(get_string('downloadlanguagenotneeded', 'install', $languages[$INSTALL['language']]), 'center', '80%');
 916                         } else {
 917                             if ($INSTALL['downloadlangpackerror']) {
 918                                 echo "<p class=\"errormsg\" align=\"center\">".$INSTALL['downloadlangpackerror']."</p>\n";
 919                                 print_simple_box(get_string('langdownloaderror', 'install', $languages[$INSTALL['language']]), 'center', '80%');
 920                             } else {
 921                                 print_simple_box(get_string('langdownloadok', 'install', $languages[$INSTALL['language']]), 'center', '80%');
 922                             }
 923                         }
 924                     }
 925                 ?>
 926                 </td>
 927             </tr>
 928
 929 <?php
 930             break;
 931         default:
 932     }
 933 ?>
 934
 935     <tr>
 936         <td colspan="<?php echo ($nextstage == COMPATIBILITY) ? 3 : 2; ?>">
 937
 938 <?php
 939     if ($needtoopenform) {
 940 ?>
 941             <form id="installform" method="post" action="<?php echo $formaction ?>">
 942             <input type="hidden" name="stage" value="<?php echo $nextstage ?>" />
 943 <?php
 944     }
 945 ?>
 946
 947             <?php echo ($nextstage < SAVE) ? "<input type=\"submit\" name=\"next\" value=\"".get_string('next')."  &raquo;\" style=\"float: ".fix_align_rtl("right")."\"/>\n" : "&nbsp;\n" ?>
 948             <?php echo ($nextstage > WELCOME) ? "<input type=\"submit\" name=\"prev\" value=\"&laquo;  ".get_string('previous')."\" style=\"float: ".fix_align_rtl("left")."\"/>\n" : "&nbsp;\n" ?>
 949
 950 <?php
 951     if ($needtoopenform) {
 952 ?>
 953             </form>
 954 <?php
 955     }
 956 ?>
 957
 958
 959         </td>
 960
 961     </tr>
 962
 963     </table>
 964 <?php
 965     if (!$needtoopenform) {
 966 ?>
 967     </form>
 968 <?php
 969     }
 970 ?>
 971
 972 <?php
 973 }
 974
 975
 976
 977 //==========================================================================//
 978
 979 function print_compatibility_row($success, $testtext, $errormessage, $helpfield='', $caution=false) {
 980     echo "<tr>\n";
 981     echo "<td class=\"td_left\" valign=\"top\" nowrap width=\"160\"><p>$testtext</p></td>\n";
 982     if ($success) {
 983         echo "<td valign=\"top\"><p class=\"p_pass\">".get_string('pass', 'install')."</p></td>\n";
 984         echo "<td valign=\"top\">&nbsp;</td>\n";
 985     } else {
 986         echo "<td valign=\"top\"";
 987         echo ($caution) ? "<p class=\"p_caution\">".get_string('caution', 'install') : "<p class=\"p_fail\">".get_string('fail', 'install');
 988         echo "</p></td>\n";
 989         echo "<td valign=\"top\">";
 990         echo "<p>$errormessage ";
 991         install_helpbutton("install.php?help=$helpfield");
 992         echo "</p></td>\n";
 993     }
 994     echo "</tr>\n";
 995     return $success;
 996 }
 997
 998
 999 //==========================================================================//
1000
1001 function install_helpbutton($url, $title='') {
1002     if ($title == '') {
1003         $title = get_string('help');
1004     }
1005     echo "<a href=\"javascript: void(0)\">";
1006     echo "<img src=\"pix/help.gif\" class=\"iconhelp\" alt=\"$title\" title=\"$title\" ";
1007     echo "onClick=\"return window.open('$url', 'Help', 'menubar=0,location=0,scrollbars,resizable,width=500,height=400')\">";
1008     echo "</a>\n";
1009 }
1010
1011
1012
1013 //==========================================================================//
1014
1015 function print_install_help($help) {
1016     switch ($help) {
1017         case 'phpversionhelp':
1018             print_string($help, 'install', phpversion());
1019             break;
1020         case 'memorylimithelp':
1021             print_string($help, 'install', get_memory_limit());
1022             break;
1023         default:
1024             print_string($help, 'install');
1025     }
1026 }
1027
1028
1029 //==========================================================================//
1030
1031 function get_memory_limit() {
1032     if ($limit = ini_get('memory_limit')) {
1033         return $limit;
1034     } else {
1035         return get_cfg_var('memory_limit');
1036     }
1037 }
1038
1039 //==========================================================================//
1040
1041 function check_memory_limit() {
1042
1043     /// if limit is already 40 or more then we don't care if we can change it or not
1044     if ((int)str_replace('M', '', get_memory_limit()) >= 40) {
1045         return true;
1046     }
1047
1048     /// Otherwise, see if we can change it ourselves
1049     @ini_set('memory_limit', '40M');
1050     return ((int)str_replace('M', '', get_memory_limit()) >= 40);
1051 }
1052
1053 //==========================================================================//
1054
1055 function inst_check_php_version() {
1056     if (!check_php_version("4.3.0")) {
1057         return false;
1058     } else if (check_php_version("5.0.0")) {
1059         return check_php_version("5.1.0"); // 5.0.x is too buggy
1060     }
1061     return true; // 4.3.x or 4.4.x is fine
1062 }
1063 //==========================================================================//
1064
1065 /* This function returns a list of languages and their full names. The
1066  * list of available languages is fetched from install/lang/xx/installer.php
1067  * and it's used exclusively by the installation process
1068  * @return array An associative array with contents in the form of LanguageCode => LanguageName
1069  */
1070 function get_installer_list_of_languages() {
1071
1072     global $CFG;
1073
1074     $languages = array();
1075
1076 /// Get raw list of lang directories
1077     $langdirs = get_list_of_plugins('install/lang');
1078     asort($langdirs);
1079 /// Get some info from each lang
1080     foreach ($langdirs as $lang) {
1081         if (file_exists($CFG->dirroot .'/install/lang/'. $lang .'/installer.php')) {
1082             include($CFG->dirroot .'/install/lang/'. $lang .'/installer.php');
1083             if (substr($lang, -5) == '_utf8') {   //Remove the _utf8 suffix from the lang to show
1084                 $shortlang = substr($lang, 0, -5);
1085             } else {
1086                 $shortlang = $lang;
1087             }
1088             if ($lang == 'en') {  //Explain this is non-utf8 en
1089                 $shortlang = 'non-utf8 en';
1090             }
1091             if (!empty($string['thislanguage'])) {
1092                 $languages[$lang] = $string['thislanguage'] .' ('. $shortlang .')';
1093             }
1094             unset($string);
1095         }
1096     }
1097 /// Return array
1098     return $languages;
1099 }
1100
1101 //==========================================================================//
1102
1103 function css_styles() {
1104 ?>
1105
1106 <style type="text/css">
1107
1108     body { background-color: #ffeece; }
1109     p, li, td {
1110         font-family: helvetica, arial, sans-serif;
1111         font-size: 10pt;
1112     }
1113     a { text-decoration: none; color: blue; }
1114     a img {
1115         border: none;
1116     }
1117     .errormsg {
1118         color: red;
1119         font-weight: bold;
1120     }
1121     blockquote {
1122         font-family: courier, monospace;
1123         font-size: 10pt;
1124     }
1125     .install_table {
1126         width: 500px;
1127     }
1128     .td_left {
1129         text-align: <?php echo fix_align_rtl("right") ?>;
1130         font-weight: bold;
1131     }
1132     .td_right {
1133         text-align: <?php echo fix_align_rtl("left") ?>;
1134     }
1135     .main {
1136         width: 500px;
1137         border-width: 1px;
1138         border-style: solid;
1139         border-color: #ffc85f;
1140         -moz-border-radius-bottomleft: 15px;
1141         -moz-border-radius-bottomright: 15px;
1142     }
1143     .td_mainheading {
1144         background-color: #fee6b9;
1145         padding: 10px;
1146     }
1147     .td_main {
1148         text-align: center;
1149     }
1150     .td_mainlogo {
1151     }
1152     .p_mainlogo {
1153     }
1154     .p_mainheading {
1155         font-size: 11pt;
1156     }
1157     .p_subheading {
1158         font-size: 10pt;
1159         padding: 10px;
1160     }
1161     .p_mainheader{
1162         text-align: right;
1163         font-size: 20pt;
1164         font-weight: bold;
1165     }
1166     .p_pass {
1167         color: green;
1168         font-weight: bold;
1169     }
1170     .p_fail {
1171         color: red;
1172         font-weight: bold;
1173     }
1174     .p_caution {
1175         color: #ff6600;
1176         font-weight: bold;
1177     }
1178     .p_help {
1179         text-align: center;
1180         font-family: helvetica, arial, sans-serif;
1181         font-size: 14pt;
1182         font-weight: bold;
1183         color: #333333;
1184     }
1185     .environmenttable {
1186         font-size: 10pt;
1187         border-color: #ffc85f;
1188     }
1189     table.environmenttable .error {
1190         background-color : red;
1191         color : inherit;
1192     }
1193
1194     table.environmenttable .warn {
1195         background-color : yellow;
1196     }
1197
1198     table.environmenttable .ok {
1199         background-color : lightgreen;
1200     }
1201     .header {
1202         background-color: #fee6b9;
1203         font-size: 10pt;
1204     }
1205     .cell {
1206         background-color: #ffeece;
1207         font-size: 10pt;
1208     }
1209     .error {
1210         color: #ff0000;
1211     }
1212     .errorboxcontent {
1213         text-align: center;
1214         font-weight: bold;
1215         padding: 20px;
1216         color: #ff0000;
1217     }
1218     .invisiblefieldset {
1219       display:inline;
1220       border:0px;
1221       padding:0px;
1222       margin:0px;
1223     }
1224     #mysql, #mysqli, #postgres7, #mssql, #mssql_n, #odbc_mssql, #oci8po {
1225         display: none;
1226     }
1227
1228 </style>
1229
1230 <?php
1231 }
1232
1233 //==========================================================================//
1234
1235 function database_js() {
1236 ?>
1237
1238 <script type="text/javascript" defer="defer">
1239 function toggledbinfo() {
1240     //Calculate selected value
1241     var showid = 'mysql';
1242     if (document.getElementById('installform').dbtype.value) {
1243         showid = document.getElementById('installform').dbtype.value;
1244     }
1245     if (document.getElementById) {
1246         //Hide all the divs
1247         document.getElementById('mysql').style.display = '';
1248         document.getElementById('mysqli').style.display = '';
1249         document.getElementById('postgres7').style.display = '';
1250         document.getElementById('mssql').style.display = '';
1251         document.getElementById('mssql_n').style.display = '';
1252         document.getElementById('odbc_mssql').style.display = '';
1253         document.getElementById('oci8po').style.display = '';
1254         //Show the selected div
1255         document.getElementById(showid).style.display = 'block';
1256     } else if (document.all) {
1257         //This is the way old msie versions work
1258         //Hide all the divs
1259         document.all['mysql'].style.display = '';
1260         document.all['mysqli'].style.display = '';
1261         document.all['postgres7'].style.display = '';
1262         document.all['mssql'].style.display = '';
1263         document.all['mssql_n'].style.display = '';
1264         document.all['odbc_mssql'].style.display = '';
1265         document.all['oci8po'].style.display = '';
1266         //Show the selected div
1267         document.all[showid].style.display = 'block';
1268     } else if (document.layers) {
1269         //This is the way nn4 works
1270         //Hide all the divs
1271         document.layers['mysql'].style.display = '';
1272         document.layers['mysqli'].style.display = '';
1273         document.layers['postgres7'].style.display = '';
1274         document.layers['mssql'].style.display = '';
1275         document.layers['mssql_n'].style.display = '';
1276         document.layers['odbc_mssql'].style.display = '';
1277         document.layers['oci8po'].style.display = '';
1278         //Show the selected div
1279         document.layers[showid].style.display = 'block';
1280     }
1281 }
1282 </script>
1283
1284 <?php
1285 }
1286
1287 /**
1288  * Add slashes for single quotes and backslashes
1289  * so they can be included in single quoted string
1290  * (for config.php)
1291  */
1292 function addsingleslashes($input){
1293     return preg_replace("/(['\\\])/", "\\\\$1", $input);
1294 }
1295 ?>