Example #1
0
function custom_field_set_sequence($p_field_id, $p_project_id, $p_sequence)
{
    $c_field_id = db_prepare_int($p_field_id);
    $c_project_id = db_prepare_int($p_project_id);
    $c_sequence = db_prepare_int($p_sequence);
    $t_custom_field_project_table = config_get('mantis_custom_field_project_table');
    $query = "UPDATE {$t_custom_field_project_table}\r\n\t\t\t\t  SET sequence='{$c_sequence}'\r\n\t\t\t\t  WHERE field_id='{$c_field_id}' AND\r\n\t\t\t\t  \t\tproject_id='{$c_project_id}'";
    $result = db_query($query);
    custom_field_clear_cache($p_field_id);
    return true;
}
Example #2
0
/**
 * Sets the sequence number for the specified custom field for the specified
 * project.
 * @param integer $p_field_id   A custom field identifier.
 * @param integer $p_project_id A Project identifier.
 * @param integer $p_sequence   Sequence order.
 * @return boolean
 * @access public
 */
function custom_field_set_sequence($p_field_id, $p_project_id, $p_sequence)
{
    $t_query = 'UPDATE {custom_field_project}
				  SET sequence=' . db_param() . '
				  WHERE field_id=' . db_param() . ' AND
				  		project_id=' . db_param();
    db_query($t_query, array($p_sequence, $p_field_id, $p_project_id));
    custom_field_clear_cache($p_field_id);
    return true;
}
Example #3
0
/**
 * Sets the sequence number for the specified custom field for the specified
 * project.
 * @param int $p_field_id custom field id
 * @param int $p_project_id project id
 * @param int $p_sequence
 * @return bool
 * @access public
 */
function custom_field_set_sequence($p_field_id, $p_project_id, $p_sequence)
{
    $c_field_id = db_prepare_int($p_field_id);
    $c_project_id = db_prepare_int($p_project_id);
    $c_sequence = db_prepare_int($p_sequence);
    $t_custom_field_project_table = db_get_table('custom_field_project');
    $query = "UPDATE {$t_custom_field_project_table}\n\t\t\t\t  SET sequence=" . db_param() . "\n\t\t\t\t  WHERE field_id=" . db_param() . " AND\n\t\t\t\t  \t\tproject_id=" . db_param();
    $result = db_query_bound($query, array($c_sequence, $c_field_id, $c_project_id));
    custom_field_clear_cache($p_field_id);
    return true;
}