Hi Everyone
First I want to excuse if this task has already been discussed. I do not want
to produce overhead ;-)
I am working with PHP and MySQL all day long, and have to work with several
customer databases. Therefore I have every database in the config file.
Adding a new database is really inconvinient, and I simply hate the way it is
done. Not because it is not useful, but simply because I have to leave the
Browser window. After adding a 6th database this morning, I decided to do
something against it. Here is what I have done:
The Database configurations are being stored in a database table. In the
config.inc.php the $cfgServer entries have been removed, instead some
$cfgDBServer entries have been written, to select the database in use.
Adv_Auth entries can either be entered globally by setting
$cfgDBServer["adv_auth"]
or database specific by setting the corresponding database entry.
libraries/common.lib.php has been expanded by adding a short (starting
at about line 300 ) If clause which checks for $cfgDBServers being TRUE,
unsetting $cfgServer if this is the case, and reading the entries from the
Database table. Therefore existing configurations have to be proted to the
database, I guess you could uncomment the unset($cfgServers) statement
without any problems, this was simply not what I wanted it to do.
Localization in the error messages is not being done by now, the errors occur
in english.
I append the additions to common.lib.php and config.inc.php as diff against
the current Release Candidate ( 2.2.2-rc1 ) version. I do not know if it
works against CVS, but should do so without any problems. Keep me posted, if
it works and what you think of it.
CU Roland
Show replies by date