From 8c6ab52c7e324c7ddc4997846ea5900ae2215e41 Mon Sep 17 00:00:00 2001
From: Othmar Gsenger <otti@wirdorange.org>
Date: Thu, 17 Jan 2013 21:26:21 +0000
Subject: added download counter

---
 local/db.pm | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'local/db.pm')

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';
-- 
cgit v1.2.3