static function DeleteType() { global $zdbh; global $controller; $numrecords = 0; $type = $controller->GetControllerRequest('FORM', 'inType'); $sql = "SELECT COUNT(*) FROM x_dns WHERE dn_type_vc = :type AND dn_deleted_ts IS NULL"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':type', $type); if ($numrows->execute()) { if ($numrows->fetchColumn() != 0) { $type = $controller->GetControllerRequest('FORM', 'inType'); $sql = $zdbh->prepare("SELECT * FROM x_dns WHERE dn_type_vc = :type AND dn_deleted_ts IS NULL"); $sql->bindParam(':type', $type); $sql->execute(); while ($row = $sql->fetch()) { $time = time(); $type = $controller->GetControllerRequest('FORM', 'inType'); $delete_record = $zdbh->prepare("UPDATE x_dns SET dn_deleted_ts=:time WHERE dn_id_pk = :dn_id_pk AND dn_type_vc = :type"); $delete_record->bindParam(':time', $time); $delete_record->bindParam(':dn_id_pk', $row['dn_id_pk']); $delete_record->bindParam(':type', $type); $delete_record->execute(); $numrecords++; } self::$deletedtype = $numrecords; self::$type = $controller->GetControllerRequest('FORM', 'inType'); } } }