diff options
author | Othmar Gsenger <otti@wirdorange.org> | 2013-01-17 21:26:21 +0000 |
---|---|---|
committer | Othmar Gsenger <otti@wirdorange.org> | 2013-01-17 21:26:21 +0000 |
commit | 8c6ab52c7e324c7ddc4997846ea5900ae2215e41 (patch) | |
tree | b3fefd13baa4a7f9ac87f88e462970361d7af3de /local | |
parent | admin can cancel any download (diff) |
added download counter
Diffstat (limited to 'local')
-rw-r--r-- | local/db.pm | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/local/db.pm b/local/db.pm index dbb5d7d..517eadb 100644 --- a/local/db.pm +++ b/local/db.pm @@ -31,6 +31,8 @@ local::db::seen->table('seen'); local::db::seen->columns(All => qw/seen_id download user/); local::db::seen->has_a(download => 'local::db::download'); local::db::seen->has_a(user => 'local::db::owner'); +local::db::seen->set_sql(count_download => qq{ SELECT COUNT(user) as dlcount ,download FROM seen GROUP BY download }); + package local::db::ip; use base 'local::db::dbi'; |