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&ccedil;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