Changeset 6745 for branches

Show
Ignore:
Timestamp:
10/06/08 19:50:04 (2 months ago)
Author:
jmathis
Message:

bug #256

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • branches/centreon-2.0/www/include/configuration/configObject/servicegroup/listServiceGroup.php

    r6675 r6745  
    3535        } 
    3636 
    37         $SearchTool = 0; 
    38         if (isset($search) && $search) 
    39                 $SearchTool = "sg_id IN (".$lcaSGStr.")"; 
    40  
    4137        if (isset($search)){ 
    4238                if ($is_admin)           
    4339                        $DBRESULT = & $pearDB->query("SELECT COUNT(*) FROM servicegroup WHERE (sg_name LIKE '%".htmlentities($search, ENT_QUOTES)."%' OR sg_alias LIKE '%".htmlentities($search, ENT_QUOTES)."%')"); 
    4440                else 
    45                         $DBRESULT = & $pearDB->query("SELECT COUNT(*) FROM servicegroup WHERE (sg_name LIKE '%".htmlentities($search, ENT_QUOTES)."%' OR sg_alias LIKE '%".htmlentities($search, ENT_QUOTES)."%') AND sg_id IN (".$lcaServiceGroupStr.")"); 
     41                        $DBRESULT = & $pearDB->query("SELECT COUNT(*) FROM servicegroup WHERE (sg_name LIKE '%".htmlentities($search, ENT_QUOTES)."%' OR sg_alias LIKE '%".htmlentities($search, ENT_QUOTES)."%') AND sg_id IN (".$lcaSGStr.")"); 
    4642        } else { 
    4743                if ($is_admin)           
    4844                        $DBRESULT = & $pearDB->query("SELECT COUNT(*) FROM servicegroup"); 
    4945                else 
    50                         $DBRESULT = & $pearDB->query("SELECT COUNT(*) FROM servicegroup WHERE $SearchTool"); 
     46                        $DBRESULT = & $pearDB->query("SELECT COUNT(*) FROM servicegroup WHERE sg_id IN (".$lcaSGStr.")"); 
    5147        } 
    5248        if (PEAR::isError($DBRESULT))