diff options
author | INOPIAE <inopiae@cacert.org> | 2013-01-07 19:38:46 +0100 |
---|---|---|
committer | INOPIAE <inopiae@cacert.org> | 2013-01-07 19:38:46 +0100 |
commit | 2afe862389e80078967ee029b1d8ea2010611f1e (patch) | |
tree | ce6a6fe5911ac5315f6eb31acf2f8777794ecb5d | |
parent | 7e3f7f845eb1112411bdcbe9b5ed1663abf85553 (diff) | |
download | cacert-devel-2afe862389e80078967ee029b1d8ea2010611f1e.tar.gz cacert-devel-2afe862389e80078967ee029b1d8ea2010611f1e.tar.xz cacert-devel-2afe862389e80078967ee029b1d8ea2010611f1e.zip |
bug 893: fixed sql-statement by certificate revokation
-rw-r--r-- | includes/temp_functions.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/temp_functions.php b/includes/temp_functions.php index c1cc96f..4373d46 100644 --- a/includes/temp_functions.php +++ b/includes/temp_functions.php @@ -9,7 +9,7 @@ function account_email_delete($mailid){ $query = "select `emailcerts`.`id` from `emaillink`,`emailcerts` where - emailid`='$mailid' and `emaillink`.`emailcertsid`=`emailcerts`.`id` and + `emailid`='$mailid' and `emaillink`.`emailcertsid`=`emailcerts`.`id` and `revoked`=0 and UNIX_TIMESTAMP(`expire`)-UNIX_TIMESTAMP() > 0 group by `emailcerts`.`id`"; $dres = mysql_query($query); |