From cb63efbfc57bd8c85b76176a6ebcbafd9bc013d5 Mon Sep 17 00:00:00 2001
From: swiergot <swiergot>
Date: Fri, 2 Sep 2005 16:25:59 +0000
Subject: added safe packages count in the statistics frame

---
 web/html/index.php       | 12 ++++++++++++
 web/lang/en/index_po.inc |  2 ++
 web/lang/pl/index_po.inc |  2 ++
 3 files changed, 16 insertions(+)

diff --git a/web/html/index.php b/web/html/index.php
index 1d5428f1..01c7b2de 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>";
@@ -224,6 +229,13 @@ print "</td>";
 print "<td class='boxSoft'><span class='f4'>$unsupported_count</span></td>";
 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>";
diff --git a/web/lang/en/index_po.inc b/web/lang/en/index_po.inc
index 7cc0c1c4..0d26e56c 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 e5fdff97..ac6ab2cf 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";
-- 
cgit v1.2.3-24-g4f1b