source: trunk/cgi-bin/newcity.cgi@ 515

Last change on this file since 515 was 431, checked in by Kris Deugau, 14 years ago

/trunk

Make sure all syslog-using scripts pick up the global logging
facility instead of hardcoding local2. See #17.

  • Property svn:executable set to *
  • Property svn:keywords set to Date Rev Author
File size: 1.5 KB
RevLine 
[139]1#!/usr/bin/perl
2# ipdb/cgi-bin/newcity.cgi
3# Add new city to database
4###
5# SVN revision info
6# $Date: 2010-07-16 19:56:36 +0000 (Fri, 16 Jul 2010) $
7# SVN revision $Rev: 431 $
8# Last update by $Author: kdeugau $
9###
[417]10# Copyright (C) 2004-2010 - Kris Deugau
[139]11
12use strict;
13use warnings;
14#use CGI::Carp qw(fatalsToBrowser);
15use DBI;
16use CommonWeb qw(:ALL);
17#use POSIX qw(ceil);
18use NetAddr::IP;
19
20use Sys::Syslog;
21
[417]22# don't remove! required for GNU/FHS-ish install from tarball
23##uselib##
24
25use MyIPDB;
26
[431]27openlog "IPDB","pid","$IPDB::syslog_facility";
[139]28
29# Collect the username from HTTP auth. If undefined, we're in a test environment.
30my $authuser;
31if (!defined($ENV{'REMOTE_USER'})) {
32 $authuser = '__temptest';
33} else {
34 $authuser = $ENV{'REMOTE_USER'};
35}
36
37my %webvar = parse_post();
38cleanInput(\%webvar);
39
[142]40my ($dbh,$errstr) = connectDB_My;
[139]41my $sth;
42
43print "Content-type: text/html\n\n";
44
45if ($webvar{pop} eq 'on') {
[370]46 $sth = $dbh->prepare("insert into cities (city,routing) values ('$webvar{city}','y')");
[139]47} else {
[370]48 $sth = $dbh->prepare("insert into cities (city,routing) values ('$webvar{city}','n')");
[139]49}
50$sth->execute;
51
52if ($sth->err) {
53 print "Error adding city to database: ".$sth->errstr;
[416]54 mailNotify($dbh, 'f:nci', "IPDB city add failure",
55 "$authuser could not add city '$webvar{city}' to database: ".$sth->errstr);
[139]56 syslog "err", "$authuser could not add city '$webvar{city}' to database: ".$sth->errstr;
57} else {
58 print "City added. Closing this window should refresh the page.";
59 syslog "notice", "$authuser added city/location '$webvar{pop}'".
60 (($webvar{pop} eq 'on') ? ' as POP location' : '');
61}
62
63finish($dbh);
Note: See TracBrowser for help on using the repository browser.