Changeset 261


Ignore:
Timestamp:
Nov 1, 2006, 10:45:09 AM (13 years ago)
Author:
Dominic Hargreaves
Message:

Try to record the user agent.

Location:
trunk/npemap.org.uk
Files:
2 edited

Legend:

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

    r251 r261  
    134134    }
    135135
    136     $sth = $dbh->prepare('INSERT INTO postcodes (outward, inward, raw_postcode_outward, raw_postcode_inward, easting, northing, ip, source) VALUES (?, ?, ?, ?, ?, ?, ?, 0)');
    137     if ($sth->execute($outward, $inward, $cgi->param('postcode1'), $cgi->param('postcode2'), $easting, $northing, $ENV{'REMOTE_ADDR'})) {
     136    $sth = $dbh->prepare('INSERT INTO postcodes (outward, inward, raw_postcode_outward, raw_postcode_inward, easting, northing, ip, source, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?, 0, ?)');
     137    if ($sth->execute($outward, $inward, $cgi->param('postcode1'), $cgi->param('postcode2'), $easting, $northing, $ENV{'REMOTE_ADDR'}, $ENV{'HTTP_USER_AGENT'})) {
    138138        print "Content-type: text/html\n\n";
    139139        print "<html><head><title>Thank you</title></head>\n";
  • trunk/npemap.org.uk/schema_postgres.sql

    r260 r261  
    3131    source integer NOT NULL,
    3232    deleted boolean NOT NULL default 'f',
    33     delete_reason integer
     33    delete_reason integer,
     34    user_agent character varying
    3435
    3536        CONSTRAINT pk_postcode PRIMARY KEY (id),
Note: See TracChangeset for help on using the changeset viewer.