diff options
Diffstat (limited to 'perllib/Problems.pm')
| -rw-r--r-- | perllib/Problems.pm | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/perllib/Problems.pm b/perllib/Problems.pm index 404717705..c9caf41f2 100644 --- a/perllib/Problems.pm +++ b/perllib/Problems.pm @@ -348,12 +348,13 @@ sub update_search { my ($search) = @_; my $search_n = 0; $search_n = int($search) if $search =~ /^\d+$/; - my $updates = select_all("select comment.*, problem.council from comment, problem where problem.id = comment.problem_id + my $updates = select_all("select comment.*, problem.council, problem.state as problem_state + from comment, problem where problem.id = comment.problem_id and (comment.id=? or problem_id=? or comment.email ilike '%'||?||'%' or comment.name ilike '%'||?||'%' or comment.text ilike '%'||?||'%' or comment.cobrand_data ilike '%'||?||'%') $site_restriction - order by (comment.state='hidden'),created", $search_n, $search_n, $search, $search, + order by (comment.state='hidden'),(problem.state='hidden'),created", $search_n, $search_n, $search, $search, $search, $search); return $updates; } |