# # ChangeLog for / # # Generated by Trac 1.6 # 11/01/24 04:21:32 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 19:05:24 GMT Kris Deugau [178] * branches/stable/cgi-bin/ipdb.psql (modified) /branches/stable Fix buglet in SQL definitions Tue, 01 Mar 2005 18:33:45 GMT Kris Deugau [177] * branches/stable/cgi-bin/ipdb.psql (modified) /branches/stable Update ipdb.psql database definition with ... 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:14:06 GMT Kris Deugau [174] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Backported SQL cleanup from /trunk r173 Thu, 24 Feb 2005 22:12:09 GMT Kris Deugau [173] * trunk/cgi-bin/main.cgi (modified) /trunk Merged additional SQL cleanup changes from ... Thu, 24 Feb 2005 22:09:30 GMT Kris Deugau [172] * branches/sql-cleanup/cgi-bin/main.cgi (modified) /branches/sql-cleanup Missed some slightly hairy SQL in the search ... Thu, 24 Feb 2005 20:09:46 GMT Kris Deugau [171] * branches/new-search-20050223/cgi-bin/main.cgi (modified) * branches/new-search-20050223/header.inc (modified) /branches/new-search-20050223 First iteration: - Changed search ... Wed, 23 Feb 2005 16:50:22 GMT Kris Deugau [170] * branches/new-search-20050223 (copied) Create branch to revise IPDB search system Tue, 22 Feb 2005 22:00:37 GMT Kris Deugau [169] * branches/stable/cgi-bin/checkcusts.pl (modified) /branches/stable Updated checkcusts.pl hack to skip new ... Tue, 22 Feb 2005 19:30:36 GMT Kris Deugau [168] * branches/stable/cgi-bin/IPDB.pm (modified) * branches/stable/cgi-bin/consistency-check.pl (modified) * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Port forward enhanced "default CustID" feature ... 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: ... Mon, 14 Feb 2005 15:54:41 GMT Kris Deugau [165] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Eliminated another buglet relating to the change ... Thu, 10 Feb 2005 18:17:59 GMT Kris Deugau [164] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable More bugs on pool allocations - this time the the ... Thu, 10 Feb 2005 15:36:22 GMT Kris Deugau [163] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Added some debug logging to catch times of billing ... Thu, 10 Feb 2005 15:13:45 GMT Kris Deugau [162] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable D'OH!! Missed a change from ptype->type in one ... Wed, 09 Feb 2005 22:56:08 GMT Kris Deugau [161] * trunk/cgi-bin/main.cgi (modified) /trunk Backport bugfix from /branches/stable r160 Wed, 09 Feb 2005 22:52:20 GMT Kris Deugau [160] * branches/stable/cgi-bin/main.cgi (modified) /branches/stable Mildly embarrasing display microfix for the edge ... Wed, 09 Feb 2005 22:11:19 GMT Kris Deugau [159] * branches/stable/cgi-bin/IPDB.pm (modified) * branches/stable/cgi-bin/main.cgi (modified) * branches/stable/changes.html (modified) /branches/stable Merged /trunk r157 in. Clean merge required ... Wed, 09 Feb 2005 20:53:56 GMT Kris Deugau [158] * branches/stable/assign.html (modified) * branches/stable/cgi-bin/IPDB.pm (modified) * branches/stable/cgi-bin/MyIPDB.pm (copied) * branches/stable/cgi-bin/admin.cgi (modified) * branches/stable/cgi-bin/consistency-check.pl (modified) * branches/stable/cgi-bin/extras/db2rwhois.pl (modified) * branches/stable/cgi-bin/freespace.pl (modified) * branches/stable/cgi-bin/main.cgi (modified) * branches/stable/cgi-bin/newcity.cgi (modified) /branches/stable Merge all changes from /trunk r141-144 and r146 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 - ... Mon, 07 Feb 2005 17:00:47 GMT Kris Deugau [156] * branches/stable/cgi-bin/CustIDCK.pm (modified) * branches/stable/cgi-bin/checkcusts.pl (modified) /branches/stable Updated CustIDCK.pm and checkcusts.pl with new ... 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 ...