summaryrefslogtreecommitdiffstats
path: root/weblog-adhocquery-html.lsp
diff options
context:
space:
mode:
authorTed Trask <ttrask01@yahoo.com>2009-09-04 14:55:05 +0000
committerTed Trask <ttrask01@yahoo.com>2009-09-04 14:55:05 +0000
commit8044a8225aa46c9cb7cbc39920fabf5edd782b59 (patch)
treecad598daf9b6b25f23e22dade5890ed488a24504 /weblog-adhocquery-html.lsp
parent138ae855953c6ba7dadd62a092d53feb46777579 (diff)
downloadacf-weblog-8044a8225aa46c9cb7cbc39920fabf5edd782b59.tar.bz2
acf-weblog-8044a8225aa46c9cb7cbc39920fabf5edd782b59.tar.xz
Added code to display short reason from DG log and shorten URI and fixed bug with empty reason. Bumped to 0.4.0v0.4.0
Required new shortreason field in several tables which breaks backward compatibility. Full reason and full URI available by hovering.
Diffstat (limited to 'weblog-adhocquery-html.lsp')
-rw-r--r--weblog-adhocquery-html.lsp5
1 files changed, 3 insertions, 2 deletions
diff --git a/weblog-adhocquery-html.lsp b/weblog-adhocquery-html.lsp
index 538bd54..c581fbe 100644
--- a/weblog-adhocquery-html.lsp
+++ b/weblog-adhocquery-html.lsp
@@ -28,7 +28,7 @@ This form accepts a Postgresql SELECT statement and displays the results. Exampl
</ul>
The available database tables and descriptions are as follows:<br>
<H3>PubWeblog and PubBlocklog</H3>
-These tables contain the combined squid access log and dansguardian log for every access and blocked accesses respectively. The definition of the table is as follows:
+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>
(
sourcename character varying(40),
@@ -38,7 +38,8 @@ These tables contain the combined squid access log and dansguardian log for ever
uri text NOT NULL,
bytes integer NOT NULL,
reason text,
- score integer
+ score integer,
+ shortreason text
)
</pre>
<H3>dbHistLog</H3>