source: branches/new-custids/cgi-bin/newcity.cgi@ 255

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

/trunk

Wrap connectDB() function in a "module" so we don't get headaches
tracking password changes (if and when). This change *may* get
merged back to IPDB.pm, but it may not so as to allow the HTTP
username to be the user authenticated at the database level.

  • 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-28 19:04:55 +0000 (Fri, 28 Jan 2005) $
7# SVN revision $Rev: 142 $
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 MyIPDB;
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_My;
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.