summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Tänzer <neo@nhng.de>2013-08-14 21:37:38 +0200
committerMichael Tänzer <neo@nhng.de>2013-08-14 21:37:38 +0200
commitacd4f0f92cc29cd3c622d11fc2f5e61c97401a51 (patch)
treef230024f3ae066ec544b7dd98fc93ca14ce57fad
parent945f334cc612b6f853d926163815f71242ea342a (diff)
downloadcacert-devel-acd4f0f92cc29cd3c622d11fc2f5e61c97401a51.tar.gz
cacert-devel-acd4f0f92cc29cd3c622d11fc2f5e61c97401a51.tar.xz
cacert-devel-acd4f0f92cc29cd3c622d11fc2f5e61c97401a51.zip
bug 893: domaincerts has no column memid, it has to be referenced via domainsbug-893
Signed-off-by: Michael Tänzer <neo@nhng.de>
-rw-r--r--includes/notary.inc.php26
1 files changed, 22 insertions, 4 deletions
diff --git a/includes/notary.inc.php b/includes/notary.inc.php
index 819fb0b..2dda1c1 100644
--- a/includes/notary.inc.php
+++ b/includes/notary.inc.php
@@ -993,11 +993,29 @@
// called from includes/account.php if($oldid == 50 && $process != "")
$uid = intval($uid);
if (0==$cca) {
- $query1 = "select 1 from `domaincerts` where `memid`='$uid' and `expire`>NOW() and `revoked`<`created`";
- $query2 = "select 1 from `domaincerts` where `memid`='$uid' and `revoked`>NOW()";
+ $query1 = "
+ select 1 from `domaincerts` join `domains`
+ on `domaincerts`.`domid` = `domains`.`id`
+ where `domains`.`memid` = '$uid'
+ and `domaincerts`.`expire` > NOW()
+ and `domaincerts`.`revoked` < `domaincerts`.`created`";
+ $query2 = "
+ select 1 from `domaincerts` join `domains`
+ on `domaincerts`.`domid` = `domains`.`id`
+ where `domains`.`memid` = '$uid'
+ and `revoked`>NOW()";
}else{
- $query1 = "select 1 from `domaincerts` where `memid`='$uid' and `expire`>(NOW()-90*86400) and `revoked`<`created`";
- $query2 = "select 1 from `domaincerts` where `memid`='$uid' and `revoked`>(NOW()-90*86400)";
+ $query1 = "
+ select 1 from `domaincerts` join `domains`
+ on `domaincerts`.`domid` = `domains`.`id`
+ where `domains`.`memid` = '$uid'
+ and `expire`>(NOW()-90*86400)
+ and `revoked`<`created`";
+ $query2 = "
+ select 1 from `domaincerts` join `domains`
+ on `domaincerts`.`domid` = `domains`.`id`
+ where `domains`.`memid` = '$uid'
+ and `revoked`>(NOW()-90*86400)";
}
$res = mysql_query($query1);
$r1 = mysql_num_rows($res)>0;