<?php
/*
****************************************************************
	Copyright (c) 2011-2012 Viper Network Systems, LLC
	All Rights Reserved
****************************************************************
*/
require ( "mysqlConnect.php" ) ;
include ( "header.php" ) ;

if ( $permissions["admin"] != 'Y' )
	die ( "permission denied" );

	$country_result = mysqli_query ($GLOBALS['__mysqli_conn'],
		"SELECT distinct countryCode, countryName
		 FROM country_info
		 ORDER BY countryName");

	$gnl_result = mysqli_query ($GLOBALS['__mysqli_conn'],
		"SELECT DISTINCT(list_id)
		 FROM list_detail");

if ( isset ( $_GET["pageID"] ) )
	$pageID = $_GET["pageID"];
else
{
	$pageID = "0";
	$pageTotal = "";
	$rangeTotal = "";
}

if ( isset( $_GET["gnl"] ) )
	$gnl = $_GET["gnl"];
else
	$gnl = '';
if ( isset( $_GET["gnlSort"] ) && $_GET["gnlSort"] == 'y' )
	$gnlSort = $_GET["gnlSort"];
else
	$gnlSort = '';
$ipAddress = '';
$ispName = '';
$region = '';
$country = '';
$ip2l = '';
$ipGeo = '';
$subscriber = '';
$priority = '';
if ( isset( $_GET["ip"] ) )
	$ipAddress = $_GET["ip"];
if ( isset( $_GET["isp"] ) )
	$ispName = $_GET["isp"];
if ( isset( $_GET["region"] ) )
	$region = $_GET["region"];
if ( isset( $_GET["country"] ) )
	$country = $_GET["country"];
if ( isset( $_GET["ip2l"] ) )
	$ip2l = $_GET["ip2l"];
if ( isset( $_GET["ip_geo"] ) )
	$ipGeo = $_GET["ip_geo"];
if ( isset( $_GET["subscriber"] ) )
	$subscriber = $_GET["subscriber"];
if ( isset( $_GET["priority"] ) )
	$priority = $_GET["priority"];

$query1 = "";
if (!empty($ipAddress)) {
$query1 = $query1."INET_ATON('".$ipAddress."') >= ipFrom and INET_ATON('".$ipAddress."') <= ipTo and ";
}
if (!empty($ispName)) {
$query1 = $query1."UPPER(ispName) LIKE UPPER('%".str_replace( "'", "''", $ispName )."%') and ";
}
if (!empty($region)) {
$query1 = $query1."UPPER(region) = UPPER('".str_replace( "'", "''", $region )."') and ";    
}
if (!empty($country)) {
$query1 = $query1."countryCode = '".str_replace( "'", "''", $country )."' and ";   
}

$query2 = "";
if (!empty($gnl)) {
$query2 = $query2.", list_detail as d ";
}
$query2 = $query2." WHERE ";
if (!empty($gnl)) {
$query2 = $query2."d.list_id = '".$gnl."' and d.ipFrom = s.ipFrom and d.ipTo = s.ipTo and ";
}
if (!empty($ipAddressip2l)) {
$query2 = $query2."INET_ATON('".$ipAddress."') >= s.ipFrom and INET_ATON('".$ipAddress."') <= s.ipTo and ";
}
if (!empty($ispNameip2l)) {
$query2 = $query2."UPPER(s.ispName) LIKE UPPER('%".str_replace( "'", "''", $ispName )."%') and ";
}
if (!empty($region)) {
$query2 = $query2."UPPER(s.region) = UPPER('".str_replace( "'", "''", $region )."') and ";    
}
if (!empty($country)) {
$query2 = $query2."s.countryCode = '".str_replace( "'", "''", $country )."' and ";    
}

if ( $gnl == "")
{
	if ( $ip2l !== "" ) {
		$query = "";
		if ( $gnlSort == 'y' )
		{
			$query = "SELECT INET_NTOA(ipFrom) as ipFromText, INET_NTOA(ipTo) as ipToText, countryCode, countryName, 
				latitude, longitude, region, ispName, city, zipcode
				FROM ip2l_db14 WHERE ";

			$query = $query.$query1." NOT EXISTS ( SELECT list_id FROM list_detail 
						WHERE list_detail.ipFrom = ip2l_db14.ipFrom AND list_detail.ipTo = ip2l_db14.ipTo )";
		}
		else
		{
			$query = "SELECT INET_NTOA(ipFrom) as ipFromText, INET_NTOA(ipTo) as ipToText, countryCode, countryName, 
				latitude, longitude, region, ispName, city, zipcode
				FROM ip2l_db14 WHERE ";

			$query = $query.$query1." 1=1";
		}
        $result = mysqli_query ( $GLOBALS['__mysqli_conn'], $query ) ;
		$num_rows = mysqli_num_rows( $result );
		
		$rangeTotal = $num_rows;

		$query = "";

		if ( $gnlSort == 'y' )
		{
			$query = "SELECT INET_NTOA(ipFrom) as ipFromText, INET_NTOA(ipTo) as ipToText, countryCode, countryName, 
				latitude, longitude, region, ispName, city, zipcode
				FROM ip2l_db14 WHERE ";

			$query = $query.$query1." NOT EXISTS ( SELECT list_id FROM list_detail 
						WHERE list_detail.ipFrom = ip2l_db14.ipFrom AND list_detail.ipTo = ip2l_db14.ipTo ) LIMIT ".( ($pageID)*200 ).", 200";
		}
		else
		{
			$query = "SELECT INET_NTOA(ipFrom) as ipFromText, INET_NTOA(ipTo) as ipToText, countryCode, countryName, 
				latitude, longitude, region, ispName, city, zipcode
				FROM ip2l_db14 WHERE ";

			$query = $query.$query1." 1=1 LIMIT ".( ($pageID)*200 ).", 200";
		}

        $ip2l_result =  mysqli_query ($GLOBALS['__mysqli_conn'], $query);
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);
		$pageTotal = floor( ( $rangeTotal-1 )/200 ) ;

		$ip2lRows = mysqli_num_rows($ip2l_result);  
	}
	if ($ipGeo != "") {
		$query = "";
		$query = "SELECT INET_NTOA(ipFrom) as ipFromText, INET_NTOA(ipTo) as ipToText, 
			priority, countryCode, countryName, longitude, latitude, 
			region, city, zipcode, timeZone, ispName, domainName, info_source
			FROM ip_geolocation
			WHERE "; 
		
		$query = $query.$query1." 1=1";
        $geo_result = mysqli_query ( $GLOBALS['__mysqli_conn'], $query ) ;
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);

		$geoRows = mysqli_num_rows($geo_result);
	}
	if ($subscriber != "") {
		//There is no empty check for $ipAddress since that is the only query that makes sense
		//If the user does not set it then an empty result set is returned
		$iplist_result = mysqli_query ($GLOBALS['__mysqli_conn'],
			"SELECT INET_NTOA(d.ipFrom) as ipFromText, INET_NTOA(d.ipTo) as ipToText, d.list_id, 
			d.cidr, s.list_name, SUBSTRING_INDEX(d.cidr,'/',1) as startIP
			FROM list_detail as d, subscriber_lists as s
			WHERE INET_ATON('".$ipAddress."') >= ipFrom AND INET_ATON('".$ipAddress."') <= ipTo 
			AND d.list_id = s.list_id");
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);

		$subscriberRows = mysqli_num_rows($iplist_result);
	}
}
else
{
	if ($ip2l != "") {
		$query= "SELECT INET_NTOA(s.ipFrom) as ipFromText, INET_NTOA(s.ipTo) as ipToText, s.countryCode, s.countryName, 
			s.latitude, s.longitude, s.region, s.ispName, s.city, s.zipcode
			FROM ip2l_db14 as s ";

		$query = $query.$query2." 1=1";
        $result = mysqli_query ( $GLOBALS['__mysqli_conn'], $query ) ;
		$num_rows = mysqli_num_rows( $result );

		$rangeTotal = $num_rows;

		$query = "";
		$query = "SELECT INET_NTOA(s.ipFrom) as ipFromText, INET_NTOA(s.ipTo) as ipToText, s.countryCode, s.countryName, 
			s.latitude, s.longitude, s.region, s.ispName, s.city, s.zipcode
			FROM ip2l_db14 as s ";

		$query = $query.$query2." 1=1 LIMIT ".( ($pageID)*200 ).", 200";
        $ip2l_result =  mysqli_query ($GLOBALS['__mysqli_conn'], $query);
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);
		$pageTotal = floor( ( $rangeTotal-1 )/200 ) ;

		$ip2lRows = mysqli_num_rows($ip2l_result); 
	}
	if ($ipGeo != "") {
		$query = "";
		$query = "SELECT INET_NTOA(s.ipFrom) as ipFromText, INET_NTOA(s.ipTo) as ipToText, 
			s.priority, s.countryCode, s.countryName, s.longitude, s.latitude, 
			s.region, s.city, s.zipcode, s.timeZone, s.ispName, s.domainName, s.info_source, INET_NTOA(d.ipFrom) as ipFromTextd, d.list_id 
			FROM ip_geolocation as s "; 
		
		if (!empty($priority)) {
		$query = $query.$query2."s.priority = ".intval($priority)." and ";    
		}    
		$query = $query.$query2." 1=1";
        $geo_result = mysqli_query ( $GLOBALS['__mysqli_conn'], $query ) ;
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);

		$geoRows = mysqli_num_rows($geo_result);
	}
	if ($subscriber != "") {
		//There is no empty checl for $ipAddress since that is the only query that makes sense
		//If the user does not set it that an empty result set is returned
		$iplist_result = mysqli_query ($GLOBALS['__mysqli_conn'],
			"SELECT INET_NTOA(list_detail.ipFrom) as ipFromText, INET_NTOA(list_detail.ipTo) as ipToText, list_detail.list_id, 
			list_detail.cidr, subscriber_lists.list_name, SUBSTRING_INDEX(list_detail.cidr,'/',1) as startIP
			FROM list_detail, subscriber_lists
			WHERE INET_ATON('".$ipAddress."') >= ipFrom AND INET_ATON('".$ipAddress."') <= ipTo 
			AND list_detail.list_id = subscriber_lists.list_id");
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);

		$subscriberRows = mysqli_num_rows($iplist_result);
	}
}

