1 | #!/usr/bin/perl |
---|
2 | # ipdb/cgi-bin/newcity.cgi |
---|
3 | # Add new city to database |
---|
4 | ### |
---|
5 | # SVN revision info |
---|
6 | # $Date: 2011-09-27 17:41:43 +0000 (Tue, 27 Sep 2011) $ |
---|
7 | # SVN revision $Rev: 505 $ |
---|
8 | # Last update by $Author: kdeugau $ |
---|
9 | ### |
---|
10 | # Copyright (C) 2004-2010 - Kris Deugau |
---|
11 | |
---|
12 | use strict; |
---|
13 | use warnings; |
---|
14 | #use CGI::Carp qw(fatalsToBrowser); |
---|
15 | use CGI::Simple; |
---|
16 | use HTML::Template; |
---|
17 | use DBI; |
---|
18 | #use POSIX qw(ceil); |
---|
19 | use NetAddr::IP; |
---|
20 | |
---|
21 | use Sys::Syslog; |
---|
22 | |
---|
23 | # don't remove! required for GNU/FHS-ish install from tarball |
---|
24 | ##uselib## |
---|
25 | |
---|
26 | use MyIPDB; |
---|
27 | |
---|
28 | openlog "IPDB","pid","$IPDB::syslog_facility"; |
---|
29 | |
---|
30 | # Collect the username from HTTP auth. If undefined, we're in a test environment. |
---|
31 | my $authuser; |
---|
32 | if (!defined($ENV{'REMOTE_USER'})) { |
---|
33 | $authuser = '__temptest'; |
---|
34 | } else { |
---|
35 | $authuser = $ENV{'REMOTE_USER'}; |
---|
36 | } |
---|
37 | |
---|
38 | # Set up the CGI object... |
---|
39 | my $q = new CGI::Simple; |
---|
40 | # ... and get query-string params as well as POST params if necessary |
---|
41 | $q->parse_query_string; |
---|
42 | |
---|
43 | # Convenience; saves changing all references to %webvar |
---|
44 | ##fixme: tweak for handling <select multiple='y' size=3> (list with multiple selection) |
---|
45 | my %webvar = $q->Vars; |
---|
46 | |
---|
47 | my ($dbh,$errstr) = connectDB_My; |
---|
48 | my $sth; |
---|
49 | |
---|
50 | $ENV{HTML_TEMPLATE_ROOT} = '../templates'; |
---|
51 | |
---|
52 | my $page = HTML::Template->new(filename => "newcity.tmpl"); |
---|
53 | |
---|
54 | if ($webvar{city}) { |
---|
55 | if ($webvar{pop} eq 'on') { |
---|
56 | $sth = $dbh->prepare("insert into cities (city,routing) values (?,'y')"); |
---|
57 | } else { |
---|
58 | $sth = $dbh->prepare("insert into cities (city,routing) values (?,'n')"); |
---|
59 | } |
---|
60 | ##fixme: don't allow duplicate cities |
---|
61 | $sth->execute($webvar{city}); |
---|
62 | $page->param(city => $webvar{city}); |
---|
63 | if ($sth->err) { |
---|
64 | $page->param(err => $sth->errstr); |
---|
65 | my $msg = "$authuser could not add city '$webvar{city}' to database: ".$sth->errstr; |
---|
66 | mailNotify($dbh, 'f:nci', "IPDB city add failure", $msg); |
---|
67 | syslog "err", $msg; |
---|
68 | } else { |
---|
69 | syslog "notice", "$authuser added city/location '$webvar{pop}'". |
---|
70 | (($webvar{pop} eq 'on') ? ' as POP location' : ''); |
---|
71 | } |
---|
72 | } |
---|
73 | |
---|
74 | print "Content-type: text/html\n\n"; |
---|
75 | |
---|
76 | print $page->output; |
---|
77 | |
---|
78 | finish($dbh); |
---|
79 | |
---|