From a9837329d697a9e18401309a1496cc3b5015bc6a Mon Sep 17 00:00:00 2001
From: eliott <eliott@cactuswax.net>
Date: Sat, 17 Nov 2007 00:01:58 -0800
Subject: Hand diff of simo's patch to remove flag safe functionality.

Simo's original commit text:
 The idea of safe flagging is unclear, poorly named, misunderstood,
 and not even used. At the time this patch was created, less than
 a third of the packages in unsupported were flagged safe, and less
 than a tenth of users knew how to interpret it.

 The safe flag has been replaced by a disclaimer on the main page.
---
 web/html/index.php | 37 +------------------------------------
 1 file changed, 1 insertion(+), 36 deletions(-)

(limited to 'web/html/index.php')

diff --git a/web/html/index.php b/web/html/index.php
index b379d4d..854c32c 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -210,11 +210,6 @@ $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];
-
 # Added the user statistcs.
 # Added by: dsa <dsandrade@gmail.com>
 $user = username_from_sid($_COOKIE["AURSID"]);
@@ -270,30 +265,6 @@ if (!empty($user)) {
     print "</td>";
     print "<td class='boxSoft'><span class='f4'>$flagged_outdated</span></td>";
     print "</tr>";    
-    
-    # Number of safe packages
-    print "<tr>";
-    print "<td class='boxSoft'>";
-    if ($atype == 'Trusted User' || $atype == 'Developer') {
-	$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.VerifiedBy = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
-	$result = db_query($q, $dbh);
-	$row = mysql_fetch_row($result);
-	$flagged_safe = $row[0];
-
-	print "<span class='f4'>".__("Flagged as safe by me")."</span>";
-    }
-    else
-    {
-	$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
-	$result = db_query($q, $dbh);
-	$row = mysql_fetch_row($result);
-	$flagged_safe = $row[0];
-
-	print "<span class='f4'>".__("Flagged as safe")."</span>";
-    }
-    print "</td>";
-    print "<td class='boxSoft'><span class='f4'>$flagged_safe</span></td>";
-    print "</tr>"; 
         
     print "</table><br />";
 }
@@ -313,13 +284,6 @@ 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>";
@@ -356,6 +320,7 @@ print "</tr>\n";
 print "</table>\n";
 echo "</div>\n";
 # End Table 1
+echo "<span class='f4'>".__("DISCLAIMER: Unsupported PKGBUILDs are user produced content, by downloading them you agree to do so at your own risk.")."</span>";
 echo "  </div>";
 echo "</div>";
 html_footer(AUR_VERSION);
-- 
cgit v1.2.3-70-g09d2