From 878989065d9e92ab74ad310eca886323178d44f0 Mon Sep 17 00:00:00 2001
From: Mika Havela <mika.havela@gmail.com>
Date: Wed, 7 Oct 2009 16:42:53 +0200
Subject: Graphical fix. Modifying <DL> to fix skin issues.\n Removing
 hardcoded backgroundcolor from table and using class=header instead to have
 the skins do the choosing of colors.

---
 weblog-adhocquery-html.lsp | 26 +++++++++++++++-----------
 1 file changed, 15 insertions(+), 11 deletions(-)

(limited to 'weblog-adhocquery-html.lsp')

diff --git a/weblog-adhocquery-html.lsp b/weblog-adhocquery-html.lsp
index b55fc4d..e1c79f2 100644
--- a/weblog-adhocquery-html.lsp
+++ b/weblog-adhocquery-html.lsp
@@ -4,30 +4,29 @@ require("viewfunctions")
 
 <% if form.value.result then %>
 <H1><%= html.html_escape(form.value.result.label) %></H1>
+<DL>
 <% require("html") %>
 <%= html.cfe_unpack(form.value.result.value) %>
 <form action="/cgi-bin/acf/weblog/weblog/downloadadhocquery" method="POST">
 <input class="hidden" type="hidden"  name="query"  value="<%= html.html_escape(form.value.query.value) %>" >
-<DL>
 <DT>Download query result</DT><DD><input class="submit" type="submit" name="Download" value="Download"></DD>
-</DL>
 </FORM>
+</DL>
 <% end %>
 
 <H1><%= html.html_escape(form.label) %></H1>
 <% displayformstart(form, page_info) %>
-<DL>
 <% displayformitem(form.value.query, "query") %>
-</DL>
-<% displayformend(form) %>
-
 This form accepts a Postgresql SELECT statement and displays the results. Examples:
 <ul>
 <li><pre>SELECT clientuserid, sum(bytes) AS total FROM weblog GROUP BY clientuserid ORDER BY total DESC</pre>
 <li><pre>SELECT extract(hour from date) AS hour, sum(numrequest) AS numrequest, sum(numblock) AS numblock FROM usagestat GROUP BY extract(hour from date) ORDER BY hour</pre>
 </ul>
 The available database tables and descriptions are as follows:<br>
+<% displayformend(form) %>
+
 <H3>PubWeblog and PubBlocklog</H3>
+<DL>
 These tables contain the combined squid access log and dansguardian log for every access and blocked access respectively. The definition of the table is as follows:
 <pre>
 (
@@ -41,16 +40,19 @@ These tables contain the combined squid access log and dansguardian log for ever
     score integer,
     shortreason text
 )
-</pre>
+</pre></DL>
 <H3>dbHistLog</H3>
+<DL>
 This table contains the database history, including such information as which log files were loaded and how many entries they contained. The definition of the table is as follows:
 <pre>
 (
     logdatetime timestamp(3) without time zone NOT NULL,
     msgtext text
 )
-</pre>
+</pre></DL>
+
 <H3>Source</H3>
+<DL>
 This table contains the list of log file sources. The definition of the table is as follows:
 <pre>
 (
@@ -62,8 +64,9 @@ This table contains the list of log file sources. The definition of the table is
     tzislocal boolean,
     enabled boolean
 )
-</pre>
+</pre></DL>
 <H3>Usagestat</H3>
+<DL>
 This table contains a historical record of pages requested and blocked by hour. The definition of the table is as follows:
 <pre>
 (
@@ -72,12 +75,13 @@ This table contains a historical record of pages requested and blocked by hour.
     numrequest integer,
     numblock integer
 )
-</pre>
+</pre></DL>
 <H3>Watchlist</H3>
+<DL>
 This table contains the user watch list. The definition of the table is as follows:
 <pre>
 (
     clientuserid character varying(64) NOT NULL,
     expiredatetime timestamp(0) without time zone NOT NULL
 )
-</pre>
+</pre></DL>
-- 
cgit v1.2.3