rendered paste body<?php
include ('../sql.inc.php');
/*
* Array
* (
* [0] => 8330
* [1] => LONAP
* [2] => LONAP
* [3] => AS-LONAP
* [4] => support@lonap.net
* [5] =>
* [6] => 3
* )
*/
$IX_Code = array (
"LONAP-IPv4" => "lnp",
"LONAP-IPv6" => "lp6",
"LINX Extreme LAN-IPv4" => "lnx",
"LINX Brocade LAN-IPv4" => "lnx",
"LINX Extreme LAN-IPv6" => "ln6",
"LINX Brocade LAN-IPv6" => "ln6"
);
$peers = file('ips');
$badpeers ="";
foreach ($peers as $peer => $peer_ip)
{
$peer_ip = rtrim($peer_ip);
$peer_sql = mysql_query("select pp.asn, mp.name, pp.name, pp.irr_as_set, ppc.email, ppc.telephone,ppp.protocol, pp.info_prefixes from peerParticipants pp
left join peerParticipantsPublics ppp on (pp.id = ppp.participant_id)
left join mgmtPublics mp on (ppp.public_id = mp.id)
left join peerParticipantsContacts ppc on (ppp.participant_id = ppc.participant_id)
where (ppc.role LIKE 'NOC' OR ppc.name LIKE 'NOC' OR ppc.email LIKE 'NOC') and ppp.local_ipaddr = '$peer_ip'");
$peer_sqlr = mysql_fetch_row($peer_sql);
if ((mysql_num_rows($peer_sql) > 0)) {
echo "neighbour $peer_ip description as:$peer_sqlr[0] p:".$IX_Code[($peer_sqlr[1]."-".(substr_count($peer_ip,":") > 0 ? "IPv6" : "IPv4"))]." c:$peer_sqlr[2] set:".strtoupper($peer_sqlr[3])." ac:AS-TIMICO e:$peer_sqlr[4] t:".str_replace(" ","",$peer_sqlr[5])."\n";
} else {
$badpeers .= "ERROR: $peer_ip NOT FOUND IN PEERINGDB\n";
}
}
echo "\n\n\n\n".$badpeers;
?>