diff options
author | Bernhard Fröhlich <bernhard@cacert.org> | 2011-09-19 23:32:35 +0200 |
---|---|---|
committer | Bernhard Fröhlich <bernhard@cacert.org> | 2011-09-19 23:32:35 +0200 |
commit | aca0ac8f5998232a82a0ec8fe97fbff20f45ecd0 (patch) | |
tree | e2cc656f1cb9cafeb8d16498956a2db8f3dc57c0 /pages/account | |
parent | 1ca33e5eb5b678767d7cbcef5d55b758b7c71452 (diff) | |
download | cacert-devel-aca0ac8f5998232a82a0ec8fe97fbff20f45ecd0.tar.gz cacert-devel-aca0ac8f5998232a82a0ec8fe97fbff20f45ecd0.tar.xz cacert-devel-aca0ac8f5998232a82a0ec8fe97fbff20f45ecd0.zip |
Backticks and last expiry of email certs
Diffstat (limited to 'pages/account')
-rw-r--r-- | pages/account/43.php | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/pages/account/43.php b/pages/account/43.php index 425add5..1ecc25e 100644 --- a/pages/account/43.php +++ b/pages/account/43.php @@ -324,13 +324,13 @@ // list total, expired, deleted, latest_expire_date ? - $query = "select COUNT(domaincerts.id) as countdomaincerts from `domains` inner join `domaincerts` on `domaincerts`.`domid` = `domains`.`id` where `memid`='".intval($row['id'])."' "; + $query = "select COUNT(`domaincerts`.`id`) as `countdomaincerts` from `domains` inner join `domaincerts` on `domaincerts`.`domid` = `domains`.`id` where `memid`='".intval($row['id'])."' "; $dres = mysql_query($query); $drow = mysql_fetch_assoc($dres); $rctotal = $drow['countdomaincerts']; if($rctotal > 0) { // select domid's - $query = "select id as domids from `domains` where `memid`='".intval($row['id'])."' "; + $query = "select `id` as `domids` from `domains` where `memid`='".intval($row['id'])."' "; $dres = mysql_query($query); $rcexpired = 0; $rcrevoked = 0; @@ -338,18 +338,18 @@ while ($drow = mysql_fetch_assoc($dres)) { $ndomid = intval($drow['domids']); - $query2 = "select COUNT(id) as dexpired from `domaincerts` where `domid`='".$ndomid."' and revoked = '0000-00-00 00:00:00' and expire < now() "; + $query2 = "select COUNT(`id`) as `dexpired` from `domaincerts` where `domid`='".$ndomid."' and `revoked` = '0000-00-00 00:00:00' and `expire` < now() "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcexpired += intval($drow2['dexpired']); - $query2 = "select COUNT(id) as drevoked from `domaincerts` where `domid`='".$ndomid."' and revoked != '0000-00-00 00:00:00' "; + $query2 = "select COUNT(`id`) as `drevoked` from `domaincerts` where `domid`='".$ndomid."' and `revoked` != '0000-00-00 00:00:00' "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcrevoked += intval($drow2['drevoked']); // For Arbitration purpose expiry dates of revoked certs are also relevant! - $query2 = "select expire as mexpire from `domaincerts` where `domid`='".$ndomid."' order by expire desc "; + $query2 = "select `expire` as `mexpire` from `domaincerts` where `domid`='".$ndomid."' order by `expire` desc "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcexpiremax = max($rcexpiremax,$drow2['mexpire']); @@ -388,7 +388,7 @@ </tr> <? } - $query = "select COUNT(id) as countemailcerts from `emailcerts` where `memid`='".intval($row['id'])."' "; + $query = "select COUNT(`id`) as `countemailcerts` from `emailcerts` where `memid`='".intval($row['id'])."' "; $dres = mysql_query($query); $drow = mysql_fetch_assoc($dres); $rctotal = $drow['countemailcerts']; @@ -397,17 +397,17 @@ $rcrevoked = 0; $rcexpiremax = "0000-00-00 00:00:00"; - $query2 = "select COUNT(id) as eexpired from `emailcerts` where `memid`='".intval($row['id'])."' and revoked = '0000-00-00 00:00:00' and expire < now() "; + $query2 = "select COUNT(`id`) as `eexpired` from `emailcerts` where `memid`='".intval($row['id'])."' and `revoked` = '0000-00-00 00:00:00' and `expire` < now() "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcexpired = intval($drow2['dexpired']); - $query2 = "select COUNT(id) as erevoked from `emailcerts` where `memid`='".intval($row['id'])."' and revoked != '0000-00-00 00:00:00' "; + $query2 = "select COUNT(`id`) as `erevoked` from `emailcerts` where `memid`='".intval($row['id'])."' and `revoked` != '0000-00-00 00:00:00' "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcrevoked = intval($drow2['erevoked']); - $query2 = "select expire as eexpire from `emailcerts` where `memid`='".intval($row['id'])."' and revoked = '0000-00-00 00:00:00' order by expire desc "; + $query2 = "select `expire` as `eexpire` from `emailcerts` where `memid`='".intval($row['id'])."' order by `expire` desc "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcexpiremax = $drow2['eexpire']; @@ -429,7 +429,7 @@ <td colspan="5" class="DataTD"><?=_("None")?></td> </tr> <? } - $query = "select COUNT(id) as countgpgcerts from `gpg` where `memid`='".intval($row['id'])."' "; + $query = "select COUNT(`id`) as `countgpgcerts` from `gpg` where `memid`='".intval($row['id'])."' "; $dres = mysql_query($query); $drow = mysql_fetch_assoc($dres); $rctotal = $drow['countgpgcerts']; @@ -437,19 +437,19 @@ $rcexpired = 0; $rcexpiremax = "0000-00-00 00:00:00"; - $query2 = "select COUNT(id) as gexpired from `gpg` where `memid`='".intval($row['id'])."' and expire < now() "; + $query2 = "select COUNT(`id`) as `gexpired` from `gpg` where `memid`='".intval($row['id'])."' and `expire` < now() "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcexpired = intval($drow2['gexpired']); /* - $query2 = "select COUNT(id) as erevoked from `gpg` where `memid`='".intval($row['id'])."' and revoked != '0000-00-00 00:00:00' "; + $query2 = "select COUNT(`id`) as `erevoked` from `gpg` where `memid`='".intval($row['id'])."' and `revoked` != '0000-00-00 00:00:00' "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcrevoked = intval($drow2['erevoked']); */ - $query2 = "select expire as gexpire from `gpg` where `memid`='".intval($row['id'])."' order by expire desc "; + $query2 = "select `expire` as `gexpire` from `gpg` where `memid`='".intval($row['id'])."' order by `expire` desc "; $dres2 = mysql_query($query2); $drow2 = mysql_fetch_assoc($dres2); $rcexpiremax = $drow2['gexpire']; |