static function Purge()
{
global $zdbh;
global $controller;
$numrecords = 0;
$sql = "SELECT COUNT(*) FROM x_dns WHERE dn_deleted_ts IS NOT NULL";
if ($numrows = $zdbh->query($sql)) {
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare("SELECT * FROM x_dns WHERE dn_deleted_ts IS NOT NULL");
$sql->execute();
while ($row = $sql->fetch()) {
$delete_record = $zdbh->prepare("DELETE FROM x_dns WHERE dn_id_pk = :dn_id_pk");
$delete_record->bindParam(':dn_id_pk', $row['dn_id_pk']);
$delete_record->execute();
$numrecords++;
}
self::$purged = $numrecords;
}
}
}
