summaryrefslogtreecommitdiff
path: root/includes
diff options
context:
space:
mode:
Diffstat (limited to 'includes')
-rw-r--r--includes/temp_functions.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/temp_functions.php b/includes/temp_functions.php
index 86b55c2..127acc6 100644
--- a/includes/temp_functions.php
+++ b/includes/temp_functions.php
@@ -186,7 +186,7 @@ function check_client_cert_running($uid,$cca=0){
$query1 = "select 1 from `emailcerts` where `memid`='$uid' and `expire`>NOW()";
$query2 = "select 1 from `emailcerts` where `memid`='$uid' and `revoked`>NOW()";
}else{
- $query1 = "select 1 from `emailcerts` where `memid`='$uid' and `expire`>(NOW()-90*86400)";
+ $query1 = "select 1 from `emailcerts` where `memid`='$uid' and `expire`>(NOW()-90*86400) and `revoked`<`created`";
$query2 = "select 1 from `emailcerts` where `memid`='$uid' and `revoked`>(NOW()-90*86400)";
}
$res = mysql_query($query1);
@@ -204,7 +204,7 @@ function check_server_cert_running($uid,$cca=0){
$query1 = "select 1 from `domiancerts` where `memid`='$uid' and `expire`>NOW()";
$query2 = "select 1 from `domiancerts` where `memid`='$uid' and `revoked`>NOW()";
}else{
- $query1 = "select 1 from `domiancerts` where `memid`='$uid' and `expire`>(NOW()-90*86400)";
+ $query1 = "select 1 from `domiancerts` where `memid`='$uid' and `expire`>(NOW()-90*86400) and `revoked`<`created`";
$query2 = "select 1 from `domiancerts` where `memid`='$uid' and `revoked`>(NOW()-90*86400)";
}
$res = mysql_query($query1);