Changeset 367


Ignore:
Timestamp:
Nov 13, 2006, 1:14:26 PM (14 years ago)
Author:
Dominic Hargreaves
Message:

Display source

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/scripts/process-problems

    r328 r367  
    2323SELECT   p.id, outward, inward, p.ip AS sub_ip, b.ip AS prob_ip, b.reason,
    2424         reporter_email, p.created_at AS sub_date, b.created_at AS prob_date,
    25          p.easting, p.northing
     25         p.easting, p.northing, s.name AS source_name
    2626FROM     bad_postcodes AS b INNER JOIN postcodes AS p ON (b.postcode = p.id)
     27         INNER JOIN sources AS s ON (p.source = s.id)
    2728WHERE    not b.actioned   $postcode_where
    2829ORDER BY p.id, b.created_at
     
    5657    print " http://www.npemap.org.uk/tiles/map.html#" .
    5758        int($hr->{'easting'} / 1000) . ',' . int($hr->{'northing'} / 1000) . ",1\n";
     59    print "Source: " . $hr->{'source_name'} . "\n";
    5860}
    5961
Note: See TracChangeset for help on using the changeset viewer.