3 // set to defaults if undefined
4 if (!isset($config->host
)) {
5 $config->host
= 'localhost';
7 if (!isset($config->type
)) {
8 $config->type
= 'mysql';
10 if (!isset($config->sybasequoting
)) {
11 $config->sybasequoting
= 0;
13 if (!isset($config->name
)) {
16 if (!isset($config->user
)) {
19 if (!isset($config->pass
)) {
22 if (!isset($config->table
)) {
25 if (!isset($config->fielduser
)) {
26 $config->fielduser
= '';
28 if (!isset($config->fieldpass
)) {
29 $config->fieldpass
= '';
31 if (!isset($config->passtype
)) {
32 $config->passtype
= 'plaintext';
34 if (!isset($config->changepasswordurl
)) {
35 $config->changepasswordurl
= '';
37 if (empty($config->extencoding
)) {
38 $config->extencoding
= 'utf-8';
40 if (empty($config->debugauthdb
)) {
41 $config->debugauthdb
= 0;
43 if (!isset($config->setupsql
)) {
44 $config->setupsql
= '';
46 if (!isset($config->removeuser
)) {
47 $config->removeuser
= AUTH_REMOVEUSER_KEEP
;
50 $yesno = array( get_string('no'), get_string('yes') );
53 <table cellspacing=
"0" cellpadding=
"5" border=
"0">
55 <tr valign=
"top" class=
"required">
56 <td align=
"right"><label for=
"host"><?php print_string("auth_dbhost_key", "auth_db") ?></label></td>
58 <input id=
"host" name=
"host" type=
"text" size=
"30" value=
"<?php echo $config->host?>" />
61 if (isset($err["host"])) {
62 echo $OUTPUT->error_text($err["host"]);
67 <td><?php print_string("auth_dbhost", "auth_db") ?></td>
70 <tr valign=
"top" class=
"required">
71 <td align=
"right"><label for=
"menutype"><?php print_string("auth_dbtype_key", "auth_db") ?></label></td>
73 <?php $dbtypes = array("access","ado_access", "ado", "ado_mssql", "borland_ibase", "csv", "db2", "fbsql", "firebird", "ibase", "informix72", "informix", "mssql", "mssql_n", "mssqlnative", "mysql", "mysqli", "mysqlt", "oci805", "oci8", "oci8po", "odbc", "odbc_mssql", "odbc_oracle", "oracle", "postgres64", "postgres7", "postgres", "proxy", "sqlanywhere", "sybase", "vfp");
74 foreach ($dbtypes as $dbtype) {
75 $dboptions[$dbtype] = $dbtype;
77 echo html_writer
::select($dboptions, "type", $config->type
, false);
82 <?php print_string("auth_dbtype","auth_db") ?>
86 <tr valign=
"top" class=
"required">
87 <td align=
"right"><label for=
"menusybasequoting"><?php print_string("auth_dbsybasequoting", "auth_db") ?></label></td>
89 <?php echo html_writer
::select($yesno, 'sybasequoting', $config->sybasequoting
, false); ?>
91 <td><?php print_string("auth_dbsybasequotinghelp", "auth_db") ?></td>
94 <tr valign=
"top" class=
"required">
95 <td align=
"right"><label for=
"name"><?php print_string("auth_dbname_key", "auth_db") ?></label></td>
97 <input id=
"name" name=
"name" type=
"text" size=
"30" value=
"<?php echo $config->name?>" />
100 if (isset($err["name"])) {
101 echo $OUTPUT->error_text($err["name"]);
106 <td><?php print_string("auth_dbname", "auth_db") ?></td>
109 <tr valign=
"top" class=
"required">
110 <td align=
"right"><label for=
"user"><?php print_string("auth_dbuser_key", "auth_db") ?></label></td>
112 <input id=
"user" name=
"user" type=
"text" size=
"30" value=
"<?php echo $config->user?>" />
115 if (isset($err["user"])) {
116 echo $OUTPUT->error_text($err["user"]);
121 <td><?php print_string("auth_dbuser", "auth_db") ?></td>
124 <tr valign=
"top" class=
"required">
125 <td align=
"right"><label for=
"pass"><?php print_string("auth_dbpass_key", "auth_db") ?></label></td>
127 <input id=
"pass" name=
"pass" type=
"password" size=
"30" value=
"<?php p($config->pass)?>" autocomplete
="off"/>
130 if (isset($err["pass"])) {
131 echo $OUTPUT->error_text($err["pass"]);
137 <?php print_string("auth_dbpass", "auth_db") ?>
141 <tr valign=
"top" class=
"required">
142 <td align=
"right"><label for=
"table"><?php print_string("auth_dbtable_key", "auth_db") ?></label></td>
144 <input id=
"table" name=
"table" type=
"text" size=
"30" value=
"<?php echo $config->table?>" />
147 if (isset($err["table"])) {
148 echo $OUTPUT->error_text($err["table"]);
153 <td><?php print_string("auth_dbtable", "auth_db") ?></td>
156 <tr valign=
"top" class=
"required">
157 <td align=
"right"><label for=
"fielduser"><?php print_string("auth_dbfielduser_key", "auth_db") ?></label></td>
159 <input id=
"fielduser" name=
"fielduser" type=
"text" size=
"30" value=
"<?php echo $config->fielduser?>" />
162 if (isset($err["fielduser"])) {
163 echo $OUTPUT->error_text($err["fielduser"]);
168 <td><?php print_string("auth_dbfielduser", "auth_db") ?></td>
171 <tr valign=
"top" class=
"required">
172 <td align=
"right"><label for=
"fieldpass"><?php print_string("auth_dbfieldpass_key", "auth_db") ?></label></td>
174 <input id=
"fieldpass" name=
"fieldpass" type=
"text" size=
"30" value=
"<?php echo $config->fieldpass?>" />
177 if (isset($err["fieldpass"])) {
178 echo $OUTPUT->error_text($err["fieldpass"]);
183 <td><?php print_string("auth_dbfieldpass", "auth_db") ?></td>
186 <tr valign=
"top" class=
"required">
187 <td align=
"right"><label for=
"menupasstype"><?php print_string("auth_dbpasstype_key", "auth_db") ?></label></td>
191 $passtype["plaintext"] = get_string("plaintext", "auth");
192 $passtype["md5"] = get_string("md5", "auth");
193 $passtype["sha1"] = get_string("sha1", "auth");
194 $passtype["saltedcrypt"] = get_string("auth_dbsaltedcrypt", "auth_db");
195 $passtype["internal"] = get_string("internal", "auth");
196 echo html_writer
::select($passtype, "passtype", $config->passtype
, false);
200 <td><?php print_string("auth_dbpasstype", "auth_db") ?></td>
203 <tr valign=
"top" class=
"required">
204 <td align=
"right"><label for=
"extencoding"><?php print_string("auth_dbextencoding", "auth_db") ?></label></td>
206 <input id=
"extencoding" name=
"extencoding" type=
"text" value=
"<?php echo $config->extencoding ?>" />
209 if (isset($err['extencoding'])) {
210 echo $OUTPUT->error_text($err['extencoding']);
215 <td><?php print_string('auth_dbextencodinghelp', 'auth_db') ?></td>
219 <td align=
"right"><label for=
"setupsql"><?php print_string("auth_dbsetupsql", "auth_db") ?></label></td>
221 <input id=
"setupsql" name=
"setupsql" type=
"text" value=
"<?php echo $config->setupsql ?>" />
223 <td
><?php
print_string('auth_dbsetupsqlhelp', 'auth_db') ?></td>
227 <td align=
"right"><label for=
"menudebugauthdb"><?php print_string("auth_dbdebugauthdb", "auth_db") ?></label></td>
229 <?php echo html_writer
::select($yesno, 'debugauthdb', $config->debugauthdb
, false); ?>
231 <td><?php print_string("auth_dbdebugauthdbhelp", "auth_db") ?></td>
235 <td align=
"right"><label for=
"changepasswordurl"><?php print_string("auth_dbchangepasswordurl_key", "auth_db") ?></label></td>
237 <input id=
"changepasswordurl" name=
"changepasswordurl" type=
"text" value=
"<?php echo $config->changepasswordurl ?>" />
240 if (isset($err['changepasswordurl'])) {
241 echo $OUTPUT->error_text($err['changepasswordurl']);
246 <td><?php print_string('changepasswordhelp', 'auth') ?></td>
251 <h4><?php print_string('auth_sync_script', 'auth') ?> </h4>
256 <td align=
"right"><label for=
"menuremoveuser"><?php print_string('auth_remove_user_key','auth') ?></label></td>
259 $deleteopt = array();
260 $deleteopt[AUTH_REMOVEUSER_KEEP
] = get_string('auth_remove_keep','auth');
261 $deleteopt[AUTH_REMOVEUSER_SUSPEND
] = get_string('auth_remove_suspend','auth');
262 $deleteopt[AUTH_REMOVEUSER_FULLDELETE
] = get_string('auth_remove_delete','auth');
263 echo html_writer
::select($deleteopt, 'removeuser', $config->removeuser
, false);
267 <?php print_string('auth_remove_user','auth') ?>
273 print_auth_lock_options($this->authtype
, $user_fields, get_string('auth_dbextrafields', 'auth_db'), true, true, $this->get_custom_user_profile_fields());