diff options
| author | Bernhard Fröhlich <bernhard@cacert.org> | 2011-03-29 21:32:34 +0200 |
|---|---|---|
| committer | Bernhard Fröhlich <bernhard@cacert.org> | 2011-03-29 21:32:34 +0200 |
| commit | ab74a1333cb130bdb19f4fddd6f96c55d1473234 (patch) | |
| tree | 38e8e274f60a983f80d3c8b1ce7912f21505ad90 | |
| parent | a706b59b4c033466916a923264ac12e1c164a432 (diff) | |
| download | cacert-devel-ab74a1333cb130bdb19f4fddd6f96c55d1473234.tar.gz cacert-devel-ab74a1333cb130bdb19f4fddd6f96c55d1473234.tar.xz cacert-devel-ab74a1333cb130bdb19f4fddd6f96c55d1473234.zip | |
Added restriction "revoked=0" to cert queries
| -rwxr-xr-x | scripts/DumpWeakCerts.pl | 8 |
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( |