diff options
Diffstat (limited to 'extensions/Review/Extension.pm')
-rw-r--r-- | extensions/Review/Extension.pm | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/extensions/Review/Extension.pm b/extensions/Review/Extension.pm index ed155bbd2..ed8191ab8 100644 --- a/extensions/Review/Extension.pm +++ b/extensions/Review/Extension.pm @@ -98,14 +98,15 @@ sub _bug_mentor { sub _user_review_count { my ($self) = @_; if (!exists $self->{review_count}) { - ($self->{review_count}) = Bugzilla->dbh->selectrow_array( + my $dbh = Bugzilla->dbh; + ($self->{review_count}) = $dbh->selectrow_array( "SELECT COUNT(*) - FROM flags + FROM flags INNER JOIN flagtypes ON flagtypes.id = flags.type_id - WHERE flags.requestee_id = ? - AND flagtypes.name = ?", + WHERE flags.requestee_id = ? + AND " . $dbh->sql_in('flagtypes.name', [ "'review'", "'feedback'" ]), undef, - $self->id, 'review', + $self->id, ); } return $self->{review_count}; |