PHP category_ensure_unique Examples

Example #1

File: category_api.php Project: centaurustech/BenFund

function category_add($p_project_id, $p_category)
{
    $c_project_id = db_prepare_int($p_project_id);
    $c_category = db_prepare_string($p_category);
    category_ensure_unique($p_project_id, $p_category);
    $t_project_category_table = config_get('mantis_project_category_table');
    $query = "INSERT INTO {$t_project_category_table}\n\t\t\t\t\t( project_id, category )\n\t\t\t\t  VALUES\n\t\t\t\t\t( '{$c_project_id}', '{$c_category}' )";
    db_query($query);
    # db_query() errors on failure so:
    return true;
}

Example #2

File: manage_proj_cat_update.php Project: Kirill/mantisbt

require_api('html_api.php');
require_api('lang_api.php');
require_api('print_api.php');
require_api('utility_api.php');
form_security_validate('manage_proj_cat_update');
auth_reauthenticate();
$f_category_id = gpc_get_int('category_id');
$f_project_id = gpc_get_int('project_id', ALL_PROJECTS);
$f_name = trim(gpc_get_string('name'));
$f_assigned_to = gpc_get_int('assigned_to', 0);
access_ensure_project_level(config_get('manage_project_threshold'), $f_project_id);
if (is_blank($f_name)) {
    trigger_error(ERROR_EMPTY_FIELD, ERROR);
}
$t_row = category_get_row($f_category_id);
$t_old_name = $t_row['name'];
$t_project_id = $t_row['project_id'];
# check for duplicate
if (utf8_strtolower($f_name) != utf8_strtolower($t_old_name)) {
    category_ensure_unique($t_project_id, $f_name);
}
category_update($f_category_id, $f_name, $f_assigned_to);
form_security_purge('manage_proj_cat_update');
if ($f_project_id == ALL_PROJECTS) {
    $t_redirect_url = 'manage_proj_page.php';
} else {
    $t_redirect_url = 'manage_proj_edit_page.php?project_id=' . $f_project_id;
}
html_page_top(null, $t_redirect_url);
html_operation_successful($t_redirect_url);
html_page_bottom();

Example #3

File: category_api.php Project: rombert/mantisbt

/**
 * Add a new category to the project
 * @param int $p_project_id Project id
 * @param string $p_name Category Name
 * @return int Category ID
 * @access public
 */
 function category_add( $p_project_id, $p_name ) {
	$c_project_id = db_prepare_int( $p_project_id );

	if( is_blank( $p_name ) ) {
		error_parameters( lang_get( 'category' ) );
		trigger_error( ERROR_EMPTY_FIELD, ERROR );
	}

	category_ensure_unique( $p_project_id, $p_name );

	$t_category_table = db_get_table( 'category' );

	$query = "INSERT INTO $t_category_table
					( project_id, name )
				  VALUES
					( " . db_param() . ', ' . db_param() . ' )';
	db_query_bound( $query, array( $c_project_id, $p_name ) );

	# db_query errors on failure so:
	return db_insert_id( $t_category_table );
}

Example #4

File: category_api.php Project: derrickweaver/mantisbt

/**
 * Add a new category to the project
 * @param integer $p_project_id Project identifier.
 * @param string  $p_name       Category Name.
 * @return integer Category ID
 * @access public
 */
function category_add($p_project_id, $p_name)
{
    if (is_blank($p_name)) {
        error_parameters(lang_get('category'));
        trigger_error(ERROR_EMPTY_FIELD, ERROR);
    }
    category_ensure_unique($p_project_id, $p_name);
    $t_query = 'INSERT INTO {category} ( project_id, name )
				  VALUES ( ' . db_param() . ', ' . db_param() . ' )';
    db_query($t_query, array($p_project_id, $p_name));
    # db_query() errors on failure so:
    return db_insert_id(db_get_table('category'));
}