/**
* Commits changes (increases serial by 1)
*
* @return Array on success, string on error
*/
public static function commit()
{
// do some checks first
$pdns_version = trim(shell_exec("sudo /usr/bin/pdns_control version 2>&1"));
if (!preg_match('/^[0-9,\\.]+$/', $pdns_version)) {
if (preg_match('/\\[sudo\\] password/', $pdns_version)) {
return "Unable to run 'sudo /usr/bin/pdns_control'. Is it defined in sudoers file?";
} else {
return $pdns_version;
}
}
$commited = array();
$c = new Criteria();
$c->add(AuditPeer::OBJECT, 'Record');
$c->addGroupByColumn(AuditPeer::DOMAIN_ID);
$c->add(AuditPeer::CREATED_AT, date("Y-m-d H:i:s", MyTools::getLastCommit()), Criteria::GREATER_THAN);
foreach (AuditPeer::doSelect($c) as $audit) {
$domain = DomainPeer::retrieveByPK($audit->getDomainId());
$commited[] = $domain->getName();
// get SOA record
$c = new Criteria();
$c->add(RecordPeer::DOMAIN_ID, $domain->getId());
$c->add(RecordPeer::TYPE, 'SOA');
$SOA = RecordPeer::doSelectOne($c);
$temp = explode(" ", $SOA->getContent());
$serial = $temp[2];
$date = substr($serial, 0, 8);
$id = substr($serial, 8);
// today ?
if ($date == date("Ymd")) {
$id++;
if (strlen($id) == 1) {
$id = "0" . $id;
}
$serial = $date . $id;
} else {
$serial = date("Ymd") . "01";
}
if ($serial >= 4294967295) {
continue;
}
// don't allow >= 32bit unsigned
$SOA->setContent(implode(" ", array($temp[0], $temp[1], $serial)));
$SOA->save();
}
if ($commited) {
SettingPeer::setValue('last_commit', time());
sleep(2);
if ($also_notify = sfConfig::get('app_default_also-notify')) {
foreach ($commited as $domain) {
foreach ($also_notify as $host) {
exec("sudo /usr/bin/pdns_control notify-host {$domain} {$host}");
}
}
}
}
return $commited;
}
public function needsCommit()
{
$connection = Propel::getConnection();
$sql = sprintf("SELECT COUNT(%s) AS count FROM %s \n WHERE %s = 'Record' \n AND %s = %d \n AND %s = %d \n AND %s > '%s'", AuditPeer::ID, AuditPeer::TABLE_NAME, AuditPeer::OBJECT, AuditPeer::OBJECT_KEY, $this->getId(), AuditPeer::DOMAIN_ID, $this->getDomainId(), AuditPeer::CREATED_AT, date("Y-m-d H:i:s", MyTools::getLastCommit()));
$statement = $connection->prepareStatement($sql);
$resultset = $statement->executeQuery();
$resultset->next();
return $resultset->getInt('count');
}
