this is simple sql correction...
USE [fredworld]
GO
/****** Object: StoredProcedure [dbo].[lin_UpdateUserItem] Script Date: 06/19/2010 14:07:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[lin_UpdateUserItem]
(
@char_id INT,
@item_type INT,
@amount INT,
@enchant INT,
@eroded INT,
@bless INT,
@ident INT,
@wished INT,
@warehouse INT,
@item_id INT,
@attack_attr_type TINYINT,
@attack_attr_value INT,
@def_attr_fire INT,
@def_attr_water INT,
@def_attr_wind INT,
@def_attr_earth INT,
@def_attr_holy INT,
@def_attr_unholy INT
)
AS
SET NOCOUNT ON
UPDATE user_item set char_id=@char_id, item_type=@item_type, amount=@amount, enchant=@enchant, eroded=@eroded, bless=@bless, ident=@ident, wished=@wished, warehouse=@warehouse, attack_attr_type=@attack_attr_type, attack_attr_value=@attack_attr_value, def_attr_fire=@def_attr_fire, def_attr_water=@def_attr_water, def_attr_wind=@def_attr_wind, def_attr_earth=@def_attr_earth, def_attr_holy=@def_attr_holy, def_attr_unholy=@def_attr_unholy WHERE item_id=@item_id