<?PHP
    if (!isset($config->auth_dbhost)) {
        $config->auth_dbhost = "localhost";
    }
    if (!isset($config->auth_dbtype)) {
        $config->auth_dbtype = "mysql";
    }
    if (!isset($config->auth_dbname)) {
        $config->auth_dbname = "";
    }
    if (!isset($config->auth_dbuser)) {
        $config->auth_dbuser = "";
    }
    if (!isset($config->auth_dbpass)) {
        $config->auth_dbpass = "";
    }
    if (!isset($config->auth_dbtable)) {
        $config->auth_dbtable = "";
    }
    if (!isset($config->auth_dbfielduser)) {
        $config->auth_dbfielduser = "";
    }
    if (!isset($config->auth_dbfieldpass)) {
        $config->auth_dbfieldpass = "";
    }
    if (!isset($config->auth_dbpasstype)) {
        $config->auth_dbpasstype = "plaintext";
    }
?>
<tr valign="top"  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbhost:</TD>
	<TD>
        <INPUT name=auth_dbhost TYPE=text SIZE=30 VALUE="<?php echo $config->auth_dbhost?>">
	<?php  if (isset($err["auth_dbhost"])) formerr($err["auth_dbhost"]); ?>
	</TD>
    <TD>
    <?php  print_string("auth_dbhost","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbtype:</TD>
	<TD>
    <?php  $dbtypes = array("access","ado_access", "ado", "ado_mssql", "borland_ibase", "csv", "db2", "fbsql", "firebird", "ibase", "informix72", "informix", "mssql", "mysql", "mysqlt", "oci805", "oci8", "oci8po", "odbc", "odbc_mssql", "odbc_oracle", "oracle", "postgres64", "postgres7", "postgres", "proxy", "sqlanywhere", "sybase", "vfp");
       foreach ($dbtypes as $dbtype) {
           $dboptions[$dbtype] = $dbtype;
       }
       choose_from_menu($dboptions, "auth_dbtype", $config->auth_dbtype, "");
    ?>
      
    </TD>
    <TD>
    <?php  print_string("auth_dbtype","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbname:</TD>
	<TD>
    <INPUT name=auth_dbname TYPE=text SIZE=30 VALUE="<?php echo $config->auth_dbname?>">
    <?php  if (isset($err["auth_dbname"]))formerr($err["auth_dbname"]); ?>
    </TD>
    <TD>
    <?php  print_string("auth_dbname","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbuser:</TD>
	<TD>
    <INPUT name=auth_dbuser TYPE=text SIZE=30 VALUE="<?php echo $config->auth_dbuser?>">
    <?php  if (isset($err["auth_dbuser"])) formerr($err["auth_dbuser"]); ?>
    </TD>
    <TD>
    <?php  print_string("auth_dbuser","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbpass:</TD>
	<TD>
    <INPUT name="auth_dbpass" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_dbpass?>">
    <?php  if (isset($err["auth_dbpass"])) formerr($err["auth_dbpass"]); ?>
    </TD>
    <TD>
    <?php  print_string("auth_dbpass","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbtable:</TD>
	<TD>
    <INPUT name="auth_dbtable" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_dbtable?>">
    <?php  if (isset($err["auth_dbtable"])) formerr($err["auth_dbtable"]); ?>
    </TD>
    <TD>
    <?php  print_string("auth_dbtable","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbfielduser:</TD>
	<TD>
    <INPUT name="auth_dbfielduser" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_dbfielduser?>">
    <?php  if (isset($err["auth_dbfielduser"])) formerr($err["auth_dbfielduser"]); ?>
    </TD>
    <TD>
    <?php  print_string("auth_dbfielduser","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbfieldpass:</TD>
	<TD>
    <INPUT name="auth_dbfieldpass" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_dbfieldpass?>">
    <?php  if (isset($err["auth_dbfieldpass"])) formerr($err["auth_dbfieldpass"]); ?>
    </TD>
    <TD>
    <?php  print_string("auth_dbfieldpass","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP  BGCOLOR="<?php echo $THEME->cellheading2 ?>">
	<TD ALIGN=RIGHT><P>auth_dbpasstype:</TD>
	<TD>
    <?php  $passtype["plaintext"] = get_string("plaintext", "auth");
       $passtype["md5"]       = get_string("md5", "auth");
       choose_from_menu($passtype, "auth_dbpasstype", $config->auth_dbpasstype, "");
    ?>
      
    </TD>
    <TD>
    <?php  print_string("auth_dbpasstype","auth") ?>
    </TD>
</TR>


<TR>
	<TD ALIGN=RIGHT><P><?php  print_string("firstname") ?>:</TD>
	<TD>
    <INPUT name="auth_user_firstname" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_firstname?>">
    </TD>
    <TD rowspan=12 VALIGN=CENTER>
    <?php  print_string("auth_dbextrafields","auth") ?>
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("lastname") ?>:</TD>
	<TD>
    <INPUT name="auth_user_lastname" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_lastname?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("email") ?>:</TD>
	<TD>
    <INPUT name="auth_user_email" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_email?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("phone") ?> 1:</TD>
	<TD>
    <INPUT name="auth_user_phone1" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_phone1?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("phone") ?> 2:</TD>
	<TD>
    <INPUT name="auth_user_phone2" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_phone2?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("department") ?>:</TD>
	<TD>
    <INPUT name="auth_user_department" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_department?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("address") ?>:</TD>
	<TD>
    <INPUT name="auth_user_address" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_address?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("city") ?>:</TD>
	<TD>
    <INPUT name="auth_user_city" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_city?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("country") ?>:</TD>
	<TD>
    <INPUT name="auth_user_country" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_country?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("description") ?>:</TD>
	<TD>
    <INPUT name="auth_user_description" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_description?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("idnumber") ?>:</TD>
	<TD>
    <INPUT name="auth_user_idnumber" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_idnumber?>">
    </TD>
</TR>

<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("language") ?>:</TD>
	<TD>
    <INPUT name="auth_user_lang" TYPE="text" SIZE="30" VALUE="<?php echo $config->auth_user_lang?>">
    </TD>
</TR>


<TR VALIGN=TOP>
	<TD ALIGN=RIGHT><P><?php  print_string("instructions", "auth") ?>:</TD>
	<TD>
    <TEXTAREA NAME=auth_instructions COLS=30 ROWS=10 WRAP=virtual><?php  p($config->auth_instructions) ?></TEXTAREA> 
    </TD>
    <TD>
    <?php  print_string("authinstructions","auth") ?>
    <?php  helpbutton("text", get_string("helptext")) ?>
    </TD>
</TR>
