5 files changed, 7 insertions, 6 deletions
diff --git a/bin/send-alerts b/bin/send-alerts
index 89dc18ee7..4464b16e9 100755
--- a/bin/send-alerts
+++ b/bin/send-alerts
@@ -1,4 +1,4 @@
-#!/usr/bin/perl -w
+#!/usr/bin/env perl -w
 
 # send-alerts:
 # Email alerts for FixMyStreet
diff --git a/bin/send-questionnaires b/bin/send-questionnaires
index d6e269e32..4910abc02 100755
--- a/bin/send-questionnaires
+++ b/bin/send-questionnaires
@@ -1,4 +1,4 @@
-#!/usr/bin/perl -w
+#!/usr/bin/env perl -w
 
 # send-questionnaires:
 # Send out creator questionnaires
diff --git a/bin/send-reports b/bin/send-reports
index f1d8c5742..d92c10467 100755
--- a/bin/send-reports
+++ b/bin/send-reports
@@ -1,4 +1,4 @@
-#!/usr/bin/perl -w
+#!/usr/bin/env perl -w
 
 # send-reports:
 # Send new problem reports to councils
diff --git a/bin/showcouncilrates b/bin/showcouncilrates
index cc8ce8d10..1dacae597 100755
--- a/bin/showcouncilrates
+++ b/bin/showcouncilrates
@@ -26,9 +26,10 @@ BEGIN {
 
 my $query = "SELECT council, COUNT(*) AS total, SUM(fixed) AS fixed
   FROM (SELECT council,
-        CASE WHEN state = 'fixed' THEN 1 ELSE 0 END AS fixed
+        CASE WHEN state in ('fixed','fixed - user', 'fixed - council')
+             THEN 1 ELSE 0 END AS fixed
         FROM problem WHERE confirmed IS NOT NULL AND
-        state IN ('fixed', 'confirmed') AND
+        state IN ('fixed', 'fixed - user', 'fixed - council', 'confirmed') AND
         whensent < NOW() - INTERVAL '4 weeks') AS a
   GROUP BY council";
 
diff --git a/bin/update-all-reports b/bin/update-all-reports
index 2263a3d9d..c87977f68 100755
--- a/bin/update-all-reports
+++ b/bin/update-all-reports
@@ -1,4 +1,4 @@
-#!/usr/bin/perl
+#!/usr/bin/env perl
 
 # update-all-reports:
 # Generate the data for the /reports page