Changeset 356 for branches/stable/cgi-bin/IPDB.pm

Timestamp:

01/05/07 10:50:47 (17 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

File:

• branches/stable/cgi-bin/IPDB.pm (modified) (3 diffs)

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