diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2009-10-09 09:32:29 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2009-10-09 09:32:29 +0000 |
| commit | c5002b34c1701bc8c31464067e6c90742582d863 (patch) | |
| tree | 4ac7a7bfa7764d322a54e315ee10e88517d34405 | |
| parent | 562f4dd00159654246e80dd0c094680036ca7687 (diff) | |
| download | acf-weblog-c5002b34c1701bc8c31464067e6c90742582d863.tar.bz2 acf-weblog-c5002b34c1701bc8c31464067e6c90742582d863.tar.xz | |
Bumped to 0.4.8v0.4.8
| -rw-r--r-- | Makefile | 2 | ||||
| -rw-r--r-- | weblog-adhocquery-html.lsp | 3 |
2 files changed, 3 insertions, 2 deletions
@@ -1,6 +1,6 @@ APP_NAME=weblog PACKAGE=acf-$(APP_NAME) -VERSION=0.4.7 +VERSION=0.4.8 CRON_FILE=weblogimport diff --git a/weblog-adhocquery-html.lsp b/weblog-adhocquery-html.lsp index 17ee021..002dba3 100644 --- a/weblog-adhocquery-html.lsp +++ b/weblog-adhocquery-html.lsp @@ -50,10 +50,11 @@ This form accepts a Postgresql SELECT statement and displays the results. Exampl <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> +The available database tables and descriptions are listed below. <% displayformitem(form.value.query, "query") %> <% displayformend(form) %> -<H1>The available database tables and descriptions are as follows</H1> +<H2>Available Database Tables</H2> <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: |