All pastes #2081789 Raw Edit

Unnamed

public text v1 · immutable
#2081789 ·published 2011-09-21 10:39 UTC
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;
?>