$val) { if ($val) { $device= get_record($db_link,"devices","id='$val'"); if (!empty($device)) { unbind_ports($db_link, $val); run_sql($db_link, 'DELETE FROM connections WHERE device_id='.$val); run_sql($db_link, 'DELETE FROM device_l3_interfaces WHERE device_id='.$val); run_sql($db_link, 'DELETE FROM device_ports WHERE device_id='.$val); delete_record($db_link, "devices", "id=".$val); LOG_WARNING($db_link,"Removed device ".$device['device_name']." id: ".$val); } } } header("Location: " . $_SERVER["REQUEST_URI"]); exit; } $unknown=1; if (!isset($_POST['f_unknown']) and isset($_POST['OK'])) { $unknown=0; } if (isset($_POST['f_unknown'])) { $unknown=$_POST['f_unknown']*1; } $unknown_checked=''; if ($unknown) { $unknown_checked='checked="checked"'; } $sort_table = 'A'; if ($sort_field == 'login') { $sort_table = 'L'; } if ($sort_field == 'fio') { $sort_table = 'L'; } if ($sort_field == 'model_name') { $sort_table = 'M'; } $sort_url = "
: 2"); ?>
>
1 '; } else { if (!empty($f_vendor_select) and $f_vendor_select>=1) { $u_filter = " AND V.id=".$f_vendor_select." "; } } $countSQL="SELECT Count(*) FROM User_auth A, User_list L, devices D, device_models M, vendors V. WHERE D.user_id=L.id AND A.ip = D.ip AND D.device_model_id=M.id AND M.vendor_id=V.id AND A.deleted =0 $u_filter $ip_list_filter $d_filter"; $res = mysqli_query($db_link, $countSQL); $count_records = mysqli_fetch_array($res); $total=ceil($count_records[0]/$displayed); if ($page>$total) { $page=$total; } if ($page<1) { $page=1; } $start = ($page * $displayed) - $displayed; print_navigation($page_url,$page,$displayed,$count_records[0],$total); ?>
\n"; $cl = "data"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } print "
" . WEB_cell_login . ""; ?> " . WEB_cell_ip . ""; ?> " . WEB_cell_mac . ""; ?> ".WEB_cell_host_model; ?> ".WEB_cell_last_found.""; ?>
" . $user['login'] . "" . $user['ip'] . "" . expand_mac($db_link,$user['mac']) . "".$user['name'].' '.$user['model_name']."".$user['comment']."" . get_connection($db_link, $user['id']) . "".$user['last_found']."
\n"; print_navigation($page_url,$page,$displayed,$count_records[0],$total); ?>