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; }
/** * 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; }
/** * 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; }