summaryrefslogtreecommitdiff
path: root/web/html/packages.php
diff options
context:
space:
mode:
authorCallan Barrett <wizzomafizzo@gmail.com>2008-01-07 09:44:21 +0900
committerDan McGee <dan@archlinux.org>2008-01-20 00:21:19 -0600
commit8c94552042115d2a7bb04de3b4f66cdf95f2a5de (patch)
tree88734e06dd9a123a0c6a5e243e48d5345ad415b6 /web/html/packages.php
parentbf5c28cf2260df822efa72095af69cc119170a3e (diff)
Add notify column in search results and notify button
Adds a column to search results showing if a package has comment notification enabled and adds support for toggling notify for multiple packages from search Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
Diffstat (limited to 'web/html/packages.php')
-rw-r--r--web/html/packages.php54
1 files changed, 23 insertions, 31 deletions
diff --git a/web/html/packages.php b/web/html/packages.php
index 85ab6b7..9deff6a 100644
--- a/web/html/packages.php
+++ b/web/html/packages.php
@@ -509,44 +509,36 @@ if (isset($_REQUEST["do_Flag"])) {
# There currently shouldn't be multiple requests here, but the format in which
# it's sent requires this
while (list($pid, $v) = each($ids)) {
- $q = "INSERT INTO CommentNotify (PkgID, UserID) VALUES (".$pid.', '.$uid.')';
- db_query($q, $dbh);
- print '<p>';
- print __("You have been added to the comment notification list.");
- print '<br /></p>';
- pkgdetails_link($pid);
+ $q = "SELECT Name FROM Packages WHERE ID = " . $pid;
+ $pkgname = mysql_result(db_query($q, $dbh), 0);
+
+ $q = "SELECT * FROM CommentNotify WHERE UserID = ".$uid;
+ $q.= " AND PkgID = ".$pid;
+
+ if (!mysql_num_rows(db_query($q, $dbh))) {
+ $q = "INSERT INTO CommentNotify (PkgID, UserID) VALUES (".$pid.', '.$uid.')';
+ db_query($q, $dbh);
+ print '<p>';
+ print __("You have been added to the comment notification list for %s.",
+ array("<b>" . $pkgname . "</b>"));
+ print '<br /></p>';
+ } else {
+ $q = "DELETE FROM CommentNotify WHERE PkgID = ".$pid;
+ $q.= " AND UserID = ".$uid;
+ db_query($q, $dbh);
+ print '<p>';
+ print __("You have been removed from the comment notification list for %s.",
+ array("<b>" . $pkgname . "</b>"));
+ print '<br /></p>';
+ }
}
+ pkgdetails_link($pid);
} else {
print '<p>';
print __("Couldn't add to notification list.");
print '<br /></p>';
}
}
-} elseif (isset($_REQUEST["do_UnNotify"])) {
- if (!$atype) {
- print __("You must be logged in before you can cancel notification on comments.");
- print "<br />\n";
- } else {
- if (!empty($ids)) {
- $dbh = db_connect();
- $uid = uid_from_sid($_COOKIE["AURSID"]);
- # There currently shouldn't be multiple requests here, but the format in which
- # it's sent requires this
- while (list($pid, $v) = each($ids)) {
- $q = "DELETE FROM CommentNotify WHERE PkgID = ".$pid;
- $q.= " AND UserID = ".$uid;
- db_query($q, $dbh);
- print '<p>';
- print __("You have been removed from the comment notification list.");
- print '<br /></p>';
- pkgdetails_link($pid);
- }
- } else {
- print '<p>';
- print __("Couldn't remove from notification list.");
- print '<br /></p>';
- }
- }
} else {
# do_More/do_Less/do_Search/do_MyPackages - just do a search
#