Roundcube Community Forum

Recycle Bin => Recycle Bin => Topic started by: StErMi on January 31, 2007, 02:19:56 PM

Title: Some important questions ( password and the way to connect to DB )
Post by: StErMi on January 31, 2007, 02:19:56 PM
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?
Title: Re: Some important questions ( password and the way to connect to DB )
Post by: bugler on February 09, 2007, 04:18:14 AM
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:

// 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))