summaryrefslogtreecommitdiffstats
path: root/extensions/Review/Extension.pm
diff options
context:
space:
mode:
Diffstat (limited to 'extensions/Review/Extension.pm')
-rw-r--r--extensions/Review/Extension.pm11
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};