From d316742b43ca8a0b9e4e46090af9b078aa19f0a1 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Bernhard=20Fr=C3=B6hlich?= Date: Tue, 6 Sep 2011 23:57:43 +0200 Subject: Changes proposed by moh / Uli on https://bugs.cacert.org/view.php?id=596 --- pages/account/5.php | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/pages/account/5.php b/pages/account/5.php index ee500c0..5c131ba 100644 --- a/pages/account/5.php +++ b/pages/account/5.php @@ -19,12 +19,13 @@
- + + @@ -38,6 +39,7 @@ UNIX_TIMESTAMP(`emailcerts`.`revoked`) as `revoked`, `emailcerts`.`id`, `emailcerts`.`CN`, + `emailcerts`.`serial`, emailcerts.disablelogin as `disablelogin` from `emailcerts` where `emailcerts`.`memid`='".$_SESSION['profile']['id']."' @@ -54,7 +56,7 @@ { ?> - + +
- -
-- cgit v1.2.1 From 93c32cf1f508bedd509ccc6fd2c64799b5a97eee Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Bernhard=20Fr=C3=B6hlich?= Date: Wed, 14 Sep 2011 23:59:59 +0200 Subject: Changes by moh for other certificate types --- pages/account/12.php | 10 ++++++---- pages/account/18.php | 10 ++++++---- pages/account/22.php | 12 ++++++++---- 3 files changed, 20 insertions(+), 12 deletions(-) mode change 100644 => 100755 pages/account/22.php diff --git a/pages/account/12.php b/pages/account/12.php index 40135be..44926ca 100644 --- a/pages/account/12.php +++ b/pages/account/12.php @@ -19,12 +19,13 @@ - + + @@ -33,7 +34,7 @@ UNIX_TIMESTAMP(`domaincerts`.`expire`) - UNIX_TIMESTAMP() as `timeleft`, UNIX_TIMESTAMP(`domaincerts`.`expire`) as `expired`, `domaincerts`.`expire` as `expires`, `revoked` as `revoke`, - UNIX_TIMESTAMP(`revoked`) as `revoked`, `CN`, `domaincerts`.`id` as `id` + UNIX_TIMESTAMP(`revoked`) as `revoked`, `CN`, `domaincerts`.`serial`, `domaincerts`.`id` as `id` from `domaincerts`,`domains` where `memid`='".intval($_SESSION['profile']['id'])."' and `deleted`=0 and `domaincerts`.`domid`=`domains`.`id` "; if($viewall != 1) @@ -48,7 +49,7 @@ { ?> - + + - diff --git a/pages/account/18.php b/pages/account/18.php index 5ee1a3b..47fac9e 100644 --- a/pages/account/18.php +++ b/pages/account/18.php @@ -19,12 +19,13 @@
- -
">     + ">     ">
- + + @@ -33,7 +34,7 @@ UNIX_TIMESTAMP(`expire`) - UNIX_TIMESTAMP() as `timeleft`, UNIX_TIMESTAMP(`expire`) as `expired`, `expire` as `expires`, `revoked` as `revoke`, - UNIX_TIMESTAMP(`revoked`) as `revoked`, `CN`, `id` + UNIX_TIMESTAMP(`revoked`) as `revoked`, `CN`, `serial`, `id` from `orgemailcerts`, `org` where `memid`='".intval($_SESSION['profile']['id'])."' and `org`.`orgid`=`orgemailcerts`.`orgid` "; @@ -48,7 +49,7 @@ { ?> - + + - diff --git a/pages/account/22.php b/pages/account/22.php old mode 100644 new mode 100755 index 565cb5f..9df8200 --- a/pages/account/22.php +++ b/pages/account/22.php @@ -19,12 +19,13 @@
- -
">     + ">     ">
- + + @@ -33,7 +34,9 @@ UNIX_TIMESTAMP(`orgdomaincerts`.`expire`) - UNIX_TIMESTAMP() as `timeleft`, UNIX_TIMESTAMP(`orgdomaincerts`.`expire`) as `expired`, `orgdomaincerts`.`expire` as `expires`, `revoked` as `revoke`, - UNIX_TIMESTAMP(`revoked`) as `revoked`, `CN`, `orgdomaincerts`.`id` as `id` + UNIX_TIMESTAMP(`revoked`) as `revoked`, `CN`, + `orgdomaincerts`.`serial`, + `orgdomaincerts`.`id` as `id` from `orgdomaincerts`,`org` where `org`.`memid`='".intval($_SESSION['profile']['id'])."' and `orgdomaincerts`.`orgid`=`org`.`orgid` "; if($viewall != 1) @@ -48,7 +51,7 @@ { ?> - + + - -- cgit v1.2.1
- -
">     + ">     ">