query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function operational_nodes() { $loc_db = new locDatabase; $sql = "SELECT count(id) as count FROM nodes WHERE status='operational'"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function testing_nodes() { $loc_db = new locDatabase; $sql = "SELECT count(id) as count FROM nodes WHERE status='testing'"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function building_nodes() { $loc_db = new locDatabase; $sql = "SELECT count(id) as count FROM nodes WHERE status='building'"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function gathering_nodes() { $loc_db = new locDatabase; $sql = "SELECT count(id) as count FROM nodes WHERE status='gathering'"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function interested_nodes() { $loc_db = new locDatabase; $sql = "SELECT count(id) as count FROM nodes WHERE status='interested'"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function total_interfaces() { $loc_db = new locDatabase; $sql = "SELECT count(id) as count FROM interfaces"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function total_links() { $loc_db = new locDatabase; $sql = "SELECT count(id) as count FROM links"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("count"); } function count_nodes($area_id) { $loc_db = new locDatabase; $sql = "SELECT count(id) as total FROM nodes WHERE area=" . $area_id; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("total"); } function count_non_routers($area_id) { $loc_db = new locDatabase; $sql = "SELECT count(id) as total FROM nodes WHERE ((area=" . $area_id . ") AND (ospf_mode='none'))"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("total"); } function count_internal_routers($area_id) { $loc_db = new locDatabase; $sql = "SELECT count(id) as total FROM nodes WHERE ((area=" . $area_id . ") AND (ospf_mode='Area Internal Router'))"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("total"); } function count_area_border_routers($area_id) { $loc_db = new locDatabase; $sql = "SELECT count(id) as total FROM nodes WHERE ((area=" . $area_id . ") AND (ospf_mode='Area Border Router'))"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("total"); } function count_system_border_routers($area_id) { $loc_db = new locDatabase; $sql = "SELECT count(id) as total FROM nodes WHERE ((area=" . $area_id . ") AND (ospf_mode='System Border Router'))"; $loc_db->query( $sql ); $loc_db->next_record(); return $loc_db->f("total"); } function count_areas() { GLOBAL $opt_area; return count($opt_area); } ?>