<link rel="stylesheet" href="styles/default/css/installation.css" />

<form action="index.php?module=installation&event=create_structure" method="post" name="setup_db">

    <table id="maintable">
        <tr>
            <td valign="top" class="mainleft">
                <ul>
                    <li><a href="index.php?module=installation">pre-installation check</a></li>
                    <li><a href="index.php?module=installation&event=db">Step 1</a></li>
                    <li><a href="index.php?module=installation&event=dbselect">Step 2</a></li>
                    <li class="active">Step 3</li>
                    <li>Step 4</li>
                    <li>Step 5</li>
                </ul>
            </td>
            <td valign="top" class="mainright">


                <table class="settings">
                    <tr>
                        <td colspan="2">
                            [% if !$update == 1 %]                    
                                <div style="float:right;">
                                    <a href="#" onclick="document.setup_db.submit();
                                            return false;" class="button">next &gt;</a><br />
                                </div>
                            [% /if %]                        
                            <h1>Step 3</h1>
                        </td>
                    </tr>
                    <tr>
                        <th colspan="2">Kind of installation :</th>
                    </tr>
                    <tr><td colspan="2" class="spacer"></td></tr>
                    <tr>
                        <td valign="top">
                            Confirm the kind of <b>HEINZELM<span style="color:red;">A</span>NN</b>
                            installation<br />
                            [% if $NewDB == '' %]
                                [% $NewDB %]
                                <p><strong>We recommend to backup your database before installing</strong> <b>HEINZELM<span style="color:red;">A</span>NN</b>.</p>
                                [% if $backup_possible == 1 %]
                                    <br />If you want to make a backup of your database or restore the database from a backupfile click here: <br />
                                    <b><a href="index.php?option=backup">Backup / Restore</a></b>
                                [% /if %]
                            [% /if %]
                        </td>
                        <td valign="top" class="boxed">
                            <table>
                                <tr>
                                    <th colspan="2">Installation-Mode:</th>
                                </tr>

                                <tr>

                                    <td colspan="2"><i>
                                            [% if $NewDB != '' %]
                                                The new database <b>[% $NewDB %]</b> was created. In the next step the tables for <b>HEINZELM<span style="color:red;">A</span>NN</b> will be inserted.
                                                <input type="hidden" name="mode" value="0" checked="checked" />
                                            [% else %]                                
                                                The choosen database <b>[% $database %]</b> contains
                                                [% if $hm_exists == 1 && $update != 1 %]
                                                    <b>HEINZELM<span style="color:red;">A</span>NN</b>  [% if $assetdesk %] and AssetDesk [% /if %] data. There will be an update.
                                                    <input type="hidden" name="mode" value="1" checked="checked" />
                                                [% /if %]
                                                [% if $hm_exists != 1 %]
                                                    no <b>HEINZELM<span style="color:red;">A</span>NN</b> [% if $assetdesk %] but AssetDesk [% /if %] data. The <b>HEINZELM<span style="color:red;">A</span>NN</b> tables will be inserted.
                                                    <input type="hidden" name="mode" value="0" checked="checked" />
                                                [% /if %]
                                                [% if $hm_exists == 1 && $update == 1 %]
                                                    a <b>HEINZELM<span style="color:red;">A</span>NN</b> database from version 1.x.<br />
                                                    Therefor are no automatic updates in this installation.
                                                    If you want to use <b>HEINZELM<span style="color:red;">A</span>NN</b> with this data, please call our support.
                                                [% /if %]

                                            [% /if %]

                                        </i></td>
                                </tr>

                                <tr><td colspan="3">&nbsp;</tr>

                                <tr><td colspan="2">&nbsp;</td></tr>
                                <tr>

                                    <td>Database Name:</td>
                                    <td>
                                        [% $database %]

                                    </td>
                                </tr>
                                <tr>

                                    <td>Database Type:</td>
                                    <td>
                                        [% if $phptype == "mssql" %]Microsoft SQL Server[% /if %]
                                        [% if $phptype == "odbc" %]Microsoft SQL Server (ODBC)[% /if %]
                                        [% if $phptype == "oci8" %]Oracle Server[% /if %]
                                    </td>
                                </tr>
                                <tr>
                                    <td>Host Name:</td>
                                    <td>[% $hostspec %]</td>
                                </tr>
                                <tr>
                                    <td>User Name:</td>
                                    <td>[% $username %]</td>
                                </tr>
                                <tr>
                                    <td>Password:</td>
                                    <td>[% $password|regex_replace:"/\S/":"*" %]</td>
                                </tr>
                                <tr>
                                    <td>Database Port (optional):</td>
                                    <td>[% $port %]</td>
                                </tr>                            
                            </table>

                        </td>
                    </tr>
                    <tr>
                        <td colspan="2">&nbsp;</td>
                    </tr>

                </table>

            </td>
        </tr>
    </table>

</form>