summaryrefslogtreecommitdiff
path: root/scripts/DumpWeakCerts.pl
diff options
context:
space:
mode:
authorBernhard Fröhlich <bernhard@cacert.org>2011-03-29 21:32:34 +0200
committerBernhard Fröhlich <bernhard@cacert.org>2011-03-29 21:32:34 +0200
commitab74a1333cb130bdb19f4fddd6f96c55d1473234 (patch)
tree38e8e274f60a983f80d3c8b1ce7912f21505ad90 /scripts/DumpWeakCerts.pl
parenta706b59b4c033466916a923264ac12e1c164a432 (diff)
downloadcacert-devel-ab74a1333cb130bdb19f4fddd6f96c55d1473234.tar.gz
cacert-devel-ab74a1333cb130bdb19f4fddd6f96c55d1473234.tar.xz
cacert-devel-ab74a1333cb130bdb19f4fddd6f96c55d1473234.zip
Added restriction "revoked=0" to cert queries
Diffstat (limited to 'scripts/DumpWeakCerts.pl')
-rwxr-xr-xscripts/DumpWeakCerts.pl8
1 files changed, 4 insertions, 4 deletions
diff --git a/scripts/DumpWeakCerts.pl b/scripts/DumpWeakCerts.pl
index dc6030c..7b648b9 100755
--- a/scripts/DumpWeakCerts.pl
+++ b/scripts/DumpWeakCerts.pl
@@ -64,7 +64,7 @@ sub IsWeak($) {
$sth_certs = $dbh->prepare(
"SELECT `dc`.`domid`, `dc`.`CN`, `dc`.`expire`, `dc`.`crt_name` ".
" FROM `domaincerts` AS `dc` ".
- " WHERE `dc`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
+ " WHERE `dc`.`revoked`=0 AND `dc`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
$sth_certs->execute();
$sth_userdata = $dbh->prepare(
@@ -88,7 +88,7 @@ $sth_certs->finish();
$sth_certs = $dbh->prepare(
"SELECT `ec`.`memid`, `ec`.`CN`, `ec`.`expire`, `ec`.`crt_name` ".
" FROM `emailcerts` AS `ec` ".
- " WHERE `ec`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
+ " WHERE `ec`.`revoked`=0 AND `ec`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
$sth_certs->execute();
$sth_userdata = $dbh->prepare(
@@ -112,7 +112,7 @@ $sth_certs->finish();
$sth_certs = $dbh->prepare(
"SELECT `dc`.`orgid`, `dc`.`CN`, `dc`.`expire`, `dc`.`crt_name` ".
" FROM `orgdomaincerts` AS `dc` ".
- " WHERE `dc`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
+ " WHERE `dc`.`revoked`=0 AND `dc`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
$sth_certs->execute();
$sth_userdata = $dbh->prepare(
@@ -137,7 +137,7 @@ $sth_certs->finish();
$sth_certs = $dbh->prepare(
"SELECT `ec`.`orgid`, `ec`.`CN`, `ec`.`expire`, `ec`.`crt_name` ".
" FROM `orgemailcerts` AS `ec` ".
- " WHERE `ec`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
+ " WHERE `ec`.`revoked`=0 AND `ec`.`expire` > DATE_ADD(NOW(), INTERVAL 14 DAY)");
$sth_certs->execute();
$sth_userdata = $dbh->prepare(