From 1ca33e5eb5b678767d7cbcef5d55b758b7c71452 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Bernhard=20Fr=C3=B6hlich?= <bernhard@cacert.org>
Date: Mon, 19 Sep 2011 23:03:31 +0200
Subject: Expiry dates of revoked certificates count as well for "Latest
 Expire"

---
 pages/account/43.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/pages/account/43.php b/pages/account/43.php
index 0d9ec11..425add5 100644
--- a/pages/account/43.php
+++ b/pages/account/43.php
@@ -348,7 +348,8 @@
       $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']);      
@@ -359,7 +360,7 @@
 ?>
 <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>
-- 
cgit v1.2.1