added safe packages count in the statistics frame

1 files changed, 12 insertions, 0 deletions

diff --git a/web/html/index.php b/web/html/index.php
index 1d5428f..01c7b2d 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -209,6 +209,11 @@ $result = db_query($q, $dbh);
 $row = mysql_fetch_row($result);
 $update_count = $row[0];
 
+$q = "SELECT count(*) FROM Packages,PackageLocations WHERE Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported' AND Packages.Safe = 1";
+$result = db_query($q, $dbh);
+$row = mysql_fetch_row($result);
+$safe_count = $row[0];
+
 print "<table class='boxSoft'>";
 
 print "<tr>";
@@ -226,6 +231,13 @@ print "</tr>";
 
 print "<tr>";
 print "<td class='boxSoft'>";
+print "<span class='f4'>".__("Packages in unsupported and flagged as safe")."</span>";
+print "</td>";
+print "<td class='boxSoft'><span class='f4'>$safe_count</span></td>";
+print "</tr>";
+
+print "<tr>";
+print "<td class='boxSoft'>";
 print "<span class='f4'>".__("Packages in [community]")."</span>";
 print "</td>";
 print "<td class='boxSoft'><span class='f4'>$community_count</span></td>";