Some important questions ( password and the way to connect to DB )

[StErMi]

Hello to all!
I can't find the password's field in the DB. Where is it?

Another question: can you say me which is the funcions that allow you to do query to mysql server?

[bugler]

Hi,

the password is not in roundcube db. It is in your imap server and roundcube can not change it or read it.

In main.inc you have plenty of samples of database access like:

Code Select Expand

// query if user already registered
 $sql_result = $DB->query("SELECT user_id, username, language, preferences
              FROM ".get_table_name('users')."
              WHERE mail_host=? AND (username=? OR alias=?)",
              $host,
              $user,
              $user);

 // user already registered -> overwrite username
 if ($sql_arr = $DB->fetch_assoc($sql_result))