From 20c02507ab2e9ea1f36910611b50b00f32a8365d Mon Sep 17 00:00:00 2001 From: pjmattal Date: Wed, 6 Apr 2005 03:25:28 +0000 Subject: fixed multiple maintainer mess --- web/html/packages.php | 51 +++++++++++++++++++++++++++------------------------ web/lib/aur.inc | 14 ++++++++++++++ web/lib/pkgfuncs.inc | 12 ++++++++---- 3 files changed, 49 insertions(+), 28 deletions(-) diff --git a/web/html/packages.php b/web/html/packages.php index 48fc9a0b..210f1354 100644 --- a/web/html/packages.php +++ b/web/html/packages.php @@ -133,14 +133,16 @@ if (isset($_REQUEST["do_Flag"])) { $disown .= ", ".$pid; } } - if ($atype == "Trusted User" || $atype == "Developer") { - $field = "AURMaintainerUID"; - } elseif ($atype == "User") { - $field = "MaintainerUID"; - } else { - $field = ""; - } - + # 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 "; @@ -184,13 +186,14 @@ if (isset($_REQUEST["do_Flag"])) { $delete .= ", ".$pid; } } - if ($atype == "Trusted User" || $atype == "Developer") { - $field = "AURMaintainerUID"; - } elseif ($atype == "User") { - $field = "MaintainerUID"; - } else { - $field = ""; - } + # 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 # @@ -199,7 +202,7 @@ if (isset($_REQUEST["do_Flag"])) { $q.= "WHERE Packages.ID IN (" . $delete . ") "; $q.= "AND Packages.LocationID = PackageLocations.ID "; $q.= "AND PackageLocations.Location = 'unsupported' "; - $q.= "AND AURMaintainerUID IN (0, " . uid_from_sid($_COOKIE["AURSID"]) . ")"; + $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)) { @@ -280,14 +283,14 @@ if (isset($_REQUEST["do_Flag"])) { $adopt .= ", ".$pid; } } - if ($atype == "Trusted User" || $atype == "Developer") { - $field = "AURMaintainerUID"; - } elseif ($atype == "User") { - $field = "MaintainerUID"; - } else { - $field = ""; - } - + # 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). diff --git a/web/lib/aur.inc b/web/lib/aur.inc index 793ef7c4..0563da86 100644 --- a/web/lib/aur.inc +++ b/web/lib/aur.inc @@ -56,6 +56,20 @@ function getDevelopers() { return $devs; } +# return an array of info for each user +function getUsers() { + $users = array(); + $dbh = db_connect(); + $q = "SELECT * FROM Users ORDER BY Username ASC"; + $result = db_query($q, $dbh); + if ($result) { + while ($row = mysql_fetch_assoc($result)) { + $users[$row["ID"]] = $row; + } + } + return $users; +} + # see if the visitor is already logged in # function check_sid() { diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc index bef63005..b5428dde 100644 --- a/web/lib/pkgfuncs.inc +++ b/web/lib/pkgfuncs.inc @@ -444,6 +444,7 @@ function pkg_search_page($SID="") { $cats = pkgCategories(); $devs = getDevelopers(); $tus = getTrustedUsers(); + $users = getUsers(); $dbh = db_connect(); @@ -827,10 +828,13 @@ function pkg_search_page($SID="") { # print the package manager, also determine if it is managed # $managed = 1; - if (isset($devs[$row["AURMaintainerUID"]])) { - print $devs[$row["AURMaintainerUID"]]["Username"]; - } elseif (isset($tus[$row["MaintainerUID"]])) { - print $tus[$row["MaintainerUID"]]["Username"]; + # if (isset($devs[$row["AURMaintainerUID"]])) { + # print $devs[$row["AURMaintainerUID"]]["Username"]; + # } else + # if (isset($tus[$row["MaintainerUID"]])) { + # print $tus[$row["MaintainerUID"]]["Username"]; + if (isset($users[$row["MaintainerUID"]])) { + print $users[$row["MaintainerUID"]]["Username"]; } else { print __("None"); $managed = 0; -- cgit v1.2.3-24-g4f1b