hackers  

[freeipdb-hackers] new SQL subroutines

Ish-Lev Avshalom
Tue, 16 Sep 2003 06:26:29 -0700

Hi all,
It's been awhile since I last wrote to this list...

I've been experimenting with the code a bit, and found that it was extremly
difficult to modify the code to support a new column I've added to the IPDB
table.
this was because all the code reffered to the columns by location in the
table (fetchrow). so I've added some functions to the ipdb_lib.pl file that
standardize the way the SQL db is queried, and modified most of the
functions to use those subs. it also cut down the number of code lines
significantly. I have also improved the list view to show for each parent
the number of free subnets available from it (e.g. 2 16bits subnets, 1
24bits and 1 32bits").
there were also alot of bug fixes.
only problem is that I made all those changes awhile ago, and they were made
to version 0.1.1 if anyone is interested in helping me apply those changes
to the v0.2 branch, please contact me - I just don't have the time nowadays
to do it myself. it's mostly cut&paste and small code alterations.


-- 
Regards,
Ish-Lev Avshalom.