Changeset 46 for trunk/cgi-bin

Timestamp:

11/01/04 11:57:52 (20 years ago)

Author:

Kris Deugau

Message:

/trunk

SQL bugfixes:

• New static IP would not get assigned
• Deleting a static IP assignment now clears the "Description" field

File:

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

trunk/cgi-bin/main.cgi

@@ -979 +979 @@
     my $cidr = $data[1];
 
-    $sth = $ip_dbh->prepare("update poolips set custid='$webvar{custid}',city='$webvar{city}'".
-        " available='n',description='$webvar{desc}'".
+    $sth = $ip_dbh->prepare("update poolips set custid='$webvar{custid}',".
+        "city='$webvar{city}',available='n',description='$webvar{desc}'".
         " where ip='$cidr'");
     $sth->execute;
@@ -1416 +1416 @@
       @data = $sth->fetchrow_array;
       $sth = $ip_dbh->prepare("update poolips set custid='6750400', available='y',".
-        " city='$data[0]' where ip='$webvar{block}'");
+        " city='$data[0]', description='' where ip='$webvar{block}'");
       $sth->execute;
       $ip_dbh->commit;