auth/db/config.html

   1 <?PHP
   2     if (!isset($config->auth_dbhost)) {
   3         $config->auth_dbhost = "localhost";
   4     }
   5     if (!isset($config->auth_dbtype)) {
   6         $config->auth_dbtype = "mysql";
   7     }
   8     if (!isset($config->auth_dbname)) {
   9         $config->auth_dbname = "";
  10     }
  11     if (!isset($config->auth_dbuser)) {
  12         $config->auth_dbuser = "";
  13     }
  14     if (!isset($config->auth_dbpass)) {
  15         $config->auth_dbpass = "";
  16     }
  17     if (!isset($config->auth_dbtable)) {
  18         $config->auth_dbtable = "";
  19     }
  20     if (!isset($config->auth_dbfielduser)) {
  21         $config->auth_dbfielduser = "";
  22     }
  23     if (!isset($config->auth_dbfieldpass)) {
  24         $config->auth_dbfieldpass = "";
  25     }
  26     if (!isset($config->auth_dbpasstype)) {
  27         $config->auth_dbpasstype = "plaintext";
  28     }
  29 ?>
  30 <tr valign="top"  BGCOLOR="<?=$THEME->cellheading2 ?>">
  31         <TD ALIGN=RIGHT><P>auth_dbhost:</TD>
  32         <TD>
  33         <INPUT name=auth_dbhost TYPE=text SIZE=30 VALUE="<?=$config->auth_dbhost?>">
  34         <? if (isset($err["auth_dbhost"])) formerr($err["auth_dbhost"]); ?>
  35         </TD>
  36     <TD>
  37     <? print_string("auth_dbhost","auth") ?>
  38     </TD>
  39 </TR>
  40
  41 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
  42         <TD ALIGN=RIGHT><P>auth_dbtype:</TD>
  43         <TD>
  44     <? $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");
  45        foreach ($dbtypes as $dbtype) {
  46            $dboptions[$dbtype] = $dbtype;
  47        }
  48        choose_from_menu($dboptions, "auth_dbtype", $config->auth_dbtype, "");
  49     ?>
  50
  51     </TD>
  52     <TD>
  53     <? print_string("auth_dbtype","auth") ?>
  54     </TD>
  55 </TR>
  56
  57 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
  58         <TD ALIGN=RIGHT><P>auth_dbname:</TD>
  59         <TD>
  60     <INPUT name=auth_dbname TYPE=text SIZE=30 VALUE="<?=$config->auth_dbname?>">
  61     <? if (isset($err["auth_dbname"]))formerr($err["auth_dbname"]); ?>
  62     </TD>
  63     <TD>
  64     <? print_string("auth_dbname","auth") ?>
  65     </TD>
  66 </TR>
  67
  68 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
  69         <TD ALIGN=RIGHT><P>auth_dbuser:</TD>
  70         <TD>
  71     <INPUT name=auth_dbuser TYPE=text SIZE=30 VALUE="<?=$config->auth_dbuser?>">
  72     <? if (isset($err["auth_dbuser"])) formerr($err["auth_dbuser"]); ?>
  73     </TD>
  74     <TD>
  75     <? print_string("auth_dbuser","auth") ?>
  76     </TD>
  77 </TR>
  78
  79 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
  80         <TD ALIGN=RIGHT><P>auth_dbpass:</TD>
  81         <TD>
  82     <INPUT name="auth_dbpass" TYPE="text" SIZE="30" VALUE="<?=$config->auth_dbpass?>">
  83     <? if (isset($err["auth_dbpass"])) formerr($err["auth_dbpass"]); ?>
  84     </TD>
  85     <TD>
  86     <? print_string("auth_dbpass","auth") ?>
  87     </TD>
  88 </TR>
  89
  90 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
  91         <TD ALIGN=RIGHT><P>auth_dbtable:</TD>
  92         <TD>
  93     <INPUT name="auth_dbtable" TYPE="text" SIZE="30" VALUE="<?=$config->auth_dbtable?>">
  94     <? if (isset($err["auth_dbtable"])) formerr($err["auth_dbtable"]); ?>
  95     </TD>
  96     <TD>
  97     <? print_string("auth_dbtable","auth") ?>
  98     </TD>
  99 </TR>
 100
 101 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
 102         <TD ALIGN=RIGHT><P>auth_dbfielduser:</TD>
 103         <TD>
 104     <INPUT name="auth_dbfielduser" TYPE="text" SIZE="30" VALUE="<?=$config->auth_dbfielduser?>">
 105     <? if (isset($err["auth_dbfielduser"])) formerr($err["auth_dbfielduser"]); ?>
 106     </TD>
 107     <TD>
 108     <? print_string("auth_dbfielduser","auth") ?>
 109     </TD>
 110 </TR>
 111
 112 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
 113         <TD ALIGN=RIGHT><P>auth_dbfieldpass:</TD>
 114         <TD>
 115     <INPUT name="auth_dbfieldpass" TYPE="text" SIZE="30" VALUE="<?=$config->auth_dbfieldpass?>">
 116     <? if (isset($err["auth_dbfieldpass"])) formerr($err["auth_dbfieldpass"]); ?>
 117     </TD>
 118     <TD>
 119     <? print_string("auth_dbfieldpass","auth") ?>
 120     </TD>
 121 </TR>
 122
 123 <TR VALIGN=TOP  BGCOLOR="<?=$THEME->cellheading2 ?>">
 124         <TD ALIGN=RIGHT><P>auth_dbpasstype:</TD>
 125         <TD>
 126     <? $passtype["plaintext"] = get_string("plaintext", "auth");
 127        $passtype["md5"]       = get_string("md5", "auth");
 128        choose_from_menu($passtype, "auth_dbpasstype", $config->auth_dbpasstype, "");
 129     ?>
 130
 131     </TD>
 132     <TD>
 133     <? print_string("auth_dbpasstype","auth") ?>
 134     </TD>
 135 </TR>
 136
 137
 138 <TR>
 139         <TD ALIGN=RIGHT><P><? print_string("firstname") ?>:</TD>
 140         <TD>
 141     <INPUT name="auth_user_firstname" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_firstname?>">
 142     </TD>
 143     <TD rowspan=12 VALIGN=CENTER>
 144     <? print_string("auth_dbextrafields","auth") ?>
 145     </TD>
 146 </TR>
 147
 148 <TR VALIGN=TOP>
 149         <TD ALIGN=RIGHT><P><? print_string("lastname") ?>:</TD>
 150         <TD>
 151     <INPUT name="auth_user_lastname" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_lastname?>">
 152     </TD>
 153 </TR>
 154
 155 <TR VALIGN=TOP>
 156         <TD ALIGN=RIGHT><P><? print_string("email") ?>:</TD>
 157         <TD>
 158     <INPUT name="auth_user_email" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_email?>">
 159     </TD>
 160 </TR>
 161
 162 <TR VALIGN=TOP>
 163         <TD ALIGN=RIGHT><P><? print_string("phone") ?> 1:</TD>
 164         <TD>
 165     <INPUT name="auth_user_phone1" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_phone1?>">
 166     </TD>
 167 </TR>
 168
 169 <TR VALIGN=TOP>
 170         <TD ALIGN=RIGHT><P><? print_string("phone") ?> 2:</TD>
 171         <TD>
 172     <INPUT name="auth_user_phone2" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_phone2?>">
 173     </TD>
 174 </TR>
 175
 176 <TR VALIGN=TOP>
 177         <TD ALIGN=RIGHT><P><? print_string("department") ?>:</TD>
 178         <TD>
 179     <INPUT name="auth_user_department" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_department?>">
 180     </TD>
 181 </TR>
 182
 183 <TR VALIGN=TOP>
 184         <TD ALIGN=RIGHT><P><? print_string("address") ?>:</TD>
 185         <TD>
 186     <INPUT name="auth_user_address" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_address?>">
 187     </TD>
 188 </TR>
 189
 190 <TR VALIGN=TOP>
 191         <TD ALIGN=RIGHT><P><? print_string("city") ?>:</TD>
 192         <TD>
 193     <INPUT name="auth_user_city" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_city?>">
 194     </TD>
 195 </TR>
 196
 197 <TR VALIGN=TOP>
 198         <TD ALIGN=RIGHT><P><? print_string("country") ?>:</TD>
 199         <TD>
 200     <INPUT name="auth_user_country" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_country?>">
 201     </TD>
 202 </TR>
 203
 204 <TR VALIGN=TOP>
 205         <TD ALIGN=RIGHT><P><? print_string("description") ?>:</TD>
 206         <TD>
 207     <INPUT name="auth_user_description" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_description?>">
 208     </TD>
 209 </TR>
 210
 211 <TR VALIGN=TOP>
 212         <TD ALIGN=RIGHT><P><? print_string("idnumber") ?>:</TD>
 213         <TD>
 214     <INPUT name="auth_user_idnumber" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_idnumber?>">
 215     </TD>
 216 </TR>
 217
 218 <TR VALIGN=TOP>
 219         <TD ALIGN=RIGHT><P><? print_string("language") ?>:</TD>
 220         <TD>
 221     <INPUT name="auth_user_lang" TYPE="text" SIZE="30" VALUE="<?=$config->auth_user_lang?>">
 222     </TD>
 223 </TR>
 224
 225
 226 <TR VALIGN=TOP>
 227         <TD ALIGN=RIGHT><P><? print_string("instructions", "auth") ?>:</TD>
 228         <TD>
 229     <TEXTAREA NAME=auth_instructions COLS=30 ROWS=10 WRAP=virtual><? p($config->auth_instructions) ?></TEXTAREA>
 230     </TD>
 231     <TD>
 232     <? print_string("authinstructions","auth") ?>
 233     <? helpbutton("text", get_string("helptext")) ?>
 234     </TD>
 235 </TR>