IP Ranges

"; $post = ""; } else { $pre = ""; $post = ""; } if( $row["ipr_dhcp"] == "t" ) { $dhcp = "X"; } else { $dhcp = " "; } if( $row["ipr_temp"] == "t" ) { $temp = "X"; } else { $temp = " "; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } ?>
ID min. Addr. max. Addr. Domain DHCP Temp Description  
" . $pre . $id . $post . "" . $pre . intToIP($row["ipr_min_addr"]) . $post . "" . $pre . intToIP($row["ipr_max_addr"]) . $post . "" . $pre . $row["dom_name"] . $post . "" . $pre . $dhcp . $post . "" . $pre . $temp . $post . "" . $pre . htmlentities($row["ipr_descr"]) . $post . "edit
Update IP Range\n"; } else { $ipmin = getPostVar( "ipmin", "" ); $ipmax = getPostVar( "ipmax", "" ); $domain = getPostVar( "domain", "" ); if( getPostVar( "dhcp", "" ) == "checked" ) { $dhcp = true; } else { $dhcp = false; } if( getPostVar( "temp", "" ) == "checked" ) { $temp = true; } else { $temp = false; } $maxdays = getPostVar( "maxdays", "" ); $descr = stripslashes( getPostVar( "descr", "" ) ); echo "

Add New IP Range

\n"; } echo "
\n"; echo "\n"; echo "\n"; if( $id != 0 ) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if( $dhcp ) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; if( $temp ) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; if( $maxdays == "" ) { $maxdays = 100; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
ID$id
Min. IP Addr.
Max. IP Addr.
Domain"; db_domain_list( $conn, $domain, false, 0, "domain" ); echo "
DHCP
Temp. IP's
Max. Days
Description
\n"; if( $id != 0 ) { echo "\n"; } else { echo "\n"; } echo "
\n"; } function insert( $conn ) { $dnsuid = $_SESSION["dnsuid"]; $ipmini = ipToInt( getPostVar( "ipmin", "" ) ); $ipmaxi = ipToInt( getPostVar( "ipmax", "" ) ); if( $ipmini == -1 || $ipmaxi == -1 ) { echo "illegal IP address
\n"; return 0; } if( compareIP( $ipmini, $ipmaxi ) > 0 ) { echo "min ip must be less or equal max ip
\n"; return 0; } if( !checkInt( getPostVar( "domain", "" ) ) ) { echo "illegal domain
\n"; return 0; } if( !checkInt( getPostVar( "maxdays", "" ) ) ) { echo "illegal max. days
\n"; return 0; } $domain = (int)getPostVar( "domain", "" ); if( getPostVar( "dhcp", "" ) == "checked" ) { $dhcp = "true"; } else { $dhcp = "false"; } if( getPostVar( "temp", "" ) == "checked" ) { $temp = "true"; } else { $temp = "false"; } $maxdays = (int)getPostVar( "maxdays", "" ); if( !db_check_iprange( $conn, $ipmini, $ipmaxi, 0 ) ) { echo "illegal IP range
\n"; return 0; } $descr = db_check_description( getPostVar( "descr", "" ), 200 ); if( !$descr ) { echo "description is too long
\n"; return 0; } $id = db_get_next_id( $conn, "iprange", "ipr_id" ); if( $id == 0 ) { return 0; } $sql = "insert into iprange (" . "ipr_id, ipr_min_addr, ipr_max_addr, " . "dom_id, ipr_dhcp, ipr_temp, ipr_max_days, ipr_descr, " . "du_id_ins, date_ins, du_id_upd, date_upd, " . "date_del" . ") values (" . "$id, $ipmini, $ipmaxi, " . "$domain, $dhcp, $temp, $maxdays, $descr, " . "$dnsuid, CURRENT_TIMESTAMP, $dnsuid, CURRENT_TIMESTAMP, " . "CURRENT_TIMESTAMP " . ")"; showVar( "sql", $sql ); if( !pg_exec( $conn, $sql ) ) { return 0; } return $id; } function update( $conn, $id ) { $dnsuid = $_SESSION["dnsuid"]; if( !checkInt( $id ) ) { echo "illegal ID
\n"; return false; } $ipmini = ipToInt( getPostVar( "ipmin", "" ) ); $ipmaxi = ipToInt( getPostVar( "ipmax", "" ) ); if( $ipmini == -1 || $ipmaxi == -1 ) { return false; } if( compareIP( $ipmini, $ipmaxi ) > 0 ) { echo "min ip must be less or equal max ip
\n"; return false; } if( !checkInt( getPostVar( "domain", "" ) ) ) { echo "illegal domain
\n"; return false; } if( !checkInt( getPostVar( "maxdays", "" ) ) ) { echo "illegal max. days
\n"; return false; } //echo "min ip: '$ipmini'
\n"; //echo "max ip: '$ipmaxi'
\n"; $domain = (int)getPostVar( "domain", "" ); if( getPostVar( "dhcp", "" ) == "checked" ) { $dhcp = "true"; } else { $dhcp = "false"; } if( getPostVar( "temp", "" ) == "checked" ) { $temp = "true"; } else { $temp = "false"; } $maxdays = (int)getPostVar( "maxdays", "" ); $descr = db_check_description( getPostVar( "descr", "" ), 200 ); if( !$descr ) { echo "description is too long
\n"; return 0; } if( !db_check_iprange( $conn, $ipmini, $ipmaxi, $id ) ) { return false; } $sql = "update iprange set ipr_min_addr = $ipmini, " . "ipr_max_addr = $ipmaxi, dom_id = $domain, ipr_dhcp = $dhcp, ipr_temp = $temp, " . "ipr_max_days = $maxdays, ipr_descr = $descr, " . "du_id_upd = $dnsuid, date_upd = CURRENT_TIMESTAMP " . "where ipr_id = $id"; showVar( "sql", $sql ); if( !pg_exec( $conn, $sql ) ) { return false; } return true; } function delete( $conn, $id ) { $dnsuid = $_SESSION["dnsuid"]; if( !checkInt( $id ) ) { echo "illegal ID
\n"; return false; } $sql = "update iprange set " . "du_id_del = $dnsuid, date_del = CURRENT_TIMESTAMP " . "where ipr_id = $id"; if( !pg_exec( $conn, $sql ) ) { return false; } return true; } showVar( "subcmd", $subcmd ); switch( $subcmd ) { case "edit": edit( $conn, $_REQUEST["id"] ); break; case "add": edit( $conn, 0 ); break; case "insert": $id = insert( $conn ); if( $id > 0 ) { show( $conn, $id ); $subcmd = "show"; } else { edit( $conn, $id ); } break; case "update": if( update( $conn, $_REQUEST["id"] ) ) { show( $conn, $_REQUEST["id"] ); $subcmd = "show"; } else { edit( $conn, $_REQUEST["id"] ); } break; case "delete": if( update( $conn, $_REQUEST["id"] ) ) { show( $conn, 0 ); $subcmd = "show"; } else { edit( $conn, $_REQUEST["id"] ); } break; default: show( $conn, 0 ); $subcmd = "show"; break; } if( $subcmd != "show" ) { addToMenu( "show ipranges", "iprange", "" ); } if( $subcmd != "add" ) { addToMenu( "add iprange", "iprange", "add" ); } ?>