session_start(); ?>
Saving edits
include_once('../lib/proclib.php');
include_once('setup.php');
/*
@ $db = mysql_connect( "localhost", $connectUser,$connectPwd);
if (! $db) {
echo "Error: could not connect to database.
";
exit;
}
mysql_select_db($dbname);
*/
$id = $HTTP_POST_VARS['id'];
$title = $HTTP_POST_VARS['title'];
$priority = $HTTP_POST_VARS['priority'];
$status = $HTTP_POST_VARS['status'];
$description = $HTTP_POST_VARS['description'];
$otime = $HTTP_POST_VARS['otime'];
$ctime = $HTTP_POST_VARS['ctime'];
$bin_id = $HTTP_POST_VARS['bin_id'];
$type_id = $HTTP_POST_VARS['type_id'];
$user_id = $HTTP_POST_VARS['user_id'];
$system_id = $HTTP_POST_VARS['system_id'];
$creator_id = $HTTP_POST_VARS['creator_id'];
$tested = $HTTP_POST_VARS['tested'];
$approved = $HTTP_POST_VARS['approved'];
$project_id = $HTTP_POST_VARS['project_id'];
$est_hours = $HTTP_POST_VARS['est_hours'];
$deadline = $HTTP_POST_VARS['deadline'];
$start_date = $HTTP_POST_VARS['start_date'];
$wkd_hours = $HTTP_POST_VARS['wkd_hours'];
/* $relations = $HTTP_POST_VARS['relations']; */
if ($tested <> 1) {$tested = 0;}
if ($approved <> 1) {$approved = 0;}
$otime2 = date2int($otime);
$ctime2 = date2int($ctime);
if ($ctime2 <= 0) { $ctime2 = 'null';}
$start_date2 = date2int($start_date);
$deadline2 = date2int($deadline);
// echo "ctime: $ctime ctime2: $ctime2 ";
$query = "UPDATE ZENTRACK_TICKETS SET
title = '$title',
priority = $priority,
status = '$status',
description = '$description',
otime = $otime2,
ctime = $ctime2,
bin_id = $bin_id,
type_id = $type_id,
user_id = $user_id,
system_id = $system_id,
creator_id = $creator_id,
tested = $tested,
approved = $approved,
project_id = $project_id,
est_hours = $est_hours,
deadline = $deadline2,
start_date = $start_date2,
wkd_hours = $wkd_hours
where id = $id;";
/*
relations = '$relations',
*/
$result2 = mysql_query($query);
if ($result2) {
/* echo mysql_affected_rows()." log entries added.
"; */
echo "
Done.
";
} else {
echo "$query
\n";
echo "Problem inserting row.
";}
?>
require('menu.php') ?>