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

Last change on this file since 522 was 517, checked in by Kris Deugau, 12 years ago

/trunk

Finally merge conversion to HTML::Template from /branches/htmlform

  • Node "hack" showed conflict due to having been added to all branches in parallel
  • editDisplay.html was apparently changed enough that the merged delete caused an irrelevant conflict

Closes #3.

  • Property svn:executable set to *
  • Property svn:keywords set to Date Rev Author
File size: 1.9 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: 2012-10-18 20:53:10 +0000 (Thu, 18 Oct 2012) $
7# SVN revision $Rev: 517 $
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);
[517]15use CGI::Simple;
16use HTML::Template;
[139]17use DBI;
18#use POSIX qw(ceil);
19use NetAddr::IP;
20
21use Sys::Syslog;
22
[417]23# don't remove! required for GNU/FHS-ish install from tarball
24##uselib##
25
26use MyIPDB;
27
[431]28openlog "IPDB","pid","$IPDB::syslog_facility";
[139]29
30# Collect the username from HTTP auth. If undefined, we're in a test environment.
31my $authuser;
32if (!defined($ENV{'REMOTE_USER'})) {
33 $authuser = '__temptest';
34} else {
35 $authuser = $ENV{'REMOTE_USER'};
36}
37
[517]38# Set up the CGI object...
39my $q = new CGI::Simple;
40# ... and get query-string params as well as POST params if necessary
41$q->parse_query_string;
[139]42
[517]43# Convenience; saves changing all references to %webvar
44##fixme: tweak for handling <select multiple='y' size=3> (list with multiple selection)
45my %webvar = $q->Vars;
46
[142]47my ($dbh,$errstr) = connectDB_My;
[139]48my $sth;
49
[517]50$ENV{HTML_TEMPLATE_ROOT} = '../templates';
[139]51
[517]52my $page = HTML::Template->new(filename => "newcity.tmpl");
[139]53
[517]54if ($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}'".
[139]70 (($webvar{pop} eq 'on') ? ' as POP location' : '');
[517]71 }
[139]72}
73
[517]74print "Content-type: text/html\n\n";
75
76print $page->output;
77
[139]78finish($dbh);
[517]79
Note: See TracBrowser for help on using the repository browser.