From 05d398e07cfb26b4a9f14df4a3bce4d28ea9e137 Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Thu, 28 Jul 2005 16:08:17 +0000
Subject: closes #2992 (Added last 7 days update count)

---
 web/html/index.php       | 15 ++++++++++++++-
 web/lang/en/index_po.inc |  2 ++
 2 files changed, 16 insertions(+), 1 deletion(-)

(limited to 'web')

diff --git a/web/html/index.php b/web/html/index.php
index 56234260..4e9e93f2 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -92,7 +92,7 @@ print __("The most popular packages will be provided as binary packages in [comm
 
 print "<br>\n";
 
-# PACKAGE COUNTS
+# AUR STATISTICS 
 
 $q = "SELECT count(*) FROM Packages,PackageLocations WHERE Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported'";
 $result = db_query($q, $dbh);
@@ -114,6 +114,12 @@ $result = db_query($q, $dbh);
 $row = mysql_fetch_row($result);
 $tu_count = $row[0];
 
+$targstamp = intval(strtotime("-7 days"));
+$q = "SELECT count(*) from Packages WHERE (Packages.SubmittedTS >= $targstamp OR Packages.ModifiedTS >= $targstamp)";
+$result = db_query($q, $dbh);
+$row = mysql_fetch_row($result);
+$update_count = $row[0];
+
 print "<table class='boxSoft'>";
 
 print "<tr>";
@@ -150,6 +156,13 @@ print "</td>";
 print "<td class='boxSoft'><span class='f4'>$tu_count</span></td>";
 print "</tr>";
 
+print "<tr>";
+print "<td class='boxSoft'>";
+print "<span class='f4'>".__("Packages added or updated in the past 7 days")."</span>";
+print "</td>";
+print "<td class='boxSoft'><span class='f4'>$update_count</span></td>";
+print "</tr>";
+
 print "</table>";
 
 #Hey, how about listing the newest pacakges? :D
diff --git a/web/lang/en/index_po.inc b/web/lang/en/index_po.inc
index 6840acf4..7cc0c1c4 100644
--- a/web/lang/en/index_po.inc
+++ b/web/lang/en/index_po.inc
@@ -81,4 +81,6 @@ $_t["en"]["Remember to vote for your favourite packages!"] = "Remember to vote f
 
 $_t["en"]["The most popular packages will be provided as binary packages in [community]."] = "The most popular packages will be provided as binary packages in [community].";
 
+$_t["en"]["Packages added or updated in the past 7 days"] = "Packages added or updated in the past 7 days";
+
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-24-g4f1b