Changeset 367 for trunk/npemap.org.uk

Timestamp:

Nov 13, 2006, 1:14:26 PM (14 years ago)

Author:

Dominic Hargreaves

Message:

Display source

File:

• trunk/npemap.org.uk/scripts/process-problems (modified) (2 diffs)

trunk/npemap.org.uk/scripts/process-problems

@@ -23 +23 @@
 SELECT   p.id, outward, inward, p.ip AS sub_ip, b.ip AS prob_ip, b.reason,
          reporter_email, p.created_at AS sub_date, b.created_at AS prob_date,
-         p.easting, p.northing
+         p.easting, p.northing, s.name AS source_name
 FROM     bad_postcodes AS b INNER JOIN postcodes AS p ON (b.postcode = p.id)
+         INNER JOIN sources AS s ON (p.source = s.id)
 WHERE    not b.actioned   $postcode_where
 ORDER BY p.id, b.created_at
@@ -56 +57 @@
     print " http://www.npemap.org.uk/tiles/map.html#" .
         int($hr->{'easting'} / 1000) . ',' . int($hr->{'northing'} / 1000) . ",1\n";
+    print "Source: " . $hr->{'source_name'} . "\n";
 }