#!/usr/bin/env php
<?php
	$root = substr(__DIR__,0,strrpos(__DIR__,'/'));
	require_once($root."/dronebl.config.php");
	require_once($frameworks_path."/DroneBL/Database.framework");
	require_once($frameworks_path."/DroneBL/Cron.framework");
	require_once($frameworks_path."/DroneBL/Logging.framework");

	chkprog('Buildzone Generator');

	$cachefile = "/home/dronebl/rsync.dronebl.org/buildzone";
	$cachefile6 = "/home/dronebl/rsync.dronebl.org/buildzone6";
	$counter = 0;

	function dbarr_add($ip, $type, $comment=false)
	{
		global $dbarr, $counter;
		$type = intval($type);

		if (!isset($dbarr['t'.$type]))
		{
			$res2 = get_db_rows("SELECT classid,description FROM classes ORDER BY classid ASC");
			while($tuple2 = get_db_tuple($res2))
			{
				$class = intval($tuple2['classid']);
				$dbarr['t'.$class] = [];
				// $dbarr['t'.$class][] = "\$DATASET ip".(preg_match('/:/',$ip) ? 6 : 4)."tset:@";
				$dbarr['t'.$class][] = ":".$class.":".$tuple2['description'];
				if ($class > 2)
					$dbarr['t'.$class][] = (preg_match('/:/',$ip) ? '::FFFF:7F00:'.hexdec($class) : '127.0.0.'.$class);
			}
		}
		$dbarr['t'.$type][] = $ip.($comment?"\t".$comment:"");
		$counter++;
	}

	// Get list of servers
	$dns = [];
	$res = get_db_rows("SELECT name FROM rblservers WHERE active=1");
	while ($row = get_db_tuple($res))
		$dns[] = $row['name'];
	

	// Header TTL
	$data = "\$TTL 300\n";
	if (!empty($dns))
		$data .= "\$NS 1w ".implode(' ', $dns)."\n"; 
	$data .= "\$SOA 300 ns.scarynet.org outsider.scarynet.org 0 600 300 86400 300\n";
//	$data .= "\$MAXRANGE4 /8\n";

	// Whitelist
	$res = get_db_rows("SELECT ip,description FROM whitelist WHERE ip LIKE '%.%';");
	if (db_num_rows($res))
	{
		// $data .= "\$DATASET ip4tset:@\n";
		while($tuple = get_db_tuple($res))
			$data .= "!".$tuple['ip'].(!empty($tuple['description'])?"\t".$tuple['description']:"")."\n";
	}

	// Blacklist
	$res = get_db_rows("SELECT DISTINCT(ip) , type, comment FROM blacklist WHERE listed=1 AND ip << '0.0.0.0/0'::cidr  ORDER BY ip ASC;");
	$dbarr = array();
	dbarr_add('127.0.0.2',1);

	while($tuple = get_db_tuple($res))
		dbarr_add($tuple['ip'],$tuple['type'],$tuple['comment']);
	
	// Blacklist_cidr
	$res = get_db_rows("SELECT DISTINCT(cidr) , type, comment FROM blacklist_cidr WHERE listed=1 AND cidr::text LIKE '%.%' ORDER BY cidr ASC;");
	while($tuple = get_db_tuple($res))
		dbarr_add($tuple['cidr'],$tuple['type'],$tuple['comment']);

	foreach(array_keys($dbarr) AS $name)
		$data .= implode("\n",$dbarr[$name])."\n";

	file_put_contents($cachefile . ".new", $data);
	rename($cachefile . ".new", $cachefile);
	
	conlog('IPv4 contains '.$counter.' entries.');
	$counter = 0;

	// Now the IPv6 file

	// Header TTL
	$data = "\$TTL 300\n";
	if (!empty($dns))
                $data .= "\$NS 1w ".implode(' ', $dns)."\n";
        $data .= "\$SOA 300 ns.scarynet.org outsider.scarynet.org 0 600 300 86400 300\n";
//      $data .= "\$MAXRANGE6 /32\n";

	// Whitelist
	$res = get_db_rows("SELECT ip,description FROM whitelist WHERE ip LIKE '%:%';");
	if (db_num_rows($res))
	{
		// $data .= "\$DATASET ip6tset:@\n";
		while($tuple = get_db_tuple($res))
			$data .= "!".$tuple['ip'].(!empty($tuple['description'])?"\t".$tuple['description']:"")."\n";
	}

	// Blacklist
	$res = get_db_rows("SELECT DISTINCT(ip) , type, comment FROM blacklist WHERE listed=1 AND ip << '::/0'::cidr ORDER BY ip ASC;");
	$dbarr = array();

	dbarr_add('dead::beef',1);
	dbarr_add('::FFFF:7F00:2',1);

	while($tuple = get_db_tuple($res))
		dbarr_add($tuple['ip'], $tuple['type'], $tuple['comment']);
	
	// Blacklist_cidr
	$res = get_db_rows("SELECT DISTINCT(cidr) , type, comment FROM blacklist_cidr WHERE listed=1 AND cidr::text LIKE '%:%' ORDER BY cidr ASC;");
	while($tuple = get_db_tuple($res))
		dbarr_add($tuple['cidr'],$tuple['type'],$tuple['comment']);

	foreach(array_keys($dbarr) AS $name)
		$data .= implode("\n",$dbarr[$name])."\n";

	file_put_contents($cachefile6 . ".new", $data);
	rename($cachefile6 . ".new", $cachefile6);
	conlog('IPv6 contains '.$counter.' entries.');
	// _activity_log_add(0, 1, "Zone files generated");
	endprog();
?>
