diff options
| author | Struan Donald <struan@exo.org.uk> | 2012-04-30 18:43:27 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2012-04-30 18:43:27 +0100 |
| commit | ece5fb35819f90b608766ce5677a5134951b7545 (patch) | |
| tree | 0847cfad425e820318a498d9e013ec74442228db | |
| parent | 7ed720d5c1b40466a21eb9a383bb8ae1b0bf1888 (diff) | |
only send confirmed comments
| -rwxr-xr-x | bin/send-comments | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/bin/send-comments b/bin/send-comments index acd32d53a..1bd68e916 100755 --- a/bin/send-comments +++ b/bin/send-comments @@ -44,6 +44,8 @@ while ( my $council = $councils->next ) { my $comments = FixMyStreet::App->model('DB::Comment')->search( { 'me.whensent' => undef, 'me.external_id' => undef, + 'state' => 'confirmed', + 'confirmed' => { '!=' => undef }, 'problem.whensent' => { '!=' => undef }, 'problem.external_id' => { '!=' => undef }, 'problem.council' => { -like => '%' . $council->area_id .'%' }, |