Ignore:
Timestamp:
Oct 24, 2006, 8:06:02 PM (15 years ago)
Author:
Dominic Hargreaves
Message:

Have the deleted flag take effect.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/cgi/submit.fcgi

    r140 r169  
    119119    # corroboration factor; this just catches accidental double-submission
    120120    # really.
    121     $sth = $dbh->prepare('SELECT raw_postcode_outward FROM postcodes WHERE raw_postcode_outward = ? AND raw_postcode_inward = ? AND easting = ? AND northing = ? AND ip = ?');
     121    $sth = $dbh->prepare('SELECT raw_postcode_outward FROM postcodes WHERE raw_postcode_outward = ? AND raw_postcode_inward = ? AND easting = ? AND northing = ? AND ip = ? AND NOT deleted');
    122122    unless ($sth->execute($cgi->param('postcode1'), $cgi->param('postcode2'), $easting, $northing, $ENV{'REMOTE_ADDR'})) {
    123123        print_err('Database error when checking for duplicate data :(', $returnlink);
Note: See TracChangeset for help on using the changeset viewer.