added safe packages count in the statistics frame

3 files changed, 16 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>";
diff --git a/web/lang/en/index_po.inc b/web/lang/en/index_po.inc
index 7cc0c1c..0d26e56 100644
--- a/web/lang/en/index_po.inc
+++ b/web/lang/en/index_po.inc
@@ -73,6 +73,8 @@ $_t["en"]["Trusted Users"] = "Trusted Users";
 
 $_t["en"]["Packages in unsupported"] = "Packages in unsupported";
 
+$_t["en"]["Packages in unsupported and flagged as safe"] = "Packages in unsupported and flagged as safe";
+
 $_t["en"]["Packages in [community]"] = "Packages in [community]";
 
 $_t["en"]["Remember to vote for your favourite packages! The most popular packages are provided as binary packages in [community]."] = "Remember to vote for your favourite packages! The most popular packages are provided as binary packages in [community].";
diff --git a/web/lang/pl/index_po.inc b/web/lang/pl/index_po.inc
index e5fdff9..ac6ab2c 100644
--- a/web/lang/pl/index_po.inc
+++ b/web/lang/pl/index_po.inc
@@ -40,6 +40,8 @@ $_t["pl"]["Remember to vote for your favourite packages!"] = "Nie zapomnij głos
 
 $_t["pl"]["Packages in unsupported"] = "Pakietów w unsupported";
 
+$_t["pl"]["Packages in unsupported and flagged as safe"] = "Pakietów w unsupported oznaczonych jako bezpieczne";
+
 $_t["pl"]["The most popular packages will be provided as binary packages in [community]."] = "Najbardziej popularne pakiety zostaną umieszczone w formie binarnej w [community].";
 
 $_t["pl"]["Trusted Users"] = "Zaufanych Użytkowników";