diff options
Diffstat (limited to 'web/html/packages.php')
| -rw-r--r-- | web/html/packages.php | 54 |
1 files changed, 23 insertions, 31 deletions
diff --git a/web/html/packages.php b/web/html/packages.php index 85ab6b75..9deff6af 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 # |