source: trunk/cgi-bin/freespace.pl @ 320

Last change on this file since 320 was 320, checked in by Kris Deugau, 16 years ago

/trunk

Merge all bugfixes, hacks, tweaks, and miscellaneous updates from
/branches/stable necessary to bring code into line. Aside from
CustID verification and notification bits, /trunk and
/branches/stable should now be identical.

  • Property svn:executable set to *
  • Property svn:keywords set to Date Rev Author
File size: 1.2 KB
Line 
1#!/usr/bin/perl
2# ipdb/cgi-bin/freespace.pl
3# Quick hack to calculate aggregate free IP space, and statistic-ify the blocks.
4###
5# SVN revision info
6# $Date: 2006-04-04 22:25:28 +0000 (Tue, 04 Apr 2006) $
7# SVN revision $Rev: 320 $
8# Last update by $Author: kdeugau $
9###
10# Copyright (C) 2004-2006 - Kris Deugau
11
12use DBI;
13use MyIPDB;
14use NetAddr::IP;
15
16($dbh,$errstr) = connectDB_My;
17
18print "Content-type: text/plain\n\n";
19
20$tnumfree = $bigrfree = $bigufree = 0;
21
22$sql = 'select * from freeblocks where ';
23# General counts first
24if ($ARGV[0]) {
25  $sql .= 'maskbits >= $ARGV[0] and ';
26}
27$sql .= "not (cidr <<= '192.168.0.0/16') ".
28                "and not (cidr <<= '172.16.0.0/12') ".
29                "and not (cidr <<= '10.0.0.0/8') ";
30$sql .= "order by maskbits desc";
31
32$sth = $dbh->prepare($sql);
33$sth->execute;
34while (@data = $sth->fetchrow_array) {
35  # cidr,maskbits,city,routed
36  $tnumfree++;
37  $numfree{"$data[1]"}++;
38}
39
40print "Free block counts:\n";
41foreach $size (sort {$a cmp $b} keys %numfree) {
42  print "/$size: $numfree{$size}\n";
43}
44print "\n";
45
46for ($i=30; $i>16; $i--) {
47  $j = $i-1;
48  $numfree{"$j"} += int $numfree{"$i"}/2;
49  $numfree{"$i"} -= (int $numfree{"$i"}/2)*2;
50}
51
52print "Aggregate free space:\n";
53foreach $size (sort {$a cmp $b} keys %numfree) {
54  print "/$size: $numfree{$size}\n";
55}
Note: See TracBrowser for help on using the repository browser.