From 562f4dd00159654246e80dd0c094680036ca7687 Mon Sep 17 00:00:00 2001
From: Mika Havela <mika.havela@gmail.com>
Date: Fri, 9 Oct 2009 10:51:45 +0200
Subject: Graphical fix. Suggestion on how to solve the <DL> issue with various
 skins.\n Also suggesting use <H1> as subheading for the example
 tables/descriptions on the page.

---
 weblog-adhocquery-html.lsp | 7 ++-----
 1 file changed, 2 insertions(+), 5 deletions(-)

diff --git a/weblog-adhocquery-html.lsp b/weblog-adhocquery-html.lsp
index d7aee5c..17ee021 100644
--- a/weblog-adhocquery-html.lsp
+++ b/weblog-adhocquery-html.lsp
@@ -43,20 +43,17 @@ require("viewfunctions")
 <% end %>
 
 <H1><%= html.html_escape(form.label) %></H1>
+<% displayformstart(form, page_info) %>
 This form accepts a Postgresql SELECT statement and displays the results. Examples:
 <ul>
 <li>This statement will return the total bytes transferred by each user for the entire weblog history<pre>SELECT clientuserid, sum(bytes) AS total FROM pubweblog GROUP BY clientuserid ORDER BY total DESC</pre>
 <li>This statement limits the above statement to a specific range of dates (just yesterday)<pre>SELECT clientuserid, sum(bytes) AS total FROM pubweblog WHERE logdatetime >= 'yesterday' and logdatetime < 'today' GROUP BY clientuserid ORDER BY total DESC</pre>
 <li>This statement will return the number of requests and blocks by hour over the course of the entire usage history<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>
-<% displayformstart(form, page_info) %>
-<DL>
 <% displayformitem(form.value.query, "query") %>
-</DL>
 <% displayformend(form) %>
 
-<br>
-The available database tables and descriptions are as follows:
+<H1>The available database tables and descriptions are as follows</H1>
 <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:
-- 
cgit v1.2.3