Documentation TYPO3 par Ameos

Disponible dans d'autres versions de TYPO3 -> 3.7.0  3.8.1  4.0.0  4.0.1  4.1.0   <- Available in other TYPO3 versions

class.tx_install.php

<?php
/***************************************************************
*  Copyright notice
*
*  (c) 1999-2004 Kasper Skaarhoj (kasperYYYY@typo3.com)
*  All rights reserved
*
*  This script is part of the TYPO3 project. The TYPO3 project is
*  free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  The GNU General Public License can be found at
*  http://www.gnu.org/copyleft/gpl.html.
*  A copy is found in the textfile GPL.txt and important notices to the license
*  from the author is found in LICENSE.txt distributed with these scripts.
*
*
*  This script is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
require_once (PATH_t3lib.'class.t3lib_install.php');
require_once (PATH_t3lib.'class.t3lib_stdgraphic.php');

class tx_install extends t3lib_install {
        var $getGD_start_string='<H2 align="center"><A NAME="module_gd">gd</A></H2>';   // Used to identify the GD section in the output from phpinfo()
        var $getGD_end_string = '</TABLE>';     // Used to identify the end of the GD section (found with getGD_start_string) in the output from phpinfo()
        var $getTTF_string = 'with TTF library';        // Used to identify whether TTF-lib is included with GD
        var $getTTF_string_alt = 'with freetype';       // Used to identify whether TTF-lib is included with GD
        var $action = "";               // The url that calls this script
        var $scriptSelf = "index.php";          // The url that calls this script
        var $fontTag2='<font face="verdana,sans-serif" size=2 color=black>';
        var $fontTag1='<font face="verdana,sans-serif" size=1 color=black>';
        var $updateIdentity = "TYPO3 Install Tool";
        var $headerStyle ='';
        var $contentBeforeTable="";
        var $setAllCheckBoxesByDefault=0;

        var $allowFileEditOutsite_typo3conf_dir=0;

        var $INSTALL =array();          // In constructor: is set to global GET/POST var TYPO3_INSTALL
        var $checkIMlzw = 0;            // If set, lzw capabilities of the available ImageMagick installs are check by actually writing a gif-file and comparing size
        var $checkIM = 0;                       // If set, ImageMagick is checked.
        var $dumpImCommands=1;                  // If set, the image Magick commands are always outputted in the image processing checker
        var $mode = ""; // If set to "123" then only most vital information is displayed.
        var $step = 0;  // If set to 1,2,3 or GO it signifies various functions.

        // internal
        var $passwordOK=0;                      // This is set, if the password check was ok. The function init() will exit if this is not set
        var $silent=1;                          // If set, the check routines don't add to the message-array
        var $messageFunc_nl2br=1;
        var $sections=array();          // Used to gather the message information.
        var $fatalError=0;                      // This is set if some error occured that will definitely prevent TYpo3 from running.
        var $sendNoCacheHeaders=1;
        var $config_array = array(      // Flags are set in this array if the options are available and checked ok.
                "gd"=>0,
                "gd_gif"=>0,
                "gd_png"=>0,
                "gd_jpg"=>0,
                "freetype" => 0,
                "safemode" => 0,
                "dir_typo3temp" => 0,
                "dir_temp" => 0,
                "im_versions" => array(),
                "im" => 0,
                "sql.safe_mode_user" => "",
                "mysqlConnect" => 0,
                "no_database" => 0
        );
        var $typo3temp_path="";

        var $menuitems = array(
                "config" => "Basic Configuration",
                "database" => "Database Analyser",
                "images" => "Image Processing",
                "extConfig" => "All Configuration",
                "typo3temp" => "typo3temp/",
                "cleanup" => "Clean up database",
                "phpinfo" => "phpinfo()",
                "typo3conf_edit" => "Edit files in typo3conf/",
                "about" => "About"
        );
        var $cookie_name = "Typo3InstallTool";
        var $JSmessage = '';






        function tx_install()   {
                parent::t3lib_install();

                if (!$GLOBALS["TYPO3_CONF_VARS"]["BE"]["installToolPassword"])  die("Install Tool deactivated.<BR>You must enable it by setting a password in typo3conf/localconf.php. If you insert the line below, the password will be 'joh316':<BR><BR>\$TYPO3_CONF_VARS[\"BE\"][\"installToolPassword\"] = \"bacb98acf97e0b6112b1d1b650b84971\";<BR><BR>See the document 'installing_upgrading_32b1.pdf' for more info.");

                if ($this->sendNoCacheHeaders)  {
                        header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
                        header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
                        header("Expires: 0");
                        header("Cache-Control: no-cache, must-revalidate");
                        header("Pragma: no-cache");
                }

                        // ****************************
                        // Initializing incoming vars.
                        // ****************************
                $this->INSTALL = t3lib_div::_GP("TYPO3_INSTALL");
                $this->mode = t3lib_div::_GP("mode");
                $this->step = t3lib_div::_GP("step");
                if ($_GET["TYPO3_INSTALL"]["type"])     $this->INSTALL["type"] = $_GET["TYPO3_INSTALL"]["type"];

                if ($this->step==3)     {
                        $this->INSTALL["type"]="database";
                }

                if ($this->mode=="123") {
                        $tempItems = $this->menuitems;
                        unset($this->menuitems);
                        $this->menuitems["config"] = $tempItems["config"];
                        $this->menuitems["database"] = $tempItems["database"];
                        if (!$this->INSTALL["type"] || !isset($this->menuitems[$this->INSTALL["type"]]))        $this->INSTALL["type"] = "config";
                } else {
                        if (!$this->INSTALL["type"] || !isset($this->menuitems[$this->INSTALL["type"]]))        $this->INSTALL["type"] = "about";
                }

                $this->action = $this->scriptSelf."?TYPO3_INSTALL[type]=".$this->INSTALL["type"].($this->mode?"&mode=".rawurlencode($this->mode):"").($this->step?"&step=".rawurlencode($this->step):"");
                $this->typo3temp_path = PATH_site."typo3temp/";


                        // ****************
                        // Check password
                        // ****************
                        // Getting a unique session key, used to encode the session-access cookie later...
                $uKey = $_COOKIE[$this->cookie_name."_key"];
                if (!$uKey)     {
                        $uKey = md5(uniqid(microtime()));
                        SetCookie($this->cookie_name."_key", $uKey, 0, "/");            // Cookie is set

                        $this->JSmessage='SECURITY:
Make sure to protect the Install Tool with another password than "joh316".
Better yet you can add a die() function call to typo3/install/index.php after usage.

IF THE INSTALL TOOL CRASHES...
The Install Tool is checking PHPs support for image formats. However certain versions of PHP (fx. 4.3.0 with bundled GD) will crash when trying to read the PNG test file. If this happens you will see a blank screen or error message.
Workaround: Open the file typo3/t3lib/class.t3lib_install.php, go to the line where the function "isPNG()" is defined and make it return "0" hardcoded. PNG is not checked anymore and the rest of the Install Tool will work as expected. The same has been known with the other image formats as well. You can use a similar method to bypass the testing if that is also a problem.
On behalf of PHP we regret this inconvenience.

BTW: This Install Tool will only work if cookies are accepted by your web browser. If this dialog pops up over and over again you didn\'t enable cookies.
';

                }
                        // Check if the password from TYPO3_CONF_VARS combined with uKey matches the sKey cookie. If not, ask for password.
                $sKey = $_COOKIE[$this->cookie_name];

                if (md5($GLOBALS["TYPO3_CONF_VARS"]["BE"]["installToolPassword"]."|".$uKey) == $sKey || $this->checkPassword($uKey))    {
                        $this->passwordOK=1;
                }

                if ($GLOBALS["CLIENT"]["SYSTEM"]=="unix" && $GLOBALS["CLIENT"]["BROWSER"]=="konqu")     {
                        $this->fontTag2='<font face="verdana,sans-serif" size=4 color=black>';
                        $this->fontTag1='<font face="verdana,sans-serif" size=3 color=black>';
                }
        }

        function checkPassword($uKey)   {
                $p = t3lib_div::_GP("password");

                if ($p && md5($p)==$GLOBALS["TYPO3_CONF_VARS"]["BE"]["installToolPassword"])    {
                        $sKey = md5($GLOBALS["TYPO3_CONF_VARS"]["BE"]["installToolPassword"]."|".$uKey);
                        SetCookie($this->cookie_name, $sKey, 0, "/");

                                // Sending warning email
                        $wEmail = $GLOBALS["TYPO3_CONF_VARS"]["BE"]["warning_email_addr"];
                        if ($wEmail)    {
                                $subject="Install Tool Login at '".$GLOBALS["TYPO3_CONF_VARS"]["SYS"]["sitename"]."'";
                                $email_body="There has been a Install Tool login at TYPO3 site '".$GLOBALS["TYPO3_CONF_VARS"]["SYS"]["sitename"]."' (".t3lib_div::getIndpEnv("HTTP_HOST").") from remote address '".t3lib_div::getIndpEnv("REMOTE_ADDR")."' (".t3lib_div::getIndpEnv("REMOTE_HOST").")";
                                mail($wEmail,
                                        $subject,
                                        $email_body,
                                        "From: TYPO3 Install Tool WARNING <>"
                                );
                        }
                        return true;
                } else {
                        $this->messageFunc_nl2br=0;
                        $this->silent=0;
                        $content = '<form action="'.$this->action.'" method="POST">
                        <input type="password" name="password"><BR>
                        <input type="submit" value="Log in"><br>
                        <br>

                        '.$this->fw('The Install Tool Password is <i>not</i> the admin password of TYPO3.<BR>
                                If you don\'t know the current password, you can set a new one by setting the value of $TYPO3_CONF_VARS["BE"]["installToolPassword"] in typo3conf/localconf.php to the md5() hash value of the password you desire.'.
                                ($p?"<BR><BR>The password you just tried has this md5-value: <BR><BR>".md5($p):"")
                                ).'
                        </form>';

                        $this->message("Password", "Enter the Install Tool Password", $content,3);
                        echo $this->outputWrapper($this->printAll());
                                // Bad password, send warning:
                        if ($p) {
                                $wEmail = $GLOBALS["TYPO3_CONF_VARS"]["BE"]["warning_email_addr"];
                                if ($wEmail)    {
                                        $subject="Install Tool Login ATTEMPT at '".$GLOBALS["TYPO3_CONF_VARS"]["SYS"]["sitename"]."'";
                                        $email_body="There has been a Install Tool login attempt at TYPO3 site '".$GLOBALS["TYPO3_CONF_VARS"]["SYS"]["sitename"]."' (".t3lib_div::getIndpEnv("HTTP_HOST").").
Password tried was '".$p."'
REMOTE_ADDR was '".t3lib_div::getIndpEnv("REMOTE_ADDR")."' (".t3lib_div::getIndpEnv("REMOTE_HOST").")";
                                        mail($wEmail,
                                                $subject,
                                                $email_body,
                                                "From: TYPO3 Install Tool WARNING <>"
                                        );
                                }
                        }

                        return false;
                }
        }

        function init() {
                if (!defined("PATH_typo3"))     exit;           // Must be called after inclusion of init.php (or from init.php)
                if (!$this->passwordOK) exit;
//              debug($_COOKIE);

                        // Setting stuff...
                $this->check_mail();
                $this->setupGeneral();
                $this->generateConfigForm();
                if (count($this->messages))     debug($this->messages);

                if ($this->step)        {
                        echo $this->outputWrapper($this->stepOutput());
                } else {
                                // Menu...
                        switch($this->INSTALL["type"])  {
                                case "images":
                                        $this->checkIM=1;
                                        $this->checkTheConfig();
                                        $this->silent=0;
                                        $this->checkTheImageProcessing();
                                break;
                                case "database":
                                        $this->checkTheConfig();
                                        $this->silent=0;
                                        $this->checkTheDatabase();
                                break;
                                case "config":
                                        $this->silent=0;
                                        $this->checkIM=1;
                                        $this->message("About configuration","How to configure TYPO3",$this->generallyAboutConfiguration());
                                        $this->checkTheConfig();

                                        $ext = "Write config to localconf.php";
                                        if ($this->fatalError)  {
                                                if ($this->config_array["no_database"] || !$this->config_array["mysqlConnect"]) {
                                                        $this->message($ext, "Database not configured yet!", "
                                                                You need to specify database username, password and host as one of the first things.
                                                                Next you'll have to select a database to use with TYPO3.
                                                                Use the form below:
                                                        ",2);
                                                } else {
                                                        $this->message($ext, "Fatal error encountered!", "
                                                                Somewhere above a fatal configuration problem is encountered. Please make sure that you've fixed this error before you submit the configuration. TYPO3 will not run if this problem is not fixed!
                                                                You should also check all warnings that may appear.
                                                        ",2);
                                                }
                                        } elseif ($this->mode=="123") {
                                                if (!$this->fatalError) {
                                                        $this->message($ext, "Basic configuration completed", '
                                                                You have no fatal errors in your basic configuration. You may have warnings though. Please pay attention to them! However you may continue and install the database.

                                                                <B><font color=red>Step 2:</font></B> <a href="'.$this->scriptSelf.'?TYPO3_INSTALL[type]=database'.($this->mode?"&mode=".rawurlencode($this->mode):"").'">Click here to install the database.</a>
                                                        ',-1,1);
                                                }
                                        }
                                        $this->message($ext, "Very Important: Changing Image Processing settings", "
                                                When you change the settings for Image Processing you <i>must</i> take into account that <u>old images</u> may still be in typo3temp/ folder and prevent new files from being generated! This is especially important to know, if you're trying to set up image processing for the very first time.
                                                The problem is solved by <a href=\"".$this->setScriptName("typo3temp")."\">clearing the typo3temp/ folder</a>. Also make sure to clear the cache_pages table.
                                                ",1,1);
                                        $this->message($ext, "Update localconf.php", "
                                                This form updates the localconf.php file with the suggested values you see below. The values are based on the analysis above.
                                                You can change the values in case you have alternatives to the suggested defaults.
                                                By this final step you will configure TYPO3 for immediate use provided that you have no fatal errors left above."
                                                .$this->setupGeneral("get_form"),0,1);

                                        echo $this->outputWrapper($this->printAll());
                        //              debug($this->config_array);
                                break;
                                case "extConfig":
                                        $this->silent=0;

                                        $this->generateConfigForm("get_form");

                                        $content = $this->printAll();
                                        $content = '<form action="'.$this->action.'" method="POST">'.$content.'<input type="submit" value="Write to localconf.php"><BR><BR>
                                        '.$this->fw("<strong>NOTICE: </strong>By clicking this button, localconf.php is updated with new values for the parameters listed above!<BR>").'
                                        </form>';
                                        echo $this->outputWrapper($content);
                                break;
                                case "typo3temp":
                                        $this->checkTheConfig();
                                        $this->silent=0;
                                        $this->typo3TempManager();
                                break;
                                case "cleanup":
                                        $this->checkTheConfig();
                                        $this->silent=0;
                                        $this->cleanupManager();
                                break;
                                case "phpinfo":
                                        $this->silent=0;
                                        $this->phpinformation();
                                break;
                                case "typo3conf_edit":
                                        $this->silent=0;
                                        $this->typo3conf_edit();
                                break;
                                case "about":
                                default:
                                        $this->silent=0;
                                        $this->message("About", "Warning - very important!", $this->securityRisk().$this->alterPasswordForm(),2);

                                        $this->message("About", "Using this script", "
                                        Installing TYPO3 has always been a hot topic on the mailing list and forums. Therefore we've developed this tool which will help you through configuration and testing.
                                        There are three primary steps for you to take:

                                        <strong>1: Basic Configuration</strong>
                                        In this step your PHP-configuration is checked. If there are any settings that will prevent TYPO3 from running correctly you'll get warnings and errors with a description of the problem.
                                        You'll have to enter a database username, password and hostname. Then you can choose to create a new database or select an existing one.
                                        Finally the image processing settings are entered and verified and you can choose to let the script update the configuration file, typo3conf/localconf.php with the suggested settings.

                                        <strong>2: Database Analyser</strong>
                                        In this step you can either install a new database or update the database from any previous TYPO3 version.
                                        You can also get an overview of extra/missing fields/tables in the database compared to a raw sql-file.
                                        The database is also verified agains your 'tables.php' configuration (\$TCA) and you can even see suggestions to entries in \$TCA or new fields in the database.

                                        <strong>3: Image Processing</strong>
                                        This step is a visual guide to verify your configuration of the image processing software.
                                        You'll be presented to a list of images that should all match in pairs. If some irregularity appears, you'll get a warning. Thus you're able to track an error before you'll discover it on your website.

                                        <strong>4: All Configuration</strong>
                                        This gives you access to any of the configuration options in the TYPO3_CONF_VARS array. Every option is also presented with a comment explaining what it does.

                                        <strong>5: typo3temp/</strong>
                                        Here you can manage the files in typo3temp/ folder in a simple manner. typo3temp/ contains temporary files, which may still be used by the website, but some may not. By searching for files with old access-dates, you can possibly manage to delete unused files rather than files still used. However if you delete a temporary file still in use, it's just regenerated as long as you make sure to clear the cache tables afterwards.
                                        ");

                                        $this->message("About", "Why is this script stand-alone?", "
                                        You would think that this script should rather be a module in the backend and access-controlled to only admin-users from the database. But that's not how it works.
                                        The reason is, that this script must not be depending on the success of the configuration of TYPO3 and whether or not there is a working database behind. Therefore the script is invoked from the backend init.php file, which allows access if the constant 'TYPO3_enterInstallScript' has been defined and is not false. That is and should be the case <i>only</i> when calling the script 'typo3/install/index.php' - this script!
                                        ");


                                        $headCode="Header legend";
                                        $this->message($headCode, "Just information", "
                                        This is a simple message with some information about something.
                                        ");
                                        $this->message($headCode, "Check was successful", "
                                        Indicates that something was checked and returned an expected result.
                                        ",-1);
                                        $this->message($headCode, "Notice!", "
                                        Indicates that something is important to be aware of.
                                        This does <em>not</em> indicate an error.
                                        ",1);
                                        $this->message($headCode, "Warning!", "
                                        Indicates that something may very well cause trouble and you should definitely look into it before proceeding.
                                        This indicates a <em>potential</em> error.
                                        ",2);
                                        $this->message($headCode, "Error!", "
                                        Indicates that something is definitely wrong and that TYPO3 will most likely not perform as expected if this problem is not solved.
                                        This indicates an actual error.
                                        ",3);

                                        echo $this->outputWrapper($this->printAll());
                                break;
                        }
                }
        }

        function stepOutput()   {
                $this->checkTheConfig();
                $error_missingConnect='<br>
                        '.$this->fontTag2.'<img src="../t3lib/gfx/icon_fatalerror.gif" width=18 height=16 class="absmiddle">
                        There is no connection to the database!<br>
                        (Username: <i>'.TYPO3_db_username.'</i>, Password: <i>'.TYPO3_db_password.'</i>, Host: <i>'.TYPO3_db_host.'</i>).<BR>
                        <br>
                        <strong>Go to Step 1</strong> and enter a proper username/password!</font>
                        <br>
                        <br>
                ';
                $error_missingDB='<br>
                        '.$this->fontTag2.'<img src="../t3lib/gfx/icon_fatalerror.gif" width=18 height=16 class="absmiddle">
                        There is no access to the database (<i>'.TYPO3_db.'</i>)!<br>
                        <br>
                        <strong>Go to Step 2</strong> and select an accessible database!</font>
                        <br>
                        <br>
                ';

                $whichTables=$this->getListOfTables();
                $dbInfo='
                                        <table border=0 cellpadding=1 cellspacing=0>
                                                <tr>
                                                        <td valign="top" nowrap colspan=2 align=center>'.$this->fontTag2.'<strong><img src="../t3lib/gfx/icon_note.gif" hspace=5 width=18 height=16 class="absmiddle">Database summary:</strong></font></td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap>'.$this->fontTag1.'Username:</font></td>
                                                        <td valign="top" nowrap><strong>'.$this->fontTag1.''.TYPO3_db_username.'</font></strong></td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap>'.$this->fontTag1.'Password:</font></td>
                                                        <td valign="top" nowrap><strong>'.$this->fontTag1.''.TYPO3_db_password.'</font></strong></td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap>'.$this->fontTag1.'Host:</font></td>
                                                        <td valign="top" nowrap><strong>'.$this->fontTag1.''.TYPO3_db_host.'</font></strong></td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap>'.$this->fontTag1.'Database:</font></td>
                                                        <td valign="top" nowrap><strong>'.$this->fontTag1.''.TYPO3_db.'</font></strong></td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap>'.$this->fontTag1.'# of tables:</font></td>
                                                        <td valign="top" nowrap><strong>'.$this->fontTag1.''.(count($whichTables)?'<font color=red>'.count($whichTables).'</font>':count($whichTables)).'</font></strong></td>
                                                </tr>
                                        </table>
                ';
                $error_emptyDB='<br>
                        '.$this->fontTag2.'<img src="../t3lib/gfx/icon_fatalerror.gif" width=18 height=16 class="absmiddle">
                        The database is still empty. There are no tables!<br>
                        <br>
                        <strong>Go to Step 3</strong> and import a database!</font>
                        <br>
                        <br>
                ';

                switch(strtolower($this->step)) {
                        case 1:
                                $msg='
<br>
<br>
                                        <table border=0>
                                           <form action="'.$this->action.'" method="POST">
                                                <tr>
                                                        <td valign="top" nowrap><strong>
                                                           '.$this->fontTag2.'Username:</font></strong>
                                                        </td>
                                                        <td>    &nbsp;
                                                        </td>
                                                        <td valign="top">
                                                           '.$this->fontTag2.'
                                                           <input type="text" name="TYPO3_INSTALL[localconf.php][typo_db_username]" value="'.TYPO3_db_username.'"></font><BR>
                                                        </td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap><strong>
                                                           '.$this->fontTag2.'Password:</font></strong>
                                                        </td>
                                                        <td>    &nbsp;
                                                        </td>
                                                        <td valign="top">
                                                           '.$this->fontTag2.'
                                                           <input type="text" name="TYPO3_INSTALL[localconf.php][typo_db_password]" value="'.TYPO3_db_password.'"></font><BR>
                                                        </td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap><strong>
                                                           '.$this->fontTag2.'Host:</font></strong>
                                                        </td>
                                                        <td>    &nbsp;
                                                        </td>
                                                        <td valign="top">
                                                           '.$this->fontTag2.'
                                                           <input type="text" name="TYPO3_INSTALL[localconf.php][typo_db_host]" value="'.(TYPO3_db_host?TYPO3_db_host:'localhost').'"></font><BR>
                                                        </td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap><strong>
                                                           '.$this->fontTag1.'</font></strong>
                                                        </td>
                                                        <td>    &nbsp;
                                                        </td>
                                                        <td valign="top">
                                                           '.$this->fontTag1.'<BR>
                                                           <input type="hidden" name="step" value="2">
                                                           <input type="submit" value="Update localconf.php"><BR><br /><strong>NOTICE: </strong>By clicking this button, typo3conf/localconf.php is updated with new values for the parameters listed above!</font><BR>
                                                        </td>
                                                </tr>
                                           </form>
                                        </table>
<br>
<br>
                                ';
                        break;
                        case 2:
                                if ($result = $GLOBALS['TYPO3_DB']->sql_pconnect(TYPO3_db_host, TYPO3_db_username, TYPO3_db_password))  {
                                        $dbArr = $this->getDatabaseList();
                                        reset($dbArr);
                                        $options="";
                                        $options.='<option value="">[ SELECT DATABASE ]</option>';
                                        $dbIncluded=0;
                                        while(list(,$dbname)=each($dbArr))      {
                                                $options.='<option value="'.htmlspecialchars($dbname).'"'.($dbname==TYPO3_db?' selected':'').'>'.htmlspecialchars($dbname).'</option>';
                                                if ($dbname==TYPO3_db)  $dbIncluded=1;
                                        }
                                        if (!$dbIncluded && TYPO3_db)   {
                                                $options.='<option value="'.htmlspecialchars(TYPO3_db).'" selected>'.htmlspecialchars(TYPO3_db).' (NO ACCESS!)</option>';
                                        }
                                        $select='<select name="TYPO3_INSTALL[localconf.php][typo_db]">'.$options.'</select>';
                                        $msg='
<br>
<br>
                                        <table border=0>
                                           <form action="'.$this->action.'" method="POST">
                                                <tr>
                                                        <td valign="top" nowrap><strong>
                                                           '.$this->fontTag2.'
                                                           You have two options:<br>
                                                           <br><br>

                                                           1: Select an existing <u>EMPTY</u> database:</font></strong>
                                                        </td>
                                                </tr>
                                                <tr>
                                                        <td valign="top">
                                                           '.$this->fontTag1.'Any existing tables which are used by TYPO3 will be overwritten in Step 3. So make sure this database is empty:<BR>'.$select.'</font><BR>
                                                        </td>
                                                </tr>
                                                <tr>
                                                        <td valign="top" nowrap><br>
                                                        <br>
<strong>
                                                           '.$this->fontTag2.'2: Create new database (recommended):</font></strong>
                                                        </td>
                                                </tr>
                                                <tr>
                                                        <td valign="top">
                                                           '.$this->fontTag1.'Enter the desired name of the database here:<BR><input type="text" name="TYPO3_INSTALL[localconf.php][NEW_DATABASE_NAME]" value=""></font><BR>
                                                        </td>
                                                </tr>
                                                <tr>
                                                        <td valign="top">                  <br>

                                                           '.$this->fontTag1.'<BR>
                                                           <input type="hidden" name="step" value="3">
                                                           <input type="submit" value="Update localconf.php"><BR><br /><strong>NOTICE: </strong>By clicking this button, typo3conf/localconf.php is updated with new values for the parameters listed above!</font><BR>
                                                        </td>
                                                </tr>
                                           </form>
                                        </table>
<br>
<br>
                                ';
                                } else {
                                        $msg=$error_missingConnect;
                                }
                        break;
                        case 3:
                                if ($result = $GLOBALS['TYPO3_DB']->sql_pconnect(TYPO3_db_host, TYPO3_db_username, TYPO3_db_password))  {
                                        if ($GLOBALS['TYPO3_DB']->sql_select_db(TYPO3_db))      {
                                                $sFiles = t3lib_div::getFilesInDir(PATH_typo3conf,"sql",1,1);
                                                reset($sFiles);
                                                $opt='';
                                                while(list(,$f)=each($sFiles))  {
                                                        $opt.='<option value="import|'.htmlspecialchars($f).'">'.htmlspecialchars(basename($f)).'</option>';
                                                }


                                                $content='
                                                        '.$this->fontTag2.'Database dumps in typo3conf/ directory:</font><BR>
                                                        <input type="hidden" name="TYPO3_INSTALL[database_import_all]" value=1>
                                                   <input type="hidden" name="step" value="">
                                                   <input type="hidden" name="goto_step" value="go">
                                                        <select name="TYPO3_INSTALL[database_type]">'.$opt.'</select><BR>';

                                                $content = $this->getUpdateDbFormWrap("import", $content, "Import database");

                                                $msg='
                                                <br>
                                                '.$dbInfo.'<br>
                                                <br>
                                                '.$content.'

                                                ';

                                        } else {
                                                $msg=$error_missingDB;
                                        }
                                } else {
                                        $msg=$error_missingConnect;
                                }
                        break;
                        case "go":
                                if ($result = $GLOBALS['TYPO3_DB']->sql_pconnect(TYPO3_db_host, TYPO3_db_username, TYPO3_db_password))  {
                                        if ($GLOBALS['TYPO3_DB']->sql_select_db(TYPO3_db))      {
                                                if (count($whichTables))        {
                                                        $msg='
                                                        <br>
                                                        '.$this->fontTag2.'
                                                        '.nl2br($this->messageBasicFinished()).'
                                                        <br>
                                                        <hr>
                                                        <div align="center"><strong><img src="../t3lib/gfx/icon_warning.gif" hspace=5 width=18 height=16 class="absmiddle">IMPORTANT</strong></div><br>
                                                        <font size=1>'.nl2br($this->securityRisk()).'
                                                        <br>
                                                        <strong>Enter <a href="'.$this->scriptSelf.'">"Normal" mode for the Install Tool</a> to change this!</strong><br>

                                                        </font>
                                                        </font><BR>
                                                        ';
                                                } else {
                                                        $msg=$error_emptyDB;
                                                }
                                        } else {
                                                $msg=$error_missingDB;
                                        }
                                } else {
                                        $msg=$error_missingConnect;
                                }
                        break;
                        default:
                        break;
                }
                return $msg;
        }

        function checkTheConfig()       {
                        // Order important:
                $this->checkDirs();
                $this->checkConfiguration();
                $this->checkExtensions();

                if (TYPO3_OS=="WIN")    {
                        $paths=array($GLOBALS["TYPO3_CONF_VARS"]["GFX"]["im_path_lzw"], $GLOBALS["TYPO3_CONF_VARS"]["GFX"]["im_path"], "c:\\php\\imagemagick\\", 'c:\\apache\\ImageMagick\\');
                } else {
                        $paths=array($GLOBALS["TYPO3_CONF_VARS"]["GFX"]["im_path_lzw"], $GLOBALS["TYPO3_CONF_VARS"]["GFX"]["im_path"], "/usr/local/bin/","/usr/bin/","/usr/X11R6/bin/");
                }

                asort($paths);
                if (ini_get("safe_mode"))       {
                        $paths=array(ini_get("safe_mode_exec_dir"),"/usr/local/php/bin/");
                }
                if ($this->INSTALL["checkIM"]["lzw"])   {
                        $this->checkIMlzw=1;
                }
                if ($this->INSTALL["checkIM"]["path"])  {
                        $paths[]=trim($this->INSTALL["checkIM"]["path"]);
                }
                if ($this->checkIM)     $this->checkImageMagick($paths);
                $this->checkDatabase();
        }

        function typo3conf_edit()       {
                $EDIT_path = PATH_typo3conf;    // default:
                if ($this->allowFileEditOutsite_typo3conf_dir && $this->INSTALL["FILE"]["EDIT_path"])   {
                        if (t3lib_div::validPathStr($this->INSTALL["FILE"]["EDIT_path"]) && substr($this->INSTALL["FILE"]["EDIT_path"],-1)=="/")        {
                                $tmp_path = PATH_site.$this->INSTALL["FILE"]["EDIT_path"];
                                if (is_dir($tmp_path))  {
                                        $EDIT_path=$tmp_path;
                                } else {debug("'".$tmp_path."' was not dir");}
                        } else {
                                debug("BAD DIR_NAME (must be like t3lib/ or media/script/)");
                        }
                }

                $headCode = "Edit files in ".basename($EDIT_path)."/";
                $this->contentBeforeTable="";

                if ($this->INSTALL["SAVE_FILE"])        {
                        $save_to_file = $this->INSTALL["FILE"]["name"];
                        if (@is_file($save_to_file))    {
                                $save_to_file_md5 = md5($save_to_file);
                                if (isset($this->INSTALL["FILE"][$save_to_file_md5]) && t3lib_div::isFirstPartOfStr($save_to_file,$EDIT_path."") && substr($save_to_file,-1)!="~")      {
                                        $this->INSTALL["typo3conf_files"] = $save_to_file;
                                        $save_fileContent = $this->INSTALL["FILE"][$save_to_file_md5];

                                        if ($this->INSTALL["FILE"]["win_to_unix_br"])   {
                                                $save_fileContent = str_replace(chr(13).chr(10),chr(10),$save_fileContent);
                                        }
                                        if ($this->INSTALL["FILE"]["backup"])   {
                                                if (@is_file($save_to_file."~"))        unlink($save_to_file."~");
                                                rename($save_to_file,$save_to_file."~");
                                                $this->contentBeforeTable.='Backup written to <strong>'.$save_to_file.'~</strong><BR>';
                                        } else {
                                                if (@is_file($save_to_file."~"))        {
                                                        unlink($save_to_file."~");
                                                        $this->contentBeforeTable.='Backup REMOVED! (<strong>'.$save_to_file.'~</strong>)<BR>';
                                                }
                                        }

                                        t3lib_div::writeFile($save_to_file,$save_fileContent);
                                        $this->contentBeforeTable.='
                                                File saved: <strong>'.$save_to_file.'</strong><BR>
                                                MD5-sum: '.$this->INSTALL["FILE"]["prevMD5"].' (prev)<BR>
                                                MD5-sum: '.md5($save_fileContent).' (new)<BR>
                                        ';
                                }
                        }
                }


                        // Filelist:
                $typo3conf_files = t3lib_div::getFilesInDir($EDIT_path,"",1,1);
                reset($typo3conf_files);
                $lines=array();
                $fileFound = 0;
                while(list($k,$file)=each($typo3conf_files))    {
                        if ($this->INSTALL["typo3conf_files"] && !strcmp($this->INSTALL["typo3conf_files"],$file))      {
                                $wrap=array('<strong><font color=navy>','</font></strong>');
                                $fileFound = 1;
                        } else {$wrap=array();}
                        $lines[]='<tr><td nowrap><a href="'.$this->action.'&TYPO3_INSTALL[typo3conf_files]='.rawurlencode($file).($this->allowFileEditOutsite_typo3conf_dir?'&TYPO3_INSTALL[FILE][EDIT_path]='.rawurlencode($this->INSTALL["FILE"]["EDIT_path"]):"").'">'.$this->fw($wrap[0].basename($file).$wrap[1]."&nbsp;&nbsp;&nbsp;").'</a></td><td>'.$this->fw(t3lib_div::formatSize(filesize($file))).'</td></tr>';
                }
                $fileList='<table border=0 cellpadding=0 cellspacing=0>'.implode("",$lines).'</table>';
                $fileList.="<BR>(".$EDIT_path.")";

                if ($this->allowFileEditOutsite_typo3conf_dir)  {
                        $fileList.='<BR><form action="'.$this->action.'" method="POST">
                        '.PATH_site.'<input type="text" name="TYPO3_INSTALL[FILE][EDIT_path]" value="'.$this->INSTALL["FILE"]["EDIT_path"].'"><input type="submit" name="" value="Set">
                        </form>';
                }

                if ($fileFound && @is_file($this->INSTALL["typo3conf_files"]))  {
                        $this->headerStyle = '
                        <style type="text/css"><!--
                                SELECT {font-family: Verdana,Arial,Helvetica,Sans-serif; font-size: 10px;}
                                TEXTAREA  {font-family: Verdana,Arial,Helvetica,Sans-serif; font-size: 10px;}
                                INPUT {font-family: Verdana,Arial,Helvetica,Sans-serif; font-size: 10px;}
                        //--></style>
                        ';

                        $fileContent = t3lib_div::getUrl($this->INSTALL["typo3conf_files"]);
                        $this->contentBeforeTable.= '<form action="'.$this->action.'" method="POST">
                                '.(substr($this->INSTALL["typo3conf_files"],-1)!="~"?'<input type="submit" name="TYPO3_INSTALL[SAVE_FILE]" value="Save file">&nbsp;':'').'<input type="submit" name="_close" value="Close">
                                <BR>File: '.$this->INSTALL["typo3conf_files"].'
                                <BR>MD5-sum: '.md5($fileContent).'
                                <BR>

                                <input type="hidden" name="TYPO3_INSTALL[FILE][name]" value="'.$this->INSTALL["typo3conf_files"].'">
                                '.($this->allowFileEditOutsite_typo3conf_dir?'<input type="hidden" name="TYPO3_INSTALL[FILE][EDIT_path]" value="'.$this->INSTALL["FILE"]["EDIT_path"].'">':'').'
                                <input type="hidden" name="TYPO3_INSTALL[FILE][prevMD5]" value="'.md5($fileContent).'">
                                <textarea rows="30" name="TYPO3_INSTALL[FILE]['.md5($this->INSTALL["typo3conf_files"]).']" wrap="off"'.$this->formWidthText(48,"width:98%;height:80%","off").'>'.t3lib_div::formatForTextarea($fileContent).'</textarea><BR>
                                <input type="checkbox" name="TYPO3_INSTALL[FILE][win_to_unix_br]" value="1"'.(TYPO3_OS=="WIN"?"":" CHECKED").'> Convert windows linebreaks (13-10) to unix (10)<BR>
                                <input type="checkbox" name="TYPO3_INSTALL[FILE][backup]" value="1"'.(@is_file($this->INSTALL["typo3conf_files"]."~") ? " CHECKED":"").'> Make backup copy (else remove any backup copy, prepended by "~")<BR>
                                '.
                        '</form>';
                }

                if ($this->contentBeforeTable)  {
                        $this->contentBeforeTable = $this->fw($this->contentBeforeTable);
                }

                $this->message($headCode,"Files in folder",$fileList);

                echo $this->outputWrapper($this->printAll());
        }

        function phpinformation()       {
                $headCode = "PHP information";

                $sVar = t3lib_div::getIndpEnv("_ARRAY");
                $sVar["CONST: PHP_OS"]=PHP_OS;
                $sVar["CONST: TYPO3_OS"]=TYPO3_OS;
                $sVar["CONST: PATH_thisScript"]=PATH_thisScript;
                $sVar["CONST: php_sapi_name()"]=php_sapi_name();
                $sVar["OTHER: TYPO3_VERSION"]=$GLOBALS["TYPO_VERSION"];
                $sVar["OTHER: PHP_VERSION"]=phpversion();
                $sVar["imagecreatefromgif()"]=function_exists("imagecreatefromgif");
                $sVar["imagecreatefrompng()"]=function_exists("imagecreatefrompng");
                $sVar["imagecreatefromjpeg()"]=function_exists("imagecreatefromjpeg");
                $sVar["imagegif()"]=function_exists("imagegif");
                $sVar["imagepng()"]=function_exists("imagepng");
                $sVar["imagejpeg()"]=function_exists("imagejpeg");
                $sVar["imagettftext()"]=function_exists("imagettftext");
                $sVar["OTHER: IMAGE_TYPES"]=imagetypes();
                $sVar["OTHER: memory_limit"]=ini_get("memory_limit");

                $gE_keys = explode(",","SERVER_PORT,SERVER_SOFTWARE,GATEWAY_INTERFACE,SCRIPT_NAME,PATH_TRANSLATED");
                while(list(,$k)=each($gE_keys)) {
                        $sVar["SERVER: ".$k]=$_SERVER[$k];
                }

                $gE_keys = explode(",","image_processing,gdlib,gdlib_png,gdlib_2,im,im_path,im_path_lzw,im_version_5,im_negate_mask,im_imvMaskState,im_combine_filename");
                while(list(,$k)=each($gE_keys)) {
                        $sVar["T3CV_GFX: ".$k]=$GLOBALS["TYPO3_CONF_VARS"]["GFX"][$k];
                }

                $debugInfo=array();
                $debugInfo[]="### DEBUG SYSTEM INFORMATION - START ###";
                reset($sVar);
                while(list($kkk,$vvv)=each($sVar))      {
                        $debugInfo[]=str_pad(substr($kkk,0,20),20).": ".$vvv;
                }
                $debugInfo[]="### DEBUG SYSTEM INFORMATION - END ###";

                $buf=$this->messageFunc_nl2br;
                $this->messageFunc_nl2br=0;
                $this->message($headCode,"DEBUG information",'Please copy/paste the information from this text field into an email or bug-report as "Debug System Information" whenever you wish to get support or report problems. This information helps others to check if your system has some obvious misconfiguration and you\'ll get your help faster!<BR>
                <form action=""><textarea rows="10" '.$this->formWidthText(80,"","off").' wrap="OFF">'.t3lib_div::formatForTextarea(implode(chr(10),$debugInfo)).'</textarea></form>');
                $this->messageFunc_nl2br=$buf;

                $getEnvArray = array();
                $gE_keys = explode(",","QUERY_STRING,HTTP_ACCEPT,HTTP_ACCEPT_ENCODING,HTTP_ACCEPT_LANGUAGE,HTTP_CONNECTION,HTTP_COOKIE,HTTP_HOST,HTTP_USER_AGENT,REMOTE_ADDR,REMOTE_HOST,REMOTE_PORT,SERVER_ADDR,SERVER_ADMIN,SERVER_NAME,SERVER_PORT,SERVER_SIGNATURE,SERVER_SOFTWARE,GATEWAY_INTERFACE,SERVER_PROTOCOL,REQUEST_METHOD,SCRIPT_NAME,PATH_TRANSLATED,HTTP_REFERER,PATH_INFO");
                while(list(,$k)=each($gE_keys)) {
                        $getEnvArray[$k] = getenv($k);
                }
                $this->message($headCode,"t3lib_div::getIndpEnv()",t3lib_div::view_array(t3lib_div::getIndpEnv("_ARRAY")));
                $this->message($headCode,"getenv()",t3lib_div::view_array($getEnvArray));
                $this->message($headCode,"_ENV",t3lib_div::view_array($_ENV));
                $this->message($headCode,"_SERVER",t3lib_div::view_array($_SERVER));
                $this->message($headCode,"_COOKIE",t3lib_div::view_array($_COOKIE));
                $this->message($headCode,"_GET",t3lib_div::view_array($_GET));

                ob_start();
                phpinfo();
                $contents = explode("<body>",ob_get_contents());
                ob_end_clean();
                $contents = explode("</body>",$contents[1]);

                $this->message($headCode,"phpinfo()",$contents[0]);



$this->headerStyle = '
<style type="text/css"><!--
a { text-decoration: none; }
a:hover { text-decoration: underline; }
h1 { font-family: verdana,arial, helvetica, sans-serif; font-size: 14pt; font-weight: bold;}
h2 { font-family: verdana,arial, helvetica, sans-serif; font-size: 12pt; font-weight: bold;}
body, td { font-family: verdana,arial, helvetica, sans-serif; font-size: 10pt; }
th { font-family: verdana,arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold; }
//--></style>
';

                echo $this->outputWrapper($this->printAll());
        }













        /*******************************
         *
         * typo3temp/ manager
         *
         *******************************/

        function typo3TempManager()     {
                $headCode = "typo3temp/ directory";
                $this->message($headCode,"What is it?","
                TYPO3 uses this directory for temporary files, mainly processed and cached images.
                The filenames are very cryptic; They are unique representations of the file properties made by md5-hashing a serialized array with information.
                Anyway this directory may contain many thousand files and a lot of them may be of no use anymore.

                With this test you can delete the files in this folder. When you do that, you should also clear the cache database tables afterwards.
                ");

                if (!$this->config_array["dir_typo3temp"])      {
                        $this->message("typo3temp/ directory","typo3temp/ not writable!","
                                You must make typo3temp/ write enabled before you can proceed with this test.
                        ",2);
                        echo $this->outputWrapper($this->printAll());
                        return;
                }

                        // Run through files
                $fileCounter = 0;
                $deleteCounter = 0;
                $criteriaMatch = 0;
                $tmap=array("day"=>1, "week"=>7, "month"=>30);
                $tt = $this->INSTALL["typo3temp_delete"];
                $subdir = $this->INSTALL["typo3temp_subdir