query( $sql ); if ($loc_db->num_rows() == 0) die("that node doesnt exist, go here"); // build SQL query to get basic node data $sql = "SELECT *, (TO_DAYS(now()) - TO_DAYS(updated)) as age FROM nodes WHERE id='" . $node_id . "' ORDER BY id"; // run query $loc_db->query($sql); $loc_db->next_record(); $node_name = $loc_db->f("name"); $node_owner = $loc_db->f("owner"); $node_owner_email = "click to email"; $node_lat = (double)$loc_db->f("latitude"); $node_long = (double)$loc_db->f("longitude"); $node_suburb = $loc_db->f("suburb"); $node_status = $loc_db->f("status"); $node_area_id = $loc_db->f("area"); $node_area = get_area_name($loc_db->f("area")); $node_ip_block = get_ip_block($node_id); $node_age = $loc_db->f("age"); $node_url = $loc_db->f("url"); $node_wiki_url = get_node_wiki($node_id); $node_node_map = get_node_map($node_id, $zoom); $node_link_map = get_node_link_map($node_id, $zoom); if ((substr($node_url, 0, 4) != "http") && ($node_url != "")) $node_url = "http://" . $node_url; if (strlen($node_url) != 0) { $node_url = "$node_url"; } else { $node_url = " none "; } ?>
Node information
Node ID and Name
Node ID:
Short node name:
 
Contact Information and Location
Owner:
email:
Suburb:
Latitude:
Longitude:
 
Node Status
Node status:
 
Area
Area:
 
Allocated IP Addresses
IP Block:
 
Where to find more info
External URL:
Wiki:
 
Days since last update
Days since last update:
query($sql); echo "

"; echo ""; if ($loc_db->num_rows() == 0) { ?> next_record()) { $int_id = $loc_db->f("int_id"); $card_manufacturer = $loc_db->f("card_manufacturer"); $card_power = $loc_db->f("card_power"); $card_receive = $loc_db->f("card_receive"); $mac = $loc_db->f("mac"); $channel = $loc_db->f("channel"); $antenna_dbi = $loc_db->f("antenna_dbi"); $antenna_type = $loc_db->f("antenna_type"); $cable_loss = $loc_db->f("cable_loss"); $router_ip = get_ip_router($int_id); $class = $loc_db->f("class"); $mode = $loc_db->f("mode"); if ($card_power == -1) $card_power = "unknown"; if ($card_receive == -1) $card_receive = "unknown"; if ($channel == -1) $channel = "unknown"; if ($antenna_dbi == -1) $antenna_dbi = "unknown"; if ($cable_loss == -1) $cable_loss = "unknown"; ?> f("id") . ") OR (interface_2 = " . $loc_db->f("id") . "))"; $loc_db_2->query( $sql ); while($loc_db_2->next_record()) { if ($loc_db->f("id") == $loc_db_2->f("interface_1")) { $link_int = $loc_db_2->f("interface_2"); } else { $link_int = $loc_db_2->f("interface_1"); } $sql = "SELECT * FROM interfaces WHERE id = " . $link_int; $loc_db_3->query( $sql ); $loc_db_3->next_record(); ?>
No Interfaces
Interface
Card/AP Manufacturer: (?)
Card/AP Power: (?) dBm
Card/AP Receive Sensitivity: (?) dBm
MAC: (?)
Channel: (?)
Mode: (?)
Antenna Type: (?)
Antenna Gain: (?) dBi
Cable Loss: (?) dB
EIRP: (?) dBm (over 36dBm is _illegal_)
Class: (?)
IP Address: (?)
     Linked to ">f("node") ?> : (f("antenna_dbi") ?>dBi f("antenna_type") ?>)


query($sql); if ($loc_db->num_rows() == 0) { ?> next_record()) { ?>
Services
Type IP Port DESCRIPTION
No Services Offered
f("type") ?> f("ip") ?> f("port") ?> f("description") ?>
Maps
Zoom Level
-5x"; } else { $zoom_links .= " -5x "; } if ($zoom != "-4") { $zoom_links .= "-4x"; } else { $zoom_links .= " -4x "; } if ($zoom != "-3") { $zoom_links .= "-3x"; } else { $zoom_links .= " -3x "; } if ($zoom != "-2") { $zoom_links .= "-2x"; } else { $zoom_links .= " -2x "; } if ($zoom != "1") { $zoom_links .= "1x"; } else { $zoom_links .= " 1x "; } if ($zoom != "2") { $zoom_links .= "2x"; } else { $zoom_links .= " 2x "; } if ($zoom != "3") { $zoom_links .= "3x"; } else { $zoom_links .= " 3x "; } if ($zoom != "4") { $zoom_links .= "4x"; } else { $zoom_links .= " 4x "; } echo $zoom_links; ?>
All Nodes
All Nodes
 
Links
Links
 


View Closest [25, 50, 100, 250, 500, all] nodes

'$node_id' ORDER BY dist" . $nodes; // OLD DIST CALC // (1.852 * 60 * ACOS( SIN($node_lat) * SIN(latitude) + COS($node_lat) * COS(latitude) * COS(longitude - $node_long))) $loc_db->query ( $sql ); while ($loc_db->next_record()) { $close_id = $loc_db->f("id"); $close_name = $loc_db->f("name"); $close_suburb = $loc_db->f("suburb"); $close_dist = round($loc_db->f("dist"),2); $close_lat = $loc_db->f("latitude"); $close_long = $loc_db->f("longitude"); $close_status = $loc_db->f("status"); $bearing = $loc_db->f("bearing"); if ($node_lat > $loc_db->f("latitude")) $bearing = $loc_db->f("bearing") + 180; if (($loc_db->f("latitude") > $node_lat) && ($node_long > $loc_db->f("longitude"))) $bearing = $loc_db->f("bearing") + 360; $bearing = round($bearing, 2); $sql = "SELECT count(id) as count FROM interfaces WHERE node='" . $id . "'"; $loc_db_2->query( $sql ); $loc_db_2->next_record(); $this_num_interface = $loc_db_2->f("count"); $sql = "SELECT count(id) as count FROM interfaces WHERE node='" . $close_id . "'"; $loc_db_2->query( $sql ); $loc_db_2->next_record(); $close_num_interface = $loc_db_2->f("count"); if (($this_num_interface == 0) || ($close_num_interface == 0)) { $som = "---"; } else { $som = ""; } ?>
ID (?) Name (?) Distance from you (?) Coordinates (?) Bearing (?) Theoretical SOM (?) Status of node (?)
() kms
°