Changeset 5842

Timestamp:

03/28/12 14:31:33 (12 years ago)

Author:

thiago

Message:

Ticket #1959 - Limitando o maximo de resultados sem parametro

File:

• trunk/services/class.db.php (modified) (2 diffs)

trunk/services/class.db.php

@@ -70 +70 @@
     function search_contacts($search_for)
     { 
+
         $result = array();
         $query = 'select'
@@ -107 +108 @@
                                                 . ' left join phpgw_cc_state on ( phpgw_cc_addresses.id_state = phpgw_cc_state.id_state)'
                                                 ;
-
+                        
                                 $query .= ' where '
                                         . 'A.id_owner=' . $_SESSION['phpgw_info']['expressomail']['user']['account_id']
                                         . ' and lower(translate(names_ordered, \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))'
-                                                                                . ' LIKE lower(translate(\'%' . $search_for . '%\', \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))';                    
-                                
+                                                                                . ' LIKE lower(translate(\'%' . $search_for . '%\', \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))';  
+                                
+                //Se não existir parametro na busca, limita os usuarios no resultado da pesquisa.
+                                if(!$search_for){
+                                        $query .= 'LIMIT 11';        
+                                }
+                                
         if (!$this->db->query($query))
              return null;