source: branches/stable/cgi-bin/newcity.cgi@ 154

Last change on this file since 154 was 140, checked in by Kris Deugau, 20 years ago

/branches/stable

Merge changes from /trunk r138,139 into "production" code

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