function imask ( $this )
{
	// use base_convert not dechex because dechex is broken and returns 0x80000000 instead of 0xffffffff
	return base_convert ( ( pow(2,32) - pow(2, (32-$this)) ), 10, 16 ) ;
}

function imaxblock ( $ibase, $tbit )
{
	while ($tbit > 0)
	{
		$im = hexdec(imask($tbit-1));
		$imand = $ibase & $im;
		if ($imand != $ibase)
		{
			break;
		}
		$tbit--;
	}
	return $tbit;
}

function range2cidrlist ( $start, $end )
{
	// this function returns an array of cidr lists that map the range given
	$result = array();
	while ($end >= $start)
	{
		$maxsize = imaxblock($start,32);
		$x = log($end - $start + 1)/log(2);
		$maxdiff = floor(32 - floor($x));
		$ip = long2ip($start);
		if ($maxsize < $maxdiff)
		{
			$maxsize = $maxdiff;
		}
		array_push($result,"$ip/$maxsize");
		$start += pow(2, (32-$maxsize));
	}
	return $result;
}
?>

<style>
.th {
	text-align: left;
}
.td {
	text-align: left;
}
.pointer {
	cursor: pointer;
}
</style>

<br/><br/>
<div class="ui-widget-header" style="width: 600px; margin: auto; text-align: center"><b><font size="6">IP Geo Locations</font></b></div>
<br/>

