#!/usr/bin/php5-cgi -q
<?php
class MySQL
{
        var $db_hostname = "localhost";
        var $db_username = "user";
        var $db_password = 'pass';
        var $db_database = "database";
        public function GetDB_host() { return $this->db_hostname; }
        public function GetDB_user() { return $this->db_username; }
        public function GetDB_pass() { return $this->db_password; }
        public function GetDB_database() { return $this->db_database; }
}
class Domain
{
        function __construct()
        {
                $this->MySQL = new MySQL();
                $this->mysqli = new mysqli($this->MySQL->GetDB_host(), $this->MySQL->GetDB_user(),$this->MySQL->GetDB_pass(),$this->MySQL->GetDB_database());
        }
        function set_domain($domain)
        {
                $this->domain = $domain;
                $this->get_domain_id();
        }
        function inc_serial()
        {
                $result = $this->mysqli->query("SELECT * FROM records WHERE domain_id = '$this->domain_id' AND type = 'SOA'");
                $row = $result->fetch_array();
                $data = explode(" ",$row['content']);
                $ns1 = $data[0];
                $ns2 = $data[1];
                $serial = $data[2];
                $serial++;
                $refresh = $data[3];
                $retry = $data[4];
                $expire = $data[5];
                $minttl = $data[6];
                return "RESULT: ".$ns1." ".$ns2." ".$serial." ".$refresh." ".$retry." ".$expire." ".$minttl."\n";
        }
        function get_domain_id()
        {
                $result = $this->mysqli->query("SELECT * FROM domains WHERE name = '$this->domain'");
                $row = $result->fetch_array();
                $this->domain_id = $row['id'];
        }
}
$Domain = new Domain();
$Domain->set_domain("dnsbl.me");
echo $Domain->inc_serial();

echo "Done\n";
?>