function testset_add($testset_name, $testset_description, $build_id, $page_name)
{
    global $db;
    $ts_tbl = TS_TBL;
    $f_ts_id = TS_ID;
    $f_name = TS_NAME;
    $f_desc = TS_DESCRIPTION;
    $f_date_created = TS_DATE_CREATED;
    $f_orderby = TS_ORDERBY;
    $f_archive = TS_ARCHIVE;
    $f_build_id = TS_BUILD_ID;
    $date = date_get_short_dt();
    $archive = 'N';
    # query testset table by build and get the max order by
    # add one to the order by when inserting into the testset table
    $q = "SELECT MAX({$f_orderby}) FROM {$ts_tbl} WHERE {$f_build_id} = '{$build_id}'";
    $order_by = db_get_one($db, $q);
    if (!isset($order_by) || $order_by == '') {
        $order_by = '1';
    } else {
        $order_by = $order_by + 1;
    }
    $q = "INSERT INTO {$ts_tbl}\n\t\t ({$f_name}, {$f_desc}, {$f_date_created}, {$f_orderby}, {$f_archive}, {$f_build_id})\n\t\t VALUES\n\t\t ('{$testset_name}', '{$testset_description}', '{$date}', '{$order_by}', '{$archive}', '{$build_id}')";
    db_query($db, $q);
    $q = "SELECT MAX({$f_ts_id}) FROM {$ts_tbl} WHERE {$f_build_id} = '{$build_id}'";
    $testset_id = db_get_one($db, $q);
    #######################################################################################################
    #Add entry into the log table for the project
    $build_name = admin_get_build_name($build_id);
    $deletion = 'N';
    $creation = 'Y';
    $upload = 'N';
    $action = "ADDED TESTSET {$testset_name} to {$build_name}";
    log_activity_log($page_name, $deletion, $creation, $upload, $action);
    #logfile entry end
    #######################################################################################################
    session_set_properties("release", array("testset_id" => $testset_id));
    return $testset_id;
}
include "./api/include_api.php";
auth_authenticate_user();
$page = basename(__FILE__);
$project_manage_page = 'project_manage_page.php';
$project_add_page = 'project_add_page.php';
$project_edit_page = 'project_edit_page.php';
$user_manage_page = 'user_manage_page.php';
$user_add_page = 'user_add_page.php';
$project_manage_action = 'project_manage_action.php';
$delete_page = 'delete_page.php';
$s_project_properties = session_get_project_properties();
$project_name = $s_project_properties['project_name'];
$project_id = $s_project_properties['project_id'];
$s_user_properties = session_get_user_properties();
$user_id = $s_user_properties['user_id'];
session_set_properties("project_manage", $_GET);
$selected_project_properties = session_get_properties("project_manage");
$selected_project_id = $selected_project_properties['project_id'];
$project_manager = user_has_rights($selected_project_id, $user_id, MANAGER);
$redirect_url = $page . "?project_id=" . $selected_project_id;
$s_user_properties = session_get_user_properties();
$user_id = $s_user_properties['user_id'];
$row_style = '';
$order_by = MAN_DOC_TYPE_NAME;
$order_dir = "ASC";
$page_number = 1;
util_set_order_by($order_by, $_GET);
util_set_order_dir($order_dir, $_GET);
util_set_page_number($page_number, $_GET);
util_set_order_by($order_by, $_POST);
util_set_order_dir($order_dir, $_POST);
#----------------------------------------------------------------------
# ---------------------------------------------------------------------
# Requirement Edit Page
#
# $RCSfile: requirement_edit_page.php,v $  $Revision: 1.9 $
# ---------------------------------------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
$page = basename(__FILE__);
$project_properties = session_get_project_properties();
$project_id = $project_properties['project_id'];
$project_name = $project_properties['project_name'];
$username = session_get_username();
$display_options = session_set_display_options("requirements", array_merge($_POST, $_GET));
$s_tab = $display_options['tab'];
$s_properties = session_set_properties("requirements", $_GET);
$s_req_id = $s_properties['req_id'];
$s_req_version_id = $s_properties['req_version_id'];
html_window_title();
html_print_body();
html_page_title($project_name . " - REQUIREMENT DETAIL");
html_page_header($db, $project_name);
html_print_menu();
requirement_menu_print($page);
error_report_check($_GET);
$rows_requirement = requirement_get_detail($project_id, $s_req_id, $s_req_version_id);
$row_requirement = $rows_requirement[0];
$req_version_id = $row_requirement[REQ_VERS_UNIQUE_ID];
$req_rec_or_file = $row_requirement[REQ_REC_FILE];
$req_name = $row_requirement[REQ_FILENAME];
$req_detail = $row_requirement[REQ_VERS_DETAIL];
# Copyright (C) 2005 George Holbrook - rth@lists.sourceforge.net
# This program is distributed under the terms and conditions of the GPL
# See the README and LICENSE files for details
#----------------------------------------------------------------------
# ---------------------------------------------------------------------
# Test Step Import CSV Action Page
#
# $RCSfile: test_step_import_csv_action.php,v $  $Revision: 1.4 $
# ---------------------------------------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
$page = basename(__FILE__);
$s_user_properties = session_get_user_properties();
$s_project_properties = session_get_project_properties();
$s_show_options = session_get_show_options();
$s_test_details = session_set_properties("test", $_GET);
$s_user_id = $s_user_properties['user_id'];
$s_username = $s_user_properties['username'];
$s_tempest_admin = $s_user_properties['tempest_admin'];
$s_project_rights = $s_user_properties['project_rights'];
$s_delete_rights = $s_user_properties['delete_rights'];
$s_email = $s_user_properties['email'];
$project_name = $s_project_properties['project_name'];
$project_id = $s_project_properties['project_id'];
$project_details = project_get_details($project_id);
$s_show_test_input = $project_details[PROJ_SHOW_TEST_INPUT];
$test_id = util_pad_id($s_test_details['test_id']);
$test_version_id = $s_test_details['test_version_id'];
$redirect_page = "test_detail_page.php?test_id={$test_id}&project_id={$project_id}&tab=1";
# Upload function
if (IMPORT_EXPORT_TO_EXCEL) {
# rth is a requirement, test, and bugtracking system
# Copyright (C) 2005 George Holbrook - rth@lists.sourceforge.net
# This program is distributed under the terms and conditions of the GPL
# See the README and LICENSE files for details
#----------------------------------------------------------------------
# ---------------------------------------------------------------------
# Results Update Test Result Page
#
# $RCSfile: results_update_test_result_page.php,v $  $Revision: 1.7 $
# ---------------------------------------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
$project_properties = session_get_project_properties();
$project_name = $project_properties['project_name'];
$project_id = $project_properties['project_id'];
$s_results = session_set_properties("results", $_GET);
$s_test_id = $s_results['test_id'];
$s_testset_id = $s_results['testset_id'];
$page = basename(__FILE__);
$action_page = "results_update_test_result_action.php";
html_window_title();
html_print_body();
html_page_title($project_name . " - " . lang_get('update_test_result_page'));
html_page_header($db, $project_name);
html_print_menu();
print "<br>" . NEWLINE;
error_report_check($_GET);
print "<div align=center>" . NEWLINE;
print "<form method=post action={$action_page}>" . NEWLINE;
print "<input type='hidden' name='testset_id' value='{$_GET['testset_id']}'>" . NEWLINE;
print "<input type='hidden' name='test_id' value='{$_GET['test_id']}'>" . NEWLINE;
<?php

# ---------------------------------------------------------------------
# rth is a requirement, test, and bugtracking system
# Copyright (C) 2005 George Holbrook - rth@lists.sourceforge.net
# This program is distributed under the terms and conditions of the GPL
# See the README and LICENSE files for details
#----------------------------------------------------------------------
# ------------------------------------
# Project Edit Area Tested Action
#
# $RCSfile: project_edit_user_action.php,v $  $Revision: 1.1.1.1 $
# ------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
$redirect_page = 'project_manage_page.php';
$proj_properties = session_set_properties("project_manage", $_POST);
project_edit_user($proj_properties['project_id'], $proj_properties['user_id'], $_POST['user_rights'], isset($_POST['user_delete_rights']) ? "Y" : "N", isset($_POST['user_email_testset']) ? "Y" : "N", isset($_POST['user_email_discussions']) ? "Y" : "N", isset($_POST['user_qa_owner']) ? "Y" : "N", isset($_POST['user_ba_owner']) ? "Y" : "N");
html_print_operation_successful("user_edit_page", $redirect_page . "#users");
# ------------------------------------
# $Log: project_edit_user_action.php,v $
# Revision 1.1.1.1  2005/11/30 23:00:57  gth2
# importing initial version - gth
#
# ------------------------------------
# ------------------------------------
# Bug Close Page
#
# $RCSfile: bug_close_page.php,v $  $Revision: 1.3 $
# ------------------------------------
$page = basename(__FILE__);
$action_page = 'bug_close_action.php';
include "./api/include_api.php";
auth_authenticate_user();
$s_project_properties = session_get_project_properties();
$project_name = $s_project_properties['project_name'];
$project_id = $s_project_properties['project_id'];
$s_user_properties = session_get_user_properties();
$s_user_id = $s_user_properties['user_id'];
$s_username = $s_user_properties['username'];
$s_bug_details = session_set_properties("bug", $_GET);
$bug_id = $s_bug_details['bug_id'];
$padded_bug_id = util_pad_id($bug_id);
html_window_title();
html_print_body();
html_page_title($project_name . " - " . lang_get('bug_close_page'));
html_page_header($db, $project_name);
html_print_menu();
bug_menu_print($page);
print "<br>" . NEWLINE;
error_report_check($_GET);
$row = bug_get_detail($bug_id);
$closed_reason_code = $row[BUG_CLOSED_REASON_CODE];
print "<div align=center>";
print "<span class='required'>*</span><span class='print'>" . lang_get('must_complete_field') . "</span><br>";
# ADD BUGNOTE TABLE
# $RCSfile: build_page.php,v $ $Revision: 1.5 $
# ------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
$page = basename(__FILE__);
$form_name = 'add_build';
$action_page = 'build_add_action.php';
$build_edit_page = 'build_edit_page.php';
$testset_page = 'testset_page.php';
$delete_page = 'delete_page.php';
$s_project_properties = session_get_project_properties();
$project_name = $s_project_properties['project_name'];
$project_id = $s_project_properties['project_id'];
$row_style = '';
# Set release build properties in session and assign all values to variable
$s_release_properties = session_set_properties("release", $_GET);
$release_id = $s_release_properties['release_id'];
$release_name = admin_get_release_name($release_id);
$redirect_url = $page . "?release_id=" . $release_id;
$display_options = session_set_display_options("build", $_POST);
$order_by = $display_options['order_by'];
$order_dir = $display_options['order_dir'];
html_window_title();
html_print_body($form_name, 'build_name_required');
html_page_title($project_name . " - " . lang_get('build_page'));
html_page_header($db, $project_name);
html_print_menu();
html_release_map(array("release_link", lang_get("builds")));
error_report_check($_GET);
print "<div align=center>" . NEWLINE;
print "<span class='required'>*</span> <span class='print'>" . lang_get('must_complete_field') . "</span>" . NEWLINE;
# This program is distributed under the terms and conditions of the GPL
# See the README and LICENSE files for details
#----------------------------------------------------------------------
# ---------------------------------------------------------------------
# User Edit Account Page
#
# $RCSfile: user_edit_account_page.php,v $  $Revision: 1.1.1.1 $
# ---------------------------------------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
$page = basename(__FILE__);
$action_page = "user_edit_account_action.php";
$s_project_properties = session_get_project_properties();
$project_name = $s_project_properties['project_name'];
$project_id = $s_project_properties['project_id'];
session_set_properties("user_edit", $_GET);
$s_properties = session_get_properties("user_edit");
$selected_user_id = $s_properties['user_id'];
$s_user_properties = session_get_user_properties();
$user_id = $s_user_properties['user_id'];
if (empty($selected_user_id) || !user_has_rights($project_id, $user_id, MANAGER)) {
    html_redirect('user_edit_my_account_page.php');
    exit;
} else {
    $selected_user_id = $selected_user_id;
}
require_once "user_edit_page.php";
# ---------------------------------------------------------------------
# $Log: user_edit_account_page.php,v $
# Revision 1.1.1.1  2005/11/30 23:00:59  gth2
# importing initial version - gth
# rth is a requirement, test, and bugtracking system
# Copyright (C) 2005 George Holbrook - rth@lists.sourceforge.net
# This program is distributed under the terms and conditions of the GPL
# See the README and LICENSE files for details
#----------------------------------------------------------------------
# ------------------------------------
# Page name
#
# $RCSfile: build_edit_action.php,v $  $Revision: 1.2 $
# ------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
#### Change to correct redirect page ####
$redirect_page = 'build_page.php';
$edit_page = 'build_edit_page.php';
$s_release_properties = session_set_properties("release");
session_validate_form_set($_POST, $edit_page);
if (admin_build_name_exists($s_release_properties['release_id'], session_validate_form_get_field('build_edit_name_required'))) {
    error_report_show($edit_page, DUPLICATE_BUILD_NAME);
}
#### Call api function to add/update database passing in form field values ####
admin_edit_build(session_validate_form_get_field('build_id'), session_validate_form_get_field('build_edit_name_required'), session_validate_form_get_field('build_edit_date'), session_validate_form_get_field('build_edit_description'));
session_validate_form_reset();
html_print_operation_successful('build_page', $redirect_page);
# ------------------------------------
# $Log: build_edit_action.php,v $
# Revision 1.2  2008/08/08 11:22:10  peter_thal
# disabled update buildname to an existing buildname
# test_detail_update_action.php: changed redirect page on error
#
# Revision 1.1.1.1  2005/11/30 23:00:56  gth2
# ---------------------------------------------------------------------
# rth is a requirement, test, and bugtracking system
# Copyright (C) 2005 George Holbrook - rth@lists.sourceforge.net
# This program is distributed under the terms and conditions of the GPL
# See the README and LICENSE files for details
#----------------------------------------------------------------------
# ---------------------------------------------------------------------
# Test Set Copy Sort Page
#
# $RCSfile: testset_copy_sort.php,v $  $Revision: 1.2 $
# ---------------------------------------------------------------------
include "./api/include_api.php";
auth_authenticate_user();
$redirect_page = 'testset_copy_page.php';
session_set_properties("testset_copy", $_GET);
html_window_title();
html_print_body();
print "<form method=post action={$redirect_page}>" . NEWLINE;
foreach ($_POST as $key => $value) {
    print "\t<input type=hidden name=\"{$key}\" value=\"" . stripslashes($value) . "\">" . NEWLINE;
}
print "</form>" . NEWLINE;
?>

<script language="JavaScript" type="text/javascript">
	document.forms[0].submit();
</script>

<?php 
html_print_footer();