Changeset 121 for branches/stable/cgi-bin

Timestamp:

01/07/05 11:01:47 (20 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Fixed SQL buglet where deleted static IP allocations retain
information in the Notes and CircuitID fields when deallocated

File:

• branches/stable/cgi-bin/main.cgi (modified) (1 diff)

branches/stable/cgi-bin/main.cgi

@@ -1484 +1484 @@
       @data = $sth->fetchrow_array;
       $sth = $ip_dbh->prepare("update poolips set custid='6750400', available='y',".
-        " city='$data[0]', description='' where ip='$webvar{block}'");
+        " city='$data[0]', description='', notes='', circuitid='' where ip='$webvar{block}'");
       $sth->execute;
       $ip_dbh->commit;