summaryrefslogtreecommitdiffstats
path: root/web/html/packages.php
diff options
context:
space:
mode:
Diffstat (limited to 'web/html/packages.php')
-rw-r--r--web/html/packages.php349
1 files changed, 349 insertions, 0 deletions
diff --git a/web/html/packages.php b/web/html/packages.php
new file mode 100644
index 0000000..546ed2b
--- /dev/null
+++ b/web/html/packages.php
@@ -0,0 +1,349 @@
+<?
+include("aur.inc"); # access AUR common functions
+include("pkgfuncs.inc"); # package specific functions
+include("search_po.inc"); # use some form of this for i18n support
+set_lang(); # this sets up the visitor's language
+check_sid(); # see if they're still logged in
+html_header(); # print out the HTML header
+
+# enable debugging
+#
+$DBUG = 0;
+if ($DBUG) {
+ print "<pre>\n";
+ print_r($_REQUEST);
+ print "</pre>\n";
+}
+
+# get login privileges
+#
+if (isset($_COOKIE["AURSID"])) {
+ # Only logged in users can do stuff
+ #
+ $atype = account_from_sid($_COOKIE["AURSID"]);
+} else {
+ $atype = "";
+}
+
+# grab the list of Package IDs to be operated on
+#
+isset($_REQUEST["IDs"]) ? $ids = $_REQUEST["IDs"] : $ids = array();
+#isset($_REQUEST["All_IDs"]) ?
+# $all_ids = explode(":", $_REQUEST["All_IDs"]) :
+# $all_ids = array();
+
+
+# determine what button the visitor clicked
+#
+if (isset($_REQUEST["do_Flag"])) {
+ if (!$atype) {
+ print __("You must be logged in before you can flag packages.");
+ print "<br />\n";
+
+ } else {
+
+ if (!empty($ids)) {
+ $dbh = db_connect();
+
+ # Flag the packages in $ids array
+ #
+ $first = 1;
+ while (list($pid, $v) = each($ids)) {
+ if ($first) {
+ $first = 0;
+ $flag = $pid;
+ } else {
+ $flag .= ", ".$pid;
+ }
+ }
+ $q = "UPDATE Packages SET OutOfDate = 1 ";
+ $q.= "WHERE ID IN (" . $flag . ")";
+ db_query($q, $dbh);
+
+ print "<p>\n";
+ print __("The selected packages have been flagged out-of-date.");
+ print "</p>\n";
+ } else {
+ print "<p>\n";
+ print __("You did not select any packages to flag.");
+ print "</p>\n";
+ }
+
+ pkgsearch_results_link();
+
+ }
+
+} elseif (isset($_REQUEST["do_UnFlag"])) {
+ if (!$atype) {
+ print __("You must be logged in before you can unflag packages.");
+ print "<br />\n";
+
+ } else {
+
+ if (!empty($ids)) {
+ $dbh = db_connect();
+
+ # Un-Flag the packages in $ids array
+ #
+ $first = 1;
+ while (list($pid, $v) = each($ids)) {
+ if ($first) {
+ $first = 0;
+ $unflag = $pid;
+ } else {
+ $unflag .= ", ".$pid;
+ }
+ }
+ $q = "UPDATE Packages SET OutOfDate = 0 ";
+ $q.= "WHERE ID IN (" . $unflag . ")";
+ db_query($q, $dbh);
+
+ print "<p>\n";
+ print __("The selected packages have been unflagged.");
+ print "</p>\n";
+ } else {
+ print "<p>\n";
+ print __("You did not select any packages to unflag.");
+ print "</p>\n";
+ }
+
+ pkgsearch_results_link();
+
+ }
+
+} elseif (isset($_REQUEST["do_Disown"])) {
+ if (!$atype) {
+ print __("You must be logged in before you can disown packages.");
+ print "<br />\n";
+
+ } else {
+ # Disown the packages in $ids array
+ #
+ if (!empty($ids)) {
+ $dbh = db_connect();
+
+ # Disown the packages in $ids array
+ #
+ $first = 1;
+ while (list($pid, $v) = each($ids)) {
+ if ($first) {
+ $first = 0;
+ $disown = $pid;
+ } else {
+ $disown .= ", ".$pid;
+ }
+ }
+ $atype = account_from_sid($_COOKIE["AURSID"]);
+ if ($atype == "Trusted User" || $atype == "Developer") {
+ $field = "AURMaintainerUID";
+ } elseif ($atype == "User") {
+ $field = "MaintainerUID";
+ } else {
+ $field = "";
+ }
+
+ if ($field) {
+ $q = "UPDATE Packages ";
+ $q.= "SET ".$field." = 0 ";
+ $q.= "WHERE ID IN (" . $disown . ") ";
+ $q.= "AND ".$field." = ".uid_from_sid($_COOKIE["AURSID"]);
+ db_query($q, $dbh);
+ }
+
+ print "<p>\n";
+ print __("The selected packages have been disowned.");
+ print "</p>\n";
+ } else {
+ print "<p>\n";
+ print __("You did not select any packages to disowned.");
+ print "</p>\n";
+ }
+
+ pkgsearch_results_link();
+
+ }
+
+
+} elseif (isset($_REQUEST["do_Adopt"])) {
+ if (!$atype) {
+ print __("You must be logged in before you can adopt packages.");
+ print "<br />\n";
+
+ } else {
+ # Adopt the packages in $ids array
+ #
+ if (!empty($ids)) {
+ $dbh = db_connect();
+
+ # Adopt the packages in $ids array
+ #
+ $first = 1;
+ while (list($pid, $v) = each($ids)) {
+ if ($first) {
+ $first = 0;
+ $adopt = $pid;
+ } else {
+ $adopt .= ", ".$pid;
+ }
+ }
+ $atype = account_from_sid($_COOKIE["AURSID"]);
+ if ($atype == "Trusted User" || $atype == "Developer") {
+ $field = "AURMaintainerUID";
+ } elseif ($atype == "User") {
+ $field = "MaintainerUID";
+ } else {
+ $field = "";
+ }
+
+ if ($field) {
+ $q = "UPDATE Packages ";
+ $q.= "SET ".$field." = ".uid_from_sid($_COOKIE["AURSID"])." ";
+ $q.= "WHERE ID IN (" . $adopt . ") ";
+ $q.= "AND ".$field." = 0";
+ db_query($q, $dbh);
+ }
+
+ print "<p>\n";
+ print __("The selected packages have been adopted.");
+ print "</p>\n";
+ } else {
+ print "<p>\n";
+ print __("You did not select any packages to adopt.");
+ print "</p>\n";
+ }
+
+ pkgsearch_results_link();
+
+ }
+
+
+} elseif (isset($_REQUEST["do_Vote"])) {
+ if (!$atype) {
+ print __("You must be logged in before you can vote for packages.");
+ print "<br />\n";
+
+ } else {
+ # vote on the packages in $ids array.
+ #
+ if (!empty($ids)) {
+ $dbh = db_connect();
+ $my_votes = pkgvotes_from_sid($_COOKIE["AURSID"]);
+ $uid = uid_from_sid($_COOKIE["AURSID"]);
+ # $vote_ids will contain the string of Package.IDs that
+ # the visitor hasn't voted for already
+ #
+ $first = 1;
+ while (list($pid, $v) = each($ids)) {
+ if (!isset($my_votes[$pid])) {
+ # cast a vote for this package
+ #
+ if ($first) {
+ $first = 0;
+ $vote_ids = $pid;
+ $vote_clauses = "(".$uid.", ".$pid.")";
+ } else {
+ $vote_ids .= ", ".$pid;
+ $vote_clauses .= ", (".$uid.", ".$pid.")";
+ }
+ }
+ }
+ # only vote for packages the user hasn't already voted for
+ #
+ $q = "UPDATE Packages SET NumVotes = NumVotes + 1 ";
+ $q.= "WHERE ID IN (".$vote_ids.")";
+ db_query($q, $dbh);
+
+ $q = "INSERT INTO PackageVotes (UsersID, PackageID) VALUES ";
+ $q.= $vote_clauses;
+ db_query($q, $dbh);
+
+ print "<p>\n";
+ print __("Your votes have been cast for the selected packages.");
+ print "</p>\n";
+
+ } else {
+ print "<p>\n";
+ print __("You did not select any packages to vote for.");
+ print "</p>\n";
+ }
+
+ pkgsearch_results_link();
+
+ }
+
+
+} elseif (isset($_REQUEST["do_UnVote"])) {
+ if (!$atype) {
+ print __("You must be logged in before you can un-vote for packages.");
+ print "<br />\n";
+
+ } else {
+ # un-vote on the packages in $ids array.
+ #
+ if (!empty($ids)) {
+ $dbh = db_connect();
+ $my_votes = pkgvotes_from_sid($_COOKIE["AURSID"]);
+ $uid = uid_from_sid($_COOKIE["AURSID"]);
+ # $unvote_ids will contain the string of Package.IDs that
+ # the visitor has voted for and wants to unvote.
+ #
+ $first = 1;
+ while (list($pid, $v) = each($ids)) {
+ if (isset($my_votes[$pid])) {
+ # cast a un-vote for this package
+ #
+ if ($first) {
+ $first = 0;
+ $unvote_ids = $pid;
+ } else {
+ $unvote_ids .= ", ".$pid;
+ }
+ }
+ }
+ # only un-vote for packages the user has already voted for
+ #
+ $q = "UPDATE Packages SET NumVotes = NumVotes - 1 ";
+ $q.= "WHERE ID IN (".$unvote_ids.")";
+ db_query($q, $dbh);
+
+ $q = "DELETE FROM PackageVotes WHERE UsersID = ".$uid." ";
+ $q.= "AND PackageID IN (".$unvote_ids.")";
+ db_query($q, $dbh);
+
+ print "<p>\n";
+ print __("Your votes have been removed from the selected packages.");
+ print "</p>\n";
+
+ } else {
+ print "<p>\n";
+ print __("You did not select any packages to un-vote for.");
+ print "</p>\n";
+ }
+
+ pkgsearch_results_link();
+
+ }
+
+
+} elseif (isset($_REQUEST["do_Details"])) {
+
+ if (!isset($_REQUEST["ID"]) || !intval($_REQUEST["ID"])) {
+ print __("Error trying to retrieve package details.")."<br />\n";
+
+ } else {
+ package_details($_REQUEST["ID"]);
+ }
+
+ print "<br />\n";
+ pkgsearch_results_link();
+
+
+} else {
+ # do_More/do_Less/do_Search/do_MyPackages - just do a search
+ #
+ pkg_search_page($_COOKIE["AURSID"]);
+
+}
+
+html_footer("\$Id$");
+?>
generated by cgit v1.2.3-70-g09d2 (git 2.47.0) at 2024-11-09 16:35:10 +0000