Change proposed during review
authorBernhard Fröhlich <bernhard@cacert.org>
Sun, 1 Sep 2013 15:28:33 +0000 (17:28 +0200)
committerBernhard Fröhlich <bernhard@cacert.org>
Sun, 1 Sep 2013 15:28:33 +0000 (17:28 +0200)
includes/notary.inc.php

index 571d73b..24d152a 100644 (file)
                $mailid = intval($mailid);
                $query = "select `emailcerts`.`id`
                        from `emaillink`,`emailcerts` where
-                       `emailid`='$mailid' and `emaillink`.`emailcertsid`=`emailcerts`.`id` and `revoked`=0
+                       `emaillink`.`emailid`='$mailid' and `emaillink`.`emailcertsid`=`emailcerts`.`id` and `emailcerts`.`revoked`=0
                        group by `emailcerts`.`id`";
                $dres = mysql_query($query);
                while($drow = mysql_fetch_assoc($dres)){