diff options
Diffstat (limited to 'web/html')
-rw-r--r-- | web/html/index.php | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/web/html/index.php b/web/html/index.php index 5623426..4e9e93f 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 |