| | |
| | | |
| | | |
| | | // get user record |
| | | $sql_result = $DB->query(sprintf("SELECT username, mail_host FROM %s |
| | | WHERE user_id=%d", |
| | | get_table_name('users'), |
| | | $_SESSION['user_id'])); |
| | | $sql_result = $DB->query("SELECT username, mail_host FROM ".get_table_name('users')." |
| | | WHERE user_id=?", |
| | | $_SESSION['user_id']); |
| | | |
| | | if ($USER_DATA = $DB->fetch_assoc($sql_result)) |
| | | $PAGE_TITLE = sprintf('%s %s@%s', rcube_label('settingsfor'), $USER_DATA['username'], $USER_DATA['mail_host']); |
| | |
| | | { |
| | | global $DB, $CONFIG, $sess_user_lang; |
| | | |
| | | // add some labels to client |
| | | rcube_add_label('nopagesizewarning'); |
| | | |
| | | list($form_start, $form_end) = get_form_tags($attrib, 'save-prefs'); |
| | | unset($attrib['form']); |
| | | |
| | |
| | | 'prettydate' => array('type' => 'text')); |
| | | |
| | | // show language selection |
| | | $a_lang = rcube_list_languages(); |
| | | asort($a_lang); |
| | | |
| | | $field_id = 'rcmfd_lang'; |
| | | $select_lang = new select(array('name' => '_language', 'id' => $field_id)); |
| | | $select_lang->add('Dansk', 'da'); |
| | | $select_lang->add('Deutsch', 'de'); |
| | | $select_lang->add('English', 'en'); |
| | | $select_lang->add('Espanol', 'es'); |
| | | $select_lang->add('Français', 'fr'); |
| | | $select_lang->add('Italiano', 'it'); |
| | | $select_lang->add('Nederlands', 'nl'); |
| | | $select_lang->add(array_values($a_lang), array_keys($a_lang)); |
| | | |
| | | |
| | | $out .= sprintf("<tr><td class=\"title\"><label for=\"%s\">%s</label></td><td>%s</td></tr>\n", |
| | | $field_id, |
| | |
| | | $select_timezone->add('(GMT +1:00) Central European Time', '1'); |
| | | $select_timezone->add('(GMT +2:00) EET: Kaliningrad, South Africa', '2'); |
| | | $select_timezone->add('(GMT +3:00) Baghdad, Kuwait, Riyadh, Moscow, Nairobi', '3'); |
| | | $select_timezone->add('(GMT +3:30) Tehran', '3.5'); |
| | | $select_timezone->add('(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi', '4'); |
| | | $select_timezone->add('(GMT +4:30) Kabul', '4.5'); |
| | | $select_timezone->add('(GMT +5:00) Ekaterinburg, Islamabad, Karachi', '5'); |
| | | $select_timezone->add('(GMT +5:30) Chennai, Kolkata, Mumbai, New Delhi', '5.5'); |
| | | $select_timezone->add('(GMT +5:45) Kathmandu', '5.75'); |
| | | $select_timezone->add('(GMT +6:00) Almaty, Dhaka, Colombo', '6'); |
| | | $select_timezone->add('(GMT +7:00) Bangkok, Hanoi, Jakarta', '7'); |
| | | $select_timezone->add('(GMT +8:00) Beijing, Perth, Singapore, Taipei', '8'); |
| | | $select_timezone->add('(GMT +9:00) Tokyo, Seoul, Yakutsk', '9'); |
| | | $select_timezone->add('(GMT +9:30) Adelaide, Darwin', '9.5'); |
| | | $select_timezone->add('(GMT +10:00) EAST/AEST: Guam, Vladivostok', '10'); |
| | | $select_timezone->add('(GMT +11:00) Magadan, Solomon Islands', '11'); |
| | | $select_timezone->add('(GMT +12:00) Auckland, Wellington, Kamchatka', '12'); |
| | |
| | | |
| | | |
| | | // get contacts from DB |
| | | $sql_result = $DB->query(sprintf("SELECT * FROM %s |
| | | WHERE del!='1' |
| | | AND user_id=%d |
| | | ORDER BY `default` DESC, name ASC", |
| | | get_table_name('identities'), |
| | | $_SESSION['user_id'])); |
| | | $sql_result = $DB->query("SELECT * FROM ".get_table_name('identities')." |
| | | WHERE del<>1 |
| | | AND user_id=? |
| | | ORDER BY standard DESC, name ASC", |
| | | $_SESSION['user_id']); |
| | | |
| | | |
| | | // add id to message list table if not specified |