Domains

"; $post = ""; } else { $pre = ""; $post = ""; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } ?>
ID Name      
" . $pre . $id . $post . "" . $pre . $row["dom_name"] . $post . "edit
Update IP Range\n"; } else { $name = getPostVar( "name", "" ); $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 "
ID$id
Name
Description
\n"; if( $id != 0 ) { echo "\n"; } else { echo "\n"; } echo "
\n"; } function insert( $conn ) { $dnsuid = $_SESSION["dnsuid"]; $name = getPostVar( "name", "" ); if( !checkDomainName( $name ) ) { return 0; } $descr = stripslashes( getPostVar( "descr", "" ) ); if( strlen($descr) > 200 ) { echo "description is too long
\n"; return 0; } $dbdescr = addslashes( $descr ); $id = db_get_next_id( $conn, "domain", "dom_id" ); if( $id == 0 ) { return 0; } $sql = "insert into domain (" . "dom_id, dom_name, dom_descr, " . "du_id_ins, date_ins, du_id_upd, date_upd, " . "du_id_del, date_del " . ") values ( " . "$id, '$name', '$dbdescr', " . "$dnsuid, CURRENT_TIMESTAMP, $dnsuid, CURRENT_TIMESTAMP, " . "null, to_date( '1970010100', 'YYYYMMDDHH24' ) " . ")"; #showSQL( $sql ); if( !pg_exec( $conn, $sql ) ) { return 0; } return $id; } function update( $conn, $id ) { $dnsuid = $_SESSION["dnsuid"]; $name = getPostVar( "name", "" ); if( !checkDomainName( $name ) ) { return 0; } $descr = stripslashes( getPostVar( "descr", "" ) ); if( strlen($descr) > 200 ) { echo "description is too long
\n"; return 0; } $dbdescr = addslashes( $descr ); $sql = "update domain set dom_name = '$name', dom_descr = '$dbdescr', " . "du_id_upd = $dnsuid, date_upd = CURRENT_TIMESTAMP " . "where dom_id = $id"; #showSQL( $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 domain set " . "du_id_del = $dnsuid, date_del = CURRENT_TIMESTAMP " . "where dom_id = $id"; if( !pg_exec( $conn, $sql ) ) { return false; } return true; } //echo "$cmd/$subcmd
\n"; 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 domains", "domain", "" ); } if( $subcmd != "add" ) { addToMenu( "add domain", "domain", "add" ); } ?>