# # ChangeLog for / # # Generated by Trac 1.6 # 12/22/24 07:18:28 Fri, 04 Feb 2005 22:35:56 GMT Kris Deugau [155] * branches/sql-cleanup/cgi-bin/main.cgi (modified) /branches/sql-cleanup Fixed (most) of the last of the semi-"legacy" ... Fri, 04 Feb 2005 22:29:30 GMT Kris Deugau [154] * branches/sql-cleanup/cgi-bin/main.cgi (modified) /branches/sql-cleanup main.cgi: - Removed commented legacy ... Fri, 04 Feb 2005 21:32:25 GMT Kris Deugau [153] * branches/sql-cleanup/cgi-bin/IPDB.pm (modified) /branches/sql-cleanup Another fix related to generalizing pools and ... Fri, 04 Feb 2005 19:32:42 GMT Kris Deugau [152] * branches/stable/cgi-bin/IPDB.pm (modified) /branches/stable Temporary-ish patch to properly handle static ... Fri, 04 Feb 2005 16:04:55 GMT Kris Deugau [151] * branches/stable/cgi-bin/CustIDCK.pm (modified) /branches/stable More bugfixes and error-trapping to make sure we ... Thu, 03 Feb 2005 19:25:01 GMT Kris Deugau [150] * branches/sql-cleanup/cgi-bin/IPDB.pm (modified) /branches/sql-cleanup Oops, missed some code updates required for ... Thu, 03 Feb 2005 19:23:34 GMT Kris Deugau [149] * branches/sql-cleanup/cgi-bin/IPDB.pm (modified) * branches/sql-cleanup/cgi-bin/main.cgi (modified) /branches/sql-cleanup Fixed a bunch of general problems with pool ... Tue, 01 Feb 2005 22:53:31 GMT Kris Deugau [148] * branches/sql-cleanup/cgi-bin/IPDB.pm (modified) /branches/sql-cleanup Fix in initPool() - missing a bracket in the ... Tue, 01 Feb 2005 22:43:34 GMT Kris Deugau [147] * branches/sql-cleanup/cgi-bin/IPDB.pm (modified) /branches/sql-cleanup First round of SQL cleanup and fixes - IPDB.pm 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 Tue, 01 Feb 2005 20:01:46 GMT Kris Deugau [145] * branches/sql-cleanup (copied) Branch /trunk r144 to /branches/sql-cleanup to go over the SQL with ... 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:37:31 GMT Kris Deugau [140] * branches/stable/assign.html (modified) * branches/stable/cgi-bin/main.cgi (modified) * branches/stable/cgi-bin/newcity.cgi (copied) * branches/stable/changes.html (modified) * branches/stable/newcity.html (copied) /branches/stable Merge changes from /trunk r138,139 into ... 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 22:05:46 GMT Kris Deugau [136] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Bugfix for new "dw" Dynamic WiFi type to let it ... 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 Tue, 25 Jan 2005 15:49:35 GMT Kris Deugau [134] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Fix display glitch that causes an extra cell to be ... Tue, 25 Jan 2005 15:42:45 GMT Kris Deugau [133] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Fix "change allocation type" glitch due to change ... Fri, 21 Jan 2005 17:31:49 GMT Kris Deugau [132] * branches/stable/cgi-bin/IPDB.pm (modified) /branches/stable Bugfix for missing IP in static-IP allocation ... Fri, 21 Jan 2005 17:18:25 GMT Kris Deugau [131] * branches/stable/cgi-bin/IPDB.pm (modified) /branches/stable Bugfix for mailNotify() - probably mangled in the ... 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 Thu, 20 Jan 2005 17:32:03 GMT Kris Deugau [129] * branches/stable/cgi-bin/IPDB.pm (modified) /branches/stable Fix SQL (un)sort buglet (cities not sorted) Tue, 18 Jan 2005 19:56:09 GMT Kris Deugau [128] * branches/stable/cgi-bin/checkcusts.pl (modified) /branches/stable Fixed checkcusts.pl to work with new IPDB.pm interface. Tue, 18 Jan 2005 19:43:51 GMT Kris Deugau [127] * branches/stable/cgi-bin/IPDB.pm (modified) /branches/stable Whoops! Miscopied the "patch" for the hack to ... Tue, 18 Jan 2005 18:13:14 GMT Kris Deugau [126] * branches/stable/cgi-bin/IPDB.pm (modified) /branches/stable Re-port temporary hack to "properly" deallocate ... Fri, 14 Jan 2005 23:03:44 GMT Kris Deugau [125] * branches/stable/cgi-bin/IPDB.pm (modified) * branches/stable/cgi-bin/consistency-check.pl (modified) * branches/stable/cgi-bin/freespace.pl (modified) * branches/stable/cgi-bin/main.cgi (modified) * branches/stable/index.shtml (modified) /branches/stable Complete merge of code rewrite from /trunk ~r104 ... Fri, 07 Jan 2005 18:20:32 GMT Kris Deugau [124] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Fixed buglet that caused deallocated "netblocks" ... Fri, 07 Jan 2005 17:59:52 GMT Kris Deugau [123] * branches/stable/cgi-bin/checkcusts.pl (added) /branches/stable Added checkcusts.pl script to walk through the ... Fri, 07 Jan 2005 16:43:08 GMT Kris Deugau [122] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Added email notification for customer netblock ... Fri, 07 Jan 2005 16:01:47 GMT Kris Deugau [121] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Fixed SQL buglet where deleted static IP ... 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 ... Thu, 06 Jan 2005 16:14:21 GMT Kris Deugau [117] * branches/stable/cgi-bin/freespace.pl (added) /branches/stable Added freespace.pl free-space-stats generator Wed, 05 Jan 2005 20:49:17 GMT Kris Deugau [116] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Removed hardcoded CustID check for "TEMP" 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 Wed, 05 Jan 2005 16:06:37 GMT Kris Deugau [114] * branches/stable/cgi-bin/CustIDCK.pm (modified) /branches/stable Second iteration of billing-failure detection. ... Fri, 31 Dec 2004 16:50:32 GMT Kris Deugau [113] * branches/stable/cgi-bin/CustIDCK.pm (modified) /branches/stable First-pass patch to avoid just hanging if the ... Thu, 30 Dec 2004 17:04:34 GMT Kris Deugau [112] * branches/stable/cgi-bin/CommonWeb.pm (modified) /branches/stable Backport printError fix from /trunk r105 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 ... Tue, 21 Dec 2004 19:35:43 GMT Kris Deugau [104] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Added description and "authuser" (HTTP-auth user) ... Wed, 15 Dec 2004 22:32:45 GMT Kris Deugau [103] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Fix bug validating static wireless IP type Tue, 07 Dec 2004 22:56:43 GMT Kris Deugau [102] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable TEMPORARY change to "properly" deallocate static ... Tue, 07 Dec 2004 21:06:13 GMT Kris Deugau [101] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Fixed allocation bug that put the wrong city on ... Tue, 07 Dec 2004 19:20:27 GMT Kris Deugau [100] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Whoops, forgot one final part of moving cities to ... Fri, 03 Dec 2004 19:39:31 GMT Kris Deugau [99] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Removed full_alloc_types hash definition Cleaned ... Thu, 02 Dec 2004 21:02:23 GMT Kris Deugau [98] * branches/stable/assign.html (modified) * branches/stable/cgi-bin/main.cgi (modified) * branches/stable/fb-assign.html (modified) /branches/stable Move most storage of alloctypes int a database ... Thu, 02 Dec 2004 20:48:33 GMT Kris Deugau [97] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Backported pool/static type checks from /trunk r72 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:42:57 GMT Kris Deugau [94] * branches/stable/cgi-bin/CommonWeb.pm (modified) * branches/stable/cgi-bin/CustIDCK.pm (modified) * branches/stable/cgi-bin/admin.cgi (modified) /branches/stable Corrected svn:* properties on several files 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 ... Tue, 30 Nov 2004 19:22:50 GMT Kris Deugau [91] * branches/stable/assign.html (modified) * branches/stable/cgi-bin/ipdb.psql (modified) * branches/stable/cgi-bin/main.cgi (modified) * branches/stable/changes.html (modified) * branches/stable/fb-assign.html (modified) /branches/stable Overhaul of city listings - first stage. Cities ... Tue, 30 Nov 2004 16:51:24 GMT Kris Deugau [90] * branches/stable/assign.html (modified) /branches/stable Added Bracebridge to POP list Mon, 29 Nov 2004 19:47:57 GMT Kris Deugau [89] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Nitpick bugfix for more broken apostophes Mon, 29 Nov 2004 18:18:19 GMT Kris Deugau [88] * branches/stable/assign.html (modified) /branches/stable Added Gravenhurst to POP list 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 22:05:27 GMT Kris Deugau [86] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Modified process for allocating a static IP - ... Fri, 26 Nov 2004 22:03:01 GMT Kris Deugau [85] * branches/stable/changes.html (added) * branches/stable/header.inc (modified) /branches/stable Added "Changes" page as a quick reference for ... Fri, 26 Nov 2004 22:02:01 GMT Kris Deugau [84] * branches/stable/assign.html (modified) * branches/stable/fb-assign.html (modified) /branches/stable Updated and bugfixed cities for customer location ... Fri, 26 Nov 2004 21:18:10 GMT Kris Deugau [83] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Bugfix to the bugfix for improperly-escaped ... Fri, 26 Nov 2004 19:30:49 GMT Kris Deugau [82] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Bugfix for assigning a block to someone in Burk's ... Fri, 26 Nov 2004 18:40:48 GMT Kris Deugau [81] * branches/stable/fb-assign.html (modified) /branches/stable Visual nitpick bugfix for assigning a specific ... 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 ... Fri, 19 Nov 2004 19:44:18 GMT Kris Deugau [76] * branches/stable/cgi-bin/IPDB.pm (modified) * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Bugfixes for mail notification - Subject should ... Tue, 16 Nov 2004 20:24:12 GMT Kris Deugau [75] * branches/stable/assign.html (modified) * branches/stable/cgi-bin/ipdb.psql (modified) * branches/stable/cgi-bin/main.cgi (modified) * branches/stable/confirm.html (modified) * branches/stable/confirmRemove.html (modified) * branches/stable/editDisplay.html (modified) * branches/stable/updated.html (modified) /branches/stable Backports from /trunk r74: - Addition of ... 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:42:35 GMT Kris Deugau [71] * branches/stable/cgi-bin/IPDB.pm (modified) * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Backport email notification for static IP ... 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 17:37:17 GMT Kris Deugau [64] * branches/stable/cgi-bin/consistency-check.pl (modified) * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Backported bugfixes and changes from /trunk r60:63 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 22:09:25 GMT Kris Deugau [60] * branches/stable/cgi-bin/admin.cgi (copied) /branches/stable Add admin interface script to stable tree from ... Wed, 10 Nov 2004 22:08:23 GMT Kris Deugau [59] * branches/stable/cgi-bin/ipdb.psql (modified) /branches/stable Update IPDB schema dump from /trunk 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 Wed, 10 Nov 2004 16:10:28 GMT Kris Deugau [56] * branches/stable/cgi-bin/CustIDCK.pm (added) * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Add support for checking CustIDs against an ...