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

<form action="index.php?module=installation&event=db&task=store" 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 class="active">Step 1</li>
                <li>Step 2</li>
                <li>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">
                        <div style="float:right;">
                            <a href="#" onclick="document.setup_db.submit();return false;location.reload(true);" class="button">next &gt;</a><br />
                        </div>
                        <h1>Step 1</h1>
                    </td>
                </tr>
                <tr>
                    <th colspan="2">Database configuration:</th>
                </tr>
                <tr><td colspan="2" class="spacer"></td></tr>
                <tr>
                    <td valign="top">
Setting up <b>HEINZELM<span style="color:red;">A</span>NN</b> to run on your
server involves 5 simple steps...<br /><br />

Please enter the hostname of the
server <b>HEINZELM<span style="color:red;">A</span>NN</b> is to be installed on.<br /><br />

Enter the username and password
you wish to use with <b>HEINZELM<span style="color:red;">A</span>NN</b>.<br /><br />

Optionally enter the port of 
database server.<br />
                    </td>
                    <td valign="top" class="boxed">
                        <table>
                            [% if $connection_failed %]
                                <tr>
                                    <td colspan="2">
                                        <b>Connection failed</b><br /><br />
                                        <span class="error">[% $error %]</span>
                                    </td>
                                </tr>
                            [% /if %]
                            <tr>
                                <td colspan="2">
                                    <label for="phptype">Database Type</label>
                                    <select size="1" name="phptype" onChange="location.href='index.php?option=db&phptype='+this.value;">
                                        [% if $mssql %]<option value="mssql" [% if $phptype == "mssql" %]selected="selected"[% /if %]>Microsoft SQL Server</option>[% /if %]
                                        [% if $sqlsrv %]<option value="sqlsrv" [% if $phptype == "sqlsrv" %]selected="selected"[% /if %]>Microsoft SQL Server (sqlsrv)</option>[% /if %]
                                        [% if $oracle %]<option value="oci8" [% if $phptype == "oci8" %]selected="selected"[% /if %]>Oracle Server</option>[% /if %]
                                    </select>
                                </td>
                              
                            </tr>
                            <tr>
                                <td>
                                    <label for="hostspec">Host Name</label>
                                    <input type="text" name="hostspec" value="[% $hostspec %]" class="textbox" />
                                </td>
                                <td><i>This is usually 'localhost'</i></td>
                            </tr>
                            <tr>
                                <td>
                                    <label for="username">[% if $phptype == "oci8" %]Servicename [% else %]User Name [% /if %]</label>
                                    <input type="text" name="username" value="[% $username %]" class="textbox" />
                                </td>
                                <td><i>Ether something as 'sa' or a<br /> username given by hoster</i></td>
                            </tr>
                            <tr>
                                <td>
                                    <label for="password">Password</label>
                                    <input type="password" name="password" value="[% $password %]" class="textbox" />
                                </td>
                                <td><i>For site security using a password for<br />the sql account is mandatory</i></td>
                            </tr>
                            <tr>
                                <td>
                                    <label for="port">Database Port (optional)</label>
                                    <input type="text" name="port" value="[% $port %]" class="textbox" />
                                </td>
                                <td></td>
                            </tr>
                        </table>

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

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

</form>