<div class="ui-widget ui-widget-content" style="width: 425px; margin: auto">
<button class="ui-button-text addIP" id="addIP" value="Add IP Range">Add IP Range</button>
<button class="ui-button-text addGNL" style="float:right">Add Global Network List</button>

<form method="GET" action="ipLocations.php">
<table class="ui-widget ui-corner-all ui-widget-content" style="width: 425px; margin: auto">
	<tr><td colspan="2"><i class="validateTips">&nbsp;</i></td></tr>
	<thead>
		<tr>
			<th class="ui-widget ui-widget-header" colspan="3">IP Geo Locations</th>
		</tr>
	</thead>
    <tbody>
	<tr>
		<td><b>ISP Name:</b></td><td><input type="text" name="isp" size=15 maxlength=45 value="<?= $isp?>"/></td>
	</tr>
	<tr>
		<td><b>IP Address:</b></td><td><input type="text" name="ip" class="ip" size=15 maxlength=15 value="<?= $ip ?>"/></td>
	</tr>
	<tr>        
		<td><b>Region:</b></td><td><input type="text" name="region" size=15 maxlength=128 value="<?= $region ?>"/></td>
	</tr>
	<tr>
		<td><b>GNL:</b></td><td><select name="gnl" style="width: 136px;">
		<option value="" 
<?php
if ( $gnl == "" )
	echo ' selected';
?>>-</option>
		<?php
			while ($gnl = mysqli_fetch_array ($gnl_result)) {
				echo '<option value="'.$gnl["list_id"].'"';
				if ( $gnl == $gnl["list_id"] ) 
					echo ' selected';
				echo '>'.$gnl["list_id"].'</option>';
			}
		?>
		</select></td>
	</tr>
	<tr>
		<td><b>Country:</b></td><td><select name="country">
		<option value="" selected>-</option>
		<option value="us">UnitedStates</option>
		<option value="ca">Canada</option>

		<?php
			while ($countries = mysqli_fetch_array ($country_result)) {
				echo '<option value="'.$countries["countryCode"].'">'.$countries["countryName"].'</option>';
			}
		?>
		</select></td>
	</tr>
	<tr>
		<td><b>Priority:</b></td><td><input type="text" name="priority" size=15 maxlength=15 value="<?= $priority ?>"/>
	</tr>
	<tr>
		<td><input type="checkbox" name="gnlSort" id="gnlSort" style="float:right" value="y" 
<?php
	if ( $gnlSort != '' )
		echo ' checked';
?>
		/></td>
		<td><b>Only show results without GNL</b></td>
	</tr>
	<tr>
		<td><input style="display:none" name="ip2l" value="true" checked/></td>
		<td><input style="display:none" name="ip_geo" value="true" checked/></td>            
		<td><input style="display:none" name="subscriber" value="true" checked/></td>
	</tr>
	<tr>
		<td><button class="ui-button-text submit" id="submit" type="submit" value="Search">Submit</button></td>
	</tr>
    </tbody>
