bug 976: Typo and masking bug-976
authorMichael Tänzer <neo@nhng.de>
Sun, 6 Nov 2011 15:42:44 +0000 (16:42 +0100)
committerMichael Tänzer <neo@nhng.de>
Sun, 6 Nov 2011 15:42:44 +0000 (16:42 +0100)
`oemail` masks `orgemailcerts` so that won't work anymore

Signed-off-by: Michael Tänzer <neo@nhng.de>
pages/account/18.php

index b5ec08e..13dcc30 100644 (file)
                        UNIX_TIMESTAMP(`oemail`.`expire`) as `expired`,
                        `oemail`.`expire` as `expires`, `oemail`.`revoked` as `revoke`,
                        UNIX_TIMESTAMP(`oemail`.`revoked`) as `revoked`,
-                       `oemail`.`CN`, `oemail`.`serial`, `oeamil`.`id`
+                       `oemail`.`CN`, `oemail`.`serial`, `oemail`.`id`
                        from `orgemailcerts` as `oemail`, `org`
                        where `org`.`memid`='".intval($_SESSION['profile']['id'])."' and
-                               `org`.`orgid`=`orgemailcerts`.`orgid` ";
+                               `org`.`orgid`=`oemail`.`orgid` ";
        if($viewall != 1)
        {
                $query .= "AND `oemail`.`revoked`=0 AND `oemail`.`renewed`=0 ";