More robustness, and some little bug fixes.
[moodle.git] / 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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
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>