summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorpjmattal <pjmattal>2005-07-28 18:08:17 +0200
committerpjmattal <pjmattal>2005-07-28 18:08:17 +0200
commit05d398e07cfb26b4a9f14df4a3bce4d28ea9e137 (patch)
tree69af52d7d51a79716a8836a76fe9b552ee43e74b
parent25d3f782885264063c4070de5fb72cb959b30b36 (diff)
downloadaur-05d398e07cfb26b4a9f14df4a3bce4d28ea9e137.tar.gz
aur-05d398e07cfb26b4a9f14df4a3bce4d28ea9e137.tar.xz
closes #2992 (Added last 7 days update count)
-rw-r--r--web/html/index.php15
-rw-r--r--web/lang/en/index_po.inc2
2 files changed, 16 insertions, 1 deletions
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