#!/usr/local/bin/php
<?php

require_once 'DB.php';

$dsn = "mysql://user:pass@host/ip2country";
$dbh = DB::connect($dsn, true);

$query  = "SELECT * FROM ip_map WHERE code = 'FI' ORDER BY ip_from";
$result = $dbh->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) {
    $start    = $row->ip_from;
    $end      = $row->ip_to;
    $numhosts = $end-$start;
    $netmask  = ip2long('255.255.255.255') - $numhosts;
    $cidr     = strpos(decbin(ip2long($netmask)), "0");
    echo("/sbin/ipfw add pass tcp from ". long2ip($start) .'/'. $cidr ." to 192.168.10.1 21 setup\n");
}