diff options
Diffstat (limited to 'Bugzilla/Mailer.pm')
-rw-r--r-- | Bugzilla/Mailer.pm | 15 |
1 files changed, 6 insertions, 9 deletions
diff --git a/Bugzilla/Mailer.pm b/Bugzilla/Mailer.pm index 593a1067a..20175db15 100644 --- a/Bugzilla/Mailer.pm +++ b/Bugzilla/Mailer.pm @@ -260,17 +260,14 @@ sub build_thread_marker { sub send_staged_mail { my $dbh = Bugzilla->dbh; - my @ids; - my $emails - = $dbh->selectall_arrayref("SELECT id, message FROM mail_staging"); - foreach my $row (@$emails) { - MessageToMTA($row->[1]); - push(@ids, $row->[0]); - } + my $emails = $dbh->selectall_arrayref('SELECT id, message FROM mail_staging'); + my $sth = $dbh->prepare('DELETE FROM mail_staging WHERE id = ?'); - if (@ids) { - $dbh->do("DELETE FROM mail_staging WHERE " . $dbh->sql_in('id', \@ids)); + foreach my $email (@$emails) { + my ($id, $message) = @$email; + MessageToMTA($message); + $sth->execute($id); } } |