From 7b9956f225cd885c861db0cb145b16b3b8441ca7 Mon Sep 17 00:00:00 2001 From: eric Date: Sun, 11 Jul 2004 17:04:32 +0000 Subject: cleaned up physical scripts --- web/html/packages.php | 349 +++++++++++++++++++++++++++++++++++++++++++++++++ web/html/pkgsearch.php | 349 ------------------------------------------------- web/html/pkgvote.php | 16 --- 3 files changed, 349 insertions(+), 365 deletions(-) create mode 100644 web/html/packages.php delete mode 100644 web/html/pkgsearch.php delete mode 100644 web/html/pkgvote.php (limited to 'web/html') diff --git a/web/html/packages.php b/web/html/packages.php new file mode 100644 index 00000000..546ed2b5 --- /dev/null +++ b/web/html/packages.php @@ -0,0 +1,349 @@ +\n"; + print_r($_REQUEST); + print "\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 "
\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 "

\n"; + print __("The selected packages have been flagged out-of-date."); + print "

\n"; + } else { + print "

\n"; + print __("You did not select any packages to flag."); + print "

\n"; + } + + pkgsearch_results_link(); + + } + +} elseif (isset($_REQUEST["do_UnFlag"])) { + if (!$atype) { + print __("You must be logged in before you can unflag packages."); + print "
\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 "

\n"; + print __("The selected packages have been unflagged."); + print "

\n"; + } else { + print "

\n"; + print __("You did not select any packages to unflag."); + print "

\n"; + } + + pkgsearch_results_link(); + + } + +} elseif (isset($_REQUEST["do_Disown"])) { + if (!$atype) { + print __("You must be logged in before you can disown packages."); + print "
\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 "

\n"; + print __("The selected packages have been disowned."); + print "

\n"; + } else { + print "

\n"; + print __("You did not select any packages to disowned."); + print "

\n"; + } + + pkgsearch_results_link(); + + } + + +} elseif (isset($_REQUEST["do_Adopt"])) { + if (!$atype) { + print __("You must be logged in before you can adopt packages."); + print "
\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 "

\n"; + print __("The selected packages have been adopted."); + print "

\n"; + } else { + print "

\n"; + print __("You did not select any packages to adopt."); + print "

\n"; + } + + pkgsearch_results_link(); + + } + + +} elseif (isset($_REQUEST["do_Vote"])) { + if (!$atype) { + print __("You must be logged in before you can vote for packages."); + print "
\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 "

\n"; + print __("Your votes have been cast for the selected packages."); + print "

\n"; + + } else { + print "

\n"; + print __("You did not select any packages to vote for."); + print "

\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 "
\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 "

\n"; + print __("Your votes have been removed from the selected packages."); + print "

\n"; + + } else { + print "

\n"; + print __("You did not select any packages to un-vote for."); + print "

\n"; + } + + pkgsearch_results_link(); + + } + + +} elseif (isset($_REQUEST["do_Details"])) { + + if (!isset($_REQUEST["ID"]) || !intval($_REQUEST["ID"])) { + print __("Error trying to retrieve package details.")."
\n"; + + } else { + package_details($_REQUEST["ID"]); + } + + print "
\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$"); +?> diff --git a/web/html/pkgsearch.php b/web/html/pkgsearch.php deleted file mode 100644 index 546ed2b5..00000000 --- a/web/html/pkgsearch.php +++ /dev/null @@ -1,349 +0,0 @@ -\n"; - print_r($_REQUEST); - print "\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 "
\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 "

\n"; - print __("The selected packages have been flagged out-of-date."); - print "

\n"; - } else { - print "

\n"; - print __("You did not select any packages to flag."); - print "

\n"; - } - - pkgsearch_results_link(); - - } - -} elseif (isset($_REQUEST["do_UnFlag"])) { - if (!$atype) { - print __("You must be logged in before you can unflag packages."); - print "
\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 "

\n"; - print __("The selected packages have been unflagged."); - print "

\n"; - } else { - print "

\n"; - print __("You did not select any packages to unflag."); - print "

\n"; - } - - pkgsearch_results_link(); - - } - -} elseif (isset($_REQUEST["do_Disown"])) { - if (!$atype) { - print __("You must be logged in before you can disown packages."); - print "
\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 "

\n"; - print __("The selected packages have been disowned."); - print "

\n"; - } else { - print "

\n"; - print __("You did not select any packages to disowned."); - print "

\n"; - } - - pkgsearch_results_link(); - - } - - -} elseif (isset($_REQUEST["do_Adopt"])) { - if (!$atype) { - print __("You must be logged in before you can adopt packages."); - print "
\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 "

\n"; - print __("The selected packages have been adopted."); - print "

\n"; - } else { - print "

\n"; - print __("You did not select any packages to adopt."); - print "

\n"; - } - - pkgsearch_results_link(); - - } - - -} elseif (isset($_REQUEST["do_Vote"])) { - if (!$atype) { - print __("You must be logged in before you can vote for packages."); - print "
\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 "

\n"; - print __("Your votes have been cast for the selected packages."); - print "

\n"; - - } else { - print "

\n"; - print __("You did not select any packages to vote for."); - print "

\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 "
\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 "

\n"; - print __("Your votes have been removed from the selected packages."); - print "

\n"; - - } else { - print "

\n"; - print __("You did not select any packages to un-vote for."); - print "

\n"; - } - - pkgsearch_results_link(); - - } - - -} elseif (isset($_REQUEST["do_Details"])) { - - if (!isset($_REQUEST["ID"]) || !intval($_REQUEST["ID"])) { - print __("Error trying to retrieve package details.")."
\n"; - - } else { - package_details($_REQUEST["ID"]); - } - - print "
\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$"); -?> diff --git a/web/html/pkgvote.php b/web/html/pkgvote.php deleted file mode 100644 index eed4a357..00000000 --- a/web/html/pkgvote.php +++ /dev/null @@ -1,16 +0,0 @@ -\n"; - - -html_footer("\$Id$"); -?> -- cgit v1.2.3-24-g4f1b