source: trunk/cgi-bin/admin.cgi@ 555

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

/trunk

Clean up another couple of syntax-mess warnings. See #31.

  • Property svn:executable set to *
  • Property svn:keywords set to Date Rev Author
File size: 18.8 KB
RevLine 
[54]1#!/usr/bin/perl
2# ipdb/cgi-bin/admin.cgi
3# Hack interface to make specific changes to IPDB that (for one reason
4# or another) can't be made through the main interface.
[65]5#
[54]6###
7# SVN revision info
8# $Date: 2012-11-08 22:57:54 +0000 (Thu, 08 Nov 2012) $
9# SVN revision $Rev: 548 $
10# Last update by $Author: kdeugau $
11###
[417]12# Copyright (C) 2004-2010 - Kris Deugau
[54]13
14use strict;
15use warnings;
16use CGI::Carp qw(fatalsToBrowser);
[517]17use CGI::Simple;
18use HTML::Template;
[54]19use DBI;
20#use POSIX qw(ceil);
21use NetAddr::IP;
22
23use Sys::Syslog;
24
[417]25# don't remove! required for GNU/FHS-ish install from tarball
26##uselib##
27
[515]28use CustIDCK;
[417]29use MyIPDB;
30
[431]31openlog "IPDB-admin","pid","$IPDB::syslog_facility";
[54]32
33# Collect the username from HTTP auth. If undefined, we're in a test environment.
34my $authuser;
35if (!defined($ENV{'REMOTE_USER'})) {
36 $authuser = '__temptest';
37} else {
38 $authuser = $ENV{'REMOTE_USER'};
39}
40
41syslog "debug", "$authuser active";
42
[517]43# Set up the CGI object...
44my $q = new CGI::Simple;
45# ... and get query-string params as well as POST params if necessary
46$q->parse_query_string;
47
48# Convenience; saves changing all references to %webvar
49##fixme: tweak for handling <select multiple='y' size=3> (list with multiple selection)
50my %webvar = $q->Vars;
51
52# anyone got a better name? :P
53my $thingroot = $ENV{SCRIPT_FILENAME};
54$thingroot =~ s|cgi-bin/admin.cgi||;
55
56# Set up some globals
57$ENV{HTML_TEMPLATE_ROOT} = $thingroot."templates";
58
[199]59# Why not a global DB handle? (And a global statement handle, as well...)
60# Use the connectDB function, otherwise we end up confusing ourselves
61my $ip_dbh;
62my $sth;
63my $errstr;
64($ip_dbh,$errstr) = connectDB_My;
65if (!$ip_dbh) {
[517]66 $webvar{action} = "dberr";
67} else {
68 initIPDBGlobals($ip_dbh);
[199]69}
70
[548]71if(!defined($webvar{action})) {
72 $webvar{action} = "main"; #shuts up the warnings.
73}
74
[517]75# handle DB error output
76if ($webvar{action} eq 'dberr') {
77 my $page = HTML::Template->new(filename => "admin/dberr.tmpl");
78 $page->param(errmsg => $errstr);
79 print "Content-Type: text/html\n\n".$page->output;
80 exit;
81}
82
[233]83if ($IPDBacl{$authuser} !~ /A/) {
[517]84 my $page = HTML::Template->new(filename => "admin/aclerr.tmpl");
85##fixme: need params for IPDB admin email and name
86 $page->param(ipdbadmin_email => 'ipdbadmin@example.com');
87 $page->param(ipdbadmin_name => 'the IPDB administrator');
88 print "Content-Type: text/html\n\n".$page->output;
[233]89 exit;
90}
91
[517]92my $header = HTML::Template->new(filename => "admin/header.tmpl");
[58]93
[517]94my $page;
95if (-e "$ENV{HTML_TEMPLATE_ROOT}/admin/$webvar{action}.tmpl") {
96 $page = HTML::Template->new(filename => "admin/$webvar{action}.tmpl");
97} else {
98 $page = HTML::Template->new(filename => "admin/dunno.tmpl");
99}
100
101# handle index page
102if ($webvar{action} eq 'main') {
103 $header->param(mainpage => 1);
104
[541]105 my $tlist = getTypeList($ip_dbh, 'a');
106 $tlist->[0]->{sel} = 1;
107 $page->param(typelist => $tlist);
[199]108
[541]109 my $mlist = getMasterList($ip_dbh, 'm');
110 $page->param(masterlist => $mlist);
[54]111}
112
[517]113## Non-default actions.
[199]114
[517]115elsif ($webvar{action} eq 'alloc') {
[199]116
[543]117 my $cidr = new NetAddr::IP $webvar{cidr};
118 if (!$cidr || "$cidr" =~ /^0/) {
[517]119 $page->param(errmsg => "Can't allocate something that's not a netblock/ip");
120 goto ERRJUMP;
[199]121 }
122
[544]123 my $custid = $def_custids{$webvar{alloctype}};
[199]124 if ($custid eq '') {
[546]125 # Crosscheck with billing.
126 my $status = CustIDCK->custid_exist($webvar{custid});
127 if ($CustIDCK::Error) {
128 $page->param(errmsg => "Error verifying customer ID: ".$CustIDCK::ErrMsg);
129 goto ERRJUMP;
[400]130 }
[546]131 if (!$status) {
132 $page->param(errmsg => "Customer ID not valid. Make sure the Customer ID ".
133 "is correct.<br>\nUse STAFF for staff static IPs, and $IPDB::defcustid for any other ".
134 "non-customer assignments.");
135 goto ERRJUMP;
136 }
[199]137 # Type that doesn't have a default custid
138 $custid = $webvar{custid};
139 }
140
[544]141 my $maskbits = $cidr->masklen;
142 my $fbtmp = findAllocateFrom($ip_dbh, $maskbits, $webvar{alloctype}, '','',
143 (gimme => "$cidr", allowpriv => 1));
144
[199]145 if ($webvar{alloctype} eq 'rm') {
[544]146 if (!$fbtmp) {
[517]147 $page->param(errmsg => "Can't allocate from outside a free block!!");
148 goto ERRJUMP;
149 }
[256]150 } elsif ($webvar{alloctype} =~ /^(.)i$/) {
[544]151 my $iptype = $1;
152 my $ptmp = ipParent($ip_dbh, "$cidr");
153 if ($ptmp->{type} =~ /^(.)[dp]$/) {
154 my $newiptype = "$1i";
155 $fbtmp = $ptmp->{cidr};
156 if ($ptmp->{type} !~ /^$iptype./) {
157 $page->param(warnmsg => "Warning: Allocating IP as '".$disp_alloctypes{$newiptype}."' instead of '".
158 $disp_alloctypes{$webvar{alloctype}}."' to match pool $fbtmp\n");
159 $webvar{alloctype} = $newiptype;
160 }
161 }
162 if (!$fbtmp) {
[517]163 $page->param(errmsg => "Can't allocate static IP from outside a pool!!");
164 goto ERRJUMP;
165 }
[199]166 } else {
[544]167 if (!$fbtmp) {
[517]168 $page->param(errmsg => "Can't allocate from outside a routed block!!");
169 goto ERRJUMP;
170 }
[199]171 }
172
[544]173 my $alloc_from = new NetAddr::IP $fbtmp;
[199]174
[517]175 my @cities;
[199]176 foreach my $city (@citylist) {
[517]177 my %row = (city => $city);
178 push @cities, \%row;
[199]179 }
[517]180 $page->param(
181 cidr => $cidr,
182 disptype => $disp_alloctypes{$webvar{alloctype}},
183 type => $webvar{alloctype},
184 alloc_from => $alloc_from,
185 custid => $custid,
186 citylist => \@cities
187 );
[199]188
189} elsif ($webvar{action} eq 'confirm') {
190
[517]191 $page->param(
192 cidr => $webvar{cidr},
193 custid => $webvar{custid},
194 desc => $webvar{desc},
195 disptype => $disp_alloctypes{$webvar{alloctype}}
196 );
[199]197 # Only need to check city here.
198 if ($webvar{city} eq '-') {
[517]199 $page->param(locerr => "Invalid customer location! Go back and select customer's location.");
200 goto ERRJUMP;
[545]201 }
202
203 my ($retcode,$msg) = allocateBlock($ip_dbh, $webvar{cidr}, $webvar{alloc_from},
[199]204 $webvar{custid}, $webvar{alloctype}, $webvar{city}, $webvar{desc}, $webvar{notes},
205 $webvar{circid});
[545]206 if ($retcode eq 'OK') {
207 syslog "notice", "$authuser allocated '$webvar{cidr}' to '$webvar{custid}' as ".
208 "'$webvar{alloctype}'";
209 if ($webvar{alloctype} =~ /^.i$/) {
210 mailNotify($ip_dbh, "a$webvar{alloctype}", "ADDED: $disp_alloctypes{$webvar{alloctype}} allocation",
211 "$disp_alloctypes{$webvar{alloctype}} $webvar{cidr} allocated to customer $webvar{custid}\n".
212 "Description: $webvar{desc}\n\nAllocated by: $authuser\n");
213 }
214 } else {
215 $page->param(errmsg => $msg);
216 syslog "err", "($authuser) Allocation of '$webvar{cidr}' to '$webvar{custid}' as ".
217 "'$webvar{alloctype}' failed: '$msg'";
218 }
[199]219
[54]220} elsif ($webvar{action} eq 'alloctweak') {
[517]221
[54]222 fix_allocfrom();
223 showAllocs($webvar{allocfrom});
[517]224
[54]225} elsif ($webvar{action} eq 'update') {
[517]226
[54]227 update();
[58]228
[517]229} elsif ($webvar{action} eq 'touch') {
[58]230
[547]231 my ($code,$msg) = touchMaster($ip_dbh, $webvar{whichmaster});
232 $page->param(errmsg => $msg) if $code eq 'FAIL';
[517]233
[329]234} elsif ($webvar{action} eq 'listcust') {
[517]235
[329]236 $sth = $ip_dbh->prepare("select custid,name,tech_handle from customers order by custid");
237 $sth->execute;
[517]238 my @custlist;
[329]239 while (my @data = $sth->fetchrow_array) {
[517]240 my %row = (
241 custid => $data[0],
242 custname => $data[1],
243 tech => $data[2]
244 );
245 push @custlist, \%row;
[329]246 }
[517]247 $page->param(custlist => \@custlist);
248
[331]249} elsif ($webvar{action} eq 'edcust') {
[517]250
[418]251 if ($webvar{newcust}) {
252 $sth = $ip_dbh->prepare("INSERT INTO customers (custid) VALUES (?)");
253 $sth->execute($webvar{custid});
254 }
[331]255 $sth = $ip_dbh->prepare("select custid,name,street,city,province,".
[436]256 "country,pocode,phone,tech_handle,abuse_handle,admin_handle,special ".
[331]257 "from customers where custid='$webvar{custid}'");
258 $sth->execute;
[436]259 my ($custid, $name, $street, $city, $prov, $country, $pocode, $phone, $tech, $abuse, $admin, $special) =
[331]260 $sth->fetchrow_array;
261
[517]262 $page->param(
263 custid => $custid,
264 name => $name,
265 street => $street,
266 city => $city,
267 prov => $prov,
268 country => $country,
269 pocode => $pocode,
270 phone => $phone,
271 tech => $tech,
272 abuse => $abuse,
273 admin => $admin,
274 special => $special
275 );
276
[329]277} elsif ($webvar{action} eq 'updcust') {
[517]278
[418]279 $sth = $ip_dbh->prepare("UPDATE customers SET".
280 " name=?, street=?, city=?, province=?, country=?, pocode=?,".
281 " phone=?, tech_handle=?, abuse_handle=?, admin_handle=?, special=?".
282 " WHERE custid=?");
283 $sth->execute($webvar{name}, $webvar{street}, $webvar{city}, $webvar{province},
284 $webvar{country}, $webvar{pocode}, $webvar{phone}, $webvar{tech_handle},
285 $webvar{abuse_handle}, $webvar{admin_handle}, $webvar{special}, $webvar{custid});
[517]286 $page->param(
287 custid => $webvar{custid},
288 name => $webvar{name},
289 street => $webvar{street},
290 city => $webvar{city},
291 prov => $webvar{province},
292 country => $webvar{country},
293 pocode => $webvar{pocode},
294 phone => $webvar{phone},
295 tech => $webvar{tech_handle},
296 abuse => $webvar{abuse_handle},
297 admin => $webvar{admin_handle},
298 special => $webvar{special}
299 );
[418]300
[65]301} elsif ($webvar{action} eq 'showpools') {
[517]302
303 $sth = $ip_dbh->prepare("select pool, count(*) from poolips where available='y' group by pool order by pool");
[65]304 $sth->execute;
[517]305 my @poollist;
306 while (my ($pool,$free) = $sth->fetchrow_array) {
307 my %row = (
308 pool => $pool,
309 free => $free
310 );
311 push @poollist, \%row;
[65]312 }
[517]313 $page->param(poollist => \@poollist);
314
[65]315} elsif ($webvar{action} eq 'tweakpool') {
[517]316
[65]317 showPool($webvar{pool});
[517]318
[65]319} elsif ($webvar{action} eq 'updatepool') {
[199]320
[65]321 $sth = $ip_dbh->prepare("update poolips set custid='$webvar{custid}', ".
[517]322 "city=?, type='$webvar{type}', available='".
[65]323 (($webvar{available} eq 'y') ? 'y' : 'n').
[517]324 "', notes=?, description=? ".
[65]325 "where ip='$webvar{ip}'");
[517]326 $sth->execute($webvar{city},$webvar{notes},$webvar{desc});
327 $page->param(ip => $webvar{ip});
[65]328 if ($sth->err) {
[517]329 $page->param(errmsg => $sth->errstr);
330 syslog "err", "$authuser could not update pool IP $webvar{ip}: ".$sth->errstr;
331 } else {
[65]332 syslog "notice", "$authuser updated pool IP $webvar{ip}";
333 }
[517]334 $sth = $ip_dbh->prepare("select pool from poolips where ip='$webvar{ip}'");
335 $sth->execute;
336 my @data = $sth->fetchrow_array;
337 $page->param(pool => $data[0]);
338
[258]339} elsif ($webvar{action} eq 'showusers') {
[233]340
341 $sth = $ip_dbh->prepare("select username,acl from users order by username");
342 $sth->execute;
[517]343 my @userlist;
344 while (my ($username,$acl) = $sth->fetchrow_array) {
345##fixme: funky things happening with HTML::Template here; shouldn't need the "logic ? iftrue : iffalse" structure
346 my %row = (
347 username => $username,
348 can_add => ($acl =~ /a/ ? 1 : 0),
349 can_change => ($acl =~ /c/ ? 1 : 0),
350 can_del => ($acl =~ /d/ ? 1 : 0),
351 sysnet => ($acl =~ /s/ ? 1 : 0),
352 is_admin => ($acl =~ /A/ ? 1 : 0),
353 acl => $acl
354 );
355 push @userlist, \%row;
356 }
357 $page->param(userlist => \@userlist);
[233]358
359} elsif ($webvar{action} eq 'updacl') {
[517]360
361 $page->param(username => $webvar{username});
[233]362 my $acl = 'b';
363 if ($webvar{admin} eq 'on') {
[284]364 $acl .= "acdsA";
[233]365 } else {
366 $acl .= ($webvar{add} eq 'on' ? 'a' : '').
367 ($webvar{change} eq 'on' ? 'c' : '').
[284]368 ($webvar{del} eq 'on' ? 'd' : '').
369 ($webvar{sysnet} eq 'on' ? 's' : '');
[233]370 }
[517]371 $page->param(acl => $acl);
[233]372
373 $sth = $ip_dbh->prepare("update users set acl='$acl' where username='$webvar{username}'");
374 $sth->execute;
[517]375 $page->param(errmsg => $sth->errstr) if $sth->err;
[233]376
[517]377} elsif ($webvar{action} eq 'newuser') {
[233]378
[517]379 $page->param(username => $webvar{username});
[259]380 my $cr_pass = ($webvar{preenc} ? $webvar{password} :
381 crypt $webvar{password}, join('',('.','/',0..9,'A'..'Z','a'..'z')[rand 64, rand 64]));
[258]382 $sth = $ip_dbh->prepare("insert into users (username,password,acl) values ".
383 "('$webvar{username}','$cr_pass','b')");
384 $sth->execute;
[517]385 $page->param(errmsg => $sth->errstr) if $sth->err;
[258]386
[517]387} elsif ($webvar{action} eq 'deluser') {
[258]388
[517]389 $page->param(username => $webvar{username});
[258]390 $sth = $ip_dbh->prepare("delete from users where username='$webvar{username}'");
391 $sth->execute;
[517]392 $page->param(errmsg => $sth->errstr) if $sth->err;
[258]393
[517]394} elsif ($webvar{action} eq 'emailnotice') {
[258]395
[422]396 $sth = $ip_dbh->prepare("SELECT action,reciplist FROM notify");
397 $sth->execute;
[517]398 my @spamlist;
[422]399 while (my ($notice_code,$reciplist) = $sth->fetchrow_array() ) {
400##fixme: hairy mess, only a few things call mailNotify() anyway, so many possible notices won't work.
401 my $action_out = dispNoticeCode($notice_code);
[517]402 my %row = (
403 action => $action_out,
404 code => $notice_code,
405 recips => $reciplist
406 );
407 push @spamlist, \%row;
[422]408 }
[517]409 $page->param(spamlist => \@spamlist);
[423]410
411 $sth = $ip_dbh->prepare("SELECT type,dispname FROM alloctypes WHERE listorder < 500 ".
412 "ORDER BY listorder");
413 $sth->execute;
414 my $i=0;
[517]415 my @typelist;
[423]416 while (my ($type,$disp) = $sth->fetchrow_array) {
[517]417 my %row = (
418 type => $type,
419 disptype => $disp,
420# ahh, off-by-one counts, how we do love thee... NOT!
421 newrow => ($i+2 > $sth->rows ? 1 : (++$i % 4)),
422 );
423 push @typelist, \%row;
[423]424 }
[517]425 $page->param(typelist => \@typelist);
[423]426
[517]427} elsif ($webvar{action} eq 'addnotice') {
[423]428
[426]429 $webvar{alloctype} = $webvar{special} if $webvar{msgaction} eq 's:';
430 if ($webvar{msgaction} && $webvar{alloctype} && $webvar{reciplist}) {
[517]431 $page->param(cantry => 1);
[426]432 $webvar{reciplist} =~ s/[\r\n]+/,/g;
[438]433 $webvar{msgaction} = "f:$webvar{msgaction}" if $webvar{onfail};
[517]434 $page->param(reciplist => $webvar{reciplist});
435 $page->param(dispnotice => dispNoticeCode($webvar{msgaction}.$webvar{alloctype}));
[426]436 $sth = $ip_dbh->prepare("INSERT INTO notify (action, reciplist) VALUES (?,?)");
[423]437##fixme: automagically merge reciplists iff action already exists
[426]438 $sth->execute($webvar{msgaction}.$webvar{alloctype}, $webvar{reciplist});
[517]439 $page->param(addfailed => $sth->errstr) if $sth->err;
[423]440 }
441
[424]442} elsif ($webvar{action} eq 'delnotice') {
[517]443
444 $page->param(dispnotice => dispNoticeCode($webvar{code}.$webvar{alloctype}));
[424]445 $sth = $ip_dbh->prepare("DELETE FROM notify WHERE action=?");
446 $sth->execute($webvar{code});
[517]447 $page->param(delfailed => $sth->errstr) if $sth->err;
[424]448
[422]449} elsif ($webvar{action} eq 'ednotice') {
[517]450
451 $page->param(dispnotice => dispNoticeCode($webvar{code}));
452 $page->param(code => $webvar{code});
[422]453 $sth = $ip_dbh->prepare("SELECT reciplist FROM notify WHERE action=?");
454 $sth->execute($webvar{code});
455 my ($reciplist) = $sth->fetchrow_array;
456 $reciplist =~ s/,/\n/g;
[517]457 $page->param(reciplist => $reciplist);
458
[422]459} elsif ($webvar{action} eq 'updnotice') {
[517]460
461 $page->param(dispnotice => dispNoticeCode($webvar{code}));
[422]462 $sth = $ip_dbh->prepare("UPDATE notify SET reciplist=? WHERE action=?");
463 $webvar{reciplist} =~ s/[\r\n]+/,/g;
464 $sth->execute($webvar{reciplist}, $webvar{code});
[517]465 $page->param(updfailed => $sth->errstr) if $sth->err;
466
[256]467} elsif ($webvar{action} ne '<NULL>') {
[517]468 $page->param(dunno => $webvar{action});
[54]469}
470
[517]471ERRJUMP: print "Content-type: text/html\n\n".$header->output;
472print $page->output;
[54]473
[517]474##fixme: make me a footer param!
475print qq(<hr><div><a href="$IPDB::webpath/">Back</a> to main interface</div>\n);
[54]476
[517]477# We print the footer here, so we don't have to do it elsewhere.
478my $footer = HTML::Template->new(filename => "footer.tmpl");
479# we're already in the admin tools, no need to provide a bottom link. maybe.
480#$footer->param(adminlink => ($IPDBacl{$authuser} =~ /A/));
[54]481
[517]482print $footer->output;
483
[54]484$ip_dbh->disconnect;
485
486exit;
487
488
[517]489# Hokay. This is a little different. We have a few specific functions here:
490# -> Assign arbitrary subnet from arbitrary free space
491# -> Tweak individual DB fields
492#
493
494
[54]495# Tweak allocfrom into shape.
496sub fix_allocfrom {
497 if ($webvar{allocfrom} =~ /^(\d+\.){2}\d+$/) {
498 # 3-octet class C specified
499 $webvar{allocfrom} .= ".0/24";
500 } elsif ($webvar{allocfrom} =~ /^(\d+\.){3}\d+$/) {
501 # 4-octet IP specified;
502 $webvar{allocfrom} .= "/24";
503 }
504}
505
506
[517]507# Show allocations to allow editing.
508sub showAllocs {
[58]509
[517]510 my $within = new NetAddr::IP $_[0];
511 $page->param(within => $within);
[58]512
[517]513 $sth = $ip_dbh->prepare("select cidr,custid,type,city,description from allocations where cidr <<= '$within' order by cidr");
[54]514 $sth->execute;
[517]515 my @blocklist;
516 while (my ($cidr,$custid,$type,$city,$desc) = $sth->fetchrow_array) {
517 my %row = (
518 cidr => $cidr,
519 custid => $custid,
520 city => $city,
521 desc => $desc,
522 );
[54]523
[517]524##fixme: don't wanna retrieve the whole type list *every time around the outer loop*
[348]525 my $sth2 = $ip_dbh->prepare("select type,listname from alloctypes".
526 " where listorder < 500 and not (type like '_i') order by listorder");
527 $sth2->execute;
[517]528 my @typelist;
529 while (my ($listtype,$dispname) = $sth2->fetchrow_array) {
530 my %subrow = (
531 type => $listtype,
532 dispname => $dispname,
533 selected => ($listtype eq $type)
534 );
535 push @typelist, \%subrow;
[348]536 }
[517]537 $row{typelist} = \@typelist;
538 push @blocklist, \%row;
[54]539 }
[517]540 $page->param(blocklist => \@blocklist);
541} # end showAllocs()
[54]542
543
544# Stuff updates into DB
545sub update {
[517]546 # Relatively simple SQL transaction here. Note that we're deliberately NOT
547 # updating notes/desc here as it's available through the main interface.
548 $sth = $ip_dbh->prepare("update allocations set custid='$webvar{custid}',".
549 "city=?,type='$webvar{alloctype}' where cidr='$webvar{block}'");
550 $sth->execute($webvar{city});
551
552 $page->param(block => $webvar{block});
553 if ($sth->err) {
554 $page->param(updfailed => $sth->errstr);
555 syslog "err", "$authuser could not update block '$webvar{block}': '".$sth->errstr."'";
[54]556 } else {
557 syslog "notice", "$authuser updated $webvar{block}";
558 }
559 # need to get /24 that block is part of
560 my @bits = split /\./, $webvar{block};
561 $bits[3] = "0/24";
562 showAllocs((join ".", @bits));
[517]563} # end update()
[65]564
565
566# showPool()
567# List all IPs in a pool, and allow arbitrary admin changes to each
568# Allow changes to ALL fields
[548]569sub showPool {
[65]570 my $pool = new NetAddr::IP $_[0];
[348]571
572 $sth = $ip_dbh->prepare("select type,listname from alloctypes where type like '_i' order by listorder");
573 $sth->execute;
[517]574 my @typelist;
575 while (my ($type,$dispname) = $sth->fetchrow_array) {
576 my %row = (
577 type => $type,
578 dispname => $dispname
579 );
580 push @typelist, \%row;
[348]581 }
[517]582 $page->param(typelist => \@typelist);
[348]583
[548]584 $sth = $ip_dbh->prepare("SELECT ip,custid,city,type,available,description,notes from poolips".
585 " WHERE pool=? ORDER BY ip");
586 $sth->execute($pool);
[517]587 my @iplist;
588 while (my ($ip,$custid,$city,$type,$avail,$desc,$notes) = $sth->fetchrow_array) {
589 my %row = (
590 ip => $ip,
591 custid => $custid,
592 city => $city,
593 type => $type,
594 avail => $avail,
595 desc => $desc,
596 notes => $notes
597 );
598 push @iplist, \%row;
[65]599 }
[517]600 $page->param(iplist => \@iplist);
601} # end showPool()
[422]602
603
604# interpret the notify codes
605sub dispNoticeCode {
606 my $code = shift;
607 my $action_out = '';
[426]608
609 if ($code =~ /^s:/) {
610 $code =~ s/^s:/Special: /;
611 return $code;
612 }
[422]613 if ($code =~ /^f:(.+)$/) {
614 $code =~ s/^f://;
615 $action_out = "Failure on ";
616 }
617 if (my $target = $code =~ /^n(.+)/) {
618 $action_out .= "New ";
619 if ($1 eq 'ci') { $action_out .= "city"; }
620 elsif ($1 eq 'no') { $action_out .= "node"; }
621 else { $action_out .= '&lt;unknown&gt;'; }
622 } else {
623 my ($action,$target) = ($code =~ /^(.)(.+)$/);
624 if ($action eq 'a') { $action_out .= 'Add '; }
625 elsif ($action eq 'u') { $action_out .= 'Update '; }
626 elsif ($action eq 'd') { $action_out .= 'Delete '; }
627##fixme: what if we get something funky?
[423]628# What about the eleventy-billion odd combinations possible?
629# this should give an idea of the structure tho
[422]630 if ($target eq 'a') { $action_out .= "all"; }
[438]631 elsif ($target eq '.i') {
[423]632 $action_out .= "all static IPs";
633 }
[422]634 else { $action_out .= $disp_alloctypes{$target}; }
635 }
636 return $action_out;
637}
Note: See TracBrowser for help on using the repository browser.