Changeset 50 for branches/stable/cgi-bin

Timestamp:

11/02/04 13:14:41 (20 years ago)

Author:

Kris Deugau

Message:

/branches/stable

SQL update for deleting blocks to make sure the correct city
gets attached to the new freeblocks entry.

File:

• branches/stable/cgi-bin/main.cgi (modified) (2 diffs)

branches/stable/cgi-bin/main.cgi

@@ -1482 +1482 @@
 
         # Set up query for compacting free blocks.
-        $sth = $ip_dbh->prepare("select * from freeblocks where city='$webvar{city}'".
+        $sth = $ip_dbh->prepare("select * from freeblocks where cidr << ".
+                "(select cidr from routed where cidr >> '$cidr') ".
                 " and maskbits<=".$cidr->masklen." and routed='y' order by maskbits desc");
 
@@ -1528 +1529 @@
       } else {
         $sth = $ip_dbh->prepare("insert into freeblocks values ('$cidr',".$cidr->masklen.
-                ",'$webvar{city}','y')");
+                ",(select city from routed where cidr >>= '$cidr'),'y')");
       }
       $sth->execute;