From be2380fb47b05a222ec5b22deff36d5156a8c943 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Fri, 13 Jan 2006 13:08:41 -0500 Subject: [PATCH] Added labels for LDAP search --- program/steps/settings/func.inc | 38 +++++++++++++++++++++----------------- 1 files changed, 21 insertions(+), 17 deletions(-) diff --git a/program/steps/settings/func.inc b/program/steps/settings/func.inc index a7571e0..ccc7871 100644 --- a/program/steps/settings/func.inc +++ b/program/steps/settings/func.inc @@ -21,10 +21,9 @@ // 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']); @@ -35,6 +34,9 @@ { 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']); @@ -50,15 +52,13 @@ '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, @@ -84,12 +84,17 @@ $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'); @@ -145,12 +150,11 @@ // 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 -- Gitblit v1.9.1