/**
* Update the field definition
* return true on success, false on failure
* @param integer $p_field_id Custom field identifier.
* @param array $p_def_array Custom field definition.
* @return boolean
* @access public
*/
function custom_field_update($p_field_id, array $p_def_array)
{
if (is_blank($p_def_array['name'])) {
error_parameters('name');
trigger_error(ERROR_EMPTY_FIELD, ERROR);
}
if ($p_def_array['access_level_rw'] < $p_def_array['access_level_r']) {
error_parameters(lang_get('custom_field_access_level_r') . ', ' . lang_get('custom_field_access_level_rw'));
trigger_error(ERROR_CUSTOM_FIELD_INVALID_PROPERTY, ERROR);
}
if ($p_def_array['length_min'] < 0 || $p_def_array['length_max'] != 0 && $p_def_array['length_min'] > $p_def_array['length_max']) {
error_parameters(lang_get('custom_field_length_min') . ', ' . lang_get('custom_field_length_max'));
trigger_error(ERROR_CUSTOM_FIELD_INVALID_PROPERTY, ERROR);
}
if (!custom_field_is_name_unique($p_def_array['name'], $p_field_id)) {
trigger_error(ERROR_CUSTOM_FIELD_NAME_NOT_UNIQUE, ERROR);
}
# Build fields update statement
$t_update = '';
foreach ($p_def_array as $t_field => $t_value) {
switch ($t_field) {
case 'name':
case 'possible_values':
case 'default_value':
case 'valid_regexp':
# Possible values doesn't apply to textarea fields
if ($p_def_array['type'] == CUSTOM_FIELD_TYPE_TEXTAREA && $t_field == 'possible_values') {
$t_value = '';
}
$t_update .= $t_field . '=' . db_param() . ', ';
$t_params[] = (string) $t_value;
break;
case 'type':
case 'access_level_r':
case 'access_level_rw':
case 'length_min':
case 'length_max':
$t_update .= $t_field . '=' . db_param() . ', ';
$t_params[] = (int) $t_value;
break;
case 'filter_by':
case 'display_report':
case 'display_update':
case 'display_resolved':
case 'display_closed':
case 'require_report':
case 'require_update':
case 'require_resolved':
case 'require_closed':
$t_update .= $t_field . '=' . db_param() . ', ';
$t_params[] = (bool) $t_value;
break;
}
}
# If there are fields to update, execute SQL
if ($t_update !== '') {
$t_query = 'UPDATE {custom_field} SET ' . rtrim($t_update, ', ') . ' WHERE id = ' . db_param();
$t_params[] = $p_field_id;
db_query($t_query, $t_params);
custom_field_clear_cache($p_field_id);
return true;
}
return false;
}
function custom_field_update($p_field_id, $p_def_array)
{
if (string_contains_scripting_chars($p_def_array['name'])) {
trigger_error(ERROR_CUSTOM_FIELD_INVALID_DEFINITION, ERROR);
}
$c_field_id = db_prepare_int($p_field_id);
$c_name = db_prepare_string(trim($p_def_array['name']));
$c_type = db_prepare_int($p_def_array['type']);
$c_possible_values = db_prepare_string($p_def_array['possible_values']);
$c_default_value = db_prepare_string($p_def_array['default_value']);
$c_valid_regexp = db_prepare_string($p_def_array['valid_regexp']);
$c_access_level_r = db_prepare_int($p_def_array['access_level_r']);
$c_access_level_rw = db_prepare_int($p_def_array['access_level_rw']);
$c_length_min = db_prepare_int($p_def_array['length_min']);
$c_length_max = db_prepare_int($p_def_array['length_max']);
$c_advanced = db_prepare_bool($p_def_array['advanced']);
$c_display_report = db_prepare_bool($p_def_array['display_report']);
$c_display_update = db_prepare_bool($p_def_array['display_update']);
$c_display_resolved = db_prepare_bool($p_def_array['display_resolved']);
$c_display_closed = db_prepare_bool($p_def_array['display_closed']);
$c_require_report = db_prepare_bool($p_def_array['require_report']);
$c_require_update = db_prepare_bool($p_def_array['require_update']);
$c_require_resolved = db_prepare_bool($p_def_array['require_resolved']);
$c_require_closed = db_prepare_bool($p_def_array['require_closed']);
if (is_blank($c_name)) {
error_parameters('name');
trigger_error(ERROR_EMPTY_FIELD, ERROR);
}
if ($c_access_level_rw < $c_access_level_r || $c_length_min < 0 || $c_length_max != 0 && $c_length_min > $c_length_max) {
trigger_error(ERROR_CUSTOM_FIELD_INVALID_DEFINITION, ERROR);
}
if ($c_advanced == true && ($c_require_report == true || $c_require_update)) {
trigger_error(ERROR_CUSTOM_FIELD_INVALID_DEFINITION, ERROR);
}
if (!custom_field_is_name_unique($c_name, $c_field_id)) {
trigger_error(ERROR_CUSTOM_FIELD_NAME_NOT_UNIQUE, ERROR);
}
$t_update_something = false;
$t_mantis_custom_field_table = config_get('mantis_custom_field_table');
$query = "UPDATE {$t_mantis_custom_field_table}\r\n\t\t\t\t SET ";
if (array_key_exists('name', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "name='{$c_name}'";
}
if (array_key_exists('type', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "type='{$c_type}'";
}
if (array_key_exists('possible_values', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "possible_values='{$c_possible_values}'";
}
if (array_key_exists('default_value', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "default_value='{$c_default_value}'";
}
if (array_key_exists('valid_regexp', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "valid_regexp='{$c_valid_regexp}'";
}
if (array_key_exists('access_level_r', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "access_level_r='{$c_access_level_r}'";
}
if (array_key_exists('access_level_rw', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "access_level_rw='{$c_access_level_rw}'";
}
if (array_key_exists('length_min', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "length_min='{$c_length_min}'";
}
if (array_key_exists('length_max', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "length_max='{$c_length_max}'";
}
if (array_key_exists('advanced', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "advanced='{$c_advanced}'";
}
if (array_key_exists('display_report', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_report='{$c_display_report}'";
}
if (array_key_exists('display_update', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_update='{$c_display_update}'";
}
if (array_key_exists('display_resolved', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_resolved='{$c_display_resolved}'";
}
if (array_key_exists('display_closed', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_closed='{$c_display_closed}'";
}
if (array_key_exists('require_report', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_report='{$c_require_report}'";
}
if (array_key_exists('require_update', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_update='{$c_require_update}'";
}
if (array_key_exists('require_resolved', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_resolved='{$c_require_resolved}'";
}
if (array_key_exists('require_closed', $p_def_array)) {
if (!$t_update_something) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_closed='{$c_require_closed}'";
}
$query .= " WHERE id='{$c_field_id}'";
if ($t_update_something) {
db_query($query);
custom_field_clear_cache($p_field_id);
} else {
return false;
# there is nothing to update...
}
# db_query() errors on failure so:
return true;
}
# Copyright (C) 2002 - 2004 Mantis Team - mantisbt-dev@lists.sourceforge.net
# This program is distributed under the terms and conditions of the GPL
# See the README and LICENSE files for details
# --------------------------------------------------------
# $Id: manage_custom_field_create.php,v 1.15 2005/02/12 20:01:05 jlatour Exp $
# --------------------------------------------------------
require_once 'core.php';
$t_core_path = config_get('core_path');
require_once $t_core_path . 'custom_field_api.php';
access_ensure_global_level(config_get('manage_custom_fields_threshold'));
$f_name = gpc_get_string('name');
$f_name = trim($f_name);
if (is_blank($f_name)) {
trigger_error(ERROR_EMPTY_FIELD, ERROR);
}
if (!custom_field_is_name_unique($f_name)) {
trigger_error(ERROR_CUSTOM_FIELD_NAME_NOT_UNIQUE, ERROR);
}
$t_field_id = custom_field_create($f_name);
if (ON == config_get('custom_field_edit_after_create')) {
$t_redirect_url = "manage_custom_field_edit_page.php?field_id={$t_field_id}";
} else {
$t_redirect_url = 'manage_custom_field_page.php';
}
html_page_top1();
html_meta_redirect($t_redirect_url);
html_page_top2();
?>
<br />
/**
* Update the field definition
* return true on success, false on failure
* @param int $p_field_id custom field id
* @param array $p_def_array custom field definition
* @return bool
* @access public
*/
function custom_field_update($p_field_id, $p_def_array)
{
if (is_blank($p_def_array['name'])) {
error_parameters('name');
trigger_error(ERROR_EMPTY_FIELD, ERROR);
}
if ($p_def_array['access_level_rw'] < $p_def_array['access_level_r']) {
error_parameters(lang_get('custom_field_access_level_r') . ', ' . lang_get('custom_field_access_level_rw'));
trigger_error(ERROR_CUSTOM_FIELD_INVALID_PROPERTY, ERROR);
}
if ($p_def_array['length_min'] < 0 || $p_def_array['length_max'] != 0 && $p_def_array['length_min'] > $p_def_array['length_max']) {
error_parameters(lang_get('custom_field_length_min') . ', ' . lang_get('custom_field_length_max'));
trigger_error(ERROR_CUSTOM_FIELD_INVALID_PROPERTY, ERROR);
}
if (!custom_field_is_name_unique($p_def_array['name'], $p_field_id)) {
trigger_error(ERROR_CUSTOM_FIELD_NAME_NOT_UNIQUE, ERROR);
}
# Build fields update statement
$t_update = '';
foreach ($p_def_array as $field => $value) {
$t_update .= "{$field} = " . db_param() . ', ';
$t_params[] = is_bool($value) ? db_prepare_bool($value) : $value;
}
# If there are fields to update, execute SQL
if ($t_update !== '') {
$t_mantis_custom_field_table = db_get_table('custom_field');
$t_query = "\n\t\t\tUPDATE {$t_mantis_custom_field_table}\n\t\t\tSET " . rtrim($t_update, ', ') . "\n\t\t\tWHERE id = " . db_param();
$t_params[] = $p_field_id;
db_query_bound($t_query, $t_params);
custom_field_clear_cache($p_field_id);
# db_query errors on failure so:
return true;
}
return false;
}
/**
* Update the field definition
* return true on success, false on failure
* @param int $p_field_id custom field id
* @param array custom field definition
* @return bool
* @access public
*/
function custom_field_update( $p_field_id, $p_def_array ) {
$c_field_id = db_prepare_int( $p_field_id );
$c_name = db_prepare_string( trim( $p_def_array['name'] ) );
$c_type = db_prepare_int( $p_def_array['type'] );
$c_possible_values = db_prepare_string( $p_def_array['possible_values'] );
$c_default_value = db_prepare_string( $p_def_array['default_value'] );
$c_valid_regexp = db_prepare_string( $p_def_array['valid_regexp'] );
$c_access_level_r = db_prepare_int( $p_def_array['access_level_r'] );
$c_access_level_rw = db_prepare_int( $p_def_array['access_level_rw'] );
$c_length_min = db_prepare_int( $p_def_array['length_min'] );
$c_length_max = db_prepare_int( $p_def_array['length_max'] );
$c_filter_by = db_prepare_bool( $p_def_array['filter_by'] );
$c_display_report = db_prepare_bool( $p_def_array['display_report'] );
$c_display_update = db_prepare_bool( $p_def_array['display_update'] );
$c_display_resolved = db_prepare_bool( $p_def_array['display_resolved'] );
$c_display_closed = db_prepare_bool( $p_def_array['display_closed'] );
$c_require_report = db_prepare_bool( $p_def_array['require_report'] );
$c_require_update = db_prepare_bool( $p_def_array['require_update'] );
$c_require_resolved = db_prepare_bool( $p_def_array['require_resolved'] );
$c_require_closed = db_prepare_bool( $p_def_array['require_closed'] );
if( is_blank( $c_name ) ) {
error_parameters( 'name' );
trigger_error( ERROR_EMPTY_FIELD, ERROR );
}
if(( $c_access_level_rw < $c_access_level_r ) || ( $c_length_min < 0 ) || (( $c_length_max != 0 ) && ( $c_length_min > $c_length_max ) ) ) {
trigger_error( ERROR_CUSTOM_FIELD_INVALID_DEFINITION, ERROR );
}
if( !custom_field_is_name_unique( $c_name, $c_field_id ) ) {
trigger_error( ERROR_CUSTOM_FIELD_NAME_NOT_UNIQUE, ERROR );
}
$t_update_something = false;
$t_mantis_custom_field_table = db_get_table( 'custom_field' );
$query = "UPDATE $t_mantis_custom_field_table
SET ";
if( array_key_exists( 'name', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "name='$c_name'";
}
if( array_key_exists( 'type', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "type='$c_type'";
}
if( array_key_exists( 'possible_values', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "possible_values='$c_possible_values'";
}
if( array_key_exists( 'default_value', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "default_value='$c_default_value'";
}
if( array_key_exists( 'valid_regexp', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "valid_regexp='$c_valid_regexp'";
}
if( array_key_exists( 'access_level_r', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "access_level_r='$c_access_level_r'";
}
if( array_key_exists( 'access_level_rw', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "access_level_rw='$c_access_level_rw'";
}
if( array_key_exists( 'length_min', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "length_min='$c_length_min'";
}
if( array_key_exists( 'length_max', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "length_max='$c_length_max'";
}
if( array_key_exists( 'filter_by', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "filter_by='$c_filter_by'";
}
if( array_key_exists( 'display_report', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_report='$c_display_report'";
}
if( array_key_exists( 'display_update', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_update='$c_display_update'";
}
if( array_key_exists( 'display_resolved', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_resolved='$c_display_resolved'";
}
if( array_key_exists( 'display_closed', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "display_closed='$c_display_closed'";
}
if( array_key_exists( 'require_report', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_report='$c_require_report'";
}
if( array_key_exists( 'require_update', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_update='$c_require_update'";
}
if( array_key_exists( 'require_resolved', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_resolved='$c_require_resolved'";
}
if( array_key_exists( 'require_closed', $p_def_array ) ) {
if( !$t_update_something ) {
$t_update_something = true;
} else {
$query .= ', ';
}
$query .= "require_closed='$c_require_closed'";
}
$query .= " WHERE id='$c_field_id'";
if( $t_update_something ) {
db_query( $query );
custom_field_clear_cache( $p_field_id );
} else {
return false;
# there is nothing to update...
}
# db_query errors on failure so:
return true;
}
