Changeset 370


Ignore:
Timestamp:
11/27/07 12:18:27 (17 years ago)
Author:
Kris Deugau
Message:

/trunk

Merge bugfixes and enhancements from /branches/stable r351 through r359

Location:
trunk
Files:
9 edited

Legend:

Unmodified
Added
Removed
  • trunk/cgi-bin/IPDB.pm

    r350 r370  
    2525        %allocated %free %routed %bigfree %IPDBacl
    2626        &initIPDBGlobals &connectDB &finish &checkDBSanity &allocateBlock &deleteBlock
    27         &mailNotify
     27        &getBlockData &mailNotify
    2828        );
    2929
     
    3333                @masterblocks %allocated %free %routed %bigfree %IPDBacl
    3434                &initIPDBGlobals &connectDB &finish &checkDBSanity &allocateBlock
    35                 &deleteBlock &mailNotify
     35                &deleteBlock &getBlockData &mailNotify
    3636                )]
    3737        );
     
    492492      $msg = "Unable to deallocate $disp_alloctypes{$type} $cidr";
    493493      $sth = $dbh->prepare("update poolips set custid='6750400',available='y',".
    494         "city=(select city from allocations where cidr >>= '$cidr'),".
     494        "city=(select city from allocations where cidr >>= '$cidr'".
     495        " order by masklen(cidr) desc limit 1),".
    495496        "description='',notes='',circuitid='' where ip='$cidr'");
    496497      $sth->execute;
     
    643644
    644645
     646## IPDB::getBlockData()
     647# Return custid, type, city, and description for a block
     648sub getBlockData {
     649  my $dbh = shift;
     650  my $block = shift;
     651
     652  my $sth = $dbh->prepare("select cidr,custid,type,city,description from searchme".
     653        " where cidr='$block'");
     654  $sth->execute();
     655  return $sth->fetchrow_array();
     656} # end getBlockData()
     657
     658
    645659## IPDB::mailNotify()
    646660# Sends notification mail to recipients regarding an IPDB operation
  • trunk/cgi-bin/admin.cgi

    r348 r370  
    570570        " value='$types[0]'>$types[1]</option>\n";
    571571    }
    572     print "<option". (($data[2] eq 'in') ? ' selected' : '') .
    573         " value='in'>Internal netblock</option>\n</select></td>\n";
    574572
    575573    print qq(<td><input name=city value="$data[3]"></td>\n).
  • trunk/cgi-bin/ipdb.psql

    r347 r370  
    147147we      Dynamic WiFi block      Dynamic WiFi block      104     WL-RES  ISP-WIFI
    148148ve      Dynamic VoIP block      Dynamic VoIP block      105     DYN-VOIP        ISP
    149 li      Static IP - LAN/POP     Static LAN/POP IP       190     6750400 ISP
    150 ld      Static Pool - LAN/POP   LAN pool        191     6750400 ISP
     149li      Static IP - LAN/POP     Static LAN/POP IP       190     NOC-VPN ISP
     150li      Static IP - Management  Static management IP    191     NOC-VPN ISP
     151ld      Static Pool - LAN/POP   LAN pool        195     NOC-VPN ISP
     152ld      Static Pool - Management        Management pool 196     NOC-VPN ISP
     153in      Internal netblock       Internal netblock       199     6750400 ISP
    151154wc      Reserve for CORE/WAN blocks     CORE/WAN blocks 200     6750400 ISP
    152155pc      Reserve for dynamic-route DSL netblocks Dynamic-route netblocks 201     6750400 ISP-STATIC-DSL
     
    158161fr      Fibre   Fibre   223             ISP
    159162rm      Routing Routed netblock 500     6750400 ISP
    160 in      Internal netblock       Internal netblock       990     6750400 ISP
    161163mm      Master block    Master block    999     6750400 ISP
    162164\.
  • trunk/cgi-bin/main.cgi

    r320 r370  
    12831283  }
    12841284
     1285  # need to retrieve block data before deleting so we can notify on that
     1286  my ($cidr,$custid,$type,$city,$description) = getBlockData($ip_dbh, $webvar{block});
     1287
    12851288  my ($code,$msg) = deleteBlock($ip_dbh, $webvar{block}, $webvar{alloctype});
    12861289
    12871290  if ($code eq 'OK') {
    12881291    print "<div class=heading align=center>Success!  $webvar{block} deallocated.</div>\n";
    1289     syslog "notice", "$authuser deallocated '$webvar{alloctype}'-type netblock $webvar{block}";
     1292    syslog "notice", "$authuser deallocated '$webvar{alloctype}'-type netblock $webvar{block}".
     1293        " $custid, $city, desc='$description'";
    12901294    # Notify tech@ when a block/IP is deallocated
    12911295#    mailNotify('tech@example.com',"REMOVED: $disp_alloctypes{$webvar{alloctype}} $webvar{block}",
    1292 #       "$disp_alloctypes{$webvar{alloctype}} $webvar{block} deallocated by $authuser\n");
     1296#       "$disp_alloctypes{$webvar{alloctype}} $webvar{block} deallocated by $authuser\n".
     1297#       "CustID: $custid\nCity: $city\nDescription: $description\n");
    12931298  } else {
    12941299    if ($webvar{alloctype} =~ /^.i$/) {
  • trunk/cgi-bin/newcity.cgi

    r214 r370  
    4040
    4141if ($webvar{pop} eq 'on') {
    42   $sth = $dbh->prepare("insert into cities values ('$webvar{city}','y')");
     42  $sth = $dbh->prepare("insert into cities (city,routing) values ('$webvar{city}','y')");
    4343} else {
    44   $sth = $dbh->prepare("insert into cities values ('$webvar{city}','n')");
     44  $sth = $dbh->prepare("insert into cities (city,routing) values ('$webvar{city}','n')");
    4545}
    4646$sth->execute;
  • trunk/cgi-bin/search.cgi

    r351 r370  
    4040my %webvar = parse_post();
    4141cleanInput(\%webvar);
     42
     43if (defined($webvar{rpp})) {
     44  ($RESULTS_PER_PAGE) = ($webvar{rpp} =~ /(\d+)/);
     45}
    4246
    4347if (!defined($webvar{stype})) {
     
    185189  } else {
    186190    # Add the limit/offset clauses
    187     $sql .= " order by cidr limit $RESULTS_PER_PAGE offset $offset";
     191    $sql .= " order by cidr";
     192    $sql .= " limit $RESULTS_PER_PAGE offset $offset" if $RESULTS_PER_PAGE != 0;
    188193    # And tell the user.
    189194    print "<div class=heading>Searching...............</div>\n";
     
    420425
    421426  # print the page thing..
    422   if ($rowCount > $RESULTS_PER_PAGE) {
     427  if ($RESULTS_PER_PAGE > 0 && $rowCount > $RESULTS_PER_PAGE) {
    423428    my $pages = ceil($rowCount/$RESULTS_PER_PAGE);
    424429    print qq(<div class="center"> Page: );
  • trunk/compsearch.html

    r234 r370  
    66<td colspan=2>Match on:<input type=radio checked name=which value="all">All
    77<input type=radio name=which value="any">Any
    8 <td colspan=2 align=right><input type=submit value="Search Now"></td>
     8<td>Results per page: <select name=rpp>
     9<option value='25'>25</option>
     10<option value='50'>50</option>
     11<option value='100'>100</option>
     12<option value='200'>200</option>
     13<option value='0'>Show all</option>
     14</select>
     15<td align=right><input type=submit value="Search Now"></td>
    916</td>
    1017<tr class="color1">
  • trunk/header.inc

    r234 r370  
    77<script language=javascript>
    88function openHelp() {
    9         window.open("/ip/help.html", "help_window", "toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=700,height=300")
     9        window.open("/ip/help.html", "help_window", "toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=700,height=400")
    1010}
    1111function openTables() {
  • trunk/help.html

    r285 r370  
    2828</tr>
    2929<tr class="color2">
    30 <td>Customer ID:</td><td>705 or 6137328844</td><td>Find all alloctions to that
    31 customer.
    32 Matches on prefix (area code, area code + exchange, etc).
     30<td>Customer ID:</td><td>705 or 6137328844 or 503101</td><td>Find all alloctions to that
     31customer. Matches on prefix (area code, area code + exchange, etc).  Searches old as well as
     32new CustIDs.
    3333</td>
    3434</tr>
Note: See TracChangeset for help on using the changeset viewer.