Expiry dates of revoked certificates count as well for "Latest Expire"
authorBernhard Fröhlich <bernhard@cacert.org>
Mon, 19 Sep 2011 21:03:31 +0000 (23:03 +0200)
committerBernhard Fröhlich <bernhard@cacert.org>
Mon, 19 Sep 2011 21:03:31 +0000 (23:03 +0200)
pages/account/43.php

index 0d9ec11..425add5 100644 (file)
       $drow2  = mysql_fetch_assoc($dres2);
       $rcrevoked += intval($drow2['drevoked']);
 
-      $query2 = "select expire as mexpire  from `domaincerts` where `domid`='".$ndomid."' and revoked = '0000-00-00 00:00:00' order by expire desc ";
+      // 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 ";
       $dres2  = mysql_query($query2);
       $drow2  = mysql_fetch_assoc($dres2);
       $rcexpiremax = max($rcexpiremax,$drow2['mexpire']);      
 ?>
 <table align="center" valign="middle" border="0" cellspacing="0" cellpadding="0" class="wrapper">
   <tr>
-    <td colspan="6" class="title"><?=_("Total Certificates State")?></td>
+    <td colspan="6" class="title"><?=_("Total Certificates Status")?></td>
   </tr>
 
   <tr>