#
# ChangeLog for trunk
#
# Generated by Trac 1.6
# 06/01/24 04:37:23

Tue, 01 Mar 2005 20:57:53 GMT Kris Deugau [182]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Preseed alloctypes table with current types ("common" ones ...


Tue, 01 Mar 2005 20:56:35 GMT Kris Deugau [181]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Change SQL definitions to create the database before ...


Tue, 01 Mar 2005 19:44:40 GMT Kris Deugau [180]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Fix another buglet with the SQL definitions.  Picky, picky...


Tue, 01 Mar 2005 19:08:15 GMT Kris Deugau [179]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Fix buglet in SQL definitions (ported forward from ...


Tue, 01 Mar 2005 18:31:45 GMT Kris Deugau [176]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Full update of ipdb.psql without extraneous pg_dump bits, ...


Tue, 01 Mar 2005 16:49:46 GMT Kris Deugau [175]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Updated SQL table definitions - pg_dump format


Thu, 24 Feb 2005 22:12:09 GMT Kris Deugau [173]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Merged additional SQL cleanup changes from ...


Tue, 22 Feb 2005 19:25:58 GMT Kris Deugau [167]
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/consistency-check.pl (modified)
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 New feature:  Different "default" CustIDs depending on the ...


Tue, 22 Feb 2005 17:23:36 GMT Kris Deugau [166]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Merged bugfixes from /branches/stable r162-165.
	  ** NB:  ...


Wed, 09 Feb 2005 22:56:08 GMT Kris Deugau [161]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Backport bugfix from /branches/stable r160


Tue, 08 Feb 2005 20:56:33 GMT Kris Deugau [157]
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Merge changes from /branches/sql-cleanup into mainline
	  - ...


Tue, 01 Feb 2005 22:02:39 GMT Kris Deugau [146]
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/admin.cgi (modified)
	* trunk/cgi-bin/extras/db2rwhois.pl (modified)
	* trunk/cgi-bin/freespace.pl (modified)

	/trunk
	 Update copyright statements


Mon, 31 Jan 2005 23:12:32 GMT Kris Deugau [144]
	* trunk/assign.html (modified)

	/trunk
	 Speeling fix in assign.html


Fri, 28 Jan 2005 23:01:20 GMT Kris Deugau [143]
	* trunk/cgi-bin/extras/db2rwhois.pl (modified)

	/trunk
	 Tweak/update db2rwhois with latest (My)IPDB interface


Fri, 28 Jan 2005 19:04:55 GMT Kris Deugau [142]
	* trunk/cgi-bin/MyIPDB.pm (added)
	* trunk/cgi-bin/consistency-check.pl (modified)
	* trunk/cgi-bin/freespace.pl (modified)
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/cgi-bin/newcity.cgi (modified)

	/trunk
	 Wrap connectDB() function in a "module" so we don't get ...


Fri, 28 Jan 2005 18:41:07 GMT Kris Deugau [141]
	* trunk/cgi-bin/extras/db2rwhois.pl (modified)

	/trunk
	 Fix svn: properties on db2rwhois.pl.  Really.


Thu, 27 Jan 2005 22:31:57 GMT Kris Deugau [139]
	* trunk/assign.html (modified)
	* trunk/cgi-bin/newcity.cgi (added)
	* trunk/changes.html (modified)
	* trunk/newcity.html (added)

	/trunk
	 Added ability to add cities/locations to database.
	 Not yet ...


Wed, 26 Jan 2005 22:31:33 GMT Kris Deugau [138]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Redesign alloctype check so that it checks alloctypes that ...


Wed, 26 Jan 2005 22:07:26 GMT Kris Deugau [137]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Merge bugfix in /branches/stable r136


Wed, 26 Jan 2005 20:30:30 GMT Kris Deugau [135]
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Merge bugfixes from /branches/stable r130:134


Thu, 20 Jan 2005 20:30:33 GMT Kris Deugau [130]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Backported r128 and r129 bugfixes from /branches/stable


Fri, 07 Jan 2005 16:00:06 GMT Kris Deugau [120]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Fixed some SQL bugs before they become problems - make sure ...


Thu, 06 Jan 2005 20:42:50 GMT Kris Deugau [119]
	* trunk/cgi-bin/freespace.pl (copied)

	/trunk
	 Port freespace.pl forward from /branches/stable r117


Thu, 06 Jan 2005 20:03:33 GMT Kris Deugau [118]
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 SQL cleanup:
	  - Made liberal use of "<<=" operator and ...


Wed, 05 Jan 2005 16:35:29 GMT Kris Deugau [115]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Cosmetic fix in "Add new master" code


Fri, 24 Dec 2004 20:10:56 GMT Kris Deugau [111]
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/index.shtml (modified)

	/trunk
	 Cleanup of display and fallthrough logic:
	  - printFooter ...


Fri, 24 Dec 2004 20:03:46 GMT Kris Deugau [110]
	* trunk/fb-assign.html (modified)

	/trunk
	 Change fb-assign.html to allow pulling allocation types from ...


Fri, 24 Dec 2004 20:03:00 GMT Kris Deugau [109]
	* trunk/assign.html (modified)

	/trunk
	 Change assign.html to allow allocation types to pulled from ...


Fri, 24 Dec 2004 19:13:41 GMT Kris Deugau [108]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Fix SQL bug in static-IP section of allocateBlock()


Fri, 24 Dec 2004 19:12:34 GMT Kris Deugau [107]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Fix error reporting in allocateBlock() to return the SQL ...


Wed, 22 Dec 2004 21:25:59 GMT Kris Deugau [106]
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/consistency-check.pl (modified)
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 IPDB rewrite, first stable iteration.
	  -> uses ...


Wed, 22 Dec 2004 19:21:44 GMT Kris Deugau [105]
	* trunk/cgi-bin/CommonWeb.pm (modified)

	/trunk
	 Updated printError function so that it does NOT exit, to ...


Wed, 01 Dec 2004 20:53:28 GMT Kris Deugau [96]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Added city and POP list initialization


Wed, 01 Dec 2004 20:46:46 GMT Kris Deugau [95]
	* trunk/cgi-bin/CommonWeb.pm (modified)
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/admin.cgi (modified)
	* trunk/cgi-bin/consistency-check.pl (modified)
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Corrected incorrect or missing svn:* properties on
	 Perl ...


Wed, 01 Dec 2004 20:29:09 GMT Kris Deugau [93]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Add deleteBlock() sub


Tue, 30 Nov 2004 20:42:30 GMT Kris Deugau [92]
	* trunk/assign.html (modified)
	* trunk/cgi-bin/ipdb.psql (modified)
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/changes.html (modified)
	* trunk/fb-assign.html (modified)

	/trunk
	 Port updates and bugfixes from /branches/stable r87:91 back ...


Fri, 26 Nov 2004 22:28:19 GMT Kris Deugau [87]
	* trunk/assign.html (modified)
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/changes.html (copied)
	* trunk/fb-assign.html (modified)
	* trunk/header.inc (modified)

	/trunk
	 Port bugfixes and tweaks from /branches/stable r79:86 forward.


Fri, 26 Nov 2004 17:50:01 GMT Kris Deugau [80]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Further tweaked allocateBlock()'s calls to initPool() to ...


Fri, 26 Nov 2004 17:35:43 GMT Kris Deugau [79]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Redesigned error handling in allocateBlock() to return more ...


Tue, 23 Nov 2004 22:44:12 GMT Kris Deugau [78]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Updated allocBlock() to properly handle and return errors
	 ...


Fri, 19 Nov 2004 22:43:36 GMT Kris Deugau [77]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Flesh out allocateBlock() and initPool()
	 Begin work on ...


Tue, 16 Nov 2004 20:10:08 GMT Kris Deugau [74]
	* trunk/assign.html (modified)
	* trunk/cgi-bin/ipdb.psql (modified)
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/confirm.html (modified)
	* trunk/confirmRemove.html (modified)
	* trunk/editDisplay.html (modified)
	* trunk/updated.html (modified)

	/trunk
	 Added a CircuitID field on both netblock and static IP
	 ...


Mon, 15 Nov 2004 21:55:54 GMT Kris Deugau [73]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Hack to allow manual allocation of specific static IPs by ...


Mon, 15 Nov 2004 21:53:24 GMT Kris Deugau [72]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Fixed checks for static-ip allocation types.  Really.  For sure.


Mon, 15 Nov 2004 17:37:23 GMT Kris Deugau [70]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Add email notification for static IP assignment
	  - ...


Mon, 15 Nov 2004 17:36:31 GMT Kris Deugau [69]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Fix for mailNotify() so it works


Fri, 12 Nov 2004 21:57:59 GMT Kris Deugau [68]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Fixed broken headers in mailNotify()


Fri, 12 Nov 2004 20:18:28 GMT Kris Deugau [67]
	* trunk/cgi-bin/consistency-check.pl (modified)

	/trunk
	 Minor nitpicking cosmetic fix for consistency-check.pl


Fri, 12 Nov 2004 20:17:59 GMT Kris Deugau [66]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk
	 Shell of allocateBlock() function added
	 mailNotify ...


Fri, 12 Nov 2004 20:12:45 GMT Kris Deugau [65]
	* trunk/cgi-bin/admin.cgi (modified)

	/trunk
	 Major update to admin tool;  adds more or less complete
	 ...


Fri, 12 Nov 2004 16:52:03 GMT Kris Deugau [63]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Clean up some error handling code relating to DB transactions


Thu, 11 Nov 2004 21:27:28 GMT Kris Deugau [62]
	* trunk/cgi-bin/consistency-check.pl (modified)

	/trunk
	 Updated consistency check script to check for anomalies in ...


Thu, 11 Nov 2004 20:49:04 GMT Kris Deugau [61]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Numerous minor bugfixes in logic
	  - pool IP types ...


Wed, 10 Nov 2004 21:57:34 GMT Kris Deugau [58]
	* trunk/cgi-bin/admin.cgi (modified)

	/trunk
	 Finished first "complete" edition of admin interface for IPDB.


Wed, 10 Nov 2004 21:54:02 GMT Kris Deugau [57]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Updated schema dump for IPDB


Fri, 05 Nov 2004 19:04:03 GMT Kris Deugau [55]
	* trunk/footer.inc (modified)

	/trunk
	 Fix the cosmetic fix in footer.inc


Fri, 05 Nov 2004 19:03:21 GMT Kris Deugau [54]
	* trunk/cgi-bin/admin.cgi (added)

	/trunk
	 Added admin.cgi with mostly-complete "update allocation ...


Thu, 04 Nov 2004 21:57:55 GMT Kris Deugau [52]
	* trunk/footer.inc (modified)

	/trunk
	 Cosmetic fixes to footer.inc


Tue, 02 Nov 2004 18:15:53 GMT Kris Deugau [51]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Merge bugfixes and updates from /branches/stable r49 and r50


Mon, 01 Nov 2004 17:05:34 GMT Kris Deugau [47]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Bugfixes on error reporting:  Make sure to syslog before ...


Mon, 01 Nov 2004 16:57:52 GMT Kris Deugau [46]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 SQL bugfixes:
	 - New static IP would not get assigned
	 - ...


Mon, 01 Nov 2004 16:14:37 GMT Kris Deugau [45]
	* trunk/assign.html (modified)
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/header.inc (modified)

	/trunk
	 Merge bugfixes from /branches/stable r43 and r44


Mon, 01 Nov 2004 15:49:35 GMT Kris Deugau [42]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Merge bugfix from /branches/stable r41


Thu, 28 Oct 2004 20:26:39 GMT Kris Deugau [40]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Bugfix for final stage of allocating a static IP


Thu, 28 Oct 2004 18:59:51 GMT Kris Deugau [38]
	* trunk/alloctypes.html (modified)
	* trunk/assign.html (modified)
	* trunk/fb-assign.html (modified)
	* trunk/header.inc (modified)

	/trunk
	 Various cosmetic fixes with respect to displayed allocation types


Thu, 28 Oct 2004 18:14:03 GMT Kris Deugau [37]
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Fixed some logic errors with respect to allocating IP pools


Thu, 28 Oct 2004 17:45:53 GMT Kris Deugau [36]
	* trunk/header.inc (modified)

	/trunk
	 Blatant warnings on /trunk/header.inc

	 DO NOT MERGE TO ...


Thu, 28 Oct 2004 16:31:12 GMT Kris Deugau [34]
	* trunk/cgi-bin/ipdb.psql (modified)

	/trunk
	 Updated Postgres schema dump


Wed, 27 Oct 2004 21:01:02 GMT Kris Deugau [33]
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/editDisplay.html (modified)

	/trunk
	 Allow changing "whole" netblock types (dynamic DSL, cable,
	 ...


Wed, 27 Oct 2004 16:34:06 GMT Kris Deugau [31]
	* trunk/assign.html (modified)
	* trunk/cgi-bin/main.cgi (modified)

	/trunk
	 Allow selection of which master to allocate a block from


Wed, 27 Oct 2004 16:29:05 GMT Kris Deugau [30]
	* trunk/assign.html (modified)

	/trunk
	 Merge clarity fix for assign.html from /branches/stable r28


Tue, 26 Oct 2004 21:22:22 GMT Kris Deugau [27]
	* trunk/cgi-bin/main.cgi (modified)

	Added Thunder Bay to list of POP cities in route-new-block check


Tue, 26 Oct 2004 15:19:53 GMT Kris Deugau [23]
	* trunk/cgi-bin/main.cgi (modified)

	Add tweak to allow newly-entered custIDs to end with "-nn"


Mon, 25 Oct 2004 21:38:34 GMT Kris Deugau [22]
	* trunk/cgi-bin/main.cgi (modified)

	Tweaked delete logging to make it clear what type of block was
	deleted


Mon, 25 Oct 2004 21:38:02 GMT Kris Deugau [21]
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/fb-assign.html (added)

	Added support for directly assigning blocks listed as "free"


Mon, 25 Oct 2004 21:35:54 GMT Kris Deugau [20]
	* trunk/cgi-bin/main.cgi (modified)
	* trunk/editDisplay.html (modified)

	Allow updating city for an allocation


Mon, 25 Oct 2004 21:35:06 GMT Kris Deugau [19]
	* trunk/assign.html (modified)

	Added Thunder Bay to city list


Mon, 25 Oct 2004 21:33:36 GMT Kris Deugau [17]
	* trunk/cgi-bin/main.cgi (modified)

	Fixed incorrect syslog error statements


Mon, 25 Oct 2004 21:32:50 GMT Kris Deugau [16]
	* trunk/cgi-bin/IPDB.pm (modified)

	/trunk/cgi-bin/IPDB.pm:
	  Remove CommonWeb.pm dependency from ...


Mon, 25 Oct 2004 21:32:05 GMT Kris Deugau [15]
	* trunk/cgi-bin/extras/db2rwhois.pl (modified)

	Updated db2rwhois.pl for new database format


Mon, 25 Oct 2004 21:31:26 GMT Kris Deugau [14]
	* trunk/header.inc (modified)

	header.inc:
	 - Cosmetic fixes to spacing/indentation
	 - Remove ...


Mon, 25 Oct 2004 21:30:13 GMT Kris Deugau [13]
	* trunk/cgi-bin/main.cgi (modified)

	main.cgi:  Fix broken or not-quite-right SQL statements


Mon, 25 Oct 2004 21:29:26 GMT Kris Deugau [12]
	* trunk/cgi-bin/main.cgi (modified)

	cgi-bin/main.cgi:
	 - Added wireless IP and IP pool types
	 - Fixed ...


Mon, 25 Oct 2004 21:28:12 GMT Kris Deugau [11]
	* trunk/cgi-bin/consistency-check.pl (modified)

	Near-complete rewrite of cgi-bin/consistency-check.pl
	 - It works ...


Mon, 25 Oct 2004 21:27:31 GMT Kris Deugau [10]
	* trunk/alloctypes.html (modified)

	Typo/thinko fixes and removal of debug-ish section in alloctypes.html


Mon, 25 Oct 2004 21:26:56 GMT Kris Deugau [9]
	* trunk/cgi-bin/main.cgi (modified)

	Minor bugfix on search display - one type of pool didn't show
	a ...


Mon, 25 Oct 2004 21:26:10 GMT Kris Deugau [8]
	* trunk/cgi-bin/CommonWeb.pm (modified)
	* trunk/cgi-bin/IPDB.pm (modified)
	* trunk/cgi-bin/consistency-check.pl (modified)
	* trunk/cgi-bin/main.cgi (modified)

	Added SVN revision info section to cgi-bin/CommonWeb.pm, ...


Mon, 25 Oct 2004 21:24:33 GMT Kris Deugau [7]
	* trunk/cgi-bin/add-alloc.php (deleted)
	* trunk/cgi-bin/add-route.php (deleted)
	* trunk/cgi-bin/edit-alloc.php (deleted)
	* trunk/cgi-bin/edit-route.php (deleted)
	* trunk/cgi-bin/httpauth.php (deleted)
	* trunk/cgi-bin/import.pl (deleted)
	* trunk/cgi-bin/import2.pl (deleted)
	* trunk/cgi-bin/main-alpha1.cgi (deleted)
	* trunk/cgi-bin/main-alpha2.cgi (deleted)
	* trunk/cgi-bin/main-beta1.cgi (deleted)
	* trunk/cgi-bin/manual.htm (deleted)
	* trunk/cgi-bin/showenv.cgi (deleted)
	* trunk/cgi-bin/upd-alloc.php (deleted)

	Remove non-critical legacy and development files


Mon, 25 Oct 2004 21:17:49 GMT Kris Deugau [6]
	* trunk/cgi-bin/add-alloc.php (added)
	* trunk/cgi-bin/add-route.php (added)
	* trunk/cgi-bin/consistency-check.pl (added)
	* trunk/cgi-bin/edit-alloc.php (added)
	* trunk/cgi-bin/edit-route.php (added)
	* trunk/cgi-bin/httpauth.php (added)
	* trunk/cgi-bin/import.pl (added)
	* trunk/cgi-bin/import2.pl (added)
	* trunk/cgi-bin/main-alpha1.cgi (added)
	* trunk/cgi-bin/main-alpha2.cgi (added)
	* trunk/cgi-bin/main-beta1.cgi (added)
	* trunk/cgi-bin/manual.htm (added)
	* trunk/cgi-bin/showenv.cgi (added)
	* trunk/cgi-bin/upd-alloc.php (added)

	Add intermediate development files for posterity


Mon, 25 Oct 2004 21:12:22 GMT Kris Deugau [4]
	* trunk/addmaster.shtml (added)
	* trunk/alloctypes.html (added)
	* trunk/assign.html (added)
	* trunk/cgi-bin/CommonWeb.pm (added)
	* trunk/cgi-bin/IPDB.pm (added)
	* trunk/cgi-bin/ipdb.psql (added)
	* trunk/cgi-bin/main.cgi (added)
	* trunk/cgi-bin/snCalc.cgi (added)
	* trunk/confirm.html (added)
	* trunk/confirmRemove.html (added)
	* trunk/editDisplay.html (added)
	* trunk/footer.inc (added)
	* trunk/header.inc (added)
	* trunk/help.html (added)
	* trunk/images (added)
	* trunk/images/logo.png (added)
	* trunk/index.shtml (added)
	* trunk/ipdb.css (added)
	* trunk/startsn.html (added)
	* trunk/updated.html (added)

	Import "new" IPDB development:
	  March 2004 through end of August ...


Mon, 25 Oct 2004 21:06:58 GMT Kris Deugau [2]
	* trunk/cgi-bin (added)
	* trunk/cgi-bin/extras (added)
	* trunk/cgi-bin/extras/db2rwhois.pl (added)

	/trunk
	 Import rWHOIS export script based on old db


Mon, 25 Oct 2004 21:02:57 GMT Kris Deugau [1]
	* branches (added)
	* tags (added)
	* trunk (added)

	trunk/branches/tags template import