if ($sort) {
# If phrase is only a contains search, add the % characters for the mysql query.
if ($phrasetype == "contains") { $contains = "%$contains%"; }
else { $contains = $contains; }
if ($field != "") {
if ($field == "ip") {
$aquery = "select distinct(networking_ports.ifaddr), networking_ports.device_on, computers.* from networking_ports, computers where networking_ports.ifaddr like '$contains' and networking_ports.device_on=computers.id";
} else { $fieldquery = "and ($field LIKE '$contains')"; }
}
if ($geo != "") { $geoquery = "and (geo LIKE '$geo')"; }
if ($location != '') { $locationquery = "and location like '$location'"; }
if ($owner != '') { $ownerquery = "and owner like '$owner'"; }
$andquery = "$fieldquery $geoquery $locationquery $ownerquery ORDER by $sort";
if ($field == "freetext") { $andquery="and name like '$contains' or domain like '$contains' or description like '$contains' or comments like '$contains' or a_notes like '$contains'"; }
if ($field == "contacts") { $andquery="and contact_a like '$contains' or maintenance like '$contains' or contact_c like '$contains' or contact_m like '$contains' or contact_d like '$contains' or contact_v like '$contains' or contact_i like '$contains' or contact_s like '$contains' or owner like '$contains'"; }
if($aquery) { $query=stripslashes($aquery); }
else { $query = "SELECT * FROM computers WHERE 1 $andquery"; }
?>
computerListView($query, $sort, $phrasetype); ?>
if($cfg_groups == 1) { ?> } else { ?> } ?> |