diff options
| author | Rob Stradling <rob@comodo.com> | 2017-01-17 18:12:25 +0000 |
|---|---|---|
| committer | Rob Stradling <rob@comodo.com> | 2017-01-17 18:12:25 +0000 |
| commit | 90bf874145a21d1cc6ebd2adbf9c651db1d0fd3c (patch) | |
| tree | 8934f0bc144ec3ef0da8ccab98f618156f5b4fdc | |
| parent | 8d3ec41ad0996da9a257a4010832c5368a723f38 (diff) | |
| download | certwatch_db-90bf874145a21d1cc6ebd2adbf9c651db1d0fd3c.zip certwatch_db-90bf874145a21d1cc6ebd2adbf9c651db1d0fd3c.tar.gz certwatch_db-90bf874145a21d1cc6ebd2adbf9c651db1d0fd3c.tar.bz2 | |
Show Root Owner on lint issue reports.
| -rw-r--r-- | web_apis.fnc | 23 |
1 files changed, 21 insertions, 2 deletions
diff --git a/web_apis.fnc b/web_apis.fnc index 5dfdd96..2aa6710 100644 --- a/web_apis.fnc +++ b/web_apis.fnc @@ -3584,12 +3584,24 @@ Content-Type: application/json <TD>'; END IF; IF l_record.ISSUER_CA_ID IS NOT NULL THEN - t_text := t_text || '<A href="?caid=' || l_record.ISSUER_CA_ID::text || t_opt || '">' + t_text := t_text || '<A style="white-space:normal" href="?caid=' || l_record.ISSUER_CA_ID::text || t_opt || '">' || coalesce(html_escape(l_record.ISSUER_NAME), ' ') || '</A>'; ELSE t_text := t_text || coalesce(html_escape(l_record.ISSUER_NAME), '?'); END IF; + IF lower(t_type) LIKE '%lint' THEN + SELECT md.INCLUDED_CERTIFICATE_OWNER + INTO t_temp + FROM ca_certificate cac, mozilla_disclosure md + WHERE cac.CA_ID = l_record.ISSUER_CA_ID + AND cac.CERTIFICATE_ID = md.CERTIFICATE_ID + GROUP BY md.INCLUDED_CERTIFICATE_OWNER + ORDER BY count(*) DESC + LIMIT 1; + t_text := t_text || '</TD> + <TD>' || coalesce(t_temp, ' '); + END IF; t_text := t_text || '</TD> </TR> '; @@ -3708,7 +3720,14 @@ Content-Type: application/atom+xml END IF; t_output := t_output || ' </TH> - </TR> +'; + IF lower(t_type) LIKE '%lint' THEN + t_output := t_output || +' <TH>Root Owner (Mozilla)</TH> +'; + END IF; + t_output := t_output || +' </TR> ' || t_text || '</TABLE> '; |