Updated patch inc which only modifies `scripts/notify.py` and preserves notification records.
On Fri, Jul 3, 2020 at 12:02 PM Kevin Morris <kevr.gt...@gmail.com> wrote: > This path will only trigger when suspending a user through an > account page; if the database is managed manually or through > another script, PackageNotifications will also need manual > modifications if intended. > > This change was written as a solution to > https://bugs.archlinux.org/task/65554. > > Signed-off-by: Kevin Morris <kevr.gt...@gmail.com> > --- > web/lib/acctfuncs.inc.php | 4 ++++ > 1 file changed, 4 insertions(+) > > diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php > index d238c0e0..fb7cca8c 100644 > --- a/web/lib/acctfuncs.inc.php > +++ b/web/lib/acctfuncs.inc.php > @@ -403,6 +403,10 @@ function > process_account_form($TYPE,$A,$U="",$T="",$S="",$E="",$BE="",$H="",$P=" > $q.= " WHERE ID = ".intval($UID); > $result = $dbh->exec($q); > > + // Clean up PackageNotifications for $UID as well. > + $q = "DELETE FROM PackageNotifications WHERE UserID = > ".intval($UID); > + $result = $dbh->exec($q); > + > if (isset($ssh_keys) && count($ssh_keys) > 0) { > $ssh_key_result = account_set_ssh_keys($UID, > $ssh_keys, $ssh_fingerprints); > } else { > -- > 2.20.1 > > -- Kevin Morris Software Developer Personal Inquiries: kevr.gt...@gmail.com Personal Phone: (415) 583-9687 Technologies: C, C++, Python, Django, Ruby, Rails, ReactJS, jQuery, Javascript, SQL, Redux
