diff options
Diffstat (limited to 'editusers.cgi')
-rwxr-xr-x | editusers.cgi | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/editusers.cgi b/editusers.cgi index e9e40eb4c..e53341c61 100755 --- a/editusers.cgi +++ b/editusers.cgi @@ -468,14 +468,14 @@ if ($action eq 'search') { $vars->{'longdescs'} = $dbh->selectrow_array( 'SELECT COUNT(*) FROM longdescs WHERE who = ?', undef, $otherUserID); - $vars->{'namedqueries'} = $dbh->selectcol_arrayref( + my $namedquery_ids = $dbh->selectcol_arrayref( 'SELECT id FROM namedqueries WHERE userid = ?', - undef, - $otherUserID); - if (@{$vars->{'namedqueries'}}) { + undef, $otherUserID); + $vars->{'namedqueries'} = scalar(@$namedquery_ids); + if (scalar(@$namedquery_ids)) { $vars->{'namedquery_group_map'} = $dbh->selectrow_array( 'SELECT COUNT(*) FROM namedquery_group_map WHERE namedquery_id IN' . - ' (' . join(', ', @{$vars->{'namedqueries'}}) . ')'); + ' (' . join(', ', @$namedquery_ids) . ')'); } else { $vars->{'namedquery_group_map'} = 0; |