0 ) { $ress = db_query( "select ot_name from ordertag where ot_nr = $parent" ); if( $ress ) { $row = db_next( $ress ); if( $row ) { $parentname = $row["ot_name"]; return true; } } return false; } return true; } function cmd_tags_insert() { $name = get_POST_var( "name" ); $parent = get_POST_var( "parent" ); if( $name && ereg( "^[0-9][0-9]*\$", $parent ) ) { $parentname = ""; if( cmd_tags_check_parent( $parent, $parentname ) ) { $longname = null; if( $parent > 0 ) { $longname = db_escape_str( "$parentname -- $name" ); } else { $longname = db_escape_str( $name ); } $nr = db_next_nr( "ordertag", "ot_nr" ); $name = db_escape_str( $name ); $sql = "insert into ordertag ( ot_nr, ot_parent_nr, ot_name, ot_long_name ) values ( $nr, $parent, $name, $longname )"; db_update( $sql ); } } } function cmd_tags_update() { $nr = get_POST_var( "nr" ); $name = get_POST_var( "name" ); $parent = get_POST_var( "parent" ); if( $name && ereg( "^[1-9][0-9]*\$", $nr ) && ereg( "^[0-9][0-9]*\$", $parent ) ) { $parentname = ""; if( cmd_tags_check_parent( $parent, $parentname ) ) { $longname = null; if( $parent > 0 ) { $longname = db_escape_str( "$parentname -- $name" ); } else { $longname = db_escape_str( $name ); } $name = db_escape_str( $name ); $sql = "update ordertag set ot_name = $name, ot_long_name = $longname, ot_parent_nr = $parent where ot_nr = $nr"; db_update( $sql ); } } } function cmd_tags_delete() { $nr = get_POST_var( "nr" ); if( ereg( "^[1-9][0-9]*\$", $nr ) ) { db_begin(); $sql = "delete from ordertag where ot_nr = $nr and not exists ( select ot_nr from ordertag where ot_parent_nr = $nr )"; if( db_update( $sql ) != 1 ) { db_rollback(); return; } $sql = "delete from orderparttag where ot_nr = $nr"; if( db_update( $sql ) < 0 ) { db_rollback(); return; } db_commit(); } } function cmd_tags_list() { echo "\n"; echo "


\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
nr
name
parent
\n"; echo "
\n"; } function cmd_tags( $subcmd ) { echo "

tags

\n"; switch( $subcmd ) { case "insert": cmd_tags_insert(); cmd_tags_list(); break; case "update": cmd_tags_update(); cmd_tags_list(); break; case "delete": cmd_tags_delete(); cmd_tags_list(); break; default: cmd_tags_list(); break; } } ?>