Changeset 356 for branches

Timestamp:

01/05/07 10:50:47 (18 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Bump up the verbosity of deallocation notices
Required a new function (getBlockData) to extract the data
before deleting the block

Location:

branches/stable/cgi-bin

Files:

• IPDB.pm (modified) (3 diffs)
• main.cgi (modified) (1 diff)

branches/stable/cgi-bin/IPDB.pm

@@ -25 +25 @@
         %allocated %free %routed %bigfree %IPDBacl
         &initIPDBGlobals &connectDB &finish &checkDBSanity &allocateBlock &deleteBlock
-        &mailNotify
+        &getBlockData &mailNotify
         );
 
@@ -33 +33 @@
                 @masterblocks %allocated %free %routed %bigfree %IPDBacl
                 &initIPDBGlobals &connectDB &finish &checkDBSanity &allocateBlock
-                &deleteBlock &mailNotify
+                &deleteBlock &getBlockData &mailNotify
                 )]
         );
@@ -668 +668 @@
 
 
+## IPDB::getBlockData()
+# Return custid, type, city, and description for a block
+sub getBlockData {
+  my $dbh = shift;
+  my $block = shift;
+
+  my $sth = $dbh->prepare("select cidr,custid,type,city,description from searchme".
+        " where cidr='$block'");
+  $sth->execute();
+  return $sth->fetchrow_array();
+} # end getBlockData()
+
+
 ## IPDB::mailNotify()
 # Sends notification mail to recipients regarding an IPDB operation

branches/stable/cgi-bin/main.cgi

@@ -1298 +1298 @@
   }
 
+  # need to retrieve block data before deleting so we can notify on that
+  my ($cidr,$custid,$type,$city,$description) = getBlockData($ip_dbh, $webvar{block});
+
   my ($code,$msg) = deleteBlock($ip_dbh, $webvar{block}, $webvar{alloctype});
 
   if ($code eq 'OK') {
     print "<div class=heading align=center>Success!  $webvar{block} deallocated.</div>\n";
-    syslog "notice", "$authuser deallocated '$webvar{alloctype}'-type netblock $webvar{block}";
+    syslog "notice", "$authuser deallocated '$webvar{alloctype}'-type netblock $webvar{block}".
+        " $custid, $city, desc='$description'";
     # Notify tech@ when a block/IP is deallocated
     mailNotify('tech@example.com',"REMOVED: $disp_alloctypes{$webvar{alloctype}} $webvar{block}",
-        "$disp_alloctypes{$webvar{alloctype}} $webvar{block} deallocated by $authuser\n");
+        "$disp_alloctypes{$webvar{alloctype}} $webvar{block} deallocated by $authuser\n".
+        "CustID: $custid\nCity: $city\nDescription: $description\n");
   } else {
     if ($webvar{alloctype} =~ /^.i$/) {