summaryrefslogtreecommitdiffstats
path: root/web/html
diff options
context:
space:
mode:
authorCallan Barrett <wizzomafizzo@gmail.com>2008-03-26 14:52:15 +0100
committerSimo Leone <simo@archlinux.org>2008-03-27 08:34:35 +0100
commit04dae8d94f846fe5b82d9261405cbc56a736ded3 (patch)
tree81bcb230c5f0eb0cb92586541ede7d6bca00ab2c /web/html
parent7d7ef9b112d92a3515aa042181eee08a752a086e (diff)
downloadaur-04dae8d94f846fe5b82d9261405cbc56a736ded3.tar.gz
aur-04dae8d94f846fe5b82d9261405cbc56a736ded3.tar.xz
Remove references to AURMaintainerUID
This (should) get rid of anything to do with the unused column AURMaintainerUID in the scripts and schema files Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com> Signed-off-by: Simo Leone <simo@archlinux.org>
Diffstat (limited to 'web/html')
-rw-r--r--web/html/packages.php194
1 files changed, 82 insertions, 112 deletions
diff --git a/web/html/packages.php b/web/html/packages.php
index cf8ad8c0..0394c6e1 100644
--- a/web/html/packages.php
+++ b/web/html/packages.php
@@ -159,26 +159,16 @@ if ($_POST['action'] == "do_Flag" || isset($_POST['do_Flag'])) {
$disown .= ", ".$pid;
}
}
- # Removed for now since we will have 1 maintainer
- # PJM - 5 April 2005
- # if ($atype == "Trusted User" || $atype == "Developer") {
- # $field = "AURMaintainerUID";
- # } elseif ($atype == "User") {
- # $field = "MaintainerUID";
- # } else {
- # $field = "";
- # }
+
$field = "MaintainerUID";
- if ($field) {
- $q = "UPDATE Packages ";
- $q.= "SET ".$field." = 0 ";
- $q.= "WHERE ID IN (" . $disown . ") ";
- # If a user is a TU or dev they can disown any package
- if ($atype == "User") {
- $q.= "AND ".$field." = ".uid_from_sid($_COOKIE["AURSID"]);
- }
- db_query($q, $dbh);
+ $q = "UPDATE Packages ";
+ $q.= "SET ".$field." = 0 ";
+ $q.= "WHERE ID IN (" . $disown . ") ";
+ # If a user is a TU or dev they can disown any package
+ if ($atype == "User") {
+ $q.= "AND ".$field." = ".uid_from_sid($_COOKIE["AURSID"]);
}
+ db_query($q, $dbh);
print "<p>\n";
print __("The selected packages have been disowned.");
@@ -214,83 +204,71 @@ if ($_POST['action'] == "do_Flag" || isset($_POST['do_Flag'])) {
$delete .= ", ".$pid;
}
}
- # if ($atype == "Trusted User" || $atype == "Developer") {
- # $field = "AURMaintainerUID";
- # } elseif ($atype == "User") {
- # $field = "MaintainerUID";
- # } else {
- # $field = "";
- # }
+
$field = "MaintainerUID";
- if ($field) {
- # Only grab Unsupported packages that "we" own or are not owned at all
- #
- $ids_to_delete = array();
- $q = "SELECT Packages.ID FROM Packages, PackageLocations ";
- $q.= "WHERE Packages.ID IN (" . $delete . ") ";
- $q.= "AND Packages.LocationID = PackageLocations.ID ";
- $q.= "AND PackageLocations.Location = 'unsupported' ";
- # If they're a TU or dev, can always delete, otherwise check ownership
+
+ # Only grab Unsupported packages that "we" own or are not owned at all
+ #
+ $ids_to_delete = array();
+ $q = "SELECT Packages.ID FROM Packages, PackageLocations ";
+ $q.= "WHERE Packages.ID IN (" . $delete . ") ";
+ $q.= "AND Packages.LocationID = PackageLocations.ID ";
+ $q.= "AND PackageLocations.Location = 'unsupported' ";
+ # If they're a TU or dev, can always delete, otherwise check ownership
+ #
+ if ($atype == "Trusted User" || $atype == "Developer") {
+ $result = db_query($q, $dbh);
+ } else {
+ $q.= "AND $field IN (0, " . uid_from_sid($_COOKIE["AURSID"]) . ")";
+ $result = db_query($q, $dbh);
+ }
+ if ($result != Null && mysql_num_rows($result) > 0) {
+ while ($row = mysql_fetch_assoc($result)) {
+ $ids_to_delete[] = $row['ID'];
+ }
+ }
+ if (!empty($ids_to_delete)) {
+ # These are the packages that are safe to delete
#
- if ($atype == "Trusted User" || $atype == "Developer") {
+ foreach ($ids_to_delete as $id) {
+ # 1) delete from PackageVotes
+ $q = "DELETE FROM PackageVotes WHERE PackageID = " . $id;
$result = db_query($q, $dbh);
- } else {
- $q.= "AND $field IN (0, " . uid_from_sid($_COOKIE["AURSID"]) . ")";
+
+ # 2) delete from PackageContents
+ $q = "DELETE FROM PackageContents WHERE PackageID = " . $id;
$result = db_query($q, $dbh);
- }
- if ($result != Null && mysql_num_rows($result) > 0) {
- while ($row = mysql_fetch_assoc($result)) {
- $ids_to_delete[] = $row['ID'];
- }
- }
- if (!empty($ids_to_delete)) {
- # These are the packages that are safe to delete
- #
- foreach ($ids_to_delete as $id) {
- # 1) delete from PackageVotes
- $q = "DELETE FROM PackageVotes WHERE PackageID = " . $id;
- $result = db_query($q, $dbh);
-
- # 2) delete from PackageContents
- $q = "DELETE FROM PackageContents WHERE PackageID = " . $id;
- $result = db_query($q, $dbh);
-
- # 3) delete from PackageDepends
- $q = "DELETE FROM PackageDepends WHERE PackageID = " . $id;
- $result = db_query($q, $dbh);
-
- # 4) delete from PackageSources
- $q = "DELETE FROM PackageSources WHERE PackageID = " . $id;
- $result = db_query($q, $dbh);
-
- # 5) delete from PackageComments
- $q = "DELETE FROM PackageComments WHERE PackageID = " . $id;
- $result = db_query($q, $dbh);
-
- # 6) delete from Packages
- $q = "DELETE FROM Packages WHERE ID = " . $id;
- $result = db_query($q, $dbh);
-
- # 7) delete from CommentNotify
- $q = "DELETE FROM CommentNotify WHERE PkgID = " . $id;
- $result = db_query($q, $dbh);
-
- # TODO question: Now that the package as been deleted, does
- # the unsupported repo need to be regenerated?
- # ANSWER: No, there is no actual repo for unsupported, so no worries! (PJM)
- # TODO question: What about regenerating the AUR repo? (EJ)
-
- # Print the success message
- print "<p>\n";
- print __("The selected packages have been deleted.");
- print "</p>\n";
- }
- } else {
+
+ # 3) delete from PackageDepends
+ $q = "DELETE FROM PackageDepends WHERE PackageID = " . $id;
+ $result = db_query($q, $dbh);
+
+ # 4) delete from PackageSources
+ $q = "DELETE FROM PackageSources WHERE PackageID = " . $id;
+ $result = db_query($q, $dbh);
+
+ # 5) delete from PackageComments
+ $q = "DELETE FROM PackageComments WHERE PackageID = " . $id;
+ $result = db_query($q, $dbh);
+
+ # 6) delete from Packages
+ $q = "DELETE FROM Packages WHERE ID = " . $id;
+ $result = db_query($q, $dbh);
+
+ # 7) delete from CommentNotify
+ $q = "DELETE FROM CommentNotify WHERE PkgID = " . $id;
+ $result = db_query($q, $dbh);
+
+ # Print the success message
print "<p>\n";
- print __("None of the selected packages could be deleted.");
- print "</p>\n";
- } # end if (!empty($ids_to_delete))
- } # end if ($field)
+ print __("The selected packages have been deleted.");
+ print "</p>\n";
+ }
+ } else {
+ print "<p>\n";
+ print __("None of the selected packages could be deleted.");
+ print "</p>\n";
+ } # end if (!empty($ids_to_delete))
} else {
print "<p>\n";
print __("You did not select any packages to delete.");
@@ -320,30 +298,22 @@ if ($_POST['action'] == "do_Flag" || isset($_POST['do_Flag'])) {
$adopt .= ", ".$pid;
}
}
- # if ($atype == "Trusted User" || $atype == "Developer") {
- # $field = "AURMaintainerUID";
- # } elseif ($atype == "User") {
- #$field = "MaintainerUID";
- #} else {
- # $field = "";
- # }
+
$field = "MaintainerUID";
- if ($field) {
- # NOTE: Only "orphaned" packages can be adopted at a particular
- # user class (TU/Dev or User).
- #
- $q = "UPDATE Packages ";
- $q.= "SET ".$field." = ".uid_from_sid($_COOKIE["AURSID"])." ";
- $q.= "WHERE ID IN (" . $adopt . ") ";
- if ($atype == "User")
- {
- # Regular users may only adopt orphan packages from unsupported
- # FIXME: We assume that LocationID for unsupported is "2"
- $q.= "AND ".$field." = 0";
- $q.= " AND LocationID = 2";
- }
- db_query($q, $dbh);
+ # NOTE: Only "orphaned" packages can be adopted at a particular
+ # user class (TU/Dev or User).
+ #
+ $q = "UPDATE Packages ";
+ $q.= "SET ".$field." = ".uid_from_sid($_COOKIE["AURSID"])." ";
+ $q.= "WHERE ID IN (" . $adopt . ") ";
+ if ($atype == "User")
+ {
+ # Regular users may only adopt orphan packages from unsupported
+ # FIXME: We assume that LocationID for unsupported is "2"
+ $q.= "AND ".$field." = 0";
+ $q.= " AND LocationID = 2";
}
+ db_query($q, $dbh);
print "<p>\n";
print __("The selected packages have been adopted.");