Hi , after a couple of days working on my issue, I did implement a solution which basically do what I want: Replace the configuration of the RC main.inc.php file, with configuration from a database.
This is what I did:
In main.inc.php I added this entries
//Start Database Configurations
// table containing the users configs, leave blank ('') if will not used
$rcmail_config['db_config']['table_name'] = 'my_users';
//The $rcmail_config['db_config']['field'] entries are database field names, where
//the config value needed is extracted for a config option
//Fields For User Identities, NOT MAIL IDENTITIES
//else, user credentials: email or username, mail password, user email host
//all this data can be sent from the login page or
//from an ajax post to the login page: http://<RC_HOME>/?_task=mail&_action=login
$rcmail_config['db_config']['field']['email'] = 'email';
$rcmail_config['db_config']['field']['username'] = 'email_username';
$rcmail_config['db_config']['field']['password'] = 'email_password';
// field containing default server value
$rcmail_config['db_config']['field']['default_host'] = 'email_server';
// field containing default server port value
$rcmail_config['db_config']['field']['default_port'] = 'email_server_port';
// field containing a integer value standing if ssl is used
// 1: ssl is used
// 0: ssl is not used
// this is not a config option of RC, but used in implemented solution
// to costruct the URL of the "default_host"
$rcmail_config['db_config']['field']['ssl_support'] = 'email_is_ssl';
// field containing ssl server port value
// this is not a config option of RC, but used in implemented solution
// to costruct the URL of the "default_host"
$rcmail_config['db_config']['field']['ssl_port'] = 'email_ssl_port';
// field containing smtp server value
$rcmail_config['db_config']['field']['smtp_server'] = 'email_server_smtp';
// field containing smtp server port value
$rcmail_config['db_config']['field']['smtp_port'] = 'email_server_smtp_port';
// field containing smtp server port value
// this is not a config option of RC, but used in implemented solution
// to costruct the URL of the "smtp_server"
$rcmail_config['db_config']['field']['smtp_ssl_support'] = 'email_is_ssl_smtp';
// field containing smtp server port value
$rcmail_config['db_config']['field']['smtp_user'] = 'email_server_smtp_user';
// field containing smtp server port value
$rcmail_config['db_config']['field']['smtp_pass'] = 'email_server_smtp_pass';
//End of Database Configurations
These are the config option used by the function I create in the file: /program/include/rcmail.php, here is the function:
/**
* Replace Config object with settings extracted from table :
* $rcmail_config['db_config']['table_name'], all parameters
* must be set.
*
* @param string Email Username/User Email
* @param string User Password
* @param string Imap server or default host
*/
public function replace_settings_from_db($username, $pass, $host)
{
$config_all = $this->config->all();
//if not set the value, do nothing
if ($config_all['db_config']['table_name'] == '')
return;
else
{
//Constructing the select part of query selecting all field from db
$select = "SELECT ";
$select .= implode(",", $config_all['db_config']['field']);
$select .= " FROM ".$config_all['db_config']['table_name'];
$where = sprintf(" WHERE ( %s = '%s' OR %s = '%s' ) AND %s = '%s' ",
$config_all['db_config']['field']['email'], $username,
$config_all['db_config']['field']['username'], $username,
$config_all['db_config']['field']['password'], $pass
);
$query = $select.$where;
$sql_result = $this->db->query($query);
if ($sql_arr = $this->db->fetch_assoc($sql_result))
{
$ssl=
$config_all['db_config']['field']['ssl_support'];
$smtp_ssl=
$config_all['db_config']['field']['smtp_ssl_support'];
$ssl_port =
$config_all['db_config']['field']['ssl_port'];
$server =
$config_all['db_config']['field']['default_host'];
$smtp_server =
$config_all['db_config']['field']['smtp_server'];
if( $sql_arr["$ssl"] == 1 )
$config_all['default_host'] =
"ssl://".$sql_arr["$server"].":".$sql_arr["$ssl_port"];
else
$config_all['default_host'] = $sql_arr["$server"];
if( $sql_arr["$smtp_ssl"] == 1 )
$config_all['smtp_server'] =
"ssl://".$sql_arr["$smtp_server"];
else
$config_all['smtp_server'] = $sql_arr["$smtp_server"];
foreach($config_all['db_config']['field'] as $name => $value)
{
if( !($name == "default_host" || $name == "smtp_server") )
//not overwrite the already set default host and smtp server
$config_all["$name"] = $sql_arr["$value"];
}
}
//overwrite the old config
$this->config->merge($config_all);
//I made a raise_error here with an string representation of the $this->config array as message and everything was fine, all values were ok, at least as I espect it.
return;
}
}
And this function is called from the login function in the same file, before doing anything in it:
function login($username, $pass, $host=NULL)
{
//Extract setting from DB and overwrite
$this->replace_settings_from_db($username, $pass, $host);
$host = NULL;
$user = NULL;
$config = $this->config->all();
if (!$host)
$host = $config['default_host'];
.
.
.
Well, untill here that's all, but I'm facing problem, fundamentally when sending mails (I could be able to conect to my gmail account, read but not send). I also can read message from my mail server and notice something; I couldn't be able to send messages untill I fill the smtp_server option (I leaved it blank,beacuse I was setting it from DB ) , tha's why I think the config are replace in some other place.
Please can somebody tell me if I'm doing things wrong ?
Are these settings overwritten with the ones in the main.inc.php file in a later context ?
Any help will be great since I'm really stuck.
have no more Ideas
Greeting David.