</table>
</form>
</div>
<br/>
<?php   
if ($_GET["ip2l"] == "true" || $_GET["ip_geo"] == "true" || $_GET["subscriber"] == "true")
{
	$totalRows = $rangeTotal + $geoRows + $subscriberRows;
	echo "Total Results ".$totalRows;
?>
	<button type="button" class="addSelected">Add Selected to GNL</button>
<?php
	if ( $rangeTotal > 200 )
	{
?>
		<table>
			<tr class="pages" colspan="2">
				<td><a href="ipLocations.php?pageID=<?= min(0, $pageTotal) ?>&pageTotal=<?= $pageTotal ?>&rangeTotal=<?= $rangeTotal ?>&isp=<?= $_GET["isp"] ?>&ip=<?= $_GET["ip"] ?>&region=<?= $_GET["region"] ?>&country=<?= $_GET["country"] ?>&priority=<?= $_GET["priority"] ?>&gnlSort=<?= $gnlSort ?>&ip2l=true&ip_geo=true&subscriber=true"><button class="ui-widget-header ui-corner-tl ui-corner-bl first" title="Go To First Page" style="cursor:pointer"><b>First</b></button></a></td>
				 
<?php 
	if ( $pageID == 0 ) {
?>
				<td><button class="ui-widget-header previous" title="Go To Previous Page" style="cursor:pointer"><b>Prev</b></button></td>
<?php
	} else {
?>
				<td><a href="ipLocations.php?pageID=<?= $pageID-1 ?>&pageTotal=<?= $pageTotal ?>&rangeTotal=<?= $rangeTotal ?>&isp=<?= $_GET["isp"] ?>&ip=<?= $_GET["ip"] ?>&region=<?= $_GET["region"] ?>&country=<?= $_GET["country"] ?>&priority=<?= $_GET["priority"] ?>&gnlSort=<?= $gnlSort ?>&ip2l=true&ip_geo=true&subscriber=true"><button class="ui-widget-header previous" title="Go To Previous Page" style="cursor:pointer"><b>Prev</b></button></a></td>
<?php
	}
?>
				<td><span class="page" id="PageID"><?=$pageID+1?> of <?= $pageTotal+1 ?></span></td>
<?php
	if ( $pageID == ( $pageTotal ) ) {
?>
				<td><button class="ui-widget-header next" title="Go To Next Page" style="cursor:pointer"><b>Next</b></button></td>
<?php
	} else {
?>
				<td><a href="ipLocations.php?pageID=<?= $pageID+1 ?>&pageTotal=<?= $pageTotal ?>&rangeTotal=<?= $rangeTotal ?>&isp=<?= $_GET["isp"] ?>&ip=<?= $_GET["ip"] ?>&region=<?= $_GET["region"] ?>&country=<?= $_GET["country"] ?>&priority=<?= $_GET["priority"] ?>&gnlSort=<?= $gnlSort ?>&ip2l=true&ip_geo=true&subscriber=true"><button class="ui-widget-header next" title="Go To Next Page" style="cursor:pointer"><b>Next</b></button></a></td>
<?php
	}
?>
				<td><a href="ipLocations.php?pageID=<?= max(1, $pageTotal) ?>&pageTotal=<?= $pageTotal ?>&rangeTotal=<?= $rangeTotal ?>&isp=<?= $_GET["isp"] ?>&ip=<?= $_GET["ip"] ?>&region=<?= $_GET["region"] ?>&country=<?= $_GET["country"] ?>&priority=<?= $_GET["priority"] ?>&gnlSort=<?= $gnlSort ?>&ip2l=true&ip_geo=true&subscriber=true"><button class="ui-widget-header ui-corner-tr ui-corner-br last" title="Go To Last Page" style="cursor:pointer" align="right"><b>Last</b></button></a></td>
			</tr>
		</table>
<?php
	}
?>

<table id="ipTable" class="ui-widget ui-widget-content ui-corner-all tablesorter" width="100%">
	<thead>
	<tr>
		<th class="ui-widget ui-widget-header ui-corner-tl" style="width:40px"></th>
		<th class="ui-widget ui-widget-header" style="width:90px"></th>
		<th class="ui-widget ui-widget-header"><b>Source</b></th>
		<th class="ui-widget ui-widget-header"><b>IP From</b></th>
		<th class="ui-widget ui-widget-header"><b>IP To</b></th>
		<th class="ui-widget ui-widget-header"><b>Priority</b></th>
		<th class="ui-widget ui-widget-header"><b>Region</b></th>
		<th class="ui-widget ui-widget-header"><b>City</b></th>
		<th class="ui-widget ui-widget-header"><b>Country</b></th>
		<th class="ui-widget ui-widget-header"><b>Zip Code</b></th>
		<th class="ui-widget ui-widget-header"><b>Coordinates</b></th>
		<th class="ui-widget ui-widget-header"><b>ISP Name</b></th>
		<th class="ui-widget ui-widget-header" colspan="2"></b>List</b></th>
		<th class="ui-widget ui-widget-header ui-corner-tr"><input type="checkbox" class="checkAll" name="checkAll" value="y"/></th>
	</tr>
	</thead>
	<tbody>
<?php
    if ($_GET["ip_geo"] == "true") {
	while ($geos = mysqli_fetch_array ($geo_result)) {
    ?>        
	<tr>
		<td>
			<form id="ipGeoForm">
			<input type="hidden" name="func" value="edit">
			<input type="hidden" name="ipFrom" id="ipFrom" value="<?= $geos["ipFromText"] ?>">
			<input type="hidden" name="ipTo" id="ipTo" value="<?= $geos["ipToText"] ?>">
			<input type="hidden" name="priority" id="priority" value="<?= $geos["priority"] ?>">
			<input type="hidden" name="countryCode" value="<?= $geos["countryCode"] ?>">
			<input type="hidden" name="region" value="<?= $geos["region"] ?>">
			<input type="hidden" name="city" value="<?= $geos["city"] ?>">
			<input type="hidden" name="latitude" value="<?= $geos["latitude"] ?>">
			<input type="hidden" name="longitude" value="<?= $geos["longitude"] ?>">
			<input type="hidden" name="zipcode" value="<?= $geos["zipcode"] ?>">
			<input type="hidden" name="timeZone" value="<?= $geos["timeZone"] ?>">
			<input type="hidden" name="ispName" value="<?= $geos["ispName"] ?>">
			<input type="hidden" name="domainName" value="<?= $geos["domainName"] ?>">
			<input type="hidden" name="infoSource" value="<?= $geos["info_source"] ?>">
			</form>
			<button class="editGEO" id="editGEO" value="Edit" style="width:85px">Edit</button>
			
		</td>
		<td>
		<form method="GET" action="applyIPLocation.php" 
			onsubmit="return confirm('Are you sure you want to delete this location?')">
			<input type="hidden" name="func" value="delete">
			<input type="hidden" name="ipFrom" value="<?= $geos["ipFromText"] ?>">
			<input type="hidden" name="ipTo" value="<?= $geos["ipToText"] ?>">
			<input type="hidden" name="priority" value="<?= $geos["priority"] ?>">
			<input type="submit" id="delete" value="Delete">
		</form>
		</td>
		<td><?= $geos["info_source"] ?></td>
		<td><?= $geos["ipFromText"] ?></td>
		<td><?= $geos["ipToText"] ?></td>
		<td><?= $geos["priority"] ?></td>
		<td><?= $geos["region"] ?></td>
		<td><?= $geos["city"] ?></td>
		<td><?= $geos["countryName"] ?></td>
		<td><?= $geos["zipcode"] ?></td>
		<td><a href="http://maps.google.com/maps?q=<?= $geos["latitude"] ?>,<?= $geos["longitude"] ?>" target="_blank" title="View location on map" alt="View location on map"><span style="float: left"><?= $geos["latitude"] ?>, <?= $geos["longitude"] ?></span><span class="ui-icon ui-icon-extlink lineIcon" style="height: 1em; width: 1em; display: inline; float:left"></span></a></td>
		<td class="ispName"><?= $geos["ispName"] ?></td>
		<td colspan="2"><button class="addToList">Add to GNL</button><br/>
<?php
	$start = ip2long( $geos["ipFromText"] );
	$end = ip2long( $geos["ipToText"] );
	
	$gnlArray = array();
	$result = range2cidrlist ( $start, $end );
	$sizeof_result = sizeof($result);

	foreach ( $result as $results )
	{
		$geosList = mysqli_query ($GLOBALS['__mysqli_conn'],
			"SELECT list_detail.list_id as listID, subscriber_lists.list_name AS listName
			FROM list_detail, subscriber_lists
			WHERE list_detail.cidr = '".$results."'
			AND list_detail.list_id = subscriber_lists.list_id");
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);

		while ( $list = mysqli_fetch_array ( $geosList ) )
		{
			$gnlArray[$list["listID"]]["name"] = $list["listName"];
			if ( isset ( $gnlArray[$list["listID"]]["num"] ) )
				$gnlArray[$list["listID"]]["num"]++;
			else
				$gnlArray[$list["listID"]]["num"] = 1;
		}
	}
	
	foreach ( $gnlArray AS $gnlID => $gnl )
	{
		$name = $gnl["name"];
		$num = $gnl["num"];
		if ( $num == $sizeof_result )
		{
?>
			<b><?= $name ?></b>
<?php
		}
		else
		{
?>
			<b style="opacity: 0.5"><?= $name ?></b>
<?php
		}
	}
?>
			</b>
		</td>
		<td><input type="checkbox" class="checkbox" name="checkbox" value="y"/></td>
	</tr>        
<?php
        }
    }
    if ($_GET["ip2l"] == "true") {        
	while ($ip2ls = mysqli_fetch_array ($ip2l_result)) {
    
	$start = ip2long( $ip2ls["ipFromText"] );
	$end = ip2long( $ip2ls["ipToText"] );

	$gnlArray = array();
	$result = range2cidrlist ( $start, $end );
	$sizeof_result = sizeof($result);
	$string = "";
	foreach ( $result as $results )
	{
		$ip2lList = mysqli_query ($GLOBALS['__mysqli_conn'],
			"SELECT list_detail.list_id as listID, subscriber_lists.list_name AS listName
			FROM list_detail, subscriber_lists
			WHERE list_detail.cidr = '".$results."'
			AND list_detail.list_id = subscriber_lists.list_id");
        check_for_mysqli_error($GLOBALS['__mysqli_conn']);

		while ( $list = mysqli_fetch_array ( $ip2lList ) )
		{
			$gnlArray[$list["listID"]]["name"] = $list["listName"];
			if ( isset ( $gnlArray[$list["listID"]]["num"] ) )
				$gnlArray[$list["listID"]]["num"]++;
			else
				$gnlArray[$list["listID"]]["num"] = 1;
		}
	}
	$i = 0;
	$addStr = "";
	$num = "";
	foreach ( $gnlArray AS $gnlID => $gnl )
	{
		$string = "";
		$name = $gnl["name"];
		$num = $gnl["num"];

		if ( $i >= 1 )
			$string = $string.",";
		if ( $num == $sizeof_result )
		{
			$string = $string.$name;

			$addStr = $addStr.'<div class="divRemove" style="clear:both">
				<b class="lName"  align="left">'.$name.'</b>
				<img title="Delete GNL" alt="Delete GNL" align="right" class="ui-icon ui-icon-trash pointer" onclick="removeGNL($(this));">
				<b style="display:none" class="lid">'.$gnlID.'</b>
				<b style="display:none" class="checkID">'.$string.'</b>
			</div>';
		}
		else
		{
			$string = $string.$name;

			$addStr =  $addStr.'<div class="divRemove" style="clear:both">
				<b style="display:none" class="lid">'.$gnlID.'</b>
				<b style="opacity: 0.5">'.$name.'</b>
				<img title="Delete GNL" alt="Delete GNL" align="right" class="ui-icon ui-icon-trash pointer" onclick="removeGNL($(this));">
				<b style="display:none" class="checkID">'.$string.'</b>
			</div>';
		}
		$i = $i + 1;
	}
	if ( $gnlSort != '' )
	{
		if ( $num != 1 )
		{
?>
	<tr>
		<td colspan="2">
			<button class="viewDetails" style="width:130px">View Details</button>
		</td>
		<td>ip2l</td>
		<td><span class="ipFromID"><?= $ip2ls["ipFromText"] ?></span></td>
		<td><span class="ipToID"><?= $ip2ls["ipToText"] ?></span></td>
		<td>-</td>
		<td><?= $ip2ls["region"] ?></td>
		<td><?= $ip2ls["city"] ?></td>
		<td><?= $ip2ls["countryName"] ?></td>
		<td><?= $ip2ls["zipcode"] ?></td>
		<td><a href="http://maps.google.com/maps?q=<?= $ip2ls["latitude"] ?>,<?= $ip2ls["longitude"] ?>" target="_blank" title="View location on map" alt="View location on map"><span style="float: left"><?= $ip2ls["latitude"] ?>, <?= $ip2ls["longitude"] ?></span><span class="ui-icon ui-icon-extlink lineIcon" style="height: 1em; width: 1em; display: inline; float:left"></span></a></td>
		<td class="ispName"><?= $ip2ls["ispName"] ?></td>
		<td colspan="2"><button class="addToList">Add to GNL</button></td>
		<td><input type="checkbox" class="checkbox" name="checkbox" value="y"/></td>
	</tr>
<?php
		}
	}
	elseif ( $gnlSort == '' )
	{
		?>
	<tr>
		<td colspan="2">
			<button class="viewDetails" style="width:130px">View Details</button>
		</td>
		<td>ip2l</td>
		<td><span class="ipFromID"><?= $ip2ls["ipFromText"] ?></span></td>
		<td><span class="ipToID"><?= $ip2ls["ipToText"] ?></span></td>
		<td>-</td>
		<td><?= $ip2ls["region"] ?></td>
		<td><?= $ip2ls["city"] ?></td>
		<td><?= $ip2ls["countryName"] ?></td>
		<td><?= $ip2ls["zipcode"] ?></td>
		<td><a href="http://maps.google.com/maps?q=<?= $ip2ls["latitude"] ?>,<?= $ip2ls["longitude"] ?>" target="_blank" title="View location on map" alt="View location on map"><span style="float: left"><?= $ip2ls["latitude"] ?>, <?= $ip2ls["longitude"] ?></span><span class="ui-icon ui-icon-extlink lineIcon" style="height: 1em; width: 1em; display: inline; float:left"></span></a></td>
		<td class="ispName"><?= $ip2ls["ispName"] ?></td>
		<td colspan="2"><button class="addToList">Add to GNL</button><br/>
<?php
	echo $addStr;
?>
		</td>
		<td><input type="checkbox" class="checkbox" name="checkbox" value="y"/></td>
	</tr>
<?php
	}
        }
    }
    if ($_GET["subscriber"] == "true") {
	while ($iplists = mysqli_fetch_array ($iplist_result)) {  
    ?>      
	<tr>
		<td></td>
		<td>
			<form method="GET" action="subscriberDetail.php">
				<input type="hidden" name="func" value="">
				<input type="hidden" name="sid" value="<?= $iplists["list_id"] ?>">
				<button class="edit" type="submit" value="Edit" style="width:85px">Edit</button>
			</form>
		</td>
		<td><?= $iplists["list_name"] ?></td>
		<td><?= $iplists["ipFromText"] ?></td>
		<td><?= $iplists["ipToText"] ?></td>
		<td>-</td>
		<td>-</td>
		<td>-</td>
		<td>-</td>
		<td>-</td>
		<td>-</td>
		<td>-</td>
		<td>-</td>
		<td><input type="checkbox" class="checkbox" name="checkbox" value="y"/></td>
	</tr>        
<?php
        }
    }
?>
</tbody>
</table>

<div id="dlgAddToGNL" title="Add Network Range to GNL" >
	<div id="divAddToGNL">
		<div>
			<form id="addGNLForm">
			<label><b>CIDR Description:</b> </label><input name="newCidrDesc" class="newCidrDesc"/><br/>
			<input name="dlgIPFrom" class="dlgIPFrom" value=""></input>
			<input name="dlgIPTo" class="dlgIPTo" value=""></input>
			<input type="hidden" name="func" class="func" value="add"></input>
			<div id="divListCheck">

			</div>
			</form>
		</div>
	</div>
</div>

<div id="dlgViewDetails" title="View Details" >
	<div id="divDetails">

	</div>
</div>

<?php
} 
?>

<div id="dlgIPRange" title="Add IP Range" >
	<form id="ipRangeForm">
		<table class="ui-widget ui-widget-content" style="margin: auto">
		<div id="divIPRange">
			
		</div>
		</table>
	</form>
</div>

<script>	
	$( "#dlgIPRange" ).dialog({
		autoOpen: false,
		height: '450',
		width: '500',
		modal: true,
		buttons: {
			Add: function() {
				if ( $(".ipLocation").find("input").is(".ui-state-error") )
				{
					alert ("Please fix inputs highlighted in red") ;
					e.preventDefault() ;
				}
				$.ajax ( {
				type: 'GET',
				url: "applyIPLocation.php",
				data: $("#ipRangeForm").serialize(),
				dataType: 'text',
				success: function(msg) {
					if ( msg.indexOf ( "!!ERROR!!" ) >= 0 )
					{
						alert ( "Unable to update IP range: duplicate entry" ) ;
					}
				},
				error: function ( a, errType, errMsg ) {
					alert ( "Unable to update IP range" + errType + " - " + errMsg ) ;
				},
				complete: function() {
					location.reload(true) ;
				}
			} ) ;
			},
			Close: function() {
				$( this ).dialog( "close" );
			}
		},
		close: function(event, ui) {
			
		}
	});
	
	$( "#dlgViewDetails" ).dialog({
		autoOpen: false,
		height: '350',
		width: '400',
		modal: true,
		buttons: {
			Close: function() {
				$( this ).dialog( "close" );
			}
		},
		close: function(event, ui) {
		}
	});
	$( "#dlgAddToGNL" ).dialog({
		autoOpen: false,
		height: '650',
		width: '400',
		modal: true,
		buttons: {
			Apply: function() {
				alert ( $("#addGNLForm").serialize() );
				$.ajax ( {
				type: 'POST',
				url: "applyGNL.php",
				data: $("#addGNLForm").serialize(),
				dataType: 'text',
				success: function(msg) {
					if ( msg.indexOf ( "!!ERROR!!" ) >= 0 )
					{
						alert ( "Unable to update GNL: duplicate entry" ) ;
					}
				},
				error: function ( a, errType, errMsg ) {
					alert ( "Unable to update GNL: " + errType + " - " + errMsg ) ;
				},
				complete: function() {
					location.reload(true) ;
				}
				});
				$( "body" ).css ( "cursor", "wait" ) ;
			},
			Close: function() {
				$( this ).dialog( "close" );
			}
		},
		close: function(event, ui) {
			
		}
	});
	$(".checkAll").click( function() {
		if ( $(this).is(":checked") )
			$(".checkbox").attr("checked", true);
		else
			$(".checkbox").attr("checked", false);
	});
	$(".addSelected").button({
		icons: {
			primary: "ui-icon-check"
		} })
		.click(function(e) 
		{
			addSelected();
		} ) ;
	function addSelected() {
		ipFromArray = [];
		ipToArray = [];
		ispNameArray = [];
		checkIDArray = [];
		listArray = [];
		$(".checkbox").each( function() {
			if ( $(this).is(":checked") )
			{
				addLine = $(this).closest("tr");
				var ipFrom = addLine.find(".ipFromID").text();
				ipFromArray.push( ipFrom );
				var ipTo = addLine.find(".ipToID").text();
				ipToArray.push( ipTo );
				var ispName = addLine.find(".ispName").text();
				ispNameArray.push( ispName );
				var checkID = addLine.find(".checkID").text();
				checkIDArray.push( checkID );
				listArray.push( ipFrom, ipTo, ispName, checkID );
			}
			$(".dlgIPFrom").val( ipFromArray );
			$(".dlgIPTo").val( ipToArray );
		});
		$("#divListCheck").load("ip2lCheck.php");
		$("#dlgAddToGNL").dialog( "open" );
	}
	$( ".addIP" ).button({
		icons: {
			primary: "ui-icon-plusthick"
		} })
		.click(function(e) 
		{
			addNewIPRange();
		} ) ;
	$( "#editGEO").button({
		icons: {
			primary: "ui-icon-plusthick"
		} })
		.click(function(e) 
		{
			editGEO($(this));
		} ) ;
	
	$( ".edit" ).button({
		icons: {
			primary: "ui-icon-plusthick"
		} })
		.click(function(e) 
		{
			
		} ) ;
	$( "#delete" ).button({
		icons: {
			primary: "ui-icon-plusthick"
		} })
		.click(function(e) 
		{
			
		} ) ;
	$( ".viewDetails" ).button({
		icons: {
			primary: "ui-icon-plusthick"
		} })
		.click(function(e) 
		{
			viewDetails ( $(this) );
		} ) ;
	$( ".submit" ).button({
		icons: {
			primary: "ui-icon-check"
		} })
		.click(function(e) 
		{
			
		} ) ;
	$( ".addToList" ).button({
		icons: {
			primary: "ui-icon-check"
		} })
		.click(function(e) 
		{
			addToGNL ( $(this) );
		} ) ;
	$( ".addGNL" ).button({
		icons: {
			primary: "ui-icon-plusthick"
		} })
		.click(function(e) 
		{
			window.open('subscriberEdit.php?func=new');
		} ) ;
	$( ".removeFromList" ).button({
		icons: {
			primary: "ui-icon-check"
		} })
		.click(function(e) 
		{
		
		} ) ;
		
	$(".ip").live("blur", function() {
		if ( $(this).val() == "" )
		{
			return true;
		}
		checkIPisValid ( $(this), $(this).val() );
	}); 
		
	function editGEO ( u )
	{
		ipGeo = $("#ipGeoForm").serialize();
		rangeLine = u.closest("tr");
		$("#divIPRange").load("ipRangeDetail.php?func=edit&" + ipGeo);
		$("#dlgIPRange").dialog( "open" );
	}
	
	function addNewIPRange ( u )
	{
		$("#divIPRange").load("ipRangeDetail.php?func=new" );
		$("#dlgIPRange").dialog( "open" );
	}
	
	function addToGNL ( u )
	{
		$(".dlgIPFrom").val( u.closest("tr").find(".ipFromID").text() );
		$(".dlgIPTo").val( u.closest("tr").find(".ipToID").text() );
		var ispName = u.closest("tr").find(".ispName").text();
		var checkID = u.closest("tr").find(".checkID").text();
		$("#divListCheck").load("ip2lCheck.php?listID=" + escape(checkID) + "&isp=" + escape(ispName));
		$("#dlgAddToGNL").dialog( "open" );
	}
	function removeGNL ( u )
	{
		/*if ( confirm('Are you sure you want to delete this GNL?') )
		{*/
			listID = u.closest("div").find(".lid").text();
			ipFrom = u.closest("tr").find(".ipFromID").text();
			ipTo =  u.closest("tr").find(".ipToID").text();
			$.ajax ( {
				type: 'POST',
				url: "applyGNL.php",
				data: "func=del&listID=" + listID + "&dlgIPFrom=" + ipFrom + "&dlgIPTo=" + ipTo,
				dataType: 'text',
				success: function(msg) {
					if ( msg.indexOf ( "!!ERROR!!" ) >= 0 )
					{
						alert ( "Unable to update GNL: duplicate entry" ) ;
					}
				},
				error: function ( a, errType, errMsg ) {
					alert ( "Unable to update GNL: " + errType + " - " + errMsg ) ;
				},
				complete: function() {
					u.closest(".divRemove").remove();
				}
			});
		//}
	}
	
	function viewDetails ( u )
	{
		detailLine = u.closest("tr") ;
		$("#divDetails").load("ip2lDetail.php?ipFromID=" + detailLine.find(".ipFromID").text() + "&ipToID=" + detailLine.find(".ipToID").text()) ;
		$("#dlgViewDetails").dialog( "open" );
	}
</script>


</body>
</html>