diff -r 000000000000 -r 1090e2141798 org/sonews/util/Stats.java
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/org/sonews/util/Stats.java	Wed Jul 01 10:48:22 2009 +0200
@@ -0,0 +1,194 @@
+/*
+ *   SONEWS News Server
+ *   see AUTHORS for the list of contributors
+ *
+ *   This program is free software: you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation, either version 3 of the License, or
+ *   (at your option) any later version.
+ *
+ *   This program is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package org.sonews.util;
+
+import java.sql.SQLException;
+import java.util.Calendar;
+import org.sonews.daemon.storage.Database;
+import org.sonews.daemon.storage.Group;
+
+/**
+ * Class that capsulates statistical data gathering.
+ * @author Christian Lins
+ * @since sonews/0.5.0
+ */
+public final class Stats 
+{
+      
+  public static final byte CONNECTIONS    = 1;
+  public static final byte POSTED_NEWS    = 2;
+  public static final byte GATEWAYED_NEWS = 3;
+  public static final byte FEEDED_NEWS    = 4;
+  public static final byte MLGW_RUNSTART  = 5;
+  public static final byte MLGW_RUNEND    = 6;
+
+  private static Stats instance = new Stats();
+  
+  public static Stats getInstance()
+  {
+    return Stats.instance;
+  }
+  
+  private Stats() {}
+  
+  private volatile int connectedClients = 0;
+  
+  private void addEvent(byte type, String groupname)
+  {
+    Group group = Group.getByName(groupname);
+    if(group != null)
+    {
+      try
+      {
+        Database.getInstance().addEvent(
+          System.currentTimeMillis(), type, group.getID());
+      }
+      catch(SQLException ex)
+      {
+        ex.printStackTrace();
+      }
+    }
+    else
+    {
+      Log.msg("Group " + groupname + " does not exist.", true);
+    }
+  }
+  
+  public void clientConnect()
+  {
+    this.connectedClients++;
+  }
+  
+  public void clientDisconnect()
+  {
+    this.connectedClients--;
+  }
+  
+  public int connectedClients()
+  {
+    return this.connectedClients;
+  }
+  
+  public int getNumberOfGroups()
+  {
+    try
+    {
+      return Database.getInstance().countGroups();
+    }
+    catch(SQLException ex)
+    {
+      ex.printStackTrace();
+      return -1;
+    }
+  }
+  
+  public int getNumberOfNews()
+  {
+    try
+    {
+      return Database.getInstance().countArticles();
+    }
+    catch(SQLException ex)
+    {
+      ex.printStackTrace();
+      return -1;
+    }
+  }
+  
+  public int getYesterdaysEvents(final byte eventType, final int hour,
+    final Group group)
+  {
+    // Determine the timestamp values for yesterday and the given hour
+    Calendar cal = Calendar.getInstance();
+    int year  = cal.get(Calendar.YEAR);
+    int month = cal.get(Calendar.MONTH);
+    int dayom = cal.get(Calendar.DAY_OF_MONTH) - 1; // Yesterday
+    
+    cal.set(year, month, dayom, hour, 0, 0);
+    long startTimestamp = cal.getTimeInMillis();
+    
+    cal.set(year, month, dayom, hour + 1, 0, 0);
+    long endTimestamp = cal.getTimeInMillis();
+    
+    try
+    {
+      return Database.getInstance()
+        .getEventsCount(eventType, startTimestamp, endTimestamp, group);
+    }
+    catch(SQLException ex)
+    {
+      ex.printStackTrace();
+      return -1;
+    }
+  }
+  
+  public void mailPosted(String groupname)
+  {
+    addEvent(POSTED_NEWS, groupname);
+  }
+  
+  public void mailGatewayed(String groupname)
+  {
+    addEvent(GATEWAYED_NEWS, groupname);
+  }
+  
+  public void mailFeeded(String groupname)
+  {
+    addEvent(FEEDED_NEWS, groupname);
+  }
+  
+  public void mlgwRunStart()
+  {
+    addEvent(MLGW_RUNSTART, "control");
+  }
+  
+  public void mlgwRunEnd()
+  {
+    addEvent(MLGW_RUNEND, "control");
+  }
+  
+  private double perHour(int key, long gid)
+  {
+    try
+    {
+      return Database.getInstance().getNumberOfEventsPerHour(key, gid);
+    }
+    catch(SQLException ex)
+    {
+      ex.printStackTrace();
+      return -1;
+    }
+  }
+  
+  public double postedPerHour(long gid)
+  {
+    return perHour(POSTED_NEWS, gid);
+  }
+  
+  public double gatewayedPerHour(long gid)
+  {
+    return perHour(GATEWAYED_NEWS, gid);
+  }
+  
+  public double feededPerHour(long gid)
+  {
+    return perHour(FEEDED_NEWS, gid);
+  }
+  
